PASSWORD is a reserved word for many DBs; try [PASSWORD] as the column name instead.
On 11/10/06, alex poyaoan <[EMAIL PROTECTED]> wrote: > >Are you sure that URL_PASSWORD_ID had a value otherwise it may be > >executing: "WHERE PASSWORD_ID = " > > > >Output the variable before running the query to make sure that it isn't this > > > > > > > >On 11/10/06, alex poyaoan <[EMAIL PROTECTED]> wrote: > >> > > Hi Rich, > Well the variable i guess is coming up since this is the url on the page > http://localhost/auxweb/riservate/mykey_action.cfm?PASSWORD_ID=4 > with the correct password_id > with the call i didn't place a URLENCODEDFORMAT Though but placing it it > doesn't give me the correct password_id > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259881 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
