Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Variables

Status
Not open for further replies.
garikke

garikke

Computer
Joined
Aug 2, 2001
Messages
1
Location
US
What is wrong here?

DECLARE
s_id VARCHAR2(32);
s_id =(select store_id from store where key_store_seqid = '&&storeNumber');

BEGIN

select txorder_id, from txorder where order_number = '&&orderNumber' and store_id = '$s_id';

END;
/
 
Sort by date Sort by votes
Not sure if this applies, but i had trouble doing an SQLvar1 = "INSERT INTO tablename1 (field1) VALUES ("'& aspformvar1 &'")"

This shows the syntax i was looking for.
it's the asp var name from a submitted form, inside an & on each side, inside single quotes, inside double quotes.

does this make sense? i'm really glad i got it working!! a friend of mine knew the deal and told me the syntax. thank you jason!

dcp - dcparham@directvinternet.com
 
Upvote 0 Downvote
One thing that I noticed is that you are declaring s_id as a varchar2 with a length of only 32. You are then trying to build s_id as something a lot bigger than 32 characters.
 
Upvote 0 Downvote
hi dcparham
the syntax is wrong, you wrote>>
"select txorder_id, from txorder where "

remove comma(,) after "txorder_id," and run it.


bye
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top