Highlighted

Database Connection Error

Sean_hepburn

15-05-2009

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

Replies