sql2000?
I keep getting errors when I change my proc to a simple = to an in
statement. (or more precisely when I choose more than 1 options from the
select box) so I assume it's how it's being sent?? Maybe in the cf part of
how to call a stored proc. I thought about making this into a loop list
situation, but it's actually pulling a huge amount of data and don't like
the overhead that the loop would add...
Instead of giving my huge queries here's an example of what I'm doing. The
ID is coming from a select box
------------------------------------------------------
cf page
<CFSTOREDPROC PROCEDURE="procGetInfo" DATASOURCE="#Request.Datasource#">
<CFPROCPARAM TYPE="IN" DBVARNAME="@ID" CFSQLTYPE="CF_SQL_INTEGER"
VALUE="#Attributes.ID#">
<CFPROCRESULT NAME="ShowInfo">
</CFSTOREDPROC>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
