|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
June 16th, 2005, 01:39 PM
|
||||
|
||||
|
Long column in cfquery
I have a query that has a long column in the select portion. When it returns more than one record, i recieve the following error:
[DataDirect][SequeLink JDBC Driver]null I'm trying to query oracle 8.0.6 with MX 6.1, so i had to create an ODBC connection to the database instead of using the oracle driver built into coldfusion. Does anybody know a way to stop the error or chop the amount of data returned from the long column? Thanks
|
|
#2
June 16th, 2005, 04:00 PM
|
|||
|
|||
|
Use one of the Oracle string functions that will return only part of the data, for example select substr( mycolumn, 1, 100 ) as truncatedColumn from....
would return the first 100 characters as "truncatedColumn".
__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian. How to Post a Question in the Forums
|
|
#3
June 20th, 2005, 11:27 AM
|
||||
|
||||
|
I tried that, substr and those functions are not allowed on long columns. anytime i try to do that i get an inconsistent datatypes error.
|
|
#4
June 20th, 2005, 12:03 PM
|
|||
|
|||
|
You could try adding toString() into the function call. Also, make sure you have the DSN set to allow long character fields in the datasource properties. If none of that works, you might want to ask in an Oracle forum.
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > Long column in cfquery |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
