SQL Query Problem!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 =::Dev_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.
 
Silly me. Since putting open and close quotes around the value of the
parameter it has worked.
 
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??
 
Back
Top