This is a discussion on Recordset and Stored Procedure issues! within the ASP Development forums, part of the Programming & Scripting category; removing the double quotes still sends the page to the ELSE statement......
| |||||||
|
#11
| ||||
| ||||
| removing the double quotes still sends the page to the ELSE statement... |
|
#12
| ||||
| ||||
| 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. |
|
#13
| ||||
| ||||
| have you removed the double quotes and added the single quotes ...
__________________ Quote of the Month: Mistakes: It could be that the purpose of your life is only to serve as a warning to others. 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. |
|
#14
| ||||
| ||||
| Quote:
![]() Quote:
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. |
|
#16
| ||||
| ||||
| Quote:
Code: EXEC spTestEdit1 '""'"test@test.com" |
|
#17
| ||||
| ||||
| put in the following and run it Code: EXEC spTestEdit1 '" & session("username") & "'"
|
|
#18
| ||||
| ||||
| ok, it still takes me to the ELSE statement... |
|
#19
| ||||
| ||||
| 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. |
|
#20
| ||||
| ||||
| Quote:
|
![]() |
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| SQL Job or stored procedure | todd2006 | SQL Development | 5 | February 11th, 2009 02:20 PM |
| stored procedure | todd2006 | ASP Development | 7 | February 5th, 2009 03:02 PM |
| stored procedure | todd2006 | Microsoft SQL Server | 1 | February 5th, 2009 01:25 PM |
| If statement stored procedure | peebman2000 | SQL Development | 32 | May 23rd, 2008 03:54 PM |
| Dynamic Stored Procedure | jmurrayhead | Microsoft SQL Server | 16 | March 26th, 2008 11:19 AM |