search

jeffreyhi1 / loginsystem-rd

Automatically exported from code.google.com/p/loginsystem-rd
0 stars 0 forks source link

Parameters #24

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
On the ASP pages, using named parameter does not work for MS SQL...

e.g. SELECT [id] from users WHERE (userid=@userid) works in MS Access but
not MS SQL.

SELECT [id] from users WHERE (userid=?) does work and also works in MS Access.

So all the named parameters need to be replaced with ? and the parameters
need to be appended in order.

Original issue reported on code.google.com by rdivilb...@gmail.com on 16 Feb 2010 at 2:15

GoogleCodeExporter commented 8 years ago 
Corrected code.

Original comment by rdivilb...@gmail.com on 27 Feb 2010 at 8:38