RE: Mail Distribution Loop Error
I had the same issue twice this week. E -Original Message- From: Lee Surma [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 11:17 AM To: CF-Talk Subject: Mail Distribution Loop Error Our email server is bouncing some CF Emails with the following error: 07-Dec-2000 10:09:37 -0600 Distribution loop detected It almost looks as if CF is sending the same message twice. Any ideas? _ Lee Surma Public Radio International [EMAIL PROTECTED] 612-330-9223 _ ~~ 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
Process Time Variable WAS Re: Caching Queries......
Ya know what'd be nice? A variable that outputed the time it took to process the page from the begining to the point you output the variable. I currently do this with two lines of code, one's the first line of applicaiton.cfm and the other is at the bottom of the output. but still... a variable would be nice. --- defective david http://defective.net - Original Message - From: "David Shadovitz" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, November 26, 2000 8:43 PM Subject: Re: Caching Queries.. What is cf_timer? Why not just print out CFQUERY.ExecutionTime ? -David On Mon, 27 Nov 2000 14:23:06 +1100 "Scott, Andrew" [EMAIL PROTECTED] writes: I am a little confused on this, this is something I haven't dealt with much... So forgive me if I don't understand. Anyway I have done the following as a test. cf_timer CFQUERY NAME="ASTest" DATASOURCE="anything" cachedwithin="#CreateTimeSpan(1,0,0,0)#" select * from bp_modules /CFQUERY /cf_timer cf_timer CFQUERY NAME="ASTest" DATASOURCE="anything" cachedwithin="#CreateTimeSpan(1,0,0,0)#" select * from bp_modules /CFQUERY /cf_timer The intersting thing is that, sometimes the second query returns the time it should have executed other times it returns 0ms like you would expect a cache to return This to me appears that either the logic of how it works is wrong in what I think it does, or that there is a bug in the query caching. ~~ 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: CF Salary info
:) Good question! I know people who works for 50$ per month and it is pretty good salary. Try to clarify at least country/city - Original Message - From: "C Kong" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 08, 2000 9:48 AM Subject: CF Salary info new to the forum here and new to coldfusion period. excuse the tacky question, but i was wondering what a CF beginner , intermediate level, and senior level CF programmer can make in terms of salary out there. company versus free-lance? also anyone have any opinions on how the growth of CF and the internet in the future will affect these salries? thanks in advanced colin ~~ 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: Help!!! Cooke Monster!!
You'd have to set the cookie domain to .beachin.net, otherwise only
test.beachin.net could read it (or subdomains of test).
-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 9:58 AM
To: CF-Talk
Subject: Re: Help!!! Cooke Monster!!
If you use CFCOOKIE, there is a domain attribute.
If you set a domain cookie from: test.beachin.net
You should be able to read it from *.beachin.net
It looks as if you are doing it correctly, but I haven't used the
meta tag syntax to set cookies, so I can't be sure. If you drop down to
CFCOOKIE, make sure you do not use CFLOCATION on the same page.
Emmet McGovern wrote:
Is there a way to set up a cookie on one domain and read it from another
domain? I have 2 servers, one is unix and the other is cf. I need to
secure the cf server by only allowing access to it if a cookie has been
set
by the linux server, only im having problems reading the cookie on the cf
side. The linux servers domain would be content.beachin.net while the cf
server is files.beachin.net
right now im trying to meta set the cookie on the unix server
(content.beachin.net)
META HTTP-EQUIV="Set-Cookie" Content= "beachfile=10";
domain=".beachin.net"
and check its existence on the cf server (files.beachin.net) with
cfif isdefined("cookie.beachfile")
blah blah blah
/cfif
Am i doing something wrong? Or should i be doing this another way?
Thanks,
Emmet McGovern
Systems Admin
Byte Size Inc.
~~
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: Server Administrator isn't working
Larry, Thanks for the answer. I'm using the Personal Web Server that came with Windows ME. Should I try an other one? Penny - Original Message - From: "Larry C. Lyons" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, December 07, 2000 7:29 AM Subject: Re: Server Administrator isn't working Penny, From the sounds of it, you don't have a web server installed. According to what has been said on a couple of other news groups, ME does not work, or doesn't work very well with M$ IIS or PWS. You'd probably be better off installing Win98SE (if you must go for a "consumer" type operating system), or better yet Win2000 or NT. regards, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- Penny Hutten wrote: Hello Marius, I saw you email on cf-talk and have not been able to post yet on it. My post keep comeing back. I just loaded CF sever on my Windows ME system at home and the Administrator of CF Server will not open in Windows ME but it will in NT. It displays a download box which will not let me view the web page. I have installed CF 4.5. Would you know anything about this? Penny Hutten Web Development (707)887-7598 ~~ 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
application.cfm Weirdness
Just discovered something that strikes me as _really_ odd. I began developing a small application and defined an application.cfm file that only contained a couple of constants (in the variables scope). Something like: cfset logdir = "d:\logs" cfset cflf = Chr(13) Chr(10) Now the first thing I had to do was run a small template that hashed through about 30,000 text files and made entries into a database. After some preliminary testing, it looked like the script would take 30 to 45 minutes to run. No problem. I launched it with a sufficiently large RequestTimeout set in the URL and began to work on some other parts of the application. After some more work I realized I didn't need an application.cfm file for this small app, and indeed I wanted to use the application.cfm in the directory immediately above my app. I still needed the constants defined, so I renamed 'application.cfm' to 'globals.cfm' on the server, intending to include the file at the top of all templates. About 10 seconds later, in the browser window running my 45 minute template, an error pops up saying the variable 'logdir' is no longer defined. I can't imagine how, after running for ten minutes, a variable in the variables scope should suddenly become undefined. Any reasonable explanations? This seems really strange, as I thought application.cfm was simply included at the top of each template and executed once. The template being run contained no cfincludes and no references to custom tags. Jim ~~ 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
Distributed computing ideas
I just joined that CFGames list over at eGroups: http://www.egroups.com/group/cfgames I just blurted out some ideas I've been having from distributed games via CF... and I figure it'd be best to post my other, non-games, distributed ideas here: 1) Aggrigated stats. We could band together to share stats information with each other so we'll all know on a broader scale what browsers and OSes are being run. You could set it up in such a way that you couldn't tell which stats belonged to which site. One big WDDX packet that gets added to/deleted from (old info) every night. ...or a central server, but that's not so anonymous. 2) People to block. This would best be done with a central server. Of course people would be putting in people they don't like... so you specify which people you trust to tell you who to block, and you can recieve a WDDX packet every night with add/deletes. (or just the whole thing). I'd be willing to host this (with and Access DB) until it gets too big or popular. 3) This one I know will probably never take off... but I remember a service called adult check that adults would pay a fee to have an adult check account and that verified their age with adult content sites. If someone signed up for an account off your link, you got a commission. Well, here's a twist on that: someone signs up to be a member of the ABC network of sites. They pay a monthly fee. This allows them to get into the members only area of these sites. Sites could be paid by the percentage logins they've (or pages viewed) were your site. So if 50% of the logins Joe Shmo made last month was your site, you get 50% of his monthly fee for that month. You could pay sites only when they reach a minimum, and make money on the float. OR, if it was more of a community effort, everyone could get paid automatically with PayPal, even use PayPal for the CC charging. I am very interested in helping to manage and develop this project. 4) Another idea I've been tossing around is a CF banner exchange that can handle text ads (and media other than images) *without* javasript for those wanting to do banner trading with WAP, email, or sites that pander to WebTV and the like. Problem is... this is very proned to tampering. Everyone would have to be on the honor system. 5) Here's a not so serious one. A quotes database that you can query and update. You can get quotes posted by certain people, by certain authors, places in specific categories. How many times did you want a rotating random quote on your site but didn't want to maintain a DB. You could query 100 a day, cache it, rotate them, query the next 100 the next day. I couldn't host this cause this would be best done with a DB better than Access and that's the best I can do right now. --- defective david http://defective.net ~~ 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
Read client text file from web server
Hello all, I am creating a log analyzer cfm page for an internal db application, and I've got a question about cf pages reading files. When I view the page locally, I am able to read the log files just fine as is when I use input tyep="file". However, when I uploaded this page to my web server, or when I asked somebody to test my page, it didn't work because the log file they specified is not physically located on my machine. This makes sense to me. So to get around this, I have the page do a file upload to a temp dir, and then read the file from the temp dir. All is well. And now for my question. Is there any way for me to make a CF page that will read a user specified file without having to upload it to the server 1st? E ~~ 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
links (oops)
apologies http://u8ntcn0.com/scrap/newdirectory/newindex.cfm ~~ 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
links
Thank you all for all the many links you have posted. Here is an "ordered" list of my 200 favourites. ~~ 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: coldfusion bug
Naw. It's a bug in Studio. Happens here occasionally and I'm the only developer, and I don't have two copies open. best, paul At 06:32 PM 12/7/00 -0500, you wrote: Someone else has the file open, and made a change, or you have 2 copies of the file open, and made a change to one without looking at the other. Happens a lot in multi developer environments. ~~ 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: Reverse Look up on IP address
Duane, Within Allaire's Tag Gallery there is a tag named nslookup. I use it all the time. It's pretty straight forward. Dan - Original Message - From: "Duane Boudreau" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, December 07, 2000 11:44 PM Subject: Reverse Look up on IP address Is there a way to do a reverse look up on an IP address and see who it is registered to? TIA, Duane Boudreau CFExperts.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
RE: Reverse Look up on IP address
Is there a way to do a reverse look up on an IP address and see who it is registered to? Several. It's a simple little NT function call to look up an ip. But if you want the actual mailing address of the owner :) you'll have to then strip the domain name and do a whois call (use CFX_TCPClient or CFX_NicName or any of a dozen other tags.). Then you have to decode the whois text returned. Some registries like Russia's are very easy to handle. Internic's format... well, "sucks" as far as reliable field decoding. It's apparently only for human readable. --min ~~ 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
adsi cfx example
Someone from the list (forget who, sorry) asked about an example of ADSI for CFX's the other week. While I was rebuilding ihtk 3.7 a while ago I went ahead and let the script bundle the full c++ source to CFX_NetworkTopology. What the hell. :) If I had the time, I'd completely write the code, but if you've struggling with it, hey, it's a starting place. --min ~~ 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: wddx -- SQL Server 7 ?
1. CFLOOP through structure in CF, doing insert statements (I won't do this: too many db calls from CF). you could loop thru inside just one cfquery remembering to wrap the whole mess in SET NOCOUNT ON/OFF block. 2. Use CF to create a large string, pass that to stored proc, parses and loop through with inserts. I can do this. sql is not too good at this. 3. Create wddx packet, send that to a stored proc somehow. This is what I'd like to do. you're a bit ahead of your time w/this. what you're after is i guess "updategrams" that kinda work (i know of no production sites doing this) in sql server 2000. in any case, see this article: http://msdn.microsoft.com/library/periodic/period00/TheXMLFiles.htm ~~ 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: How to input Chinese character in CF studio
i tried doing in Studio directly, but it seems unstable. what i did was to input in Notepad, then turn off the chinese software, eg. ChineseStar, and then cut paste the codes to studio. ken - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, December 08, 2000 5:58 AM Subject: OT: How to input Chinese character in CF studio Hi, I have the Chinese input method, so I can type Chinese in Notepad. But how to do that in CF studio? I got "??" when type in Chinese. Thanks! Hong ~~ 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: Dynamic Verity
Can I use verity for searching content that I store in database tables ? Yes! Try something like this; First, create a new, empty collection... CFCOLLECTION ACTION="create" COLLECTION="YourCollectionName" PATH="LogicalPath" Then run your query, and "update the collection. CFQUERY DATASOURCE="YourODBCDatasource" NAME="YourQueryName" Select * From YourTable /CFQUERY CFINDEX ACTION="update" COLLECTION="NewCollection" TYPE="Custom" QUERY="YourQueryName" KEY="IndexedDatabaseField" BODY="FieldToIndex" CUSTOM1="ExtraField" If you like, there are another 11 Verity pages here: http://cfhub.com/advanced/verity/index.cfm and a "Verity Manager" (large) here: http://cfhub.com/tutorials/verity/ either way, using Verity for your database fields fields will speed things up for you : ) ~~ 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: Server Configuration Question
7 Dec 00 1100 I need to get an answer on this ASAP today. We have a server with this configuration. Win2000 Server SP 1 IIS 5 As found on CD CF 4.5.1 SP2 Oracle 8.1.6 Client 2 CFX Tags PGP and Graphics (GifGid) Basically, I need to know what the Stability is expected to be with this configuration. How this set-up will effect the Speed. Any Known Memory Leaks that may be of concern to me with this configuration. Any issues with the use of Auto Locking Session Variables, instead of explicitly locking them. i.e. I don't want to do a whole lot of recoding at this time. In case you haven't joined CF-Server yet... Put Oracle on another server - the database server will eat memory, and CF will try (if configured properly) to use memory rather than HD, so they'll end up fighting for the memory In the long run, having a dedicated database server is a life saver for speed and stability Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: ODBC errors with MS Access after MDAC 2.6
MDAC 2.6 does not include Microsoft Jet, the Microsoft Jet OLE DB Provider, the Desktop Database Drivers ODBC Driver, or the Visual FoxPro ODBC driver. If you are installing MDAC 2.6 and also need to install the Jet components, you can download a redistributable version of Jet 4.0 Service Pack 3 Hope this helps. N ! --- Neil Clark Senior Web Applications Engineer ColdFusion / Spectra / XML mcb digital [Allaire Premium Partner] Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] http://www.mcbdigital.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
JAVA CFX sample tags
Does anybody have any sample JAVA CFX tag(s) with source to get a beginner (me) started? thanks dave --- dave fauth [EMAIL PROTECTED] "The opinions expressed here are my own and not those of DOMAIN technologies, inc." ~~ 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
Best sites for CF Job Listings?
What are the best sites for CF job listings, also I am in upstate NY, (for Now) TIA Michael ~~ 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: Setting up CF on Windows ME
What problems have you had with IIS and PWS? The setup from Allaire auto configures PWS/ISS At 07:01 PM 12/07/00 -0500, Jeffry Houser you wrote: www.apache.org I just set up Apache and ColdFusion on Windows ME. I had no problems, and had everything up and running in an hour. Allow for more time if you've never set up Apache, however if everyone is having so many problems with IIS / PWS this is an alternative. -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant Cold Fusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Acoustic Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- Promise me no dead end streets, and I'll guarantee we'll have a road ~~ 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: Best sites for CF Job Listings?
The best sites that I have found are monster.com and computerjobs.com.(computerjobs.com actually runs on CF) I think you will find that these sites usually contain the same info as "Cold Fusion Only Sites" with a few exceptions. - Original Message - From: "Michael" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 08, 2000 5:27 AM Subject: Best sites for CF Job Listings? What are the best sites for CF job listings, also I am in upstate NY, (for Now) TIA Michael ~~ 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: Big companies using CF
What sort of server setup did you have? What OS? Was this a cluster? We had CF4.0 on one machine (Win2K), SQL7 on another Win2K box, and 12 media servers all Win2K. 4 eastern US 2 central US 3 West coast 1 in Australia 1 in Taiwan 1 in western Europe. We had between 20,000-25,000 sessions going at any one time. We were not expecting such an interest. As you can probably tell, this was an internal webcast. We did have some problems, but these were not related to CF. Had more to do with the stream, bandwidth issues. The live media portion of the site had an embedded media player and slides from the presentations were pushed out to the users via an admin interface. We did another one this past Tuesday with the same setup but this one only had ~15,000 users. Tim Bahlke ~~ 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
Structure comparison
Does anyone have code (or is there a function I've overlooked) to compare two structures and verify that they're logically identical? Thanks --- Martin Herbener [EMAIL PROTECTED] Kentucky Department of Education ~~ 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: List w/ delims
You CAN use multiple characters as list delimiters...eg. "|*|". I do it frequently to cut down on the chances that one of my list items contains a delimiter. Jeff Britts ColdFusion Engineer e-Dialog -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 2:21 PM To: CF-Talk Subject: Re: List w/" " delims Keep in mind that list delimiters can only be 1 character. -- Billy Cravens [EMAIL PROTECTED] Eric Fickes wrote: Got a List question for you. I've got a text file that I need to parse and it's " delimited list, in a way. The list format is this. "Full Name" "Email Address" "Group List" "Login Name" "Demo user for startup" "" " 1;" "Demo" I was hoping to somehow use " " as a delimeter, but that's not working. When I do that it takes out the spaces in the column names. I'd like to take "Full Name" "Email Address" "Group List" "Login Name" and turn it into Full Name,Email Address,Group List,Login Name Any ideas? E ~~ 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 java object
can I call a java object on a remote machine? or does the object have to be on the same machine as CF? ~~ 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: coldfusion bug
It's a bug in studio. I get it all the time. You can click yes, or no .. it doesn't make a difference as long as you are sure someone else didn't change anything. Todd Ashworth - Original Message - From: "Michael Thomas" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, December 07, 2000 7:24 PM Subject: RE: coldfusion bug | Sounds like someone else was making changes to that document at the same | time that you were. When they saved it you went to make changes it | prompted you to see if you would like to refresh the page to make sure it is | the current template. | | | From: kwasi [EMAIL PROTECTED] | Reply-To: [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Subject: RE: coldfusion bug | Date: Thu, 07 Dec 2000 18:31:51 - | | I am using ColdFusion 4.5 SP2, on Windows 2000. | | I copied this phrase: cfif #parameterexists(accept)# is 'yes' | | and when I went to paste it, this was pasted. | | --- | Warning | --- | Another user or process has modified document | "C:\Inetpub\wwwroot\web\wwwroot\imediabriefnew\RFI\Tender\adminviewtender.c f | m." Do you wish to reload it? | --- | Yes No | --- | | Any suggestions as to why this happens. | | | I would greatly appreciate your reply. | | | Kwasi Date-Bah ~~ 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
Locking CFHTTP
Can someone please tell us what the correct locking is for CFHTTP calls ~~ 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: Bulk imports into database
Does this command only work with 4.5? I am using 4.0. - Original Message - From: "paul smith" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, December 04, 2000 9:17 PM Subject: Re: Bulk imports into database I use the following for BULK INSERTs cfquery name="InsertInitial" DATASOURCE="#DSN#" USERNAME="#user#" PASSWORD="#pass#" BULK INSERT Victor FROM 'D:\FR\FileResource\101-200.csv' WITH ( FIELDTERMINATOR=',', ROWTERMINATOR=' ' ) /cfquery Very fast! best, paul At 03:06 PM 12/4/00 -0600, you wrote: Actually, Enterprise Manager is just a front-end to SQL Server, and you'd want to automate the "back end", not the "front end". For SQL Server, take a look at "BULK INSERT" (look in the Books Online). It allows you to take a text file containing your data, and bulk insert that data (duh) into a table you specify. The syntax is a bit trickier than that, but fairly simple. ~~ 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: oracle sysdate time
I think timeformat(date_field_name), "hh:mm:ss") will help. -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 8:31 AM To: CF-Talk Subject: oracle sysdate time anyone know how to get the time part of an oracle date field to show up in a result. I have a table where "date_entered" is the primary key and when I query it in oracle developer I see the time (hh:mi:ss)part but not in CF. createodbcdatetime() does not work ~~ 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: List w/ delims
Why Not use the replace command CFSET X=Replace(x,chr(34) chr(32) chr(34),",","ALL") This should replace all " " with , all you have to deal with are the " at the start and end which can be donw with CFSET X=Replace(x,chr(34),"","ALL") Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Jeff Britts [mailto:[EMAIL PROTECTED]] Sent: 08 December 2000 13:29 To: CF-Talk Subject: RE: List w/" " delims You CAN use multiple characters as list delimiters...eg. "|*|". I do it frequently to cut down on the chances that one of my list items contains a delimiter. Jeff Britts ColdFusion Engineer e-Dialog -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 2:21 PM To: CF-Talk Subject: Re: List w/" " delims Keep in mind that list delimiters can only be 1 character. -- Billy Cravens [EMAIL PROTECTED] Eric Fickes wrote: Got a List question for you. I've got a text file that I need to parse and it's " delimited list, in a way. The list format is this. "Full Name" "Email Address" "Group List" "Login Name" "Demo user for startup" "" " 1;" "Demo" I was hoping to somehow use " " as a delimeter, but that's not working. When I do that it takes out the spaces in the column names. I'd like to take "Full Name" "Email Address" "Group List" "Login Name" and turn it into Full Name,Email Address,Group List,Login Name Any ideas? E ~~ 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: oracle sysdate time
have you used dateformat around the field? dave -- Original Message -- From: Alex [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 08 Dec 2000 07:31:24 CST anyone know how to get the time part of an oracle date field to show up in a result. I have a table where "date_entered" is the primary key and when I query it in oracle developer I see the time (hh:mi:ss)part but not in CF. createodbcdatetime() does not work ~~ 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: Setting up CF on Windows ME
What problems have you had with IIS and PWS? The setup from Allaire auto configures PWS/ISS We've had 2 ME machines that would install PWS but wouldn't run them, they'd just sit there and do nothing as though it wasn't installed With IE5.5, cookies are another problem as well Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: Server Configuration Question
There are multiple variables that will determine the stability of your application: The hardware you have: If you have quadruple processors with over 512mb of RAM, it will be better than if you just have one processor with 128mb The type of traffic you are expecting to receive. Talk to your client and assess their needs and worst case scenarios (1 million hits per second :( ) The type of application you are hosting: If it is centered in database access, then you better make sure taht your database is layoud out and designed optimally. Here is where most of your scalability and performance issues will reside. Another rule of thumb is to install as few programs in the server as possible.This not only helps your system concentrate on the tasks it need s to acomplish with no background or foreground apps to run, but will also be safer: There are many applications out there that have security holes leaving your system vulnerable to attacks (MS Office, REALAudio, MS Windows Media, etc.) Godd Luck! - Original Message - From: "Philip Arnold - ASP" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 08, 2000 5:19 AM Subject: RE: Server Configuration Question 7 Dec 00 1100 I need to get an answer on this ASAP today. We have a server with this configuration. Win2000 Server SP 1 IIS 5 As found on CD CF 4.5.1 SP2 Oracle 8.1.6 Client 2 CFX Tags PGP and Graphics (GifGid) Basically, I need to know what the Stability is expected to be with this configuration. How this set-up will effect the Speed. Any Known Memory Leaks that may be of concern to me with this configuration. Any issues with the use of Auto Locking Session Variables, instead of explicitly locking them. i.e. I don't want to do a whole lot of recoding at this time. In case you haven't joined CF-Server yet... Put Oracle on another server - the database server will eat memory, and CF will try (if configured properly) to use memory rather than HD, so they'll end up fighting for the memory In the long run, having a dedicated database server is a life saver for speed and stability Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: Order By Random?
Sure. Generate a random number in CF and run a SWITCH/CASE to determine which table column to order by. Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Craig M. Rosenblum [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 3:24 PM To: CF-Talk Subject: Order By Random? Is there any way to have a query give the results in random order? This is for Oracle... ~~ 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
structures always serialized to WDDX the same way?
Does anyone know if structures that are serialized to WDDX are always arranged the same way? That is, if I create a structure, adding keys and values in a certain order, then create another structure using the same code (but not by doing a Duplicate or StructCopy), and serialize them both, will the serialized versions string-compare as identical? The docs say that StructKeyList and StructKeyArray "do not return the keys in any particular order", so I can imagine that the WDDX versions might be arranged differently. Any experience? thanks --- Martin Herbener [EMAIL PROTECTED] Kentucky Department of Education ~~ 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: wddx -- SQL Server 7 ?
Thanks Paul and David, Paul, the updategram sounds about right, although I'll have to read more in depth. Wish I had SQL 2000. David, I cannot just insert - although I didn't specify this in my message originally, I need to insert (non-xml) into multiple fields, and I don't even know which fields ahead of time. This latter part had me worried until I remembered the dynamic evalulation functionality with sp_executesql inside a stored proc. I'll have to experiment with performance on the NOCOUNT thing and having SQL do a little parsing work. Thanks again! Mark Mark Wimer, Bird Point Count Database American Bird Conservancy, c/o USGS-Patuxent Wildlife Research Center 12100 Beech Forest Road, Laurel, MD 20708-4038 Ph: 301-497-5596 Email: [EMAIL PROTECTED] 1. CFLOOP through structure in CF, doing insert statements (I won't do this: too many db calls from CF). you could loop thru inside just one cfquery remembering to wrap the whole mess in SET NOCOUNT ON/OFF block. 2. Use CF to create a large string, pass that to stored proc, parses and loop through with inserts. I can do this. sql is not too good at this. 3. Create wddx packet, send that to a stored proc somehow. This is what I'd like to do. you're a bit ahead of your time w/this. what you're after is i guess "updategrams" that kinda work (i know of no production sites doing this) in sql server 2000. in any case, see this article: http://msdn.microsoft.com/library/periodic/period00/TheXMLFiles.htm ~~ 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: PL/SQL
We use cf and pl/sql stored procs extensively. What exactly are you trying to do? Jeff Britts wrote: Anyone have any luck running PL/SQL through ColdFusion? The simple stuff seems to work ok, but if you throw it something complex it chokes. Jeff Britts ColdFusion Engineer e-Dialog ~~ 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
Form Validation Question
This is sort of confusion to explain, but I will try. I'm attempting to validate a form using the example in MASTERING COLD FUSION 4, pg 390, ex 15.4. Of course the book example is ultra simple. 3 easy text fields, submits to another script that validates by checking to see if value is zero. This is Cold Fusion validation by the way, no Java Script. I would have used, client side JavaScript but could not get CFSELECT to give the popup using the simple message attribute. I know there are other ways w/JavaScript but I'm deep into this way and I think I am close. So, submit the form and then the next script checks for zero values. If a zero value is found, a "you messed up" message is generated and the form field is re-presented to be fixed. All works well, except I'm using a few textareas. If the textareas do not get filled out on the "fix it page" and submitted, they are not giving an error since there is some value in there. !--- Check if an address has been provided --- CFIF Len(Form.Address) is 0 CFSET Valid = False CFSET Error = Error "An Address is required.BR" CFSET address = " textarea name=""Address"" rows=""3"" VALUE=""#Form.Address#"" /textarea" /CFIF But, with another Formfield, !--- Check if a last name has been provided --- CFIF Len(Form.lastName) is 0 CFSET Valid = False CFSET Error = Error "A last Name is required.BR" CFSET lastName = "INPUT TYPE=TEXT NAME=""lastName"" SIZE=30 MAXLENGTH=50 VALUE=""#Form.lastName#""" /CFIF the above can be submited over and over and will trigger the zero value. What is wrong with my textareas so they make it past my checking for zero values?? Here is the complete code from the page: !--- The warform_entryform.cfm sends its info here for checking before insert into data base. --- !--- The following lines through 68 will set each value from the form so if we need to return any fields back to be fixed, the user does not retype everything --- CFSET Valid = True CFSET Error = "" CFSET firstname = "#Form.firstname#INPUT TYPE=HIDDEN NAME=""firstname"" VALUE=""#Form.firstName#""" CFSET lastname = "#Form.lastname#INPUT TYPE=HIDDEN NAME=""lasttname"" VALUE=""#Form.lastName#""" CFSET address = "#Form.address#INPUT TYPE=HIDDEN NAME=""address"" VALUE=""#Form.address#""" CFSET age = "#Form.age#INPUT TYPE=HIDDEN NAME=""age"" VALUE=""#Form.age#""" CFSET city = "#Form.city#INPUT TYPE=HIDDEN NAME=""city"" VALUE=""#Form.city#""" CFSET StateOrProvince = "#Form.StateOrProvince#INPUT TYPE=HIDDEN NAME=""StateOrProvince"" VALUE=""#Form.StateOrProvince#""" CFSET PostalCode = "#Form.PostalCode#INPUT TYPE=HIDDEN NAME=""PostalCode"" VALUE=""#Form.PostalCode#""" CFSET Country = "#Form.Country#INPUT TYPE=HIDDEN NAME=""Country"" VALUE=""#Form.Country#""" CFSET EmailAddress = "#Form.EmailAddress#INPUT TYPE=HIDDEN NAME=""EmailAddress"" VALUE=""#EmailAddress#""" CFSET HomePhone = "#Form.HomePhone#INPUT TYPE=HIDDEN NAME=""HomePhone"" VALUE=""#HomePhone#""" CFSET Framemodel = "#Form.Framemodel#INPUT TYPE=HIDDEN NAME=""Framemodel"" VALUE=""#Framemodel#""" CFSET stockorcustom = "#Form.stockorcustom#INPUT TYPE=HIDDEN NAME=""stockorcustom"" VALUE=""#stockorcustom#""" CFSET size = "#Form.size#INPUT TYPE=HIDDEN NAME=""size"" VALUE=""#size#""" CFSET serial = "#Form.serial#INPUT TYPE=HIDDEN NAME=""serial"" VALUE=""#serial#""" CFSET dateofpurchase = "#Form.dateofpurchase#INPUT TYPE=HIDDEN NAME=""dateofpurchase"" VALUE=""#dateofpurchase#""" CFSET color = "#Form.color#INPUT TYPE=HIDDEN NAME=""color"" VALUE=""#color#""" CFSET nameofdealer = "#Form.nameofdealer#INPUT TYPE=HIDDEN NAME=""nameofdealer"" VALUE=""#nameofdealer#""" CFSET dealerlocation = "#Form.dealerlocation#INPUT TYPE=HIDDEN NAME=""dealerlocation"" VALUE=""#dealerlocation#""" CFSET income = "#Form.income#INPUT TYPE=HIDDEN NAME=""income"" VALUE=""#income#""" CFSET gender = "#Form.gender#INPUT TYPE=HIDDEN NAME=""gender"" VALUE=""#gender#""" CFSET ride_often = "#Form.ride_often#INPUT TYPE=HIDDEN NAME=""ride_often"" VALUE=""#ride_often#""" CFSET website_visit = "#Form.website_visit#INPUT TYPE=HIDDEN NAME=""website_visit"" VALUE=""#website_visit#""" CFSET ride_often = "#Form.ride_often#INPUT TYPE=HIDDEN NAME=""ride_often"" VALUE=""#ride_often#""" CFSET motivated_buy = "#Form.motivated_buy#INPUT TYPE=HIDDEN NAME=""motivated_buy"" VALUE=""#motivated_buy#""" CFSET dealer_assistance = "#Form.dealer_assistance#INPUT TYPE=HIDDEN NAME=""dealer_assistance"" VALUE=""#dealer_assistance#""" CFSET if_contact = "#Form.if_contact#INPUT TYPE=HIDDEN NAME=""if_contact"" VALUE=""#if_contact#""" CFSET festivals_attend = "#Form.festivals_attend#INPUT TYPE=HIDDEN NAME=""festivals_attend"" VALUE=""#festivals_attend#""" CFSET dealer_assistance = "#Form.dealer_assistance#INPUT TYPE=HIDDEN NAME=""dealer_assistance"" VALUE=""#dealer_assistance#""" CFSET clubor_team = "#Form.clubor_team#INPUT TYPE=HIDDEN NAME=""clubor_team"" VALUE=""#clubor_team#""" CFSET organized_rides =
RE: CF outputing SQL Server int field with decimal's?
Their web page has all the current information on it. http://www.sccfug.org/ -Original Message- From: Kinley Pon [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 4:33 PM To: CF-Talk Subject: RE: CF outputing SQL Server int field with decimal's? Hello Sandra, You mentioned of a LA CFUG. Is this the Los Angeles CFUG? If so, GREAT. I was wondering if there was a user group here. I live in Monterey Park. Where is meeting held and when? Justme Kinley -Original Message- From: Sandra Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 06, 2000 4:31 PM To: CF-Talk Subject: RE: CF outputing SQL Server int field with decimal's? This came up in our LA CFUG meeting last night. Apparently the behavior in how CF sees a number was changed internally from 4.0 to 4.5.1. CF doesn't know the difference between a precision variable and an int. It just sees a number. Use NumberFormat() or Int to display correctly. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 10:27 AM To: CF-Talk Subject: CF outputing SQL Server int field with decimal's? I've successfully upsized an access 2000 db to SQL Server 6.5 using SQL Server 7.0 import export wizard, when I cfoutput the data or look at the table data through rds the integer fields are of the format: 1.00 2.00 2,345.00 instead of: 1 2 2345 But, when I query the db with the query tool in SQL Server 6.5 I get the correct output of: 1 2 2345 Any integer fields are like this now including index's and primary key's. When I run the following query: cfquery name="editdb" datasource="holo_bills_sql" username="sa" password="22073207" SELECT BillID,BillNumber FROM Bills WHERE SessionID = 2001 AND BillNumber = 4 /cfquery cfoutput#editdb.RecordCount#br/cfoutput cfoutput query="editdb" #BillID# - #BillNumber#br #int(BillID)# - #int(BillNumber)#br /cfoutput I get: 1 51.00 - 4.00 51 - 4 So this really screws things up. If I can't find a way to keep the integer fields whole number I'll have to change alot of code to int(BillNumber), etc. Anyone have any ideas what I did wrong or how I could fix what I've got. Thanks. Ric Smith h_o_l_o_g_r_a_p_h_i_c 103 Meridian St. Tallahassee, Florida 32301 www.holographic.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
RE: List w/ delims
I've tried to user multiple characters as a list delimiter, but whenever I then try to iterate through the list, specifying my delimiter, it doesn't work. E.g., When I have the following code, CFSET myList = "o|ne |*| t*wo |*| th|*ree" CFLOOP Index="listElement" List="#myList#" Delimiters="|*|" CFOUTPUT #listElement#BR /CFOUTPUT /CFLOOP I get: o ne t wo th ree because it takes each item in the list of delimiters and checks for them individually. Has anyone any insight on how to loop through something with a particular combination of characters for a delimiter? Any help would be appreciated, Robyn -Original Message- From: Jeff Britts [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 8:29 AM To: CF-Talk Subject: RE: List w/" " delims You CAN use multiple characters as list delimiters...eg. "|*|". I do it frequently to cut down on the chances that one of my list items contains a delimiter. Jeff Britts ColdFusion Engineer e-Dialog -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 2:21 PM To: CF-Talk Subject: Re: List w/" " delims Keep in mind that list delimiters can only be 1 character. -- Billy Cravens [EMAIL PROTECTED] Eric Fickes wrote: Got a List question for you. I've got a text file that I need to parse and it's " delimited list, in a way. The list format is this. "Full Name" "Email Address" "Group List" "Login Name" "Demo user for startup" "" " 1;" "Demo" I was hoping to somehow use " " as a delimeter, but that's not working. When I do that it takes out the spaces in the column names. I'd like to take "Full Name" "Email Address" "Group List" "Login Name" and turn it into Full Name,Email Address,Group List,Login Name Any ideas? E ~~ 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: Need help interpreting error message.
I'll check it out. We've been using session.user for a long time. It's in our login script and is where all the user's settings are loaded in. I don't think anything in the template has changed. Although there have been a lot of other changes recently. Thanks! Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: David Cummins [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 11:31 PM To: CF-Talk Subject: Re: Need help interpreting error message. Not sure... Try two things: (a) Try a different variable name than user. (b) Try assigning it to a local variable, then setting the session variable equal to that. I wonder if session variables don't support structures... If you're using CFSCRIPT, there may be some error the line before causing it to misunderstand what session.user is. ~~ 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: Order By Random?
suggest using the tag CF_queryrandomize in the allaire gallery Richard Kern -Original Message- From: Craig M. Rosenblum [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 1:24 PM To: CF-Talk Subject: Order By Random? Is there any way to have a query give the results in random order? This is for Oracle... ~~ 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: List w/ delims
Sure here you go. cfset theList = '"Full Name" "Email Address" "Group List" "Login Name"' cfset theList = replace(theList, '" "', ",", "All") cfset theList = replace(theList, '"', "", "All") cfoutput#theList#/cfoutput Short and sweet. 1. Create the list. Use single quotes to denote the string because the string contains double quotes. 2. Replace all occurrences of '" "' with ','. 3. Replace the remaining double quotes at the beginning and end of the list with nothing. Now you have a standard comma-delimited list. HTH -- Bruce btw - this code will fail if the list contains any double quotes that are not delimiters. -Original Message- From: Eric Fickes [mailto:[EMAIL PROTECTED]] snip I was hoping to somehow use " " as a delimeter, but that's not working. When I do that it takes out the spaces in the column names. I'd like to take "Full Name" "Email Address" "Group List" "Login Name" and turn it into Full Name,Email Address,Group List,Login Name Any ideas? E ~~ 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: CFFILE and IE 5.0 on a Mac doesn't work
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Craig, Check out: http://lookclose.com/learnmore/faqs/macieuploads.htm Apparently MACs send the file as Macbinary rather than as .gif or ..jpg/.jpeg Thanks to Ron @ HKSI for this info. Aaron Johnson, MCSE, MCP+I MINDSEYE, Inc. phn617.350.0339 fax949.350.8884 icq66172567 [EMAIL PROTECTED] ___ "Never forget that only dead fish swim with the stream." -- Malcolm Muggeridge ___ -Original Message- From: Craig A. Zingerline [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 3:06 PM To: CF-Talk Subject: CFFILE and IE 5.0 on a Mac doesn't work Hello, I'm wondering if anyone has found a workaround to the following situation...we are using CFFILE to upload .gif and .jpg files to our server. The scripts work fine on Netscape and IE on a PC, but only work with Netscape on a Macintosh. The mac OS is 9.0 and we are using IE 5.0. I have a couple of links with relevant information below, but have not been able to find (nor do I know) if a workaround to this problem exists. We get the following error code: "Error attempting to save uploaded file to path 'D:\inetpub\websites\oursite\.' Access is denied. (error 5)" Microsoft has a knowledge base article (which doesn't look promising) at: http://support.microsoft.com/support/kb/articles/Q161/3/95.asp?LN= EN-USSD=g nFR=0qry=RFC%201867rnk=3src=DHCS_MSPSS_gn_SRCHSPR=IE A thread in the forums about this is at: http://forums.allaire.com/devconf/Index.cfm?Message_ID=428762 THANK YOU FOR ANY HELP!! IT IS GREATLY APPRECIATED! Cheers, Craig Craig A. Zingerline Advanced Media Productions Web Application Developer ~~ 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: Server Configuration Question
Thanks for your input, I appreciate it, but that is not my question. I am inquiring as to the stability of 4.5.1 sp2 Whether anyone has had memory leaks or thread issues or other problems. My server is completly stable under 4.0.1 so I do not want to do the upgrade unless 4.5.1 is ready. Heath -Original Message- From: Andres Leon [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 9:17 AM To: CF-Talk Subject: Re: Server Configuration Question There are multiple variables that will determine the stability of your application: The hardware you have: If you have quadruple processors with over 512mb of RAM, it will be better than if you just have one processor with 128mb The type of traffic you are expecting to receive. Talk to your client and assess their needs and worst case scenarios (1 million hits per second :( ) The type of application you are hosting: If it is centered in database access, then you better make sure taht your database is layoud out and designed optimally. Here is where most of your scalability and performance issues will reside. Another rule of thumb is to install as few programs in the server as possible.This not only helps your system concentrate on the tasks it need s to acomplish with no background or foreground apps to run, but will also be safer: There are many applications out there that have security holes leaving your system vulnerable to attacks (MS Office, REALAudio, MS Windows Media, etc.) Godd Luck! - Original Message - From: "Philip Arnold - ASP" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 08, 2000 5:19 AM Subject: RE: Server Configuration Question 7 Dec 00 1100 I need to get an answer on this ASAP today. We have a server with this configuration. Win2000 Server SP 1 IIS 5 As found on CD CF 4.5.1 SP2 Oracle 8.1.6 Client 2 CFX Tags PGP and Graphics (GifGid) Basically, I need to know what the Stability is expected to be with this configuration. How this set-up will effect the Speed. Any Known Memory Leaks that may be of concern to me with this configuration. Any issues with the use of Auto Locking Session Variables, instead of explicitly locking them. i.e. I don't want to do a whole lot of recoding at this time. In case you haven't joined CF-Server yet... Put Oracle on another server - the database server will eat memory, and CF will try (if configured properly) to use memory rather than HD, so they'll end up fighting for the memory In the long run, having a dedicated database server is a life saver for speed and stability Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: CF Salary info
sorry about that gena.let's set parameterslets say the US and east or west coast earnings thanks :) Good question! I know people who works for 50$ per month and it is pretty good salary. Try to clarify at least country/city - Original Message - From: "C Kong" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 08, 2000 9:48 AM Subject: CF Salary info new to the forum here and new to coldfusion period. excuse the tacky question, but i was wondering what a CF beginner , intermediate level, and senior level CF programmer can make in terms of salary out there. company versus free-lance? ~~ 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
BULK INSERT - Access or ODBC incompatibility?
Hi! I am using the SQL7's "BULK INSERT", but I get the following error: ~~ 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: oracle sysdate time
You have to specify it in the query itself . . . select to_char(date_field, 'dd-mon- hh24:mi:ss') . . . then once you have it in CF you can do what you want with it. Dan -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 5:31 AM To: CF-Talk Subject: oracle sysdate time anyone know how to get the time part of an oracle date field to show up in a result. I have a table where "date_entered" is the primary key and when I query it in oracle developer I see the time (hh:mi:ss)part but not in CF. createodbcdatetime() does not work ~~ 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: Read client text file from web server
It's possible that you could do some reading/parsing using the FileSystemObject and some client-side JavaScript. At that point you could transfer the info to the server. In all likelihood, a message will be popped up to the user, since reading their local file system is a big security issue. The bottom line is that to read files on the client's end, there must be some user interaction. Personally, I'd stick with the file upload method, since that's the most robust (FileSystemObject only available to IE, and only if their security settings are set to allow that) solution. -- Billy Cravens [EMAIL PROTECTED] Eric Fickes wrote: Hello all, I am creating a log analyzer cfm page for an internal db application, and I've got a question about cf pages reading files. When I view the page locally, I am able to read the log files just fine as is when I use input tyep="file". However, when I uploaded this page to my web server, or when I asked somebody to test my page, it didn't work because the log file they specified is not physically located on my machine. This makes sense to me. So to get around this, I have the page do a file upload to a temp dir, and then read the file from the temp dir. All is well. And now for my question. Is there any way for me to make a CF page that will read a user specified file without having to upload it to the server 1st? E ~~ 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: PL/SQL
Basically, we're working on a tool to generate the pl/sql script on the fly so we cant use a stored proc. Any ideas? -Original Message- From: C Frederic Valone [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 9:54 AM To: CF-Talk Subject: Re: PL/SQL We use cf and pl/sql stored procs extensively. What exactly are you trying to do? Jeff Britts wrote: Anyone have any luck running PL/SQL through ColdFusion? The simple stuff seems to work ok, but if you throw it something complex it chokes. Jeff Britts ColdFusion Engineer e-Dialog ~~ 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
Undcocumented Feature (Copyright MS) in Coldfusion 4.5 isdefine d() function
This appears to be an error in ColdFusion's isdefined("") function
- the parameter is syntactically valid - I am outputting it successfully on
the line above...
==
Error Diagnostic Information
An error occurred while evaluating the expression:
isdefined("request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot[#currentslot#].att
ributes.sequencenumber.Value")
Error near line 104, column 8.
Parameter 1 of function IsDefined which is now
"request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot[1].attributes.sequencenumber
..Value" must be a syntactically valid variable name
~~
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: Form Validation Question
Use len(trim(form.formfield)). Textareas, unless in the format textarea/textarea will not be eq "". If you have, the texarea has a CRLF in it. textarea /textarea the trim() will ignore the CRLF. This is sort of confusion to explain, but I will try. I'm attempting to validate a form using the example in MASTERING COLD FUSION 4, pg 390, ex 15.4. Of course the book example is ultra simple. 3 easy text fields, submits to another script that validates by checking to see if value is zero. This is Cold Fusion validation by the way, no Java Script. I would have used, client side JavaScript but could not get CFSELECT to give the popup using the simple message attribute. I know there are other ways w/JavaScript but I'm deep into this way and I think I am close. So, submit the form and then the next script checks for zero values. If a zero value is found, a "you messed up" message is generated and the form field is re-presented to be fixed. All works well, except I'm using a few textareas. If the textareas do not get filled out on the "fix it page" and submitted, they are not giving an error since there is some value in there. !--- Check if an address has been provided --- CFIF Len(Form.Address) is 0 CFSET Valid = False CFSET Error = Error "An Address is required.BR" CFSET address = " textarea name=""Address"" rows=""3"" VALUE=""#Form.Address#"" /textarea" /CFIF But, with another Formfield, !--- Check if a last name has been provided --- CFIF Len(Form.lastName) is 0 CFSET Valid = False CFSET Error = Error "A last Name is required.BR" CFSET lastName = "INPUT TYPE=TEXT NAME=""lastName"" SIZE=30 MAXLENGTH=50 VALUE=""#Form.lastName#""" /CFIF the above can be submited over and over and will trigger the zero value. What is wrong with my textareas so they make it past my checking for zero values?? Here is the complete code from the page: !--- The warform_entryform.cfm sends its info here for checking before insert into data base. --- !--- The following lines through 68 will set each value from the form so if we need to return any fields back to be fixed, the user does not retype everything --- CFSET Valid = True CFSET Error = "" CFSET firstname = "#Form.firstname#INPUT TYPE=HIDDEN NAME=""firstname"" VALUE=""#Form.firstName#""" CFSET lastname = "#Form.lastname#INPUT TYPE=HIDDEN NAME=""lasttname"" VALUE=""#Form.lastName#""" CFSET address = "#Form.address#INPUT TYPE=HIDDEN NAME=""address"" VALUE=""#Form.address#""" CFSET age = "#Form.age#INPUT TYPE=HIDDEN NAME=""age"" VALUE=""#Form.age#""" CFSET city = "#Form.city#INPUT TYPE=HIDDEN NAME=""city"" VALUE=""#Form.city#""" CFSET StateOrProvince = "#Form.StateOrProvince#INPUT TYPE=HIDDEN NAME=""StateOrProvince"" VALUE=""#Form.StateOrProvince#""" CFSET PostalCode = "#Form.PostalCode#INPUT TYPE=HIDDEN NAME=""PostalCode"" VALUE=""#Form.PostalCode#""" CFSET Country = "#Form.Country#INPUT TYPE=HIDDEN NAME=""Country"" VALUE=""#Form.Country#""" CFSET EmailAddress = "#Form.EmailAddress#INPUT TYPE=HIDDEN NAME=""EmailAddress"" VALUE=""#EmailAddress#""" CFSET HomePhone = "#Form.HomePhone#INPUT TYPE=HIDDEN NAME=""HomePhone"" VALUE=""#HomePhone#""" CFSET Framemodel = "#Form.Framemodel#INPUT TYPE=HIDDEN NAME=""Framemodel"" VALUE=""#Framemodel#""" CFSET stockorcustom = "#Form.stockorcustom#INPUT TYPE=HIDDEN NAME=""stockorcustom"" VALUE=""#stockorcustom#""" CFSET size = "#Form.size#INPUT TYPE=HIDDEN NAME=""size"" VALUE=""#size#""" CFSET serial = "#Form.serial#INPUT TYPE=HIDDEN NAME=""serial"" VALUE=""#serial#""" CFSET dateofpurchase = "#Form.dateofpurchase#INPUT TYPE=HIDDEN NAME=""dateofpurchase"" VALUE=""#dateofpurchase#""" CFSET color = "#Form.color#INPUT TYPE=HIDDEN NAME=""color"" VALUE=""#color#""" CFSET nameofdealer = "#Form.nameofdealer#INPUT TYPE=HIDDEN NAME=""nameofdealer"" VALUE=""#nameofdealer#""" CFSET dealerlocation = "#Form.dealerlocation#INPUT TYPE=HIDDEN NAME=""dealerlocation"" VALUE=""#dealerlocation#""" CFSET income = "#Form.income#INPUT TYPE=HIDDEN NAME=""income"" VALUE=""#income#""" CFSET gender = "#Form.gender#INPUT TYPE=HIDDEN NAME=""gender"" VALUE=""#gender#""" CFSET ride_often = "#Form.ride_often#INPUT TYPE=HIDDEN NAME=""ride_often"" VALUE=""#ride_often#""" CFSET website_visit = "#Form.website_visit#INPUT TYPE=HIDDEN NAME=""website_visit"" VALUE=""#website_visit#""" CFSET ride_often = "#Form.ride_often#INPUT TYPE=HIDDEN NAME=""ride_often"" VALUE=""#ride_often#""" CFSET motivated_buy = "#Form.motivated_buy#INPUT TYPE=HIDDEN NAME=""motivated_buy"" VALUE=""#motivated_buy#""" CFSET dealer_assistance = "#Form.dealer_assistance#INPUT TYPE=HIDDEN NAME=""dealer_assistance"" VALUE=""#dealer_assistance#""" CFSET if_contact = "#Form.if_contact#INPUT TYPE=HIDDEN NAME=""if_contact"" VALUE=""#if_contact#""" CFSET festivals_attend = "#Form.festivals_attend#INPUT TYPE=HIDDEN NAME=""festivals_attend"" VALUE=""#festivals_attend#""" CFSET dealer_assistance =
RE: Form Validation Question
use len(trim(form.lastname)) If the textbox (You did mean textbox, not text area, yes? a text block is a single line field that can only accept 255 charachters, while a textarea is multiline and has no max character restriction) is empty, this combination of functions returns 0 so your cfif could look like this.. cfif len(trim(form.lastname)) !--- Any number, 1 through whatever, will trip this part --- do something cfelse !--- the number 0 trips this part --- don't /cfif The secret is the trim function. it gets rid of all leading and trailing zeros... and will make your function return 0 when it should. -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 10:04 AM To: CF-Talk Subject: Form Validation Question This is sort of confusion to explain, but I will try. I'm attempting to validate a form using the example in MASTERING COLD FUSION 4, pg 390, ex 15.4. Of course the book example is ultra simple. 3 easy text fields, submits to another script that validates by checking to see if value is zero. This is Cold Fusion validation by the way, no Java Script. I would have used, client side JavaScript but could not get CFSELECT to give the popup using the simple message attribute. I know there are other ways w/JavaScript but I'm deep into this way and I think I am close. So, submit the form and then the next script checks for zero values. If a zero value is found, a "you messed up" message is generated and the form field is re-presented to be fixed. All works well, except I'm using a few textareas. If the textareas do not get filled out on the "fix it page" and submitted, they are not giving an error since there is some value in there. !--- Check if an address has been provided --- CFIF Len(Form.Address) is 0 CFSET Valid = False CFSET Error = Error "An Address is required.BR" CFSET address = " textarea name=""Address"" rows=""3"" VALUE=""#Form.Address#"" /textarea" /CFIF But, with another Formfield, !--- Check if a last name has been provided --- CFIF Len(Form.lastName) is 0 CFSET Valid = False CFSET Error = Error "A last Name is required.BR" CFSET lastName = "INPUT TYPE=TEXT NAME=""lastName"" SIZE=30 MAXLENGTH=50 VALUE=""#Form.lastName#""" /CFIF the above can be submited over and over and will trigger the zero value. What is wrong with my textareas so they make it past my checking for zero values?? Here is the complete code from the page: !--- The warform_entryform.cfm sends its info here for checking before insert into data base. --- !--- The following lines through 68 will set each value from the form so if we need to return any fields back to be fixed, the user does not retype everything --- CFSET Valid = True CFSET Error = "" CFSET firstname = "#Form.firstname#INPUT TYPE=HIDDEN NAME=""firstname"" VALUE=""#Form.firstName#""" CFSET lastname = "#Form.lastname#INPUT TYPE=HIDDEN NAME=""lasttname"" VALUE=""#Form.lastName#""" CFSET address = "#Form.address#INPUT TYPE=HIDDEN NAME=""address"" VALUE=""#Form.address#""" CFSET age = "#Form.age#INPUT TYPE=HIDDEN NAME=""age"" VALUE=""#Form.age#""" CFSET city = "#Form.city#INPUT TYPE=HIDDEN NAME=""city"" VALUE=""#Form.city#""" CFSET StateOrProvince = "#Form.StateOrProvince#INPUT TYPE=HIDDEN NAME=""StateOrProvince"" VALUE=""#Form.StateOrProvince#""" CFSET PostalCode = "#Form.PostalCode#INPUT TYPE=HIDDEN NAME=""PostalCode"" VALUE=""#Form.PostalCode#""" CFSET Country = "#Form.Country#INPUT TYPE=HIDDEN NAME=""Country"" VALUE=""#Form.Country#""" CFSET EmailAddress = "#Form.EmailAddress#INPUT TYPE=HIDDEN NAME=""EmailAddress"" VALUE=""#EmailAddress#""" CFSET HomePhone = "#Form.HomePhone#INPUT TYPE=HIDDEN NAME=""HomePhone"" VALUE=""#HomePhone#""" CFSET Framemodel = "#Form.Framemodel#INPUT TYPE=HIDDEN NAME=""Framemodel"" VALUE=""#Framemodel#""" CFSET stockorcustom = "#Form.stockorcustom#INPUT TYPE=HIDDEN NAME=""stockorcustom"" VALUE=""#stockorcustom#""" CFSET size = "#Form.size#INPUT TYPE=HIDDEN NAME=""size"" VALUE=""#size#""" CFSET serial = "#Form.serial#INPUT TYPE=HIDDEN NAME=""serial"" VALUE=""#serial#""" CFSET dateofpurchase = "#Form.dateofpurchase#INPUT TYPE=HIDDEN NAME=""dateofpurchase"" VALUE=""#dateofpurchase#""" CFSET color = "#Form.color#INPUT TYPE=HIDDEN NAME=""color"" VALUE=""#color#""" CFSET nameofdealer = "#Form.nameofdealer#INPUT TYPE=HIDDEN NAME=""nameofdealer"" VALUE=""#nameofdealer#""" CFSET dealerlocation = "#Form.dealerlocation#INPUT TYPE=HIDDEN NAME=""dealerlocation"" VALUE=""#dealerlocation#""" CFSET income = "#Form.income#INPUT TYPE=HIDDEN NAME=""income"" VALUE=""#income#""" CFSET gender = "#Form.gender#INPUT TYPE=HIDDEN NAME=""gender"" VALUE=""#gender#""" CFSET ride_often = "#Form.ride_often#INPUT TYPE=HIDDEN NAME=""ride_often""
RE: ODBC errors with MS Access after MDAC 2.5
The update was to MDAC 2.5, not 2.6. My fault for getting the numbers mixed up. But the CF code broke after upgrading to MDAC 2.5. Also for more background the server is running NT4 SP6a, Website 2.5.8 and CF Enterprise 4.0.2. The CF code worked fine with MDAC 2.4, it was after upgrading to MDAC 2.5 that this one CF template started throwing a PCode error. - Steve -Original Message- From: Dru Whitledge [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 10:13 PM To: CF-Talk Subject: ODBC errors with MS Access after MDAC 2.6 After upgrading to MDAC 2.6 (contains ODBC) at my ISP I am now experiencing memory errors for MS Access queries that once ran without a problem (and still do on my MDAC 2.1 server). The CF server provides the following error message -- (and of course stops execution) CMemoryException: unknown cause PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag Has anyone else had this problem? Anyone aware of any fixes? As I started into this I had assumed that the new MDAC 2.6 upgrade simply tightened up some requirment for correct SQL syntax -- now I'm not so sure. One query I'm rebuilding seems to fail on a adding a simple concatenation to create an alias field -- (field1) (field2) AS Field3 while (field1) AS Field3 works fine. That's hard to workaround. Thanks, Dru ~~ 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
Passing variables to a SQL7 stored procedure
What is the equivalent of cfparam name="var" default="" inside a stored procedure? i want to pass a value to a stored procedure, but the value, and the variable that holds it, may not be passed all the time. I want the stored procedure to assign a value of "" to the variable if no value is passed to it. Then, depending on this variable, it needs to perform either one of two queries. can someone give me pointers on how to do this?? thanks andres leon ~~ 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: Which message-board to get
I set up fusetalk for a customer and it was very easy and works real well. Runs on Access or SQL Server. The open source is pretty expensive though. Do you have a URL for that Bud? Cheers Will ~~ 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: Which message-board to get
- Original Message - From: ""Dennis Powers"" [EMAIL PROTECTED] Newsgroups: dotcom.lists.cftalk Sent: Friday, December 08, 2000 5:44 AM Subject: RE: Which message-board to get For a CF BBS, check out "Forums". It is now an open-Source project. http://www.forumspot.org/ Very nice - could be good. Is it me, or are ASP boards more in abundance than CF ones? Will ~~ 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: List w/ delims
Maybe the "*" character is throwing it off. Sorry, I might have given you a bad example. This is some code I have that works. I set up an array and then convert it to a list... cfset stuff_list = #arraytolist(stuff_new,"||Q||")# I can then pick items from that list, using a #location# index. cfset stuff1 = #listGetAt(stuff_list,location + 1,"||Q||")# cfset stuff2 = #listGetAt(stuff_list,location + 2,"||Q||")# cfset stuff3 = #listGetAt(stuff_list,location + 3,"||Q||")# cfset stuff4 = #listGetAt(stuff_list,location + 4,"||Q||")# Jeff Britts ColdFusion Engineer e-Dialog -Original Message- From: Robyn Follen [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 9:58 AM To: CF-Talk Subject: RE: List w/" " delims I've tried to user multiple characters as a list delimiter, but whenever I then try to iterate through the list, specifying my delimiter, it doesn't work. E.g., When I have the following code, CFSET myList = "o|ne |*| t*wo |*| th|*ree" CFLOOP Index="listElement" List="#myList#" Delimiters="|*|" CFOUTPUT #listElement#BR /CFOUTPUT /CFLOOP I get: o ne t wo th ree because it takes each item in the list of delimiters and checks for them individually. Has anyone any insight on how to loop through something with a particular combination of characters for a delimiter? Any help would be appreciated, Robyn -Original Message- From: Jeff Britts [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 8:29 AM To: CF-Talk Subject: RE: List w/" " delims You CAN use multiple characters as list delimiters...eg. "|*|". I do it frequently to cut down on the chances that one of my list items contains a delimiter. Jeff Britts ColdFusion Engineer e-Dialog -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 2:21 PM To: CF-Talk Subject: Re: List w/" " delims Keep in mind that list delimiters can only be 1 character. -- Billy Cravens [EMAIL PROTECTED] Eric Fickes wrote: Got a List question for you. I've got a text file that I need to parse and it's " delimited list, in a way. The list format is this. "Full Name" "Email Address" "Group List" "Login Name" "Demo user for startup" "" " 1;" "Demo" I was hoping to somehow use " " as a delimeter, but that's not working. When I do that it takes out the spaces in the column names. I'd like to take "Full Name" "Email Address" "Group List" "Login Name" and turn it into Full Name,Email Address,Group List,Login Name Any ideas? E ~~ 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: Studio 4.5.1 - Setup Question
Thanks - that was it. Dave - Original Message - From: "Richard Kern" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 08, 2000 10:23 AM Subject: RE: Studio 4.5.1 - Setup Question options,settings, html gets you a switch to turn lower case on for tags. Otherwise it's as you type. Richard -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 6:51 AM To: CF-Talk Subject: Studio 4.5.1 - Setup Question Hello, I just installed Studio 4.5.1 (finally upgraded from 3.1). In 3.1 there was an option to upper case the tags when you inserted them. I have searched for two days now, and have been unable to locate this switch in 4.5.1. Does it offer that option? And if so, can someone tell me where it is? Thanks, Dave = "What we need is a list of specific unknown problems we will encounter" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 ~~ 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: loops, queries, ug...
did you try something like this cfquery datasource="subnets" name="getsubnet" SELECT * FROM subnets order by subnetid /cfquery cfoutput query="getsubnet" group="subnetid" #subnetid# cfquery datasource="subnets" name="getsubnetinfo" SELECT * FROM subnetinfo WHERE subnetid = #subnetid# /cfquery cfoutput query="getsubnetinfo" subnet ifo here... /cfoutput /cfoutput -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 10:23 AM To: CF-Talk Subject: loops, queries, ug... I'm confused! I have 2 tables in the same database, one table has a list of subnets(subnets), and the other will contain information on each subnet(subnet_info). The subnet in the subnets table is the unique id in that table, which has a one to many relationship with the subnet in the subnet_info table. What I want to do is present a table that would present a subnet, then it's corresponinding IP's and Info, then repeat for each subnet. Something like: 208.208.208 IP = 1 Name = boxname Description = what this box does 208.208.209 ect... I'm not sure of the best method to do this. I tried building a query on the subnet table, then in the cfoutput of that query, loop through another query on the subnet_info table... but it doesn't work. Any ideas for me how to do this? TIA, Pete ~~ 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
Best place to buy CF Studio?
Hi All, I need to purchase a couple of copies of CF Studio. Any online vendors you would recommend? James ~~ 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: loops, queries, ug...
Try something like this: cfquery name="getall" datasource="mydsn" Select Subnet.*, SubnetInfo.* From Subnet LEFT Join SubnetInfo ON Subnet.IPMask = SubNetInfo.IPMask /query cfset firstIPMask = "" cfoutput query="Getall" cfif NOT firstIPMask IS #getall.IPmask# cfset firstIPMask = #getall.IPmask# Subnet: #getall.IPmask#br cfelse /cfif ul liIP = #IPEnding#/li liName = #getall.boxname# liDescription = #Getall.Desc# /ul /cfoutput -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 10:23 AM To: CF-Talk Subject: loops, queries, ug... I'm confused! I have 2 tables in the same database, one table has a list of subnets(subnets), and the other will contain information on each subnet(subnet_info). The subnet in the subnets table is the unique id in that table, which has a one to many relationship with the subnet in the subnet_info table. What I want to do is present a table that would present a subnet, then it's corresponinding IP's and Info, then repeat for each subnet. Something like: 208.208.208 IP = 1 Name = boxname Description = what this box does 208.208.209 ect... I'm not sure of the best method to do this. I tried building a query on the subnet table, then in the cfoutput of that query, loop through another query on the subnet_info table... but it doesn't work. Any ideas for me how to do this? TIA, Pete ~~ 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: loops, queries, ug...
I'm not sure of the best method to do this. I tried building a query on the subnet table, then in the cfoutput of that query, loop through another query on the subnet_info table... but it doesn't work. Any ideas for me how to do this? My idea: cfoutput query="theQuery" group="subnet field name" subnet cfoutput IP = 1 Name = boxname Description = what this box does cfoutput /cfoutput of course using cf query varaibles with #'s and doing your formating. And make sure your query has the Order By clause set to subnet. Best of Luck!! ~~ 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: loops, queries, ug...
You should never put a query inside a looping structure. Try this: !--- join the tables and order by the subnet --- cfquery name="nets" datasource="whatever" SELECT s.subnet, ip.ip, ip.name, ip.description FROM subnets s, ips ip WHERE s.subnet = ip.subnet ORDER BY s.subnet /cfquery !--- output the query with a subnet group --- cfoutput query="nets" group="subnet" b#subnet#/bbr ul cfoutput!--- loop through the subnet's ips --- li#ip# #name# #description# /cfoutput /ul /cfoutput -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 7:23 AM To: CF-Talk Subject: loops, queries, ug... I'm confused! I have 2 tables in the same database, one table has a list of subnets(subnets), and the other will contain information on each subnet(subnet_info). The subnet in the subnets table is the unique id in that table, which has a one to many relationship with the subnet in the subnet_info table. What I want to do is present a table that would present a subnet, then it's corresponinding IP's and Info, then repeat for each subnet. Something like: 208.208.208 IP = 1 Name = boxname Description = what this box does 208.208.209 ect... I'm not sure of the best method to do this. I tried building a query on the subnet table, then in the cfoutput of that query, loop through another query on the subnet_info table... but it doesn't work. Any ideas for me how to do this? TIA, Pete ~~ 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
IIS plugin
where can I find an IIS plugin that allows a cookie to written to the IIS log files. Eric ~~ 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: Food for thought...
Would any of you be interested in a product that could help streamline your development time and still allow you full control over your code? no. I like my bloatware. --- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: 08 December 2000 15:27 To: CF-Talk Subject: Food for thought... Would any of you be interested in a product that could help streamline your development time and still allow you full control over your code? ~~ 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: Food for thought...
At 09:26 AM 12/8/00 -0600, you wrote: Would any of you be interested in a product that could help streamline your development time and still allow you full control over your code? This seems like a rhetorical question and I feel a marketing pitch coming on. ~~ 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: Best sites for CF Job Listings?
I've had luck with techies.com careerbuilder.com is nice because it searches a bunch of job websites (dice, monster, hotjobs etc.) -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 5:27 AM To: CF-Talk Subject: Best sites for CF Job Listings? What are the best sites for CF job listings, also I am in upstate NY, (for Now) TIA Michael ~~ 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
Renaming a CF Server (NT/Win2K)
I need to replace my aging NT 4.0 / CF 4.0.1 Pro server with new hardware, Win2K Adv. Server, and CF 4.5.1. At Verizon, we can only perform this kind of change during the late night hours. So, to save time at night, I'd like to build the new server during the day, migrate the content, and then just swap the hardware that night. No problem there. However, to maintain compliance with our company's server naming standards, I need to rename the new server once it's online so it will have the same name as the old server. Has anyone done this before? If so, has anyone run into any problems or quirks? Forewarned is forearmed... Thanks, Eric A. Laney Systems Engineer Verizon IT "It is easy to be blinded to the essential uselessness of computers by the sense of accomplishment you get from getting them to work at all." - Douglas Adams ~~ 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: structures always serialized to WDDX the same way?
cut and paste this wherever you can run it.. cfset struct1 = structNew() cfset struct2 = structNew() cfset struct1.name = "hi" cfset struct1.address = "he" cfset struct1.phone = "123" cfset struct2.phone = "123" cfset struct2.address = "he" cfset struct2.name = "hi" cfwddx action="CFML2WDDX" input="#struct1#" output="structString1" cfwddx action="CFML2WDDX" input="#struct2#" output="structString2" cfset areSame = compare(structString1,structString2) cfif areSame IS 0 The structures are identicle cfelse The structures are different /cfif Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 6:29 AM To: CF-Talk Subject: structures always serialized to WDDX the same way? Does anyone know if structures that are serialized to WDDX are always arranged the same way? That is, if I create a structure, adding keys and values in a certain order, then create another structure using the same code (but not by doing a Duplicate or StructCopy), and serialize them both, will the serialized versions string-compare as identical? The docs say that StructKeyList and StructKeyArray "do not return the keys in any particular order", so I can imagine that the WDDX versions might be arranged differently. Any experience? thanks --- Martin Herbener [EMAIL PROTECTED] Kentucky Department of Education ~~ 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: CF java object
Calling a Java class is done using HTML and thus the location of the CF machine is completely irrelevent. You can call Java classes from anywhere. Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 5:33 AM To: CF-Talk Subject: CF java object can I call a java object on a remote machine? or does the object have to be on the same machine as CF? ~~ 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: loops, queries, ug...
Pete, I think a simple group on the output is all you need. Query your tables (using, e.g., name = "get_subnets"), then on the output section, add a group parameter, as in: CFOUTPUT QUERY = "get_subnets" GROUP = "subnets" I'm assuming the value in "subnets" is the IP number. HTH, --John Peter Benoit pbenoit@triton-neTo: CF-Talk [EMAIL PROTECTED] twork.comcc: Subject: loops, queries, ug... 12/08/2000 09:22 AM Please respond to cf-talk I'm confused! I have 2 tables in the same database, one table has a list of subnets(subnets), and the other will contain information on each subnet(subnet_info). The subnet in the subnets table is the unique id in that table, which has a one to many relationship with the subnet in the subnet_info table. What I want to do is present a table that would present a subnet, then it's corresponinding IP's and Info, then repeat for each subnet. Something like: 208.208.208 IP = 1 Name = boxname Description = what this box does 208.208.209 ect... I'm not sure of the best method to do this. I tried building a query on the subnet table, then in the cfoutput of that query, loop through another query on the subnet_info table... but it doesn't work. Any ideas for me how to do this? TIA, Pete ~~ 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: Process Time Variable WAS Re: Caching Queries......
GetTickCount() Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: defective david [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 8:50 PM To: CF-Talk Subject: Process Time Variable WAS Re: Caching Queries.. Ya know what'd be nice? A variable that outputed the time it took to process the page from the begining to the point you output the variable. I currently do this with two lines of code, one's the first line of applicaiton.cfm and the other is at the bottom of the output. but still... a variable would be nice. --- defective david http://defective.net - Original Message - From: "David Shadovitz" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, November 26, 2000 8:43 PM Subject: Re: Caching Queries.. What is cf_timer? Why not just print out CFQUERY.ExecutionTime ? -David On Mon, 27 Nov 2000 14:23:06 +1100 "Scott, Andrew" [EMAIL PROTECTED] writes: I am a little confused on this, this is something I haven't dealt with much... So forgive me if I don't understand. Anyway I have done the following as a test. cf_timer CFQUERY NAME="ASTest" DATASOURCE="anything" cachedwithin="#CreateTimeSpan(1,0,0,0)#" select * from bp_modules /CFQUERY /cf_timer cf_timer CFQUERY NAME="ASTest" DATASOURCE="anything" cachedwithin="#CreateTimeSpan(1,0,0,0)#" select * from bp_modules /CFQUERY /cf_timer The intersting thing is that, sometimes the second query returns the time it should have executed other times it returns 0ms like you would expect a cache to return This to me appears that either the logic of how it works is wrong in what I think it does, or that there is a bug in the query caching. ~~ 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: Food for thought...
Will it restore my hair-loss and give my pants cuffs too? :-) At 09:26 AM 12/8/00 -0600, Clint Tredway wrote: Would any of you be interested in a product that could help streamline your development time and still allow you full control over your code? ~~ 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: Is there a way to access JavaScript variables through CF??
nothing wrong, but i was wondering if there is an easy way to transfer those JavaScript variables to CF variables. -- Original Message -- From: Nick McClure [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 07 Dec 2000 15:24:58 -0500 What is wrong with using the CGI environment variable? cgi.HTTP_USER_AGENT At 11:42 AM 12/7/2000 -0500, you wrote: In order to get the client platform in JavaScript, navigator.platform can be used. Is there a way to assign those variables to CF variable? ~~ 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: Food for thought...
No -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 10:27 AM To: CF-Talk Subject: Food for thought... Would any of you be interested in a product that could help streamline your development time and still allow you full control over your code? ~~ 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
mac address
Anyone know of a way to grab a client machines mac address? Am looking for a way to do it with Cold Fusion, scripting, ActiveX, or Java. Any tips or suggestions would be greatly appreciated. Wanting to use the mac address for security verification. Bernd VanSkiver [EMAIL PROTECTED] ICQ #: 916324 ~~ 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: loops, queries, ug...
You might want to do this in a single query which will do a LEFT OUTER JOIN between your base table(subnets) and your info table(subnet_info). That way, if you order by subnet, you can do a CFoutput query="qName" group="SUBNET" to loop over your subnets, and a CFOUTPUT inside of that to loop over the properties of each subnet. Jason Powers Fig Leaf Software 202-797-5440 -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 10:23 AM To: CF-Talk Subject: loops, queries, ug... I'm confused! I have 2 tables in the same database, one table has a list of subnets(subnets), and the other will contain information on each subnet(subnet_info). The subnet in the subnets table is the unique id in that table, which has a one to many relationship with the subnet in the subnet_info table. What I want to do is present a table that would present a subnet, then it's corresponinding IP's and Info, then repeat for each subnet. Something like: 208.208.208 IP = 1 Name = boxname Description = what this box does 208.208.209 ect... I'm not sure of the best method to do this. I tried building a query on the subnet table, then in the cfoutput of that query, loop through another query on the subnet_info table... but it doesn't work. Any ideas for me how to do this? TIA, Pete ~~ 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
OT:SQL uninstall
Does anyone know where I can find complete uninstall instructions for the desktop version of SQL Server 7? I have DLL errors that are preventing me from performing any DTS task. After using the uninstall program and reinstalling SQL Server, the problems persist. Rob ~~ 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
OT:SQL Server uninstall
Does anyone know where I can find complete uninstall instructions for the desktop version of SQL Server 7? I have DLL errors that are preventing me from performing any DTS task. After using the uninstall program and reinstalling SQL Server, the problems persist. Rob ~~ 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
if/else CFSCRIPT...
Can anyone show me a working example of an if/else statement in cfscript??? I do understand its just like working with javascript, however my use for it is a lil' bit trickier as it involves RegEx. The most Ive done with CFSCRIPT before is just setting variables. TIA, Mike ~~ 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: BULK INSERT - Access or ODBC incompatibility?
Here are some issues I ran into recently: 1. BULK INSERT has to run under a sysadmin account. For my user, I setup a CFAS mapping to a template my user could not access. The CFQUERY in THAT template had the BULK INSERT in it and have sysadmin access. 2. If you CFINCLUDE something like the following: cfquery name="InsertInitial" DATASOURCE="#DSN#" USERNAME="#user#" PASSWORD="#pass#" BULK INSERT jobsINITIAL FROM '#File.ServerDirectory#\#FILE.ServerFile#' WITH ( FIELDTERMINATOR='|', ROWTERMINATOR=' ' ) /cfquery it will fail You need to change ROWTERMINATOR=' ' to ROWTERMINATOR='#chr(13)##chr(10)#' HTH best, paul PS 3. You cannot have a Identity column in the table you're inserting to. And the number and kind of columns in the table must exactly match that in the CSV file. (I think BCP can work-around these - but I don't know its use) At 12:23 PM 12/8/00 -0400, you wrote: Hi! I am using the SQL7's "BULK INSERT", but I get the following error: ~~ 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: LA CFUG (was Re: CF outputing SQL Server int field with decimal's?)
Thanks David...hope to meet you there. Kinley Pon Westcar Consulting Group, Inc. mailto: [EMAIL PROTECTED] -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 1:04 AM To: CF-Talk Subject: LA CFUG (was Re: CF outputing SQL Server int field with decimal's?) I'm not Sandra, but... Check the Southern California CFUG's web site, www.sccfug.org. The LA branch meets on the first Tuesday of the month in the offices of Event411 in Marina Del Rey. -David On Thu, 07 Dec 2000 16:33:09 -0800 "Kinley Pon" [EMAIL PROTECTED] writes: Hello Sandra, You mentioned an LA CFUG. Is this the Los Angeles CFUG? If so, GREAT. I was wondering if there was a user group here. I live in Monterey Park. Where is meeting held and when? Justme Kinley ~~ 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: CFFILE and IE 5.0 on a Mac doesn't work
I don't suppose you could pass along this proceedure ... I tried using: cfif HTTP_USER_AGENT contains "MSIE" and HTTP_USER_AGENT contains "Mac" cfset photo=#Left(photo,Len(photo)-2)# cfelse /cfif cffile action="upload" filefield="photo" destination="c:/inetpub/wwwroot/sitename/" And I get an error saying that the filefield doesn't contain a valid file for upload... I'm proabably way off on this though. Joshua Miller Web Development Eagle Technologies Group, Inc. Business Solutions for the Next Generation www.eagletgi.com http://www.eagletgi.com [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Rob Keniger [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 8:44 PM To: CF-Talk Subject: Re: CFFILE and IE 5.0 on a Mac doesn't work on 8/12/00 6:06 AM, Craig A. Zingerline at [EMAIL PROTECTED] wrote: I'm wondering if anyone has found a workaround to the following situation...we are using CFFILE to upload .gif and .jpg files to our server. The scripts work fine on Netscape and IE on a PC, but only work with Netscape on a Macintosh. The mac OS is 9.0 and we are using IE 5.0. I have a couple of links with relevant information below, but have not been able to find (nor do I know) if a workaround to this problem exists. We get the following error code: What I have found is that IE 5 Mac appends control characters (I think CR/LF) to the end of values passed through form fields when you are using multipart/form-data encoding. If you are using a field to specify the file name then this could be the problem. I wrote a procedure for a site that had this problem that did a user-agent check and stripped the rightmost two characters if it was Mac IE. Seemed to work OK. -- Rob Keniger big bang solutions mailto:[EMAIL PROTECTED] ~~ 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
Done (if/else CFSCRIPT)...
Hmm maybe I should of tried this myself before I asked the question. ^_^ I got it everything that I wanted done. Thanx anyways. ~~ 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
Query me this ...
I need a tad bit of SQL help. I have these tables: CLASS_DESCRIPTION class_description_id (pk) num_slots min_age max_age cost location CLASS_NAME_DESCRIPTION class_name_description_id (pk) class_name class_description_id (fk for CLASS_DESCRIPTION) DAYS_TIMES days_times_id (pk) days times CLASS_SCHEDULE class_schedule_id (pk) class_name_description_id (fk for CLASS_NAME_DESCRIPTION) start_time (fk for DAYS_TIMES) end_time (fk for DAYS_TIMES) CLASS_GROUP class_group_id (pk) class_schedule_id_list (comma delimited list of fk for CLASS_SCHEDULE) start_date end_date The structure flows as such: NAMES + CLASS_DESCRIPTION = NAMES_CLASS_DESCRIPTION NAMES_CLASS_DESCRIPTION + DAYS_TIMES = CLASS_SCHEDULE CLASS_SCHEDULE + DAYS_TIMES * 7 days = CLASS_GROUP I need to qrite a query, or group of queries, that will take a single value passed to the query page (class_group_id) and extract all of the information from the related tables. I am trying to figure out a way to do this as effciently as possible. Can someone help me before my head explodes? Todd Ashworth ~~ 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: PL/SQL
Can you pass the PL/SQL to a stored procedure and use the dbms_sql package to execute it? I know I've executed simple SQL statements - like truncate which you can't do right in PL/SQL for some reason - but I don't know how complex you can do with dbms_sql. Dan -Original Message- From: Jeff Britts [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 8:39 AM To: CF-Talk Subject: RE: PL/SQL Basically, we're working on a tool to generate the pl/sql script on the fly so we cant use a stored proc. Any ideas? -Original Message- From: C Frederic Valone [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 9:54 AM To: CF-Talk Subject: Re: PL/SQL We use cf and pl/sql stored procs extensively. What exactly are you trying to do? Jeff Britts wrote: Anyone have any luck running PL/SQL through ColdFusion? The simple stuff seems to work ok, but if you throw it something complex it chokes. Jeff Britts ColdFusion Engineer e-Dialog ~~ 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: Undcocumented Feature (Copyright MS) in Coldfusion 4.5 isde fine d() function
I don't know whether it is an error or a bug or expected behavior, but have
learned that it doesn't work. The way to get around it is to not use the
array type notation "[#currentslot#]" that you are using.
Instead of:
isdefined("request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot[#currentslot#].att
ributes.sequencenumber.Value")
use:
isdefined("request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot.#currentslot#.attr
ibutes.sequencenumber.Value")
Dan
-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 8:40 AM
To: CF-Talk
Subject: "Undcocumented Feature" (Copyright MS) in Coldfusion 4.5
isdefine d() function
This appears to be an error in ColdFusion's isdefined("") function
- the parameter is syntactically valid - I am outputting it successfully on
the line above...
==
Error Diagnostic Information
An error occurred while evaluating the expression:
isdefined("request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot[#currentslot#].att
ributes.sequencenumber.Value")
Error near line 104, column 8.
Parameter 1 of function IsDefined which is now
"request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot[1].attributes.sequencenumber
...Value" must be a syntactically valid variable name
~~
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: Undcocumented Feature (Copyright MS) in Coldfusion 4.5 isde fine d() function
You cannot reference arrays in the ISDEFINED function :)
Bryan Love ACP
[EMAIL PROTECTED]
-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 8:40 AM
To: CF-Talk
Subject: "Undcocumented Feature" (Copyright MS) in Coldfusion 4.5
isdefine d() function
This appears to be an error in ColdFusion's isdefined("") function
- the parameter is syntactically valid - I am outputting it successfully on
the line above...
==
Error Diagnostic Information
An error occurred while evaluating the expression:
isdefined("request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot[#currentslot#].att
ributes.sequencenumber.Value")
Error near line 104, column 8.
Parameter 1 of function IsDefined which is now
"request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot[1].attributes.sequencenumber
...Value" must be a syntactically valid variable name
~~
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: Passing variables to a SQL7 stored procedure
You can look up CFPROCPARAM for passing parameters -Original Message- From: Andres [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 12:01 PM To: CF-Talk Subject: Passing variables to a SQL7 stored procedure What is the equivalent of cfparam name="var" default="" inside a stored procedure? i want to pass a value to a stored procedure, but the value, and the variable that holds it, may not be passed all the time. I want the stored procedure to assign a value of "" to the variable if no value is passed to it. Then, depending on this variable, it needs to perform either one of two queries. can someone give me pointers on how to do this?? thanks andres leon ~~ 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: Passing variables to a SQL7 stored procedure
This could get a little tricky, but there are many ways to do it... To default a value in a stored proc you simply put and equals sign and a value after if: Create procedure Order... storeID int, userID int, productID int = 0 This way if you only pass in storeID and userID then productID will be created and defaulted to 0 (as shown below): EXECUTE Order 1,1 The only catch is that you MUST declare the defaulted values LAST in the stored proc or you'll have problems (I think you can see why) Good luck! Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: Andres [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 9:01 AM To: CF-Talk Subject: Passing variables to a SQL7 stored procedure What is the equivalent of cfparam name="var" default="" inside a stored procedure? i want to pass a value to a stored procedure, but the value, and the variable that holds it, may not be passed all the time. I want the stored procedure to assign a value of "" to the variable if no value is passed to it. Then, depending on this variable, it needs to perform either one of two queries. can someone give me pointers on how to do this?? thanks andres leon ~~ 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: Passing variables to a SQL7 stored procedure
When you declare the input parameter, assign it a value, like so: CREATE PROC myProc @Param1 char(10) = '' AS SELECT ... Bob -Original Message- From: Andres [mailto:[EMAIL PROTECTED]] Sent: December 8, 2000 12:01 PM To: CF-Talk Subject: Passing variables to a SQL7 stored procedure What is the equivalent of cfparam name="var" default="" inside a stored procedure? i want to pass a value to a stored procedure, but the value, and the variable that holds it, may not be passed all the time. I want the stored procedure to assign a value of "" to the variable if no value is passed to it. Then, depending on this variable, it needs to perform either one of two queries. can someone give me pointers on how to do this?? thanks andres leon ~~ 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: Undcocumented Feature (Copyright MS) in Coldfusion 4.5 isdefine d() function
At 04:40 PM 12/8/00 +, you wrote:
This appears to be an error in ColdFusion's isdefined("") function
- the parameter is syntactically valid - I am outputting it successfully on
the line above...
==
Error Diagnostic Information
An error occurred while evaluating the expression:
isdefined("request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot[#currentslot#].att
ributes.sequencenumber.Value")
Error near line 104, column 8.
Parameter 1 of function IsDefined which is now
"request.XMLPacket.BOOKINGSERVICE.SLOTLIST.slot[1].attributes.sequencenumber
..Value" must be a syntactically valid variable name
I'm not sure that having "attributes" in there is syntactically valid since
that's a variable scope.
~~
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: List w/ delims
For the record: You can use more than one symbol for a list delimiter if you assign it to a variable first: cfset delim = "||*||" cfloop list="#list#" delimiter="#delim#". Don't ask why, it just works that way Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: Jeff Britts [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 9:38 AM To: CF-Talk Subject: RE: List w/" " delims Maybe the "*" character is throwing it off. Sorry, I might have given you a bad example. This is some code I have that works. I set up an array and then convert it to a list... cfset stuff_list = #arraytolist(stuff_new,"||Q||")# I can then pick items from that list, using a #location# index. cfset stuff1 = #listGetAt(stuff_list,location + 1,"||Q||")# cfset stuff2 = #listGetAt(stuff_list,location + 2,"||Q||")# cfset stuff3 = #listGetAt(stuff_list,location + 3,"||Q||")# cfset stuff4 = #listGetAt(stuff_list,location + 4,"||Q||")# Jeff Britts ColdFusion Engineer e-Dialog -Original Message- From: Robyn Follen [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 9:58 AM To: CF-Talk Subject: RE: List w/" " delims I've tried to user multiple characters as a list delimiter, but whenever I then try to iterate through the list, specifying my delimiter, it doesn't work. E.g., When I have the following code, CFSET myList = "o|ne |*| t*wo |*| th|*ree" CFLOOP Index="listElement" List="#myList#" Delimiters="|*|" CFOUTPUT #listElement#BR /CFOUTPUT /CFLOOP I get: o ne t wo th ree because it takes each item in the list of delimiters and checks for them individually. Has anyone any insight on how to loop through something with a particular combination of characters for a delimiter? Any help would be appreciated, Robyn -Original Message- From: Jeff Britts [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 8:29 AM To: CF-Talk Subject: RE: List w/" " delims You CAN use multiple characters as list delimiters...eg. "|*|". I do it frequently to cut down on the chances that one of my list items contains a delimiter. Jeff Britts ColdFusion Engineer e-Dialog -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 2:21 PM To: CF-Talk Subject: Re: List w/" " delims Keep in mind that list delimiters can only be 1 character. -- Billy Cravens [EMAIL PROTECTED] Eric Fickes wrote: Got a List question for you. I've got a text file that I need to parse and it's " delimited list, in a way. The list format is this. "Full Name" "Email Address" "Group List" "Login Name" "Demo user for startup" "" " 1;" "Demo" I was hoping to somehow use " " as a delimeter, but that's not working. When I do that it takes out the spaces in the column names. I'd like to take "Full Name" "Email Address" "Group List" "Login Name" and turn it into Full Name,Email Address,Group List,Login Name Any ideas? E ~~ 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: loops, queries, ug...
You can't nest cfoutputs if they both have query attributes. You can run this in one query with a table join and output using grouping. Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: Andres [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 9:41 AM To: CF-Talk Subject: RE: loops, queries, ug... did you try something like this cfquery datasource="subnets" name="getsubnet" SELECT * FROM subnets order by subnetid /cfquery cfoutput query="getsubnet" group="subnetid" #subnetid# cfquery datasource="subnets" name="getsubnetinfo" SELECT * FROM subnetinfo WHERE subnetid = #subnetid# /cfquery cfoutput query="getsubnetinfo" subnet ifo here... /cfoutput /cfoutput -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 10:23 AM To: CF-Talk Subject: loops, queries, ug... I'm confused! I have 2 tables in the same database, one table has a list of subnets(subnets), and the other will contain information on each subnet(subnet_info). The subnet in the subnets table is the unique id in that table, which has a one to many relationship with the subnet in the subnet_info table. What I want to do is present a table that would present a subnet, then it's corresponinding IP's and Info, then repeat for each subnet. Something like: 208.208.208 IP = 1 Name = boxname Description = what this box does 208.208.209 ect... I'm not sure of the best method to do this. I tried building a query on the subnet table, then in the cfoutput of that query, loop through another query on the subnet_info table... but it doesn't work. Any ideas for me how to do this? TIA, Pete ~~ 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: Bulk imports into database
This is a SQL command -- it depends on which DBMS you're using. It has no dependance on CF except that CF pass the info to the DBMS correctly. -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 6:05 AM To: CF-Talk Subject: Re: Bulk imports into database Does this command only work with 4.5? I am using 4.0. - Original Message - From: "paul smith" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, December 04, 2000 9:17 PM Subject: Re: Bulk imports into database I use the following for BULK INSERTs cfquery name="InsertInitial" DATASOURCE="#DSN#" USERNAME="#user#" PASSWORD="#pass#" BULK INSERT Victor FROM 'D:\FR\FileResource\101-200.csv' WITH ( FIELDTERMINATOR=',', ROWTERMINATOR=' ' ) /cfquery Very fast! best, paul At 03:06 PM 12/4/00 -0600, you wrote: Actually, Enterprise Manager is just a front-end to SQL Server, and you'd want to automate the "back end", not the "front end". For SQL Server, take a look at "BULK INSERT" (look in the Books Online). It allows you to take a text file containing your data, and bulk insert that data (duh) into a table you specify. The syntax is a bit trickier than that, but fairly simple. ~~ 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: ODBC errors with MS Access after MDAC 2.6
Drew, See the following ColdCut I wrote in the Teratech ColdCut database. It tells you how to deal with misbehaved MDAC installs. Hope it helps you! Eron http://www.teratech.com/coldcuts/cutdetail.cfm?cutid=89 -Original Message- From: Steve Pierce [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 12:04 PM To: CF-Talk Subject: RE: ODBC errors with MS Access after MDAC 2.5 The update was to MDAC 2.5, not 2.6. My fault for getting the numbers mixed up. But the CF code broke after upgrading to MDAC 2.5. Also for more background the server is running NT4 SP6a, Website 2.5.8 and CF Enterprise 4.0.2. The CF code worked fine with MDAC 2.4, it was after upgrading to MDAC 2.5 that this one CF template started throwing a PCode error. - Steve -Original Message- From: Dru Whitledge [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 10:13 PM To: CF-Talk Subject: ODBC errors with MS Access after MDAC 2.6 After upgrading to MDAC 2.6 (contains ODBC) at my ISP I am now experiencing memory errors for MS Access queries that once ran without a problem (and still do on my MDAC 2.1 server). The CF server provides the following error message -- (and of course stops execution) CMemoryException: unknown cause PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag Has anyone else had this problem? Anyone aware of any fixes? As I started into this I had assumed that the new MDAC 2.6 upgrade simply tightened up some requirment for correct SQL syntax -- now I'm not so sure. One query I'm rebuilding seems to fail on a adding a simple concatenation to create an alias field -- (field1) (field2) AS Field3 while (field1) AS Field3 works fine. That's hard to workaround. Thanks, Dru ~~ 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: IIS plugin
I don't think you need a plugin. It is usually an option that you can select from the logging menu. At 12:04 PM 12/8/2000 -0600, you wrote: where can I find an IIS plugin that allows a cookie to written to the IIS log files. Eric ~~ 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
