Hi, can anyone tell me where I'm going wrong here please? I've set up a database and linked to it, but I'm having trouble navigating it using a dropdown box to select records. The drop down lists all the ID's for the records, but the refresh button, which should update all the other fields from the same record, gives the error message in the screen grab below. The code behind the refresh button is...
if
(Len(Ltrim(Rtrim(DropDownList16.rawValue))) > 0)then
$sourceSet.DataConnection2.#command.query.commandType
="text"
$sourceSet.DataConnection2.#command.query.select.nodes.item(0).value
=Concat("Select * from Table1 Where CoureTitle = ",Ltrim(Rtrim(DropDownList16.rawValue)) ,"")
$sourceSet.DataConnection2.open()
endif
Any help or pointers to tutorials would be very much appreciated.
Sean
Views
Replies
Total Likes
http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/
If anyone else has the same problem, see here, the guy's a genius!
Views
Replies
Total Likes