SQL Query Problem!

[NEvans8993]

I currently have an ASP site using http://localhost/, with IIS. I am trying
to pass a parameter within a hyperlink from one page when a picture is
clicked upon, and then pass that para to an sql query located on a DRW page.

One the 1st page i have set my parameter as follows ' Dev_Code = MC0001',
within the hyperlink, and then on the DRW page i have the following:

Select * from Moorcroft where Dev_Code =:ev_Code::".

This is meant to find a match within the Access DB within /fpdb/ folder, and
return the results, but to no avail. The database connection is fine, because
i tested the above query putting in the actual value instead of the parameter
name.

Any help would be much appreciated.

 

[NEvans8993]

Silly me. Since putting open and close quotes around the value of the
parameter it has worked.

 

[MD Websunlimited]

Glad you got it fixed.

 

[NEvans8993]

I even surprised myself. One thing i know i am going to want to do is this:

Import the full size picture of the thumbnail hyperlink picture into the DRW
Page.

Any ideas??