Hey there ill keep it sweet and simple...Im making a search query in a web page.. but i if no input is selected i simply want it to ignore that part of the query.....
for example ...I know that
CODE
SELECT * FROM TABLE
WHERE
Columnname = Columnname
this will ignore the where as it will select all of the column values.
But i want to know how i can do this when im passing a variable in Vbscript.....
Im using the parameter append command to link the two
CODE
.Parameters.Append .CreateParameter("@Columnname", adInteger, adParamInput, 4, Int(Columnname))
What value can i store in the Columnname that will do the Columnname = Columnname function ??????
Also if it makes it easier, Does MSSQL support IF ...ELSE Sequences and if it does again what would i set a integer parameter to, so that i could get the columnname = column name function.....
Do i use; '%%' because i tried this and it didnt work
Anyways simple but SOOOO ANOYING ! lol
Thanks
| 