SQL Parimeters(MMColParam) Missing In String - ASP/VBS / Access

Report · Jan 23, 2007

Hi all,
Can any one suggest what might be up here,

Im making a recordset from an acces database...
Im using DW8 with update.

My other recordsets are fine but this one is giving me trouble.

When I make the connection to the recordset and add my SQL string and parimeters it all goes in well..
But the actual code on the page is showing ? question marks in the connections section on the page

EG: This is what i put in....

SELECT field_id, FROM table WHERE field_1 = MMColParam and field_2 <> MMColParam2 and field_3 <> 137 ORDER BY field_2 ASC

This is what goes on the page and errors at runtime..

SELECT field_id, FROM table WHERE field_1 = ? and field_2 <> ? and field_3 <> 137 ORDER BY field_2 ASC

I cant figure it out as im doing what ive done a thousand times now?? Even if I manually change the question marks it doesnt fix the problem as they revert back...??

Any suggestions are very welcome.
Thanks
W

Report · Jan 23, 2007

The ? means that that it is expecting a variable. Below the statement it
should have added a list of parameter names and where their values come
from.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"webstaffuk" <webforumsuser@macromedia.com> wrote in message
news:ep5igp$bte$1@forums.macromedia.com...
> Hi all,
> Can any one suggest what might be up here,
>
> Im making a recordset from an acces database...
> Im using DW8 with update.
>
> My other recordsets are fine but this one is giving me trouble.
>
> When I make the connection to the recordset and add my SQL string and
> parimeters it all goes in well..
> But the actual code on the page is showing ? question marks in the
> connections
> section on the page
>
> EG: This is what i put in....
>
> SELECT field_id, FROM table WHERE field_1 = MMColParam and field_2 <>
> MMColParam2 and field_3 <> 137 ORDER BY field_2 ASC
>
> This is what goes on the page and errors at runtime..
>
> SELECT field_id, FROM table WHERE field_1 = ? and field_2 <> ? and
> field_3 <>
> 137 ORDER BY field_2 ASC
>
> I cant figure it out as im doing what ive done a thousand times now?? Even
> if
> I manually change the question marks it doesnt fix the problem as they
> revert
> back...??
>
> Any suggestions are very welcome.
> Thanks
> W
>
>
>