Re: Database/CF easy problem for someone.
I assume I want it on one line means the output...???(correct?) Try this...(putting the output loop inside the tr tags) tr cfoutput query=getDeptR td align=center#NumberFormat(getDeptR.cono,'___')#/td td#getDeptR.Coname#/td tdcfif #getDeptR.roleid# eq 9#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 10#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 1#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 3#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 2#getDeptR.Firstname#/cfif/td /cfoutput tr of course the will give you numerous table datas ... What are you trying to do with these IFs??? since you are outputing #getDeptR.Firstname# in every instance... they seem spufluous... HTH JP Original Message Follows From: Corrine Clark [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Database/CF easy problem for someone. Date: Mon, 14 May 2001 14:11:47 -0500 Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id MHotMailBCC97A42003140043125CF1F7A8C2E7C0; Mon May 14 12:17:30 2001 Received: from houseoffusion.com ([207.31.122.140]) by www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID# 0-54969U100L100S0V35) with ESMTP id com for [EMAIL PROTECTED]; Mon, 14 May 2001 15:20:46 -0400 From [EMAIL PROTECTED] Mon May 14 12:19:19 2001 Message-id: 850102F6DB16D4119D5C0090272895E21F08CF@FSCSERVER2 I am pulling info from my database and trying to display in a table. Here is my code cfquery name=getDeptR datasource=fsc_intranet SELECT company.cono, company.coname, fsc_personnel.FirstName, fsc_personnel.employeeid, fsc_personnel.email, company_responsibility.cono, company_responsibility.roleid, company_responsibility.employeeid FROM company RIGHT JOIN (company_responsibility RIGHT JOIN FSC_personnel ON [company_responsibility].[employeeid]=[FSC_personnel].[employeeid]) ON [company].[CONO]=[company_responsibility].[CONO] Where company.cono 0 Order By Coname ASC /cfquery table cellspacing=2 cellpadding=2 border=1 tr tdFSC #/td tdFranchise/td tdController/td tdAnalyst/td tdRevenue/td td align=centerAP/td tdPayroll Processor/td /tr cfoutput query=getDeptR tr td align=center#NumberFormat(getDeptR.cono,'___')#/td td#getDeptR.Coname#/td tdcfif #getDeptR.roleid# eq 9#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 10#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 1#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 3#getDeptR.Firstname#/cfif/td tdcfif #getDeptR.roleid# eq 2#getDeptR.Firstname#/cfif/td tr /cfoutput /table Here is what displays Department Responsibilities ... FSC # Franchise Controller Analyst Revenue AP Payroll Processor 95 2JR Sheryl 95 2JR Vickie 95 2JR Crystal 95 2JR Tim 95 2JR Tony 69 AG HospitalitiesVirginia 69 AG HospitalitiesCharlie 69 AG HospitalitiesJoanne 98 ALTES Darla 98 ALTES Vickie 98 ALTES Erin 98 ALTES Shannon 98 ALTES Chris And I want it on one line. Can anyone help? Corrine Clark 316-689-0049 x 383 -- NOTICE OF CONFIDENTIALITY ~~ This message and all attachments are confidential. It is intended only for the use of the person to whom it is addressed. If the message is not addressed to you, then you should immediately notify the sender and delete this message. Any use or retransmission of this message by a person other than the intended recipient is strictly prohibited and may violate state or federal law. Franchise Services Company, LLC, its subsidiaries, affiliates, and employees, do not accept liability for any errors, omissions, corruption or virus in the contents of this message or any attachments that arise as a result of e-mail transmission. ~~ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Crystal Reports rehash
I hate to rehash this, but I have gone through the archives and cannot find what I need. I am trying to pass parameters to a crystal report, example - last name: if the HTML for last name is left blank I don't wantit as part of the crystal filter, if someone put something in the fieldI want to filter on it. ___ easy to do in CF ___ pulling my hair out on crystal reports. If someone could share the CFM page that calls the CR and passes params, AND share a simple CR that uses these params...I would be forever indebted... time is an issue.. Thank all, JP ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE and testing a list for items other than...
Hello all, I need the RE for seeing if a list ONLY contains 1/multiples of four allowable options. For instance, the allowable options are "jane,tom,sally,mark" you pass me a list. "Jane,tom,mark" or "Tom,Sally" or "Jane" all of these are OK you pass me a list. "jane,allisa,tom" this is NOT Ok and I will throw an error... How do I check this??? Preferably with RE - I suppose I could loop through every item in your list and checke it against my list - but this seems kludgie TIA JP ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Studio Project Deployment - Help
Has anyone EVER been successful in getting CF Studio Projects to 'deploy' either directly or via scripts... If so please help me out..I keep getting "No Deployment Path specified" for every sub-folder, even though I specify create new folders. jp ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Quick Reference for all standard variable scopes?
does anyone know of an FAQ or somesuch that contains a list of all available standard variable scopes? ie. File.ServerFile Session.CFID Session.CFToken etc. Here's what I've compiled over time. Variables. (local - server memory) Request. (local - server memory) 'queryname'. (local - server memory) CFQuery. (local - server memory (1 only/.executiontime)) Form. (local - action page - HTTP Body) URL. (local - target page - In URL) CGI. (global - to user - HTTP request) Cookie. (global - to user - on client) Session. (global - to user - time limit on server) Application. (global - to app - time limit on server) Server. (global - to machine - server memory) Client. (global - to user -in db or reg) Caller. (local - to calling page - server memory) Attributes. (local - to custom tag - server memory) ThisTag. (local - to custom tag - server memory) --return values "scopes"-- CFCatch. (local - server memory) Error. (local - server memory) File. (local - server memory) CFFTP. (local - server memory) CFHTTP. (local - server memory) CFStoredProc. (local - server memory) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
dates as long ints
I recall seeing this subject here in the past and can't turn up anything in the docs. Does anyone know how to cast a date value into a long interger, and what format that takes. So {ts 2000-12-02 14:23:03} would come out as 20001202142303 I don't know if that is the exact output but something similar. THX jp ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: dates as long ints
Thanks scott, but that doesn't answer the question of HOW to cast a date or date/time value into the interget format. It has been discussed here before - and that is the information I'm looking for. thanks again for your input. jp Original Message Follows From: "Scott Weikert" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: dates as long ints Date: Fri, 02 Feb 2001 09:43:54 -0700 Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id MHotMailBC442F4500A7D820F3A4CF1F7A8C1D850; Fri Feb 02 08:46:08 2001 Received: from houseoffusion.com ([207.31.122.140]) by www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID# 0-54969U100L100S0V35) with ESMTP id com for [EMAIL PROTECTED]; Fri, 2 Feb 2001 11:55:27 -0500 From [EMAIL PROTECTED] Fri Feb 02 08:46:52 2001 Message-id: 005501c08d37$563c6450$[EMAIL PROTECTED] References: [EMAIL PROTECTED] I would think, it wouldn't matter WHAT format you used, as long as it was consistent within your app, that you could extract the date from the long ints that you create without issue... --Scott - Original Message ----- From: "j p" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, February 02, 2001 9:36 AM Subject: dates as long ints I recall seeing this subject here in the past and can't turn up anything in the docs. Does anyone know how to cast a date value into a long interger, and what format that takes. So {ts 2000-12-02 14:23:03} would come out as 20001202142303 I don't know if that is the exact output but something similar. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
URGENT: getting return value from Stored Proc....HELP
URGENT: getting return value from Stored ProcHELP Happy new year - all, I have an hair puller (for me)... I need a return value from a stored proceedure, to use later in a template relocation. I can seem to get it toe work... I have tried the Cfquery/EXEC the Cfquery/Call and have decided on the Cfstoredproc tag for my uses. but I'm still not getting a return I can use. (read below fro more info) Current Code + cfstoredproc procedure="usp_AddAgent" datasource="#DSN#" dbname="PracticalHealth" returncode="Yes" cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@AgencyName" value="#Trim(Form.AgencyName)#" null="No" cfprocresult name="GetNewAgentID" resultset="2" . . . . A dozen more fields of various len/type - cfprocresult name="GetNewAgentID" resultset="1" /cfstoredproc cfoutput#GetNewAgentID.ID#/cfoutput --- Stop --- cfabort End Current Code + The SP looks something like this in logic: 1)get address types 2)insert address w/ type 3)get address id for later use 4)insert agent w/ address id 5)get agent id 6)insert sruff on your agent If I use...1...as a result set cfprocresult name="GetNewAgentID" resultset="1" I get the address recordset. (which in my mind should be (2) the second, as the 'get address types' should be #1 other than that...if I use any number other than 1, My GetNewAgentID recordset doesn't exist. Help please. jp ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Scope question
Does anyone have a breakdown of how variables are stored by CF?? i.e. Session and application scoped are stored in a structure, is this true of ALL scopes?? form. url. etc.. If not ..where and in what storage 'medium'?? Variables. Request. 'queryname'. Cfquery. Form. Url. Session. Application. Server. Client. Caller. Attributes. ThisTag. --return values scopes-- Cfcatch. Error. File. Cfftp. Cfhttp. Cfstoredproc. Thanks - Jp ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
TWO for the crew
1) Will CF conect to a mdb DS through a network connection?? If I map a dreve to a network machiene and try to connect using that drive letter in the CFA ODBC connection screen - it doesn't seem to like that?? Has anyone done this successfully? How? 2) The application.cfm template is used on all template under that directory... Shouldn't I be able to specify CFAPPLICATION on a page under that same directory - with a different app name and have that template function in it's own application scope??? This doesn't appear to be working - but it may be a timeout issue, or caching issue. Off to restrt the service to find out.. JP ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
carriage return question
carriage return question: Is it possible to use carriage returns to seperate a list??? For instance: In a form text area, if a series of lines get submitted, I want to use it as a list... This code is NOT working me: cfset Session.list = "#Replace(Trim(Form.List),'chr(13)chr(10)',',','All')#" cfoutput#Session.Methods#/cfoutput I would expect a comma delimited list... Any help??? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFFILE - writing a CF template REDUX
Maybe I mis-communicated my delima, here it is in code... I want to write a CF template using CFFILE - I know what the template will look like, but need some variables resolved. The only way I have foud to work is: 1) Set var to the entire contents of the page 2) use the lt; gt; quot; to replace these characters 3) Use a special character (I use ` ) to replace the pound signs 4) keep poound signs where a dynamic var will be resolved 5) Do a series of Replace() functions on this var before I pass it to CFFILE THERE HAS TO BE A BETTER WAY Example: Section A - is the actual page code I want to generate, with all character that cause a problem replaces with something else. This is needed beacuse a , , or " inside a CFSET (or inside teh CFFILE) will cause the tag to fail. Section B - Replaces these characters with their real character Section C - Writes the file !--- SECTION 'A' --- cfset PageCode =" lt;htmlgt;" lt;body bgcolor=quot;#variables.myBGColor#quot;gt; some page text `variables.SomeVar` lt;/bodygt; lt;/htmlgt; " !--- SECTION 'B' --- cfset ValidationError = Replace(Variables.ValidationError, "`","##", "All") cfset ValidationError = Replace(Variables.ValidationError, "lt;","", "All") cfset ValidationError = Replace(Variables.ValidationError, "gt;","", "All") cfset ValidationError = Replace(Variables.ValidationError, "quot;",, "All") !--- SECTION 'C' --- cffile action="WRITE" file= C:\...\Page.cfm" addnewline="Yes" output="#Variables.PageCode#" QUESTION: Is these a better way to do this??? More efficient? Better code? jp _ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFFILE - writing a CF template woes
Hey Gurus, I need help on this one I am having problems getting CFFILE to write a cf template... The " and probably some otherthings are causing some wierdness. I have tried Replace(), Evaluate(DE()) to no end... How does one create a new CF template with CFFILE??? Someone had mentioned calling the page with CFHTTP - but that wont do, as no coldfusion code will show up... Help Please. _ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Studio: am I missing something
doing a find and replace on a remote server (remote RDS or FTP) is it possible? _ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Encode - (Howie Hamlin??)
Hey a while back someone had a cfencoder application that helped with encoding files...I thought it was Howie. Does any one remember this - or have it?? I want to encrypt cfm files only... it is going through and doing all the files. I've tried *.cfm but it comes back as "can't find *.cfm" Help _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RegEx help PLEASE hurry...
Hello all I have a page of text that looks like this... H e l l o A l l I want to condense it to... Hello All (getting rid of one space following every character) I know I can do it with regEx in studio replace pane... but I don't know the syntax... Anyone, Anyone, Beuhler??? TIA jp _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Validate Multiple docs MORE
Using STUDIO - it is possible to validate a page (for syntax), Is there a way to do this validation on multiple pages, say across an entire project...??? jp _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Login logic...
I have a request that a user be returned to the page from wence they came - if they get rerouted to a log in screen (due to timeing out)... Or in lue of that, if a user is on a page, and they time out, then click on a link...Is there a way to use that "clicked on" link as teh destination after they log back in... Jp _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Validate Multiple docs
Can you use CF Studio to validate multiple pages?? _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Array Sort [help][please]
Hello All... I am trying to sort a multi-dimentional array. And am getting an error I've never seen before. The Setup I am querying two tables to populate a select box,Because I need to know which table the selection came from, and there will be duplicate IDs on two tables, I want to add a table identifier...So I thought I would make an array...(if you know a better way please share). I have reversed the order in which the array populates - because as far as I can tell - the ArraySort() will only do the first 'field', and I need to sort the text 'field' in alphabetical...not the IDs...(if you know a better way please share). Oh yea - one more piece of info - the text is stored in unicode on the db. === The Code cfset sql_getContent = ArrayNew(2) cfloop query="GetSubject" cfset sql_getContent[currentrow][3] = 1 cfset sql_getContent[currentrow][2] = GetSubject.Subject_ID cfset sql_getContent[currentrow][1] = GetSubject.Subject_Name /cfloop cfloop query="GetSSubject" cfset SSnum = GetSubject.recordCount+GetSSubject.CurrentRow cfset sql_getContent[SSnum][3] = 3 cfset sql_getContent[SSnum][2] = GetSSubject.SSubject_CD cfset sql_getContent[SSnum][1] = GetSSubject.SSubject_Name /cfloop cfset ArraySort(sql_getContent, "textnocase") = The Error The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. The most likely cause of the error is that you are trying to use a complex value as a simple one. For example, you may be trying to use a query variable in a CFIF tag. This was possible under Cold Fusion 2.0 but is an error under later versions. === Thanks! _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Expand Select Box (JS Question)
Is It possible through JS to expand a select box, I need to expand a select box when someone clicks on something (not the little arrow if the select box) JP _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Expand Select Box -- Take Two
I need to actually 'drop down' the selection options NOT expand the width of the select box. In other words, Click Here, and the select box drops down to display options somewhere else on the page. Jp From: "Doug Powell" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Expand Select Box (JS Question) Date: Tue, 17 Oct 2000 14:51:24 -0400 select multiple name=whatever size=10 option value=spacer-/option /select to get the size you want and then call a function to get rid of the lines such as function clearBlanks() { document.something.whatever.options[0] = null; document.something.whatever.options[0] = null; return true; } In the body tag call the function onLoad="clearBlanks() -Original Message- From: j p [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 17, 2000 1:37 PM To: CF-Talk Subject: Expand Select Box (JS Question) Is It possible through JS to expand a select box, I need to expand a select box when someone clicks on something (not the little arrow if the select box) JP _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
charactersets...in Netscape
This piece of code allows me to make sure teh browser is displaying Arabic...(IE) meta http-equiv="Content-Type" content="text/html; charset=windows-1256" This doesn't work in NN...not only that there doesn't seem to be a supported Arabic font set in NN...does anyone know of an international release that supports Arabic and / or a meta tag that will allow me to force NN into an arabic mode... Thoughts Thanks J _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
UNIX odbc ini file details
Can anyone give me an example of the unix odbc ini file - a copy of a real on would be preferable with an explanation of what the representation is... thanks J _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Experience with 'nvarchar' and foriegn languages stored in db
Does anyone out there have experience with foriegn languages being stored in a db, specifically Arabic,Katakana,Kanji or any other 2bit font language - stored n a n 'nvarchar' field. I am getting this type of output. ÇáÃÑÏä ÇáÇãÇÑÇÊ ÇáÈÍÑíä ÊæäÓ It is srored in the db like this (I think)...ant thoughts - what should I be looking for.. j _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Experience with 'nvarchar' and foriegn languages stored in db
Richard I need to go the other way - unicode to language... jp From: "Richard Ramos" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Experience with 'nvarchar' and foriegn languages stored in db Date: Mon, 9 Oct 2000 14:19:11 -0700 Convert the characters into unicode values, ie. #12345;. Converting characters is easily done in Frontpage. just paste the text in and preview. When you look at the text again, it will be in unicode values. Richard Ramos Network Administrator Softitler Net, Inc. www.softitler.com [EMAIL PROTECTED] - Original Message ----- From: "j p" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, October 09, 2000 1:54 PM Subject: Experience with 'nvarchar' and foriegn languages stored in db Does anyone out there have experience with foriegn languages being stored in a db, specifically Arabic,Katakana,Kanji or any other 2bit font language - stored n a n 'nvarchar' field. I am getting this type of output. ÇáÃÑÏä ÇáÇãÇÑÇÊ ÇáÈÍÑíä ÊæäÓ It is srored in the db like this (I think)...ant thoughts - what should I be looking for.. j _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Going Insane...IIF
Shouldn't these do the same thing (IIF more effeciently)...IIF is bombing I have tried it w/ and w/o the delayed eval DE()... #IIF(Len(conv_data.BankingSpecificLoansDeposits), conv_data.BankingSpecificLoansDeposits, DE(''))# cfif len(conv_data.BankingSpecificRating)#conv_data.BankingSpecificRating#cfelse''/cfif ERROR- An error occurred while evaluating the expression: #IIF(Len(conv_data.BankingSpecificLoansDeposits),conv_data.BankingSpecificLoansDeposits,DE(''))# Error near line 428, column 6. An error has occurred while processing the expression: The reason for the error is unknown. The error occurred while processing an _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Going Insane...IIF (answer)
OK OK found it..needed a NULL #IIF(Len(conv_data.BankingSpecificLoansDeposits), conv_data.BankingSpecificLoansDeposits, DE('NULL'))# From: "j p" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Going Insane...IIF Date: Fri, 06 Oct 2000 10:24:28 CDT Shouldn't these do the same thing (IIF more effeciently)...IIF is bombing I have tried it w/ and w/o the delayed eval DE()... #IIF(Len(conv_data.BankingSpecificLoansDeposits), conv_data.BankingSpecificLoansDeposits, DE(''))# cfif len(conv_data.BankingSpecificRating)#conv_data.BankingSpecificRating#cfelse''/cfif ERROR- An error occurred while evaluating the expression: #IIF(Len(conv_data.BankingSpecificLoansDeposits),conv_data.BankingSpecificLoansDeposits,DE(''))# Error near line 428, column 6. An error has occurred while processing the expression: The reason for the error is unknown. The error occurred while processing an _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Urgent Help needed!
I have never had a problem inserting null values into a db table that accepted null values before this. This below data chokes at the first NON-text blamk comma. The rub - it's a money field (SQL 7) and I can't use ''. Any ideas... 'Alda','Update','','ALDA','','',132860.0,0.48,0.45,0.45,0.46,63086.0,87.02000-01-01 00:00:00,1900-01-01 00:00:001900-01-01 00:00:001900-01-01 00:00:001900-01-01 00:00:00,, _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cftransaction failed notification
Is there a way to know (programatically - not looking at the db) if the queries in a cftransaction were successful? Does cftransaction return a failed code??? If not - does cftry/catch offer a way of knowing if the inserts were completed??? THX _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Does cftransaction return anything??
I need to be able to tell if the transaction block rolled back or committed...is there a way to do this??? Programatically NOT by looking in the db. JP _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
DSN locking options...HELP
Hello All, I am connecting to an Excel SS as a datasource, and I need to upload a fresh SS file once a day, the problem arises on the upload...The file (by the same name) uploads without throwing an error (using CFFTP to do so) BUT any queries to the DS return the OLD data...If I go into the CF Admin and disconnect and reconnect...then the new data shows up. I have the "Maintain database connections" un-checked and the Timeout set to "1 min" (Waiting over 1 min yields no difference from the above scenerio) HELP! TIA - JP _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
DSN locking options...(2)
Changing from excel to Access isn't an option, this is syndicated info provided in excel. However - you make it sound like Access can 'automatically' link to an excel file, and that access file can be used as the DSN...can you explain this a little better. No caching no where. From: "Gregory Harris" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: DSN locking options...HELP Date: Tue, 03 Oct 2000 10:16:04 -0700 The nice solution to this would be to replace the Spreadsheet w/an Access database, and use DDE to let Excel upload the spreadsheet data directly to access. However if you must use a CF solution, I would check to make sure that you aren't using query caching (the cachedwithin or cachedafter attributes in CFQUERY are your clue). Also there is some sort of "buffer" setting in the Cfadmin that needs to be set to zero if I recall. Can't remember it offhand, but hope some of this helps... Gregory Harris Los Angeles Information Technology Agency (ITA) [EMAIL PROTECTED] [EMAIL PROTECTED] 10/03 9:55 AM Hello All, I am connecting to an Excel SS as a datasource, and I need to upload a fresh SS file once a day, the problem arises on the upload...The file (by the same name) uploads without throwing an error (using CFFTP to do so) BUT any queries to the DS return the OLD data...If I go into the CF Admin and disconnect and reconnect...then the new data shows up. I have the "Maintain database connections" un-checked and the Timeout set to "1 min" (Waiting over 1 min yields no difference from the above scenerio) HELP! TIA - JP _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Math Question
To the great CF masses... I need a math formula that will tell me what 'X' is. Example: 75 is 80% of X 100 is 25% of X Any mathmaticians out there... jp _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
File Compare
Dose anyone have a good way to do a file compare??? (via CF) _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.