Hi again,
OK, in our current application I,m turning all our queries to stored procs,
and its starting to feel like maybe I've bitten off too much, as my
knowledge of t-sql is one week, I've ordered a book by Garth Wells, 'T-SQL
programming with Stored Procedures', waiting for it to arrive.
OK so this what I am trying to do,
<CFSTOREDPROC
PROCEDURE="p_checkMV"
DATASOURCE="#REQUEST.dsn#"
USERNAME="#REQUEST.user#"
PASSWORD="#REQUEST.key#">
<CFPROCRESULT NAME="q_checkMV">
<CFPROCPARAM DBVARNAME="@customerID"
VALUE="#session.customerid#" CFSQLTYPE="CF_SQL_INTEGER" TYPE="IN">
<CFPROCPARAM DBVARNAME="@cfID" VALUE="#client.cfid#"
CFSQLTYPE="CF_SQL_CHAR" TYPE="IN">
<CFPROCPARAM DBVARNAME="@cftoken" VALUE="#client.cftoken#"
CFSQLTYPE="CF_SQL_CHAR" TYPE="IN">
<CFPROCPARAM DBVARNAME="@vehicleList"
VALUE="#ATTRIBUTES.selectedItems#" CFSQLTYPE="CF_SQL_VARCHAR" TYPE="IN">
</CFSTOREDPROC>
emphasis on
" <CFPROCPARAM DBVARNAME="@vehicleList" VALUE="#ATTRIBUTES.selectedItems#"
CFSQLTYPE="CF_SQL_VARCHAR" TYPE="IN"> "
which has a value of,
"
49,X504UTU,X504UTU|50,H7WPT,H7WPT|48,J8WPT,J8WPT|51,ECZ6771,ECZ6771|83,S163T
JA,S163TJA "
now in normal sql this is what I WAS doing,
<CFQUERY ...>
DELETE
FROM DBO.vehicleSelection
WHERE customerid=#session.customerid#
AND cfid=#client.cfid#
AND cftoken=#client.cftoken#
</CFQUERY>
<CFQUERY ...>
<CFLOOP FROM="1" TO="#listlen(ATTRIBUTES.selectedItems, '|')#"
INDEX="i">
<CFIF NOT listWithinList IS "">
<CFSET listWithinList="">
</CFIF>
<CFSET listWithinList=LISTGETAT(ATTRIBUTES.selectedItems, i,
"|")>
INSERT INTO dbo.vehicleSelection
(customerID,vehicleID,callsign,registration,cfid,cftoken)
VALUES (#session.customerID#,
#LISTGETAT(listWithinList, 1, ",")#,
'#LISTGETAT(listWithinList, 2,
",")#',
'#LISTGETAT(listWithinList, 3,
",")#',
#CLIENT.cfid#,
#CLIENT.cftoken#
</CFLOOP>
</CFQUERY>
So in my proc
CREATE PROCEDURE p_checkMV
(
@customerID int,
@cfid int,
@cftoken int,
@vehicleList VARCHAR
)
AS
DELETE
FROM vehicleSelection
WHERE customerid=@customerid
AND cfid=@cfid
AND cftoken=@cftoken
what I do next that would replicate my second cfquery I do not have the
foggiest,
I'm not sure about what conditional operators I need to use,
and what functions are avialable to me to manipulate @vehicleList,
Thanks for any help on this.
jmc
.
This message is sent in confidence for the addressee only. The contents are
not to be disclosed to anyone other than the addressee(s). Unauthorised
recipients must preserve this confidentiality and should advise the sender
immediately of any error in transmission.
Andronics Receives International Award for Innovation
http://www.andronics.co.uk/news/news9.htm
______________________________________________________________________
Why Share?
Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
