How do I do/check this?
But did you set up anything to make
sure the charset of the database matches the charset of CF MX?
Jochem
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[EMAIL PRO
No luck... thanks for the response though :)
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 02/17/03 16:27 PM >>>
Candace, try "ctrl-0" on the columns
: Monday, February 17, 2003 3:24 PM
To: CF-Talk
Subject: RE: CFMX Upgrade Woes - Tony
They're coming back as empty strings...
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[
I've tried both :(
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 02/17/03 15:37 PM >>>
Are you using JDBC or ODBC Socket drivers?
- Original Mes
They are in varchar fields
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 02/17/03 15:55 PM >>>
Is the missing data stored in text fields? If so, is
Cottrell [mailto:[EMAIL PROTECTED]]
: Sent: Monday, February 17, 2003 3:24 PM
: To: CF-Talk
: Subject: RE: CFMX Upgrade Woes - Tony
:
:
: They're coming back as empty strings...
:
: Candace K. Cottrell, Web Developer
: The Children's Medical Center
: One Children's Plaza
: Dayton,
Candace Cottrell wrote:
>[EMAIL PROTECTED] 02/17/03 15:11 PM >>>
>> Candace Cottrell wrote:
>>
>>>Here's the problem and I have racked my brain and caused an aneurism
>>>trying to figure this out.
>
>> You should be carefull with those.
>
> I KNOW>>> IT HRRRTS ;)
It kills.
>>>10-30-2002 ,
Are you using JDBC or ODBC Socket drivers?
- Original Message -
From: "Candace Cottrell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, February 17, 2003 2:51 PM
Subject: CFMX Upgrade Woes
> I upgraded to CFMX from CF 5 last week. Everything seemed to be going ok
> u
Candace, try "ctrl-0" on the columns which are coming up empty, than mouseout to save
the nulls and then re-enter your data in the columns and mouseout again Requery the
page and cfdump.
There may be some corrupt data.
-- Original Message --
From: "Canda
dace Cottrell [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 3:24 PM
To: CF-Talk
Subject: RE: CFMX Upgrade Woes - Tony
They're coming back as empty strings...
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
Thanks Bryan, I fixed those. (I had copied those out of the original
page and made a new test page) It seems like a behind the scenes problem
versus a code problem because the app has worked great for a year, then
all of a sudden it's broken (after I upgraded).
Candace K. Cottrell, Web Developer
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 02/17/03 15:11 PM >>>
Candace Cottrell wrote:
>
> Here's the problem and I have racked my brain and cau
They're coming back as empty strings...
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 02/17/03 15:15 PM >>>
what happens when you cfdump the query?
It's a straight up table.
I dont get it because the other info from the table is selecting. (ie.
phone number, medical record number) Just the first and last names and
the view type are out of whack.
Thanks for the response :)
Candace K. Cottrell, Web Developer
The Children's Medical Center
One
Check your syntax.
You missed a few pounds
#DateFormat(Visit_Date,"mm-dd-")#
#PatientLName, #Patient_FName#
Visit_Type_Name#
#Visit_Description
#Patient_Phone#
#Medical_Record_No#
#Physician_LName
should be
#Dat
Candace Cottrell wrote:
>
> Here's the problem and I have racked my brain and caused an aneurism
> trying to figure this out.
You should be carefull with those.
> Setup: Win 2000, CFMX Pro w/updater 1, IIS 5.0, SQL Server 2000
Why not Updater 2?
>
>
> #DateFormat(Visit_Date,"m
what happens when you cfdump the query?
what do you see?
...tony
Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337
-Original Message-
From: Canda
By the way, the code shoud read:
CODE:
Select * from Visit, Visit_Type, Patients, Physicians
Where Visit.Patient_ID = Patients.PatientID
AND Visit.Visit_Type_ID = Visit_Type.Visit_Type_ID
AND Physicians.Physician_ID = Patients.PhysicianID
Order BY Visit.Visit_Date
#DateFormat(
Is your query on a table or a view? Views can get out of whack (I believe
that's the technical term) if the underlying tables are modified. Solution
is to open and resave them.
- Original Message -
From: "Candace Cottrell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday
Have you tried
There may have been a change in how CF is referencing the items in a query outside of
a CFOUTPUT or CFLOOP. Till now we've assumed that using a reference to the
queryname.columnname will always get us the first item. Maybe now we have to specify
the first item. Total speculation
help.
Deb
-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 18, 2002 10:15 AM
To: CF-Talk
Subject: Re: CFMX Upgrade Woes!
OH! I should really try to figure stuff out on my own first... Well...
it's early.
Here's the story: We're using
OH! I should really try to figure stuff out on my own first... Well...
it's early.
Here's the story: We're using MySQL and we happen to be storing this
column as a BLOB. Binary object. If I set it to medium text, it works
fine...
I'm sure I'll be running into some more stuff!
Willy
-
find(".",qGetArticle.Text,"150")
Have you tried taking the ,"150" and just making it ,150 ...?
~Todd
On Tue, 18 Jun 2002, Willy Ray wrote:
> Ok, we just moved our development platform from 5.0 to MX. This will
> probably be a first-of-many kind of post. First error we come across is
> this:
23 matches
Mail list logo