No WS works , but struck with how to write the binary content into file , not
able to parse into xml
below is the output from WS
--=_Part_31_11976965.1219312819993 Content-Type: text/xml; charset=utf-8
Content-Transfer-Encoding: 8bit Content-ID: __WLS__1219312819993__SOAP__
This is a new one for me. I have been querying the same database for years. I
have hundreds of queries working on this very database on a daily basis without
issues. Today a new request came in to access a field that I have not needed to
retrieve before.
Mcaidrecda (Medicaid Recertification
not knowing much about Foxpro...
Is it case sensitive, (IE: are MCAIDRECDA and Mcaidrecda the same thing)
Tim Claremont wrote:
This is a new one for me. I have been querying the same database for years. I
have hundreds of queries working on this very database on a daily basis
without
I recently ran into an issue where the table names had to be in all caps
matching the field name in the querry. I never worried about it before
and was very confused when it happened.
Could that be the case?
Tim Claremont wrote:
This is a new one for me. I have been querying the same database
You said FoxPro which leads me to believe you might be running on Mac or
Linux. Does FoxPro have case-sensitive column names?
-Original Message-
From: Tim Claremont [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2008 10:00 AM
To: CF-Talk
Subject: Flummoxed bya simple query
This is
That was my first thought, but I even went so far as to COPY AND PASTE the
field name from the actual FoxPro database.
Also, to further confirm, I entered the IDNo field as both IDNO and idno and it
works just fine. Conclusion is that I do not believe the case to be relevent.
I recently ran
Nope. Running on a PC. I have proven to myself time and again that the
fieldnames are NOT case sensitive.
You said FoxPro which leads me to believe you might be running on Mac or
Linux. Does FoxPro have case-sensitive column names?
I've worked briefly with it at an old job. In CFMX 6 ColdFusion
connected via the ODBC bridge and there were some unusual data results.
Has someone produced a JDBC driver for FoxPro? I don't think Microsoft
supports it anymore..
Scott Stewart wrote:
not knowing much about Foxpro...
Is it
Does FoxPro have case-sensitive column names?
It could be an issue with table names, since tables are actually files,
but not for columns.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
The following queries all return the same recordcount (1161 Records):
SELECT *
FROM BASICINFO
SELECT *
FROM BasicInfo
SELECT *
FROM BaSICINFO
It could be an issue with table names, since tables are actually files,
but not for columns.
I've seen issues surrounding ColdFusion caching table structures. To fix
the problem, go into CF administrator, turn off caching for that datasource,
execute your query again, and turn caching back on.
On Thu, Aug 21, 2008 at 11:24 AM, Tim Claremont
[EMAIL PROTECTED] wrote:
The following
This is REALLY clutching at straws, but here are some stupid things you
might try:
SELECT Mcaidrecad
FROM BASICINFO
WHERE IDNo = '5183' (in case there's something about IDNo, Mcaidrecad
it doesn't like)
Or output the queryname.columnlist, and cut-and-paste from that instead
of from the db
THIS works:
cfquery name=GetAll datasource=PaceCareData maxrows=10
SELECT BasicInfo.*, Identity.*, Enrollment.*
FROM BasicInfo
INNER JOIN Identity ON BasicInfo.IDID = Identity.ID
INNER JOIN Enrollment ON BasicInfo.IDID = Enrollment.IDID
ORDER BY LastName
On Thu, Aug 21, 2008 at 11:07 AM, Tim Claremont
[EMAIL PROTECTED] wrote:
THIS Fails:
cfquery name=GetAll datasource=PaceCareData maxrows=10
SELECT BasicInfo.mcaidrecda, Identity.*, Enrollment.*
FROM BasicInfo
INNER JOIN Identity ON BasicInfo.IDID = Identity.ID
Thanks Dave,
You have given me hope. At least I am on a path that is possible. I have an
example done with curl and make but they wont allow curl on our server.
Perhaps I can mimic it with cfhttp. Would you suggest any other approach,
java, ...?
-kevin
Hey Dave Watts,
Can you use
(Sorry for the repost... didn't get any responses yesterday and I'm
really stuck here.)
Greetings!
I'm having a problem with cfgrid and I need some assistance. Whenever I
try to submit an HTML format grid with the enctype=multipart/form-data
attribute applied to the cfform tag, I receive The
You have given me hope. At least I am on a path that is
possible. I have an example done with curl and make but they
wont allow curl on our server. Perhaps I can mimic it with
cfhttp. Would you suggest any other approach, java, ...?
CF is just as good as any of these for this sort of
Funny,
I went to high school with him. Had a comp sci class with him where he
spent quite a bit of time trying to get passwords from unsuspecting people.
-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2008 6:33 PM
To: CF-Talk
Subject: Re: SQL
Every time this has happened to me, it was a caching issue. Try to remove
caching from the datasource, if that doesn't work reboot the database machine
or restart the db services. After that restart CF and see if its all better.
I having an issue with ajaxOnLoad function to use with gfgrid.
if i call a function say 'myfun' using cfset ajaxOnLoad(myfun) for a
cfgrid,
the function will work ONLY IF PUT INSIDE HEAD/HEAD tags. i need to make
that js dynamic.. please some one can help me with any tweaks that will allow
JS
Hi
i am trying to format an excel file using jxl api
however i cannot seem to work out how to set the borders and border styles. i
know it is possible as they are available in the jxl.format library but cannot
work out how to apply them to a cell
i want to set a border to think and dark blue
if i call a function say 'myfun' using cfset
ajaxOnLoad(myfun) for a cfgrid, the function will work
ONLY IF PUT INSIDE HEAD/HEAD tags. i need to make that js
dynamic.. please some one can help me with any tweaks that
will allow JS to be placed anywhere in the code ?
I'm not sure what you
I had a problem once where an CFLDAP query returned an invalid column name. It
was a similar issue where I could see it there, but I could not access it
because it had an invalid column name. I found however that I could rename it
using a method that I found on Ben Nadel's site. While your
That's not a bad idea. Have you tried aliasing the column to something else
then referencing the aliased column?
-Original Message-
From: Dan Crouch [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2008 4:19 PM
To: CF-Talk
Subject: Re: Flummoxed bya simple query
I had a problem
cfsavecontent variable=headText
your javascript stuff here
/cfsavecontent
cfhtmlhead text=#headText# /
On Thu, Aug 21, 2008 at 1:53 PM, dev losh [EMAIL PROTECTED] wrote:
I having an issue with ajaxOnLoad function to use with gfgrid.
if i call a function say 'myfun' using cfset
Worth noting that you've been able to run FarCry direct from the
webroot since the release of 5.0 earlier this year. I published a
video of installing FarCry by dropping into the webroot on OpenBD (of
all things) last weekend as fate would have it:
http://www.farcrycore.org/tv
Oh cool,
Hey Great Joy it worked !!
Thanks Charilie :)
cfsavecontent variable=headText
your javascript stuff here
/cfsavecontent
cfhtmlhead text=#headText# /
On Thu, Aug 21, 2008 at 1:53 PM, dev losh [EMAIL PROTECTED] wrote:
~|
Hi
Want to know is is possible to get the SOAP attachment returned from a web
service VIA Coldfusion .
WE tested the WSDL from SOAP UI http://www.soapui.org/ by passing the request ,
it retunred the responce along with the attachment . But we struck up when
getting the attachment VIA
Hello again. I am sorry to re-post this, but I am at my wits end, and I have
to get this server up tomorrow. Can anyone here please help me?
-Bob
Hello everyone. I am stuck and am hoping someone here can help.
I am trying to install CF8 x64 on a Windows Server 2008 x64 box.
I don't know if it will be any help at all, but here's some code for
working with jexcelapi:
http://cfjexcel.googlecode.com/svn/trunk/
Probably query2xls.cfc is what might have what you need. The
formula/label stuff, *might* be similar to borders...
It's messy and un-var'ed in places, but it
Richard White wrote:
however i cannot seem to work out how to set the borders and border styles. i
know it is possible as they are available in the jxl.format library but
cannot work out how to apply them to a cell
you need to use the Label class apply a format created using the
You're right Brad, and it's pretty strange. I even tried search with:
+-1
But Google still ignores the -
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: 09 July 2008 23:58
To: CF-Talk
Subject: RE: The error occurred on line -1
I sure hope it fixes your problem. If
32 matches
Mail list logo