Illegal Operation in Cold Fusion Extention (CFX) 1

[mkyzar]

Illegal operation in Cold Fusion Extension (CFX)

You have attempted to refer to an invalid row/column combination of a query.

This query contains 1 rows. You can call CCFXQuery::GetRowCount to determine the number of rows contained within a query.

You can call CCFXQuery::GetColumns to determine the number of columns contained within a query.

The error occurred while processing an element with a general identifier of (CFHTTP), occupying document position (13:1) to (13:322).


Date/Time: 09/06/01 09:43:12
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; YIE6)


This is the strange message I've started getting when using CFHTTP to get the contents of a text file. Can anyone tell me what this means and point me in the right direction to fix it? It was working perfectly and then stopped. Any help is appreciated.

 

[mkyzar]

I've been digging into that text file and you were right. There were several extra commas hiding in some of the records in the description field. That was hard to catch considering there were so many records. That's been the problem all along. Thank you so much for your help!

 

[tleish]

Take a look at this CF Tag:

CSV File to Database

http://devex.allaire.com/developer/gallery/info.cfm?ID=EA497DE1-5A60-11D5-83F100508B94F85A

I've looked at the code, it looks pretty good. I modified a few lines in it to make it a little more forgiving. You may find this to be a better solution that CFHTTP.
- tleish

 

[strantheman]

Hi tleish and mkyzar

What format is the original inventory file in at the remote location? If its being exported, you might have other options than just delimited data. Is it some obscure 3rd party db software or is it main stream?

hope you dont even need this

 

[mkyzar]

The original data comes from a Paradox table used in a program called Protege from InCircuit Development. They have all their main tables password protected so there is no way for us to get the data directly from their tables. The only option given inside of Protege is to export text files. Thanks for your help

 

[strantheman]

hi mkyzar

I tried to download the demo so I could look into this, but their file is corrupt. Great!

heh, anyway... there are two possibilities. You can ask to see what all of their export options are, and maybe we have a better option.

Or, if you guys can install additional features to the Protege computer you could install a Microsoft access database and use Protege to export to a preformated table.

Ill keep looking.