The program populates a db from a text file using CFHTTP.
I used the actual program and text file from CF 5.
I couldn't find any discussion of this in LiveDocs.
This cost me several hours of frustration, as the error message is not
obviously (to me) referring to a data error.
Is there a way around this -- I really want to use the bullet char in
the text file)?
(used the same technique on a bunch of older CF sites)
TIA
Dick
Given this text file:
"","","","",""
"� Category","","","",""
note: line 2 contains a bullet character as the first char in the first
field
I get an error (below when I run the program (code snippet below).
If I change the bullet character to an asterisk, the program runs as
expected.
Here's the code snippet
47
48 <!--- READ THE CSV File - It must have an empty row (with comas) or
a title row --->
49
50 <cfhttp method="Get"
51
url=""
AdCategory_2.dta"
52 name="onerow">
53 <cfdump var="#onerow#">
Here's the error
String index out of range: 0
48 : <!--- READ THE CSV File - It must have an empty row (with comas)
or a title row --->
49 :
50 : <cfhttp method="Get"
51 :
url=""
AdCategory_2.dta"
52 : name="onerow">
Please try the following:
� Check the ColdFusion documentation to verify that you are using
the correct syntax.
� Search the Knowledge Base to find a solution to your problem.
Browser��
Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en) AppleWebKit/124 (KHTML,
like Gecko) Safari/125.1
Remote Address��
127.0.0.1
Referrer��
Date/Time��
12-Apr-04 07:08 PM
Stack Trace
at
cfPopulateAdCategory_22ecfm1618845784.runPage(/Applications/JRun4/
servers/cfmx61flex/cfusion/HTA/HomeTown1/HTA/DB_Creation/
PopulateAdCategory_2.cfm:50)
java.lang.StringIndexOutOfBoundsException: String index out of range: 0
at java.lang.String.charAt(String.java:511)
at
coldfusion.tagext.net.HttpTable.isValidName(HttpTag.java:2921)
at coldfusion.tagext.net.HttpTable.populate(HttpTag.java:2771)
at coldfusion.tagext.net.HttpTable.populate(HttpTag.java:2693)
at
coldfusion.tagext.net.HttpTag.getUrlContents(HttpTag.java:1822)
at coldfusion.tagext.net.HttpTag.connHelper(HttpTag.java:858)
at coldfusion.tagext.net.HttpTag.doEndTag(HttpTag.java:990)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1872)
at
cfPopulateAdCategory_22ecfm1618845784.runPage(/Applications/JRun4/
servers/cfmx61flex/cfusion/HTA/HomeTown1/HTA/DB_Creation/
PopulateAdCategory_2.cfm:50)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at
coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at
coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersist
enceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:
226)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:
527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:
198)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java
:451)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
