Re: CFMX Upgrade Woes - Jochem

2003-02-17 Thread Candace Cottrell
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

RE: CFMX Upgrade Woes - Bryan

2003-02-17 Thread Candace Cottrell
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

RE: CFMX Upgrade Woes - Tony

2003-02-17 Thread Candace Cottrell
: 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 [

Re: CFMX Upgrade Woes

2003-02-17 Thread Candace Cottrell
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

RE: CFMX Upgrade Woes - Dr. Doom

2003-02-17 Thread Candace Cottrell
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

RE: CFMX Upgrade Woes - Tony

2003-02-17 Thread Ben Doom
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,

Re: CFMX Upgrade Woes - Jochem

2003-02-17 Thread Jochem van Dieten
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 ,

Re: CFMX Upgrade Woes

2003-02-17 Thread Frank Mamone
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

RE: CFMX Upgrade Woes - Tony

2003-02-17 Thread Bryan Hogan
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

RE: CFMX Upgrade Woes - Tony

2003-02-17 Thread Tony Weeg
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

Re: CFMX Upgrade Woes - Bryan

2003-02-17 Thread Candace Cottrell
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

Re: CFMX Upgrade Woes - Jochem

2003-02-17 Thread Candace Cottrell
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

RE: CFMX Upgrade Woes - Tony

2003-02-17 Thread Candace Cottrell
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?

Re: CFMX Upgrade Woes

2003-02-17 Thread Candace Cottrell
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

Re: CFMX Upgrade Woes

2003-02-17 Thread Bryan Hogan
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

Re: CFMX Upgrade Woes

2003-02-17 Thread Jochem van Dieten
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

RE: CFMX Upgrade Woes

2003-02-17 Thread Tony Weeg
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

Re: CFMX Upgrade Woes - correction

2003-02-17 Thread Candace Cottrell
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(

Re: CFMX Upgrade Woes

2003-02-17 Thread Matthew Walker
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

Re: CFMX Upgrade Woes!

2002-06-18 Thread Michael Dinowitz
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

RE: CFMX Upgrade Woes!

2002-06-18 Thread Debbie Dickerson
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

Re: CFMX Upgrade Woes!

2002-06-18 Thread Willy Ray
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 -

Re: CFMX Upgrade Woes!

2002-06-18 Thread todd
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: