So I thought I had solved my problem of consolidating a lot of my stored
procedures into one. I found you could specify a default value for a
parameter so in case one template didn't specify it, it wouldn't throw an
error. Great, that worked, but then I went to the template that did specify
it via an input parameter. Well, here's where my troubles began. I
actually had specified two parameters in the stored procedure, one after the
other, but in this particular template, I only needed to transfer a value
for one of them. Well, despite passing the value, it only used my default
value in the stored procedure. So, I switched the order of the variables in
the stored procedure and vuala! It seems that if the first one was not
found, it assumed the second one would not be found either! How does this
make sense??? Also one of my templates now simply does not work with this
stored procedure. It gives me a "Numeric value out of range" error, though
when I put the same exact sql statement into a query (this particular sql
statement actually doesn't use any input parameters), it works fine! Ugh!
It looks like I am going to have to go back and pass my own default values
in every template via cfprocparam tags, how annoying. Unless of course I've
completely missed something...
Levi
------------------------------------------------------------------------
| Levi Wallach - [EMAIL PROTECTED] P:(703) 237-0443 F: 703-237-3490 |
| Senior Webmaster, Tran Interactive Design Group - http://www.tidg.com |
------------------------------------------------------------------------
| Creator, DVDMON.com - http://www.dvdmon.com - [EMAIL PROTECTED] |
| DVD News, Views & Reviews, Music & Book Reviews, PDA Channel Content, |
| Contests, DVD Buying Guide and more! |
-------------------------------------------------------------------------
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
