Re: CFMX Upgrade Woes - Jochem
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 PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Upgrade Woes - Bryan
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 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: "Candace Cottrell" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Mon, 17 Feb 2003 15:24:07 -0500 >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? > >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: Candace Cottrell [mailto:[EMAIL PROTECTED]] >Sent: Monday, February 17, 2003 2:51 PM >To: CF-Talk >Subject: CFMX Upgrade Woes > > >I upgraded to CFMX from CF 5 last week. Everything seemed to be going ok >until today I have gotten a bunch of calls. > >Here's the problem and I have racked my brain and caused an aneurism >trying to figure this out. > >Setup: Win 2000, CFMX Pro w/updater 1, IIS 5.0, SQL Server 2000 > >When doing a simple select, certain fields are coming up blank, even >though there is data in there. > > >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(Visit_Date,"mm-dd-")# > #PatientLName, #Patient_FName# > Visit_Type_Name# > #Visit_Description > #Patient_Phone# > #Medical_Record_No# > #Physician_LName > > > > > >Now, when I go into SQL Enterprise Manager, the data for first and last >name and visit type is there, but the data comes back as: > >10-30-2002 , MIBG SCAN @0830 937-555- 55 Broxson > >10-31-2002 , MIBG SCAN @0830 937-555- 55 Broxson > >Could this have something to do with an ISAPI filter?? > > >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] > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Upgrade Woes - Tony
You got it 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:43 PM >>> and from query analyzer they come back as values? ...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: Candace 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 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 02/17/03 15:15 PM >>> 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: Candace Cottrell [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 2:51 PM To: CF-Talk Subject: CFMX Upgrade Woes I upgraded to CFMX from CF 5 last week. Everything seemed to be going ok until today I have gotten a bunch of calls. Here's the problem and I have racked my brain and caused an aneurism trying to figure this out. Setup: Win 2000, CFMX Pro w/updater 1, IIS 5.0, SQL Server 2000 When doing a simple select, certain fields are coming up blank, even though there is data in there. 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(Visit_Date,"mm-dd-")# #PatientLName, #Patient_FName# Visit_Type_Name# #Visit_Description #Patient_Phone# #Medical_Record_No# #Physician_LName Now, when I go into SQL Enterprise Manager, the data for first and last name and visit type is there, but the data comes back as: 10-30-2002 , MIBG SCAN @0830 937-555- 55 Broxson 10-31-2002 , MIBG SCAN @0830 937-555- 55 Broxson Could this have something to do with an ISAPI filter?? 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] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Upgrade Woes
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 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 > until today I have gotten a bunch of calls. > > Here's the problem and I have racked my brain and caused an aneurism > trying to figure this out. > > Setup: Win 2000, CFMX Pro w/updater 1, IIS 5.0, SQL Server 2000 > > When doing a simple select, certain fields are coming up blank, even > though there is data in there. > > > 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(Visit_Date,"mm-dd-")# > #PatientLName, #Patient_FName# > Visit_Type_Name# > #Visit_Description > #Patient_Phone# > #Medical_Record_No# > #Physician_LName > > > > > > Now, when I go into SQL Enterprise Manager, the data for first and last > name and visit type is there, but the data comes back as: > > 10-30-2002 , MIBG SCAN @0830 937-555- 55 Broxson > > 10-31-2002 , MIBG SCAN @0830 937-555- 55 Broxson > > Could this have something to do with an ISAPI filter?? > > > 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] > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Upgrade Woes - Dr. Doom
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 the flag for returning long data set in the CF Admin? Other than the missing #s, it's all I can think of offhand. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Upgrade Woes - Tony
Is the missing data stored in text fields? If so, is the flag for returning long data set in the CF Admin? Other than the missing #s, it's all I can think of offhand. -- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -Original Message- : From: Candace 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 : 937-641-4293 : http://www.childrensdayton.org : : : [EMAIL PROTECTED] : >>> [EMAIL PROTECTED] 02/17/03 15:15 PM >>> : 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: Candace Cottrell [mailto:[EMAIL PROTECTED]] : Sent: Monday, February 17, 2003 2:51 PM : To: CF-Talk : Subject: CFMX Upgrade Woes : : : I upgraded to CFMX from CF 5 last week. Everything seemed to be going ok : until today I have gotten a bunch of calls. : : Here's the problem and I have racked my brain and caused an aneurism : trying to figure this out. : : Setup: Win 2000, CFMX Pro w/updater 1, IIS 5.0, SQL Server 2000 : : When doing a simple select, certain fields are coming up blank, even : though there is data in there. : : : 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(Visit_Date,"mm-dd-")# : #PatientLName, #Patient_FName# : Visit_Type_Name# : #Visit_Description : #Patient_Phone# : #Medical_Record_No# : #Physician_LName : : : : : : Now, when I go into SQL Enterprise Manager, the data for first and last : name and visit type is there, but the data comes back as: : : 10-30-2002 , MIBG SCAN @0830 937-555- 55 Broxson : : 10-31-2002 , MIBG SCAN @0830 937-555- 55 Broxson : : Could this have something to do with an ISAPI filter?? : : : 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] : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Upgrade Woes - Jochem
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 , MIBG SCAN @0830 937-555- 55 Broxson >>>10-31-2002 , MIBG SCAN @0830 937-555- 55 Broxson >> >>How should it come back? > > 10-31-2002 Schmo, Joe SURGERY MIBG SCAN @0830 937-555- 55 > Broxson So the fields you are missing come from different tables. Is it a coincidence that you have 2 records which appear to be identical except for the date, or are you also getting too many rows returned by the query? (Check the debug output.) Can you query the patients table and the Visit_Type table directly and get something meaningful back? >>Maybe freaky charset issues? > > Freaky charsets are the worst kind... Non-unicode charsets are the worst. But did you set up anything to make sure the charset of the database matches the charset of CF MX? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Upgrade Woes
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 > until today I have gotten a bunch of calls. > > Here's the problem and I have racked my brain and caused an aneurism > trying to figure this out. > > Setup: Win 2000, CFMX Pro w/updater 1, IIS 5.0, SQL Server 2000 > > When doing a simple select, certain fields are coming up blank, even > though there is data in there. > > > 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(Visit_Date,"mm-dd-")# > #PatientLName, #Patient_FName# > Visit_Type_Name# > #Visit_Description > #Patient_Phone# > #Medical_Record_No# > #Physician_LName > > > > > > Now, when I go into SQL Enterprise Manager, the data for first and last > name and visit type is there, but the data comes back as: > > 10-30-2002 , MIBG SCAN @0830 937-555- 55 Broxson > > 10-31-2002 , MIBG SCAN @0830 937-555- 55 Broxson > > Could this have something to do with an ISAPI filter?? > > > 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] > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Upgrade Woes - Tony
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: "Candace Cottrell" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Mon, 17 Feb 2003 15:24:07 -0500 >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? > >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: Candace Cottrell [mailto:[EMAIL PROTECTED]] >Sent: Monday, February 17, 2003 2:51 PM >To: CF-Talk >Subject: CFMX Upgrade Woes > > >I upgraded to CFMX from CF 5 last week. Everything seemed to be going ok >until today I have gotten a bunch of calls. > >Here's the problem and I have racked my brain and caused an aneurism >trying to figure this out. > >Setup: Win 2000, CFMX Pro w/updater 1, IIS 5.0, SQL Server 2000 > >When doing a simple select, certain fields are coming up blank, even >though there is data in there. > > >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(Visit_Date,"mm-dd-")# > #PatientLName, #Patient_FName# > Visit_Type_Name# > #Visit_Description > #Patient_Phone# > #Medical_Record_No# > #Physician_LName > > > > > >Now, when I go into SQL Enterprise Manager, the data for first and last >name and visit type is there, but the data comes back as: > >10-30-2002 , MIBG SCAN @0830 937-555- 55 Broxson > >10-31-2002 , MIBG SCAN @0830 937-555- 55 Broxson > >Could this have something to do with an ISAPI filter?? > > >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] > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Upgrade Woes - Tony
and from query analyzer they come back as values? ...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: Candace 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 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 02/17/03 15:15 PM >>> 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: Candace Cottrell [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 2:51 PM To: CF-Talk Subject: CFMX Upgrade Woes I upgraded to CFMX from CF 5 last week. Everything seemed to be going ok until today I have gotten a bunch of calls. Here's the problem and I have racked my brain and caused an aneurism trying to figure this out. Setup: Win 2000, CFMX Pro w/updater 1, IIS 5.0, SQL Server 2000 When doing a simple select, certain fields are coming up blank, even though there is data in there. 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(Visit_Date,"mm-dd-")# #PatientLName, #Patient_FName# Visit_Type_Name# #Visit_Description #Patient_Phone# #Medical_Record_No# #Physician_LName Now, when I go into SQL Enterprise Manager, the data for first and last name and visit type is there, but the data comes back as: 10-30-2002 , MIBG SCAN @0830 937-555- 55 Broxson 10-31-2002 , MIBG SCAN @0830 937-555- 55 Broxson Could this have something to do with an ISAPI filter?? 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] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Upgrade Woes - Bryan
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 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:26 PM >>> 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 #DateFormat(Visit_Date,"mm-dd-")# #PatientLName#, #Patient_FName# #Visit_Type_Name# #Visit_Description #Patient_Phone# #Medical_Record_No# #Physician_LName# -- Original Message -- From: "Candace Cottrell" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Mon, 17 Feb 2003 14:51:25 -0500 >I upgraded to CFMX from CF 5 last week. Everything seemed to be going ok >until today I have gotten a bunch of calls. > >Here's the problem and I have racked my brain and caused an aneurism >trying to figure this out. > >Setup: Win 2000, CFMX Pro w/updater 1, IIS 5.0, SQL Server 2000 > >When doing a simple select, certain fields are coming up blank, even >though there is data in there. > > >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(Visit_Date,"mm-dd-")# > #PatientLName, #Patient_FName# > Visit_Type_Name# > #Visit_Description > #Patient_Phone# > #Medical_Record_No# > #Physician_LName > > > > > >Now, when I go into SQL Enterprise Manager, the data for first and last >name and visit type is there, but the data comes back as: > >10-30-2002 , MIBG SCAN @0830 937-555- 55 Broxson > >10-31-2002 , MIBG SCAN @0830 937-555- 55 Broxson > >Could this have something to do with an ISAPI filter?? > > >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] > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Upgrade Woes - 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 PROTECTED] >>> [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 ;) >>Why not Updater 2? I was running out of time... >>Missing many #'s here. I got those > Now, when I go into SQL Enterprise Manager, the data for first and last > name and visit type is there, but the data comes back as: > > 10-30-2002 , MIBG SCAN @0830 937-555- 55 Broxson > > 10-31-2002 , MIBG SCAN @0830 937-555- 55 Broxson >>How should it come back? 10-31-2002 Schmo, Joe SURGERY MIBG SCAN @0830 937-555- 55 Broxson >>So if you do a Len() on the database field and >>the result is 0, an ISAPI filter is not the problem. Ok, it's coming back as a length of 0. wahhh ;( >>Maybe freaky charset issues? Freaky charsets are the worst kind... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 02/17/03 15:15 PM >>> 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: Candace Cottrell [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 2:51 PM To: CF-Talk Subject: CFMX Upgrade Woes I upgraded to CFMX from CF 5 last week. Everything seemed to be going ok until today I have gotten a bunch of calls. Here's the problem and I have racked my brain and caused an aneurism trying to figure this out. Setup: Win 2000, CFMX Pro w/updater 1, IIS 5.0, SQL Server 2000 When doing a simple select, certain fields are coming up blank, even though there is data in there. 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(Visit_Date,"mm-dd-")# #PatientLName, #Patient_FName# Visit_Type_Name# #Visit_Description #Patient_Phone# #Medical_Record_No# #Physician_LName Now, when I go into SQL Enterprise Manager, the data for first and last name and visit type is there, but the data comes back as: 10-30-2002 , MIBG SCAN @0830 937-555- 55 Broxson 10-31-2002 , MIBG SCAN @0830 937-555- 55 Broxson Could this have something to do with an ISAPI filter?? 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] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Upgrade Woes
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 Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 02/17/03 15:05 PM >>> 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, February 18, 2003 8:51 AM Subject: CFMX Upgrade Woes > I upgraded to CFMX from CF 5 last week. Everything seemed to be going ok > until today I have gotten a bunch of calls. > > Here's the problem and I have racked my brain and caused an aneurism > trying to figure this out. > > Setup: Win 2000, CFMX Pro w/updater 1, IIS 5.0, SQL Server 2000 > > When doing a simple select, certain fields are coming up blank, even > though there is data in there. > > > 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(Visit_Date,"mm-dd-")# > #PatientLName, #Patient_FName# > Visit_Type_Name# > #Visit_Description > #Patient_Phone# > #Medical_Record_No# > #Physician_LName > > > > > > Now, when I go into SQL Enterprise Manager, the data for first and last > name and visit type is there, but the data comes back as: > > 10-30-2002 , MIBG SCAN @0830 937-555- 55 Broxson > > 10-31-2002 , MIBG SCAN @0830 937-555- 55 Broxson > > Could this have something to do with an ISAPI filter?? > > > 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] > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Upgrade Woes
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 #DateFormat(Visit_Date,"mm-dd-")# #PatientLName#, #Patient_FName# #Visit_Type_Name# #Visit_Description #Patient_Phone# #Medical_Record_No# #Physician_LName# -- Original Message -- From: "Candace Cottrell" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Mon, 17 Feb 2003 14:51:25 -0500 >I upgraded to CFMX from CF 5 last week. Everything seemed to be going ok >until today I have gotten a bunch of calls. > >Here's the problem and I have racked my brain and caused an aneurism >trying to figure this out. > >Setup: Win 2000, CFMX Pro w/updater 1, IIS 5.0, SQL Server 2000 > >When doing a simple select, certain fields are coming up blank, even >though there is data in there. > > >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(Visit_Date,"mm-dd-")# > #PatientLName, #Patient_FName# > Visit_Type_Name# > #Visit_Description > #Patient_Phone# > #Medical_Record_No# > #Physician_LName > > > > > >Now, when I go into SQL Enterprise Manager, the data for first and last >name and visit type is there, but the data comes back as: > >10-30-2002 , MIBG SCAN @0830 937-555- 55 Broxson > >10-31-2002 , MIBG SCAN @0830 937-555- 55 Broxson > >Could this have something to do with an ISAPI filter?? > > >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] > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Upgrade Woes
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,"mm-dd-")# > #PatientLName, #Patient_FName# > Visit_Type_Name# > #Visit_Description > #Patient_Phone# > #Medical_Record_No# > #Physician_LName > > Missing many #'s here. > Now, when I go into SQL Enterprise Manager, the data for first and last > name and visit type is there, but the data comes back as: > > 10-30-2002 , MIBG SCAN @0830 937-555- 55 Broxson > > 10-31-2002 , MIBG SCAN @0830 937-555- 55 Broxson How should it come back? > Could this have something to do with an ISAPI filter?? I doubt it. ISAPI filter is between CF MX and the browser, not between CF MX and the database. So if you do a Len() on the database field and the result is 0, an ISAPI filter is not the problem. Maybe freaky charset issues? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Upgrade Woes
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: Candace Cottrell [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 2:51 PM To: CF-Talk Subject: CFMX Upgrade Woes I upgraded to CFMX from CF 5 last week. Everything seemed to be going ok until today I have gotten a bunch of calls. Here's the problem and I have racked my brain and caused an aneurism trying to figure this out. Setup: Win 2000, CFMX Pro w/updater 1, IIS 5.0, SQL Server 2000 When doing a simple select, certain fields are coming up blank, even though there is data in there. 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(Visit_Date,"mm-dd-")# #PatientLName, #Patient_FName# Visit_Type_Name# #Visit_Description #Patient_Phone# #Medical_Record_No# #Physician_LName Now, when I go into SQL Enterprise Manager, the data for first and last name and visit type is there, but the data comes back as: 10-30-2002 , MIBG SCAN @0830 937-555- 55 Broxson 10-31-2002 , MIBG SCAN @0830 937-555- 55 Broxson Could this have something to do with an ISAPI filter?? 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] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Upgrade Woes - correction
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(Visit_Date,"mm-dd-")# #Patient_LName#, #Patient_FName# #Visit_Type_Name# #Visit_Description# #Patient_Phone# #Medical_Record_No# #Physician_LName# 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 14:55 PM >>> I upgraded to CFMX from CF 5 last week. Everything seemed to be going ok until today I have gotten a bunch of calls. Here's the problem and I have racked my brain and caused an aneurism trying to figure this out. Setup: Win 2000, CFMX Pro w/updater 1, IIS 5.0, SQL Server 2000 When doing a simple select, certain fields are coming up blank, even though there is data in there. Now, when I go into SQL Enterprise Manager, the data for first and last name and visit type is there, but the data comes back as: 10-30-2002 , MIBG SCAN @0830 937-555- 55 Broxson 10-31-2002 , MIBG SCAN @0830 937-555- 55 Broxson Could this have something to do with an ISAPI filter?? 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] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Upgrade Woes
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, February 18, 2003 8:51 AM Subject: CFMX Upgrade Woes > I upgraded to CFMX from CF 5 last week. Everything seemed to be going ok > until today I have gotten a bunch of calls. > > Here's the problem and I have racked my brain and caused an aneurism > trying to figure this out. > > Setup: Win 2000, CFMX Pro w/updater 1, IIS 5.0, SQL Server 2000 > > When doing a simple select, certain fields are coming up blank, even > though there is data in there. > > > 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(Visit_Date,"mm-dd-")# > #PatientLName, #Patient_FName# > Visit_Type_Name# > #Visit_Description > #Patient_Phone# > #Medical_Record_No# > #Physician_LName > > > > > > Now, when I go into SQL Enterprise Manager, the data for first and last > name and visit type is there, but the data comes back as: > > 10-30-2002 , MIBG SCAN @0830 937-555- 55 Broxson > > 10-31-2002 , MIBG SCAN @0830 937-555- 55 Broxson > > Could this have something to do with an ISAPI filter?? > > > 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] > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Upgrade Woes!
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 on my part till I can test it. At 10:08 AM 6/18/02, you 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: > >ByteArray objects cannot be converted to strings. > > >The Error Occurred in /web/live/faculty_staff/index.cfm: line 13 > >11 : WHERE articleID = #variables.article# >12 : >13 : >14 : >15 : > > >I'm trying to truncate what *used to be* a text string out of my >database. Is there now some .toString() function I need to use, or >something? > >Willy > > > >- >Willy Ray >Web Applications Developer >Certified Advanced ColdFusion Developer >Westminster College > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX Upgrade Woes!
It sounds like you're running into an Axis issue that's in the queue to have a
TechNote written about it. The information that I've gotten so far is:
It's an Axis bug. xsd:base64Binary should map to byte[] in Java,
not java.lang.Byte[]. As a workaround, please use the following
UDF to convert java.lang.Byte[] into byte[].
// input type: java.lang.Byte[]
// output type: byte[]
function toByteArray(source)
{
len = arrayLen(source);
arrayClass = createObject("java", "java.lang.reflect.Array");
byteClass = createObject("java", "java.lang.Byte");
obj = arrayClass.newInstance(byteClass.TYPE, len);
for (i = 0; i lt len; i = i + 1)
{
arrayClass.set(obj, javaCast("int", i), source[i + 1]);
}
return obj;
}
That's all the info I have at this point, but hopefully it'll 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 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
-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College
>>> [EMAIL PROTECTED] 06/18/02 08:08AM >>>
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:
ByteArray objects cannot be converted to strings.
The Error Occurred in /web/live/faculty_staff/index.cfm: line 13
11 : WHERE articleID = #variables.article#
12 :
13 :
14 :
15 :
I'm trying to truncate what *used to be* a text string out of my
database. Is there now some .toString() function I need to use, or
something?
Willy
-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 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 - Willy Ray Web Applications Developer Certified Advanced ColdFusion Developer Westminster College >>> [EMAIL PROTECTED] 06/18/02 08:08AM >>> 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: ByteArray objects cannot be converted to strings. The Error Occurred in /web/live/faculty_staff/index.cfm: line 13 11 : WHERE articleID = #variables.article# 12 : 13 : 14 : 15 : I'm trying to truncate what *used to be* a text string out of my database. Is there now some .toString() function I need to use, or something? Willy - Willy Ray Web Applications Developer Certified Advanced ColdFusion Developer Westminster College __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX Upgrade Woes!
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:
>
> ByteArray objects cannot be converted to strings.
>
>
> The Error Occurred in /web/live/faculty_staff/index.cfm: line 13
>
> 11 : WHERE articleID = #variables.article#
> 12 :
> 13 :
> 14 :
> 15 :
>
>
> I'm trying to truncate what *used to be* a text string out of my
> database. Is there now some .toString() function I need to use, or
> something?
>
> Willy
>
>
>
> -
> Willy Ray
> Web Applications Developer
> Certified Advanced ColdFusion Developer
> Westminster College
>
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
