Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Database Connection Error

Avatar

Avatar
Level 1
Sean_hepburn
Level 1

Likes

0 likes

Total Posts

9 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
Sean_hepburn
Level 1

Likes

0 likes

Total Posts

9 posts

Correct Reply

0 solutions
View profile
Sean_hepburn
Level 1

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

Avatar

Avatar
Level 1
Sean_hepburn
Level 1

Likes

0 likes

Total Posts

9 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
Sean_hepburn
Level 1

Likes

0 likes

Total Posts

9 posts

Correct Reply

0 solutions
View profile
Sean_hepburn
Level 1

15-05-2009

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!