Variables
Variables
(OP)
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;
/
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;
/
RE: Variables
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
RE: Variables
RE: Variables
the syntax is wrong, you wrote>>
"select txorder_id, from txorder where "
remove comma(,) after "txorder_id," and run it.
bye