Querying Unicode fields in SQLServer on MX
Greetings -- I am in the process of migrating a site from CF 5 to MX and my queries are not returning Unicode. I've read the bulletins about inserting and updating -- I am only trying to select [neither stored procedures nor straight CFQUERY seem to work] The data was copied directly from one SQL db to the other and the data is identical - its display is not. I have checked the string Unicode box in the administrator as well. Here is the new site: http://www.dev.hopkins-gi.org/pages/latin/templates/index.cfm?pg=disease1&organ=2&disease=25&lang_id=2&setNewLang=2 here is the original 5 version, exact same data: http://www.hopkins-gi.org/pages/latin/templates/index.cfm?pg=disease1&organ=2&disease=25&lang_id=2&setNewLang=2 HELP!!! I feel like I've tried everything.. - Emily C. Grossman - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF MX and secure IPlanet Messaging?
Our problem lies in the fact that we want users who've logged into our system to be able to login to the webmail interface without having to login again. We have session and client vars for the username and pword. Right now we pass it via javascript but it's clear text which is bad.. Can I do this with a bean? thanks, -e ----- Emily C. Grossman IMAG, Database Developer x4-2643 - ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
QUESTION: XML feed
I am pulling a file from a company that has set up an xml feed. Needless to say, sometimes the file is full of errors -- things like " cause my system to break. At first I was using ReReplace and Replace to read the file and replace the non wddx code but now it seems as if I have to plan for every potential mistake they could possibly make since I may get junk like above. Does anyone have a solution to problems like the one above? Is there any magical tool I can use? As long as their XMLfeed is clean, I can run my rereplaces and replaces and turn their non-wddx into wddx but I can't plan for these types of situations, at least not how I'm currently doing it.. ~~ 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
QUESTION: Oracle returning multi referential cursors
I have re-written an app using all stored procedures and it still runs too slow (it's a series of parent-child query loops) so I'd like to move all conditional processing to the db and run it all in one sproc... is this at all possible using referential cursors? Can I return conditional cursors? Basically either one result set, two result sets or four would return for each major record... Or am I going about this all wrong? ~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
QUESTION: sorting WDDX packet
I have two queries that pull individual employee records. The results of the two queries need to be resorted alphabetically and I'm thinking the best way to do this is by dumping them into a wddx packet and sorting -- is this possible? I cannot do a join on the queries -- they *must* be run seperately.. and I'm not on CF 5.0 yet so no query of queries.. any ideas? ~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
QUESTION: SQLServer cursors vs Oracle REF cursors..
I'm working on my first SQLServer SPROC app and I'm trying to create the equivalent of an Oracle referential cursor in my sproc but am running up against this error: ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: char is incompatible with cursor In Oracle I simply create a pointer to my ref cursor package and output the results. I have no probs getting it to run, error-free but now I am stumped. Here's my sproc -- perhaps someone has some insight: CREATE PROCEDURE dbo.testProc @curr int, @undef cursor varying output as declare @currid int, @currtitle varchar(2000) declare undef cursor for select a.ID, a.TITLE from vw_CONTENT_status a, tbl_fpContent b where a.status like 'Live' and b.id=a.id and a.id=@curr order by b.pos OPEN undef while @@fetch_status = 0 begin fetch next from undef into @currid, @currtitle end close undef deallocate undef GO I'm accessing this w/ CFSTOREDPROC and resultset but am getting this error. I can find nothing in the SQL docs about referential cursors.. Any insights appreciated! thanks, -e ~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
