Ask a Question related to Coldfusion Database Access, Design and Development.
-
Loganda #1
Stored procedure's Procparam maxlength
I have been using a stored procedure in Coldfusion 6.1 that has <cfprocparam
type="in" cfsqltype="cf_sal.decimal' maxlength="3" scale=2"
value="#passvalue#">. We just installed Coldfusion 7.0 on the system. Before
installing 7.0 i have been able to pass 3.21 but could not pass 12.12 or even
1.222 . It would lock the decimal down to 3 digits not 2 digits and a decimal.
Now it seems to be counting the decimal as one of the maxlength. Is this an
error with the version 7.0 or was this a error with version 6.1. I can not
find nothing on this problem.
Thanks for any help.
Loganda Guest
-
Boolean with procparam?
:o Seems like I would have run into this in the years and years I've been writing CF, but alas, no. How does one pass a boolean with cfprocparam?... -
stored procedure help
Hi all! I am in need of writing a few stored procedures. The first one is to create a stored procedure to recover a database from backup and the... -
ADOX - how do I get "maxlength" from columns(...) collection?
I see columns collection has only following properties: Attributes, DefinedSize, Name, NumericScale, ParentCatalog, Precision, Properties,... -
SQL stored procs in 8.1
I was told ver DB2 8.1 has got SQL stored proc support (unlike earlier versions where we had only the concept of expternal stored procs which need... -
Stored Outlines For Queries In PL/SQL Stored Procs
Hi, Oracle 8.1.7.3 SunOS 5.7 I would like to know how to create stored outlines for some queries I have in stored procedures. The queries may...



Reply With Quote

