LinkBack URL
About LinkBacksremoving 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. 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:
INSIGHT: When the going gets tough, the tough get going. The smart left a long time ago.
Questions to Ponder:
Are people more violently opposed to fur rather than leather because it's much easier to harass rich women than motorcycle gangs?
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..Originally Posted by mehere
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. Void where prohibited by law. Not valid in California. Your mileage may vary.
this is what i get:
Code:EXEC spTestEdit1 '""'"test@test.com"
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:
INSIGHT: When the going gets tough, the tough get going. The smart left a long time ago.
Questions to Ponder:
Are people more violently opposed to fur rather than leather because it's much easier to harass rich women than motorcycle gangs?
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.
ok, it still takes me to the ELSE statement...
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:
INSIGHT: When the going gets tough, the tough get going. The smart left a long time ago.
Questions to Ponder:
Are people more violently opposed to fur rather than leather because it's much easier to harass rich women than motorcycle gangs?
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.
will that solve the problem though? in your opinion?
Posting Permissions 
Reply With Quote
Bookmarks