Re: ODBC error I can't explain
James Smith wrote: I am reading an excel file with an ODBC query and I am getting the following error. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Excel Driver] Too many fields defined. Can anyone explain this error, I am not sure why I am getting it. There is a limit to the number of columns you can have in a query. Chances are the driver thinks that the query is returning the maximum number of columns an excel spreadsheet can have, which I think is some thing like the magic 65535 number. I think you are looking at a maximum of 256 columns in a query. Make sure that you have ranges and columns defined in your spreadsheet to make sure that there are specific tables and columns to query. Stephen ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184368 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ODBC error I can't explain
Should be fairly self explanatory...you are passing too much information to the Datasource - it is expecting say 10 fields of data and you are passing it 11. Perform a data mapping to see what you should be passing. -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 16 November 2004 12:54 To: CF-Talk Subject: ODBC error I can't explain I am reading an excel file with an ODBC query and I am getting the following error. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Excel Driver] Too many fields defined. Can anyone explain this error, I am not sure why I am getting it. -- James Smith [EMAIL PROTECTED] ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184369 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ODBC error I can't explain
Robertson-Ravo, Neil (RX) wrote: Should be fairly self explanatory...you are passing too much information to the Datasource - it is expecting say 10 fields of data and you are passing it 11. Perform a data mapping to see what you should be passing. Wrong way around Neil. He's querying the spreadsheet not writing to it. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184371 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ODBC error I can't explain
That would be my interpretation of the error as well, however the sheet only has 1 column and that column has only 2956 records. Any other ideas? -- Jay -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 16 November 2004 12:56 To: CF-Talk Subject: Re: ODBC error I can't explain James Smith wrote: I am reading an excel file with an ODBC query and I am getting the following error. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Excel Driver] Too many fields defined. Can anyone explain this error, I am not sure why I am getting it. There is a limit to the number of columns you can have in a query. Chances are the driver thinks that the query is returning the maximum number of columns an excel spreadsheet can have, which I think is some thing like the magic 65535 number. I think you are looking at a maximum of 256 columns in a query. Make sure that you have ranges and columns defined in your spreadsheet to make sure that there are specific tables and columns to query. Stephen ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184372 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ODBC error I can't explain
James Smith wrote: That would be my interpretation of the error as well, however the sheet only has 1 column and that column has only 2956 records. Any other ideas? Still sounds like that is the problem. Although when you look at the spreadsheet it only has one column with data in it, excel has a nasty habit of saying all these x columns are actually in the spreadsheet, but empty. I can't remember exactly how the excel jdbc connector works, but couldn't you do a select COLUMN from spreadsheet, rather than select * from spreadsheet? Do you really need it to be an excel spreadsheet? If this is part of a manual process, can you save it out as a CSV and use that instead? Stephen ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184375 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ODBC error I can't explain
That would be my interpretation of the error as well, however the sheet only has 1 column and that column has only 2956 records. Any other ideas? Still sounds like that is the problem. Although when you look at the spreadsheet it only has one column with data in it, excel has a nasty habit of saying all these x columns are actually in the spreadsheet, but empty. Sorry, I wasn't clear enough, my bad. The sheet only has 1 column, all the other columns have been deleted, they are not empty, they are gone. I can't remember exactly how the excel jdbc connector works, but couldn't you do a select COLUMN from spreadsheet, rather than select * from spreadsheet? Unfortunately not, the format of the spreadsheet changes with great regularity so the first query does a select *, then presents the column names to the user for identification, this is really the only option because barcode could be expressed as bc, barcode, bar code, bcode, EAN, UPC, or any one of many other names, same goes for catalogue number (cat. No., cat number, etc...), title, etc... Do you really need it to be an excel spreadsheet? If this is part of a manual process, can you save it out as a CSV and use that instead? Unfortunately they come in to our computer illiterate staff as excel files, it is all I can do to teach them how to use a browse button, trying to get them to change to file format is not really an option. -- Jay ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184376 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54