removing the double quotes still sends the page to the ELSE statement...
removing the double quotes still sends the page to the ELSE statement...
OK, that would now indicate to me that your command text is incorrect in some way. What do you get when you write out the SQL command text?
Wolffy
------------------------
Opinions expressed are my own and do not necessity reflect those of any sane person. Any code provided is intended to be an example and is provided AS IS. Rework for your specific environment may be required. Void where prohibited by law. Not valid in California. Your mileage may vary.
have you removed the double quotes and added the single quotes ...
Quote of the Month:
Leaders: Leaders are like eagles. We don't have either of them here.
Questions to Ponder:
Why do banks charge you a "non-sufficient funds fee" on money they already know you don't have?
iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
copyright © 2008 sbenj69
Sarchasm: The gulf between the author of sarcastic wit and the person who doesn't get it.
removed double quotes left it just as username, as function spud takes care of the quotes i think..
sorry excuse my lack of knowledge, what is SQL command text?
EDIT: if you mean executing the SP in management express, then yes, i have entered the username and i get the other records showing up. so i know the username is valid and the SP is working.
Put the following right before the rs.open and let us know what you get:
Response.Write(sql)
Wolffy
------------------------
Opinions expressed are my own and do not necessity reflect those of any sane person. Any code provided is intended to be an example and is provided AS IS. Rework for your specific environment may be required. Void where prohibited by law. Not valid in California. Your mileage may vary.
put in the following and run it
forget the spud function ... which as wolffy says is adding double quotes and it should be single quotes.Code:EXEC spTestEdit1 '" & session("username") & "'"
Quote of the Month:
Leaders: Leaders are like eagles. We don't have either of them here.
Questions to Ponder:
Why do banks charge you a "non-sufficient funds fee" on money they already know you don't have?
iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
copyright © 2008 sbenj69
Sarchasm: The gulf between the author of sarcastic wit and the person who doesn't get it.
not understanding that ... but as wolffy also mentioned ... you should run stored procs using a command object. have a look at ASP and SQL Server store procedures for how to do this.
Quote of the Month:
Leaders: Leaders are like eagles. We don't have either of them here.
Questions to Ponder:
Why do banks charge you a "non-sufficient funds fee" on money they already know you don't have?
iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
copyright © 2008 sbenj69
Sarchasm: The gulf between the author of sarcastic wit and the person who doesn't get it.
Bookmarks