table and then has to be transformed some and put into 2 live tables. I need to
do the following queries:
1. get lastid+1 from items table
2. generate parent/child relationship for item
3. put tempitem into items table
4. put tempitem into lotmatrix table
5. delete temp item
These have to be done in a one at a time fashion and is a lot of queries. CFMX
doesn't like 1500+ queries inside a CFTRANSACTION block (I'm assuming that's the
source of the error as it works) so I have to do the whole operation one at a
time.
Does anyone have the syntax offhand for assigning variables from a query in an
SP to another query in an SP? I want query 1 in the SP to get the lastid and
store it as a var. Query2 in the SP will then use that var with others to
insert.
Thanks
--
Michael Dinowitz
Finding technical solutions to the problems you didn't know you had yet
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
