Re: WYSIWYG html editor applet?
Chris: I like soEditor Lite. Check it out here: http://www.siteobjects.com/pages/soeditoroverview.cfm You can download an encrypted free trial. HTH! Joel - Original Message - From: "Chris Edwards" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 10:08 AM Subject: WYSIWYG html editor applet? > Anyone know of a free and decent java applet that will do simple html > editing for a client who wants to create simple html documents for email. > this would go in place of a standard textarea. > > thanks. > > -- > Chris Edwards > Web Application Developer > Outer Banks Internet, Inc. > 252-441-6698 > [EMAIL PROTECTED] > http://www.OuterBanksInternet.com > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL on form submission
Sorry for the previous message. I stand corrected. It appears I didn't understand it correctly. Thanks. - Original Message - From: "Jesse Houwing" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 30, 2002 11:32 AM Subject: Re: SSL on form submission > Joel Firestone wrote: > > Well, if I understand it correctly, the SSL secures the data being > > transferred. > > If you only use it on the action page, and not the submission itself, the > > data going from form.cfm to action.cfm would not be secure. But if form.cfm > > is in SSL, then it would be secure. > > That would be incorrect. > > It goes as follows: > > The user enters the data into the form. > The browser compiles this to a bunch of data to send > The browser contacts the server on which the actio file resides > The browser sees it needs to use SSL as the action file is on a secure > server > The browser sends the data over the encrypted connection > > So any data sent to a file on a SSL secured server will be encrypted. > data coming FROM a secure connection and going to a unsecure connection > however is therefor NOT safe. > > Jesse > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL on form submission
Well, if I understand it correctly, the SSL secures the data being transferred. If you only use it on the action page, and not the submission itself, the data going from form.cfm to action.cfm would not be secure. But if form.cfm is in SSL, then it would be secure. HTH - Original Message - From: "Chad Gray" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 30, 2002 11:05 AM Subject: RE: SSL on form submission > That is the safe way I would assume.. but is it necessary? > > > > -----Original Message- > From: Joel Firestone [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 30, 2002 9:58 AM > To: CF-Talk > Subject: Re: SSL on form submission > > I always do it for the form. The submission would then be protected. > > HTH > > - Original Message - > From: "Chad Gray" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, July 30, 2002 10:55 AM > Subject: SSL on form submission > > > > Im wondering if when a form is submitted at what point do you request > > SSL? > > > > Do you want the form to be covered under SSL as the user is filling it > > out? https://www/form.cfm > > > > Or do you leave the form http://www/form.cfm and use > > https://www/action.cfm"; method="POST"> enough to encrypt > > the data being passed to the action page? > > > > Just curious > > > > > > > > > > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL on form submission
I always do it for the form. The submission would then be protected. HTH - Original Message - From: "Chad Gray" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 30, 2002 10:55 AM Subject: SSL on form submission > Im wondering if when a form is submitted at what point do you request > SSL? > > Do you want the form to be covered under SSL as the user is filling it > out? https://www/form.cfm > > Or do you leave the form http://www/form.cfm and use > https://www/action.cfm"; method="POST"> enough to encrypt > the data being passed to the action page? > > Just curious > > > > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Random Record
One way: HTH J - Original Message - From: "Eric J Hoffman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 5:19 PM Subject: Random Record > What is the best way to get a random record from an table that has > frequent changes and updates...best practices or practical advice from > veterans? Randrange between 1 and recordcount won't work pulling a num > and then going against primary id..so somehow to get a "row"? > > Thanks. > > Regards, > > Eric J. Hoffman > Director of Internet Development > DataStream Connexion, LLC > (formerly Small Dog Design) > > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: application.cfm
Darren: We had a machine that was using (by default) the registry to store the client variables. Then it started crashing like every few hours. We looked at the registry, and it was like 120 mb. The machine crawled. So we cleaned it out, and set the storage to cookies, and it hasn't gone down since. Joel - Original Message - From: "Darren Adams" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 10, 2002 10:08 AM Subject: RE: application.cfm > I am sure you are correct but can you explain why it might bring my system > down to it's knees ? > > Also, it cant be the ie6 error if there are 2 machines on ie5.5 which > suffer the same problems, the machine name does not use any illegal > charactors (e.g. uk1web2). > > It also works when you run programmes in the subdirectory display/ (e.g. > display/introduction.cfm). The only errors that occur are with the > csupport/ child directory of the root. > > -Daz > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 10 April 2002 15:00 > To: CF-Talk > Subject: RE: application.cfm > > > HOLD ON! do not use the registry to store your client variable information. > use a data source and change it RIGHT NOW. you will bring the machine to its > knees one day doing that. > > on a suddle note. client variables still use cookies to track the user. no > matter what you have select as your client storage. now i could be wrong > about it assigning cookies, i think it only does it if you check "assign > client cookies". i think if you don't check that it tries to track the user > by ip or some other way. can anyone confirm this? > > in any case, i think the ie6 cookie problem is what is killing him. try to > access through that ip, if that works, there's your problem. > > Anthony Petruzzi > Webmaster > 954-321-4703 > http://www.sheriff.org > > > -Original Message- > From: Darren Adams [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 10, 2002 9:51 AM > To: CF-Talk > Subject: RE: application.cfm > > > Hmmm I think he is using IE6. > > However I am not using cookies, I'm using the registry to store the client > variables. > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 10 April 2002 14:48 > To: CF-Talk > Subject: RE: application.cfm > > > just a shot in the dark, but this might be the same problem i had. is he > using ie6? if so make sure that the domain name of the machine he is trying > to connect to doesn't have an "illegal" characters in it, like an "_". see > if by accessing the machine from an ip if his client variables come up: > > instead of http://test_svr > use http://10.1.1.5 > > client variables need cookies to work and if it is the problem i'm thinking > of, ie isn't letting the cookies be assigned. > > > Anthony Petruzzi > Webmaster > 954-321-4703 > http://www.sheriff.org > > > -Original Message- > From: Darren Adams [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 10, 2002 9:25 AM > To: CF-Talk > Subject: application.cfm > > > > Hi guys, > > > > Just a quick one for you. > > > > I have an application that exists within the directory home/ within that > > directory I have anothe called display/ which contains files which call > > content from a database according to the value of a client variable. > > > > However, a colleague of mine is doing some work in another directory > > within home/ and that does not seem to be able to pick up the client > > variables. > > > > The application.cfm is in the root of the parent directory and one of the > > child directories can access the client variables so what is going on > > with the other child directory ? > > > > Any ideas ? > > > > > > > > Darren Adams > > Web Developer > > Marketing Department > > Systems Union > > > > Email: [EMAIL PROTECTED] > > Website: www.sunsytems.com / www.systemsunion.com > > > > "Data + Structure = INFORMATION" > > > > > > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF & DTS Packages
Dave: I just did this. I simply scheduled the SQL server to run it. Then there's one less player in the game (CF server). My $.02. Joel - Original Message - From: "Bosky, Dave" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 02, 2002 11:47 AM Subject: CF & DTS Packages > I have a user that uploads an Access database every 2 weeks and I want to > create a DTS package to automatically > Import the data into sql server. What are some good references for creating > Access->SQL DTS packages? > > Would you schedule the package to run through sql server or should I setup a > scheduled task in CF to connect to the package and run it every two weeks? > > Thanks, > Dave > > > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: special characters
Thanks for the code. I just went in and did a replace for the time being,
see
the ñ and Ñ were only gonna be the ones used. But thanks anyway. I still
wanna check out Dave's post, tho.
Joel
- Original Message -
From: "Park, Simon" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 26, 2002 3:07 PM
Subject: RE: special characters
> > When trying to add characters like ñ and Ñ, my SQL 7
> > server tells me I have not enclosed my strings properly.
> > I'm assuming the tilde is breaking it. Any way around
> > that, other than looking for that character and replacing
> > it, with say the HTML equivalent that works? Or will I
> > just have to do a replace() on the string?
>
> If you are using CF 5, a quick way to replace special characters (like
smart
> quotes when cutting and pasting from Word) is to use user-defined
functions.
> The one we adapted from a couple of sources is this:
>
>
> function SafeChars(textin) {
>
> bad_chars="(tm),
,"",",",',',-,-,Æ,Á,Â,À,Å,Ã,Ä,Ç,Ð,É,Ê,È,Ë,Í,Î,Ì,Ï,Ñ,Ó,Ô,Ò,Ø
>
,Õ,Ö,Þ,Ú,Û,Ù,Ü,Ý,á,â,æ,à,å,ã,ä,ç,é,ê,è,ð,ë,í,î,ì,ï,ñ,ó,ô,ò,ø,õ,ö,ß,þ,ú,û,ù,ü
> ,ý,ÿ,¡,£,¤,¥,¦,§,¨,©,ª,«,¬,,®,¯,°,±,²,³,´,µ,¶,·,¸,¹,º,»,¼,½,¾,¿,×,÷,¢";
>
>
>
good_chars="&##153;, ,",",",‘,’,—,&nda
>
sh;,Æ,Á,Â,À,Å,Ã,Ä,Ç,Ð
>
,É,Ê,È,Ë,Í,Î,Ì,Ï,Ñ,
>
Ó,Ô,Ò,Ø,Õ,Ö,Þ,Ú,Û,
>
Ù,Ü,Ý,á,â,æ,à,å,ã,
>
ä,ç,é,ê,è,ð,ë,í,î,&igr
>
ave;,ï,ñ,ó,ô,ò,ø,õ,ö,&szl
>
ig;,þ,ú,û,ù,ü,ý,ÿ,¡,£
>
,¤,¥,¦,§,¨,©,ª,«,¬,,®
>
;,¯,°,±,²,³,´,µ,¶,·,¸
>
;,¹,º,»,¼,½,¾,¿,×,÷
> ,¢";
>
> /* Replace Content with updated Content */
> text_out=ReplaceList(textin, bad_chars, good_chars);
> return text_out;
> }
>
>
> You can put this UDF at the top of the page (or include it if you want to
> use it multiple times) and then use a SQL statement like this:
>
> INSERT INTO mytable
> (myfield1, myfield2)
> VALUES
> ('#SafeChars(mytext1)#', '#SafeChars(mytext2)#')
>
>
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Simon Park Computer Systems Management, Inc.
> Director, E-Business 205 South Whiting Street #201
> Ph: 703-823-4300 x119 Alexandria, VA 22304
> fax: 703-823-4301 http://www.csmi.com
>
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: session variable renewal
Exactly. You usually just check for it's existence. If it doesn't exist, set it (which is usually "false", since it doesn't exist). It'll stay until it either 1) it times out (after 20 minutes), or 2) is deleted by you intentionally. HTH. Joel - Original Message - From: "Ricq Pattay" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 10:10 AM Subject: Re: session variable renewal > So you wouldn't need the Session.LoggedIn="true" statement to renew the > session variable? Activity alone renews it? > > - Original Message - > From: "Paul Giesenhagen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, March 26, 2002 9:02 AM > Subject: Re: session variable renewal > > > > 10:35 > > Activity starts things over. > > > > Paul Giesenhagen > > QuillDesign > > http://www.quilldesign.com > > SiteDirector v2.0 - Commerce Builder > > > > > > - Original Message - > > From: "Cornillon, Matthieu" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Tuesday, March 26, 2002 8:58 AM > > Subject: session variable renewal > > > > > > > Hello. Do session variables get renewed when you set them? In other > > words, > > > let's say that my application has a 20-minute session variable timeout. > > At > > > 10:00, a user hits a page that sets Session.LoggedIn="true". At 10:15, > > the > > > user hits that page again. Does Session.LoggedIn expire at 10:20 or > > 10:35? > > > > > > Thanks, > > > Matthieu > > > > > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: session variable renewal
Matthieu: It expires after inactivity of 20 minutes. So at 19:59 a link is clicked, the clock startes over. Joel - Original Message - From: "Cornillon, Matthieu" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 9:58 AM Subject: session variable renewal > Hello. Do session variables get renewed when you set them? In other words, > let's say that my application has a 20-minute session variable timeout. At > 10:00, a user hits a page that sets Session.LoggedIn="true". At 10:15, the > user hits that page again. Does Session.LoggedIn expire at 10:20 or 10:35? > > Thanks, > Matthieu > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
special characters
CFDJ'ers: When trying to add characters like ñ and Ñ, my SQL 7 server tells me I have not enclosed my strings properly. I'm assuming the tilde is breaking it. Any way around that, other than looking for that character and replacing it, with say the HTML equivalent that works? Or will I just have to do a replace() on the string? TIA. Joel __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: JS back?
How about:
..
alert("Your file is too big!");
history.back();
HTH
Joel
- Original Message -
From: "Greg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 11:06 AM
Subject: JS back?
> I'm testing for file size after posting a form. Is there a way to use
> javascript:history.back() to send me back to the form instead of having
> to pass all the form values back in the url of cflocation? (Also don't
> want to do the wddx thing because I have to use
> enctype="multipart/formdata" to submit the input type="file", and the
> only way I know to serialize the form data is to loop over the
> form.fieldnames and it in a structure. And with
> enctype="multipart/form-data" form.fieldnames plays out as the VALUES
> instead of the actual fieldnames.) I tried this:
>
> FILEFIELD="photo"
>
> DESTINATION="D:/wserver/ediets/myediets/profile/photos/#form.username#"
> NAMECONFLICT="OVERWRITE"
> ACCEPT="image/gif, image/jpg, image/jpeg,
> image/pjpeg">
>
>
>
>
> But it's sloppy. Any javascripters know if I could have an alert box to
> display the message. Then after you click OK it could do the
> javascript:history.back()?
>
>
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cgi.path_info
Everyone: Is there a setting in apache that would turn on/off the ability to read the cgi.path_info variable in Cold Fusion? The server is Linux Red Hat running CF 4.5. When I try to read the path info, I just get an empty string. Another server with the same setup returns the variable fine. Thanks. Joel F. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: session timeouts
Thanks. My guess was memory, tho the Linux box says the resources are fine. Oh well. J "Joel Firestone" <[EMAIL PROTECTED]> wrote in message 3b028d3f$[EMAIL PROTECTED]">news:3b028d3f$[EMAIL PROTECTED]... > Everyone: > > We have an application that uses session vars to track if the user is > logged in. Yesterday, the sessions started timing out after 10 - 15 > seconds, even tho Application.cfm sets it at 20 minutes. Is it a > memory issue? Or should I look elsewhere? Just recently we set the > default Client storage to Cookie (by default, instead of registry). > Could that play a role (even tho we're not using client management)? > > Any help is appreciated. > > Joel > > ~~ 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
session timeouts
Everyone: We have an application that uses session vars to track if the user is logged in. Yesterday, the sessions started timing out after 10 - 15 seconds, even tho Application.cfm sets it at 20 minutes. Is it a memory issue? Or should I look elsewhere? Just recently we set the default Client storage to Cookie (by default, instead of registry). Could that play a role (even tho we're not using client management)? Any help is appreciated. Joel ~~ 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
JavaScript VTM
All: Does anyone know of any .vtm file written for JavaScript functions? I've found ones for ASP, PHP, etc. I was just curious if there was one for JS. And also if anyone has a toolbar set for studio 4.5x. Thanks. = Joel Firestone - Lead Developer Delmarva Online Web Development http://www.dmv.com/ ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: COM and CFOBJECT - beginner problem
Mike: Thanks. They're actually weren't anything. So after running, I simply set and so on, and it worked. Thanks for the guidance. That's what I get for trying to copy > paste from another code snippet. : ) Joel : Looks to me like the .Fields is not a property of the OCX control The : reason that it would appear to work in the ASP code is that the ASP code : does not try to call AuthCtl.Fields and so does not error. : : Try using something like OLEView to see all the properties and methods : available in the OCX : : HTH : : 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
COM and CFOBJECT - beginner problem
All:
First, I apologize for the length of this message. I just want everyone to
see all the code I'm dealing with.
I'm currently setting up a WebAuthorize Hub. I was sent an ocx file and an
ASP page to test with. So I've supplied the ASP code and the code I'm trying
to write. So I registered the COM and the ASP page works fine. When I run
the cfm page, I get this error:
Error resolving parameter AUTHCTL.FIELDS
Thanks to all...
webtest.cfm:
#RespText.value#
=
webtest.asp:
=
<%
' Simple ASP implementation
' This script sends an Authorization & prints the results on the browser
'
Set AuthCtl1 = Server.CreateObject("AuthCtl.AuthCtlCtrl.1")
AuthCtl1.Hub = 1
AuthCtl1.Protocol = "SOCKETS"
AuthCtl1.HostName = "xxx.xx.x.xxx"
AuthCtl1.Port =
AuthCtl1.SocketTimeoutValue ="60"
AuthCtl1.Secure = FALSE
AuthCtl1.KeepSocketOpen = TRUE
AuthCtl1.Merchant = "xx"
AuthCtl1.Account = Request("card_number")
AuthCtl1.ExpDate = Request("card_exp")
AuthCtl1.Amount = Request("amount")
AuthCtl1.AVSAddress = Request("card_address")
AuthCtl1.AVSZip = Request("card_zip")
' Call the Authorize function
AuthCtl1.Authorize
%>
=
Joel Firestone
Delmarva Online Web Development
http://www.dmv.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: IsNumeric Function
One way I found useful was to use JavaScript on the client-side to test if they were numbers or not. Then you know only numbers are being submitted. J : I am trying to do some server side validation for a phone number, but I am running into an odd problem. I split the phone number entry form into three textboxes the first one for area code (ie must be 3 numbers) and then the two parts of the phone number (ie must be 3 numbers and then must be 4 numbers). I check to make sure the length of each textbox is correct and then I try to check if they are numeric, however it will throw an error. : : My code looks something like this: : : : "> : : : The strange part is that when I take out the not IsNumeric() statements for the first two form variables it works fine. Ideas??? : : -Greg ~~ 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
"Sticky" variables
Everyone: I've seen a few posts here and there discussing session variables in a clustered environment. Are there any pages or resources I can look at that would help explain them, or how to implement them? A cluster is in my not-so-distant future, so I want to be prepared. Many thanks. Joel -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: limiting upload file size - solution
I just had to do this recently. I found the tutorial here. Check it out: http://www.teamallaire.com/tutorials/limitFileUploadSize.cfm Joel : To do this use you can use the : CGI.CONTENT_LENGTH variable : : Justin MacCarthy -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help With Upgrading From Access 2000 to SQL for my cf site
I seem to get it everytime I do it, even after I've checked to make sure the fields were named correctly. So I've lately just been pasting in the tables and correcting the primary keys and ntext fields. Prolly a better way, but it's fairly quick and painless. Joel "Russell, Bonnie" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... : I've had experience with alot of this. : : Check into these areas, : : the field names are not SQL compatible : SQL has enough space alloted to it : the sql transaction log is not filled up : : I've actually had to make a CF page to import data to SQL before. Now, if : you're using SQL7.0 there's an import function which will import data from : access, if you're using 6.5 it's not there. : : Feel free to contact me if you need some extra help : bonnie : [EMAIL PROTECTED] : : -Original Message- : From: AustralianAccommodation.com Pty. Ltd. : [mailto:[EMAIL PROTECTED]] : Sent: Wednesday, June 30, 1999 10:18 AM : To: [EMAIL PROTECTED] : Subject: Help With Upgrading From Access 2000 to SQL for my cf site : : : I am using the access 2000 interface to convert and upload my access : 2000 database into sql via the upsize wizard inside access 2000 : : however when I attempt to upsize the uploads terminate with an error : report saying that either there were errors in the conversion of certain : table or else the tables were skipped : : has anyone experienced this before and if so any ideas as to the cause : and solution to the problem I am running on win 98 : : : : Kind Regards : : Claude Raiola (Director) : AustralianAccommodation.com Pty. Ltd. : Website: www.AustralianAccommodation.com : Email: [EMAIL PROTECTED] : : : -- : Archives: http://www.eGroups.com/list/cf-talk : To Unsubscribe visit : http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or : send a message to [EMAIL PROTECTED] with 'unsubscribe' in : the body. : -- : Archives: http://www.eGroups.com/list/cf-talk : To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: row numbers
Doug: Does queryname.currentrow help? Joel "Douglas Jordon" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... : Is there a way to find out which row number any given record is? : : TIA, : : Doug Jordon : -- : Archives: http://www.eGroups.com/list/cf-talk : To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Textarea
Try #body# Joel "Gregg Kachel" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... : Hi, I'm sort of a newbie with Cold fusion, so I'm probably doing some : simple mistake. I can't get my text to show up on a cfquery using : tag. Here is my code: : : Wierd thing is if I change it to an imput type ="text" it works fine. So i : know it has to be something in my textarea code. Wierd part is, that same : exact code is used elsewhere and works. If anyone can help please do, : thanks. The database is in access and is set for "memo" in that field. It : wouldn't be so bad but, some of the articles are rather long for a normal : text field. : : Gregg Kachel : : -- : Archives: http://www.eGroups.com/list/cf-talk : To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Selecting one number from a list
I guess I better beef up on my database design skills. Thanks to everyone. Joel "Dave Watts" <[EMAIL PROTECTED]> wrote in message 000601bfe055$9cc19ec0$[EMAIL PROTECTED]">news:000601bfe055$9cc19ec0$[EMAIL PROTECTED]... : This is not the right approach. You'll want to use an intersection table, as : Mark suggested. The point of using an intersection table is to allow you to : easily construct many-to-many relationships within your database. If you : want to associate one item with many categories, and associate one category : with many items, that's a many-to-many relationship and you'll want a table : between item and category which contains all of the intersections between : items and categories. : : I can't overemphasize the importance of correct database design to the : success of application development. If you've come to CF from a : non-programming background, as a lot of people have, you might not have : learned enough about relational databases. CF makes it very easy to learn : how to program, but it doesn't supply the knowledge you need to build : well-designed database applications. The sooner you learn that stuff, the : better your programming life will be. I can tell you this through my own : personal experience. I started programming with CF, and didn't know very : much about database design - and I had lots of problems until I buckled down : and learned how to use a relational database. : : To take your situation as an example, there are several potential problems : with storing lists of foreign keys within a field. If you were to delete a : category, you'd have to retrieve the list of categories stored within each : item, modify each list that contains the category to be deleted, then update : those lists. That's a lot of unnecessary work, and doesn't allow the : database to manage itself, as it can with declarative referential integrity : rules. If you simply wanted to list all of the items within a given : category, that would require a similar procedure. On the other hand, if you : simply add an intersection table to your database, you can use that to : perform these operations quickly and efficiently. : : Dave Watts, CTO, Fig Leaf Software : http://www.figleaf.com/ : voice: (202) 797-5496 : fax: (202) 797-5444 : : -- : Archives: http://www.eGroups.com/list/cf-talk : To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Selecting one number from a list
Thanks. That's exactly what I'm looking to do, and will test. Much appreciated!
And I guess I better learn to explain myself better. : )
Joel
"Philip Arnold - ASP" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
: > I have a table with a varchar field named catid. When a url variable named
: > catid is passed, the page grabs all the data for that specific
: > catid. Simple stuff.
: >
: > My problem lies in now I need for the catid to be a list
: > (2,5,56,89). Thus the
: > varchar field, and not a numeric. How can I select those items
: > that contain
: > the correct url.catid? I tried the IN keyword, with no success.
:
: If I've got this the right way round - the CatID in the database contains
: the list, and the user only passes one ID, right?
:
: If that's the case, then you're going to have to do one of 2 thinks;
: Use InStr/CharIndex to find the character
: Use Like
:
: The problems with this is that if you look for smaller digits than the
: larger ones (like looking for 1) then it'll find it in things like 1, 10,
: 11, 21 etc. etc.
: The way around this is to look for the number with commas around it - but
: you've got to add commas to the start and end of the field when you're
: looking, so;
:
: Select *
: from myTable
: where CharIndex(',#URL.CatID#,', ',' + CatID + ',') > 0
:
: CharIndex is the SQL Server version, if you're using Access, then it's
: InStr, and the parameters are round the other way
:
: With Like, you'd do;
:
: Select *
: from myTable
: where ',' + CatID + ',' Like '%,#URL.CatID#,%'
:
: But I haven't tried this, so it may not work
:
: Also note that Access uses & instead of + for string concatonation
:
: HTH
:
: Philip Arnold
: 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.
: **
:
:
: --
: Archives: http://www.eGroups.com/list/cf-talk
: To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Selecting one number from a list
I was storing them as a list so one item could be associated with several categories, instead of having to add one for each category. All I want is for an ID to be passed, and if that ID exists within that column, then display it. I'm trying all of these solutions. Thanks. Joel "Mark Warrick" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Why are you storing a list of numbers in a varchar field? If you were trying to associate attribtures of a product with attributes in other tables, then you should be using index tables. For example: PRODUCTS id_product product_name 1 t-shirt 2 baseball hat 3 sweater COLORS id_color color_name 1 white 2 black 3 red PRODUCTS_TO_COLORS id_product id_color 1 1 1 2 2 3 3 2 Creating this index table would be basically the thing as having a products table with a varchar field for colors as I suspect you have it setup: PRODUCTS id_product product_name product_colors 1 t-shirt 1,2 2 baseball hat 3 3 sweater 2 So why, you might ask, do you use another table to create the relationships? Well, becuase it's proper datbase design. You keep the numbers numbers and in doing so maintain the query and processing speed. Whenver you convert a datatype to or from text, you're going to cause headaches for yourself. ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- > -Original Message- > From: Joel Firestone [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 27, 2000 6:04 AM > To: [EMAIL PROTECTED] > Subject: Selecting one number from a list > > > Everyone: > > I'm having a complete brain fart, so hopefully you guys can help. > > I have a table with a varchar field named catid. When a url variable named > catid is passed, the page grabs all the data for that specific > catid. Simple > stuff. > > My problem lies in now I need for the catid to be a list > (2,5,56,89). Thus the > varchar field, and not a numeric. How can I select those items > that contain > the correct url.catid? I tried the IN keyword, with no success. > > Any help would be greatly appreciated. > > Joel > > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf > _talk or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Selecting one number from a list
Everyone: I'm having a complete brain fart, so hopefully you guys can help. I have a table with a varchar field named catid. When a url variable named catid is passed, the page grabs all the data for that specific catid. Simple stuff. My problem lies in now I need for the catid to be a list (2,5,56,89). Thus the varchar field, and not a numeric. How can I select those items that contain the correct url.catid? I tried the IN keyword, with no success. Any help would be greatly appreciated. Joel -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: ASP
Or try www.learnasp.com. Good tutorials there, as well. Joel <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... : hi there! I know this is a CF list, but my boss asked me to create a template : in ASP and I've never worked with it. : I have a few easy questions: : : 1st. Where can I find a good tutorial on the net? : : 2nd. How do I return the "RecordCount" of a query? : : 3rd. How can I set the maxrows so I can create broken templates in a search : (like next, and previous buttons, page1, 2, 3, 4) : : Thanks a lot : : Vinicius Carvalho : Digicadd - Official Autodesk Reseller : : : : -- : Archives: http://www.eGroups.com/list/cf-talk : To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: HTML Text Editor
Bridget: Try 1st Page 2000. It's decent, and free. http://www.evrsoft.com/1stpage2.zip Joel : Hello, : I am looking for a free downloadable html text editor. I thought had : bookmarked one that was mentioned in this forum, but I guess I didn't. : If anyone had any good suggestions, please let me know. : Thanks! : Bridget -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: removing space between words being uploaded to a database
: can I ask what the code is to remove spaces between words so that I can = : update the database with the values minus the blank spaces -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Update Query
Miriam: If they can change everything, then you really have nothing to tie the fields together, so the db doesn't know which to change. In these instances, a unique identifier should be used. Hope this helps. Joel "Miriam Hirschman" <[EMAIL PROTECTED]> wrote in message 01bfcbe4$51bd3680$6baa70d8@mhirschman">news:01bfcbe4$51bd3680$6baa70d8@mhirschman... How can I specify which row in my table I want to update if the user has the ability to change every field. Is there any way besides making an autoNumber field? I have an Access DB. Thanks, ---miriam -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Replacing line breaks and paragraph breaks with HTML equivelents
Try: ReplaceNoCase(strClean, Chr(13), "', "ALL") It's what to search for then what to replace it with. : Hi all, : : I'm currently working on building a fully threaded message board. Progress : is going well however I'm having a minor problem. I'm trying to replace user : enter line breaks with tags but I'm not having any luck. Here is what : I've tried, : : ReplaceNoCase(strClean, "", Chr(13),"ALL") : : What am I missing. : : Thanks : : Lee : : -- : Archives: http://www.eGroups.com/list/cf-talk : To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Is there a typical cause for this error message?
Normally, if memory serves me well, it means your trying to enter data into a field where the length of the data is longer then the maximum number of characters allowed. If it's a form, try maxlength="", or expand the length of your datatype. Joel : Error Occurred While Processing Request : Error Diagnostic Information : ODBC Error Code = 22001 (String data right truncation) : : : [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would : be truncated. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Automatically transferring data from one table to another
Hubert: I've found just setting an extra Yes/No column (called "Pending" in this example) in your main table. When a joke is submitted, it automatically sets "Pending" to Yes. Then, build a page that shows all of the items with Pending checked "Yes", and build it so all chosen id's get changed to "No" for Pending. Otherwise, you could build a page to do it manually, or hourly/daily/weekly with CFSCHEDULE. Joel "Hubert Earl" <[EMAIL PROTECTED]> wrote in message 001301bfca63$6da3fd20$2e0020c4@a6h8m9">news:001301bfca63$6da3fd20$2e0020c4@a6h8m9... : Hi, : : Is there a way I may transfer data from one table to another automatically? : I have a table containing jokes which can be accessed thru a browser. I'm : building another to which anyone can upload jokes. After reviewing them, I : want to be able to transfer any I wish to keep automatically to my first : table, without having to copy and paste them (for example). I'd appreciate : any suggestions. : : Sincerely, : --- : Hubert Earl : ICQ#: 16199853 : : I develop & maintain web sites internationally. I also build web : applications using ColdFusion, JavaScript and CGI scripts written in Perl. : I accept subcontracting work. : : **Personal web site: http://www.geocities.com/hfme/ : (please remember to view this with a sense of humor!) : : **Business web page: http://home.talkcity.com/MigrationPath/hearl/ : : -- : Archives: http://www.eGroups.com/list/cf-talk : To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF vs ASP
Another: http://www.houseoffusion.com/index.cfm?body=body/asp Joel : I wrote on Friday to ask for some good resources or reasons why CF is a : better application developer than ASP. Although I did receive some really : good references, I didn't receive nearly as much of a response as I thought : I would. : The web references are great and I know that everyone is very busy so I am : just throwing it out one more time in case anyone missed it over the holiday : weekend. : I have been using CF for about 7 months and love it. However, I started at : a new company who initially said that using CF wouldn't be a problem. Now : it seems that the IT department would like to standardize the products we : use and would like to use ASP. I have found several articles comparing the : two, in which CF always wins; but I really need as much input, insight and : advice that I possibly can on this issue because I am now a complete : advocate of CF. : : : Thanks very much and I apologize for sending the same issue in twice. : Bridget : -- : Archives: http://www.eGroups.com/list/cf-talk : To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: adding RDS Server in studio
Andrew: Setup your RDS to point to your Cold Fusion server. The setup an ODBC connection to your Oracle server. Then when you connect to the RDS, you'll be able to browse the datasources on that machine. The datasource is what connects directly to the database. Hope this helps. Joel "Andrew Fandre" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I've got a problem that I can't figure out where to begin solving. My cold fusion server is running on Solaris. My database is on a Netware server running Oracle 8 My CF Studio is running on Win98 I am trying to bring up the Oracle database on the RDS database tab within Studio. Whenever I put in the IP or the url to the database Studio locks up. I would appreciate any suggestions or recommendations. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: adding RDS Server in studio
Doh! I meant to say setup an ODBC datasource on your Cold Fsuion server in the admin to point to your Oracle db. After I read it, I was confused. : ) : Setup your RDS to point to your Cold Fusion server. The setup an ODBC : connection to your Oracle server. Then when you connect to the RDS, you'll : be able to browse the datasources on that machine. The datasource is what : connects directly to the database. : : Hope this helps. : : Joel : : "Andrew Fandre" <[EMAIL PROTECTED]> wrote in message : [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... : I've got a problem that I can't figure out where to begin solving. : : My cold fusion server is running on Solaris. : My database is on a Netware server running Oracle 8 : My CF Studio is running on Win98 : : I am trying to bring up the Oracle database on the RDS database tab within : Studio. Whenever I put in the IP or the url to the database Studio locks up. : : I would appreciate any suggestions or recommendations. : : -- : Archives: http://www.eGroups.com/list/cf-talk : To Unsubscribe visit : http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send a : message to [EMAIL PROTECTED] with 'unsubscribe' in the body. : : -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: simple cfselect question
Bridget: I would assume all you need to do is setup up your form page (with the option) and a result page. Once submitted, use to email the message including your chosen form option (#form.option#). Hope this helps. Joel "Bridget Corkery" <[EMAIL PROTECTED]> wrote in message 81F8640048FBD2118FA600A0C9D609DA74E2A5@KVTEXCH">news:81F8640048FBD2118FA600A0C9D609DA74E2A5@KVTEXCH... : Hello, : I have built a drop down menu, but would like to have the option of : selecting an option and having the selected item mailed to an e-mail : address. : Could anyone help me with this? : Thanks, : Bridget : -- : Archives: http://www.eGroups.com/list/cf-talk : To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Form Updates, newbie question
: Hi there, : : I have a form with a number of drop down boxes, i'd like to populate fields : further down the form from my db as the choices are made in the drop down : boxes, do i have to use JavaScript to do this or can i keep it in CF : context? Thanks for any help. : : Stewart There's a tag in the gallery called TwoSelectsRelated and ThreeSelectsRelated by Nate Weiss. Killer stuff. You may want to try them out. And yes, he uses JavaScript and arrays to do it. They're worth the download. Joel -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Why won't this work?
: : There are #Get.RecordCount# Dealers in Your State. : : #Get.RecordCount# is 0> : Please contact Us : Jeff: Try: There are #Get.RecordCount# Dealers in Your State. Please contact Us You ended the http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF Studio 4.5
: Is anyone selling a copy of the latest studio? I see that it's listed as : $495, but I was hoping to find it a bit lower (this comes oout of my : pocket). Go to http://www.pricegrabber.com/ and do a search on it. We bought a copy from thebigstore.com for like $249 - full retail licensed 1 user copy. Joel -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Sum
This is a multi-part message in MIME format. --=_NextPart_000_002F_01BFC40C.895D2DA0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Miriam: If it's numerical, you can do: select sum(myfield) as sum_myfield and that will add them up for you. Or, if you simply need the total items selected, you can use=20 #myquery.recordcount#.=20 Didn't know which ya needed. : ) Is there a way in CF that you can add the summ of all the results in a certain query? Thanks, ---miriam -= - Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit = http://www.houseoffusion.com/index.cfm?sidebar=3Dsts&body=3Dsts/cf_talk = or send a message to [EMAIL PROTECTED] with = 'unsubscribe' in the body. -- --=_NextPart_000_002F_01BFC40C.895D2DA0 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Miriam: If it's numerical, you can = do:select sum(myfield) as = sum_myfield and that will add them up for = you. Or, if you simply need the total = items selected,=20 you can use #myquery.recordcount#. Didn't know which ya needed. : = ) Is there a way in CF that you can add the summ of all the results = in=20 acertain=20 query?Thanks,---miriam---= ---Archives:=20 http://www.eGroups.com/list/cf-talk">http://www.eGroups.com/list/= cf-talkTo=20 Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dsts&body=3Ds= ts/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=3Dsts&body= =3Dsts/cf_talk=20 or send a message to mailto:[EMAIL PROTECTED]">cf-talk-request@houseof= fusion.com=20 with 'unsubscribe' in the body.-- --=_NextPart_000_002F_01BFC40C.895D2DA0-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Training
Everyone: Was wonderin gif anyone has taken any training classes from Learning Tree. I'm signing-up for a class, and was just curious if anyone has had experience with them, and how it was. I was hoping Fig Leaf would re-open to the CF Top Gun course or the JavaScript course, but both look to be put on hold. Thanks. === Joel Firestone - Lead Developer Delmarva Online http://www.dmv.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Comparison sites in CF
Everyone: Looking for a little insight. I'm interested in setting up a comparison feature for my web site. I've seen several sites that do it (books, computers, software, etc.) and I'm wondering: Do they get a current db from all of the vendors to compare with? Or do they write their own components to go out and get the prices "on-the-fly"? What would the best scenario? I figured the first would be alot faster, but the second would be alot more current. Any input would be appreciated. Thanks. === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Macs, PC's, and Cold Fusion
Everyone: I found the solution to this problem. IE cannot handle the enctype="multipart/form-date" in the tag. It just completely stops. If you take that line out, the form works fine. Netscape has no problem with it. Just an FYI. === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ > Does anyone have problems with pages working differently from PC to Mac? > I'm having problems with a site I did. All the pages do is simply perform > and > addition or update to the database. In IE and Netscape on the PC, it works > fine. It pops up an alert box and redirects. On the Mac, when the form is > submitted, it just prints a blank html page. It never writes the data, or > redirects. > It does nothing. > > Can anyone help me figure this out? I'm losing more and more hair and brain > cells. It's IE 4.5, if that helps. I don't wanna bash Macs, but... > > Thanks. > > === > Joel Firestone - Developer > Delmarva Online > http://www.dmv.com/ > > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Macs, PC's, and Cold Fusion
Xing: Thanks. I figgered it musta been with IE, so I downloaded 5 and installed it. Same problem. The problem I'm experiencing is the page all uses the same code throughout. Some pages work, and others don't. And I'm not using any tags anywhere. I'm using session and url variables throughout. But with Netscape, it's all good. I won't bash the Mac. In some aspects, I like it. I've just been born and bred PC. : ) === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ > There is an undocumentated bug with Mac IE in conjunction with CF's > cflocation tag. I have found the problem to only exist when you are > submitting a form and attemp to cflocate after some action. It does not > happen with all forms but only the critical ones you need to have working by > some deadline. ;-) In almost all cases when this happens, the script IS > executed properly. The Mac IE browser just chokes on the http redirection > headers. I haven't isolated the bug and that's the extent to what I can give > you in terms of info. Good luck! > > Xing > > p.s. Macs rule! > > >> Does anyone have problems with pages working differently from PC to Mac? > >> I'm having problems with a site I did. All the pages do is simply perform > >> and > >> addition or update to the database. In IE and Netscape on the PC, it works > >> fine. It pops up an alert box and redirects. On the Mac, when the form is > >> submitted, it just prints a blank html page. It never writes the data, or > >> redirects. > >> It does nothing. > >> > >> Can anyone help me figure this out? I'm losing more and more hair and > > brain > >> cells. It's IE 4.5, if that helps. I don't wanna bash Macs, but... > >> > >> Thanks. > >> > >> === > >> Joel Firestone - Developer > >> Delmarva Online > >> http://www.dmv.com/ > >> > >> > > > > > > -- > > Archives: http://www.eGroups.com/list/cf-talk > > To Unsubscribe visit > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > > send a message to [EMAIL PROTECTED] with 'unsubscribe' in the > > body. > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Macs, PC's, and Cold Fusion
OK. I narrowed it down to IE. It works fine in Netscape. Any help, again, would be greatly appreciated. > Does anyone have problems with pages working differently from PC to Mac? > I'm having problems with a site I did. All the pages do is simply perform > and > addition or update to the database. In IE and Netscape on the PC, it works > fine. It pops up an alert box and redirects. On the Mac, when the form is > submitted, it just prints a blank html page. It never writes the data, or > redirects. > It does nothing. > > Can anyone help me figure this out? I'm losing more and more hair and brain > cells. It's IE 4.5, if that helps. I don't wanna bash Macs, but... > > Thanks. > > === > Joel Firestone - Developer > Delmarva Online > http://www.dmv.com/ > > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Macs, PC's, and Cold Fusion
Everyone: Does anyone have problems with pages working differently from PC to Mac? I'm having problems with a site I did. All the pages do is simply perform and addition or update to the database. In IE and Netscape on the PC, it works fine. It pops up an alert box and redirects. On the Mac, when the form is submitted, it just prints a blank html page. It never writes the data, or redirects. It does nothing. Can anyone help me figure this out? I'm losing more and more hair and brain cells. It's IE 4.5, if that helps. I don't wanna bash Macs, but... Thanks. === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFHTTP - for the love of god!
This is a multi-part message in MIME format. --=_NextPart_000_00AF_01BFBA69.C6743460 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable "Stephen Garrett" <[EMAIL PROTECTED]> wrote in message = news:<[EMAIL PROTECTED]>... >=20 > I actually gave up on the builtin query aspect of CFHTTP due to buggy > problems and used one of the gallery tags instead: >=20 > Take a look at=20 >CFX_CSVToQuery Steve: I used this before, and it would print everything for me, but I could = never use=20 any of the results to write to another db. It would always say "Query = not found".=20 And I did use all of the correct attributes. How did you get around it. Thanks. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Joel Firestone - Developer Delmarva Online http://www.dmv.com/ --=_NextPart_000_00AF_01BFBA69.C6743460 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable "Stephen Garrett" <mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]> wrote in = message news:<;[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]">3.0.3.3= [EMAIL PROTECTED]>...>=20 > I actually gave up on the builtin query aspect of CFHTTP due to = buggy> problems and used one of the gallery tags instead:> = > Take a look at=20 > = ;= =20 CFX_CSVToQuery Steve: I used this before, and it would print everything for me, but I = could never=20 use any of the results to write to another db. It would always say = "Query not=20 found". And I did use all of the correct attributes. How did you get around = it. Thanks. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DJoel = Firestone - DeveloperDelmarva Onlinehttp://www.dmv.com/">http://www.dmv.com/ --=_NextPart_000_00AF_01BFBA69.C6743460-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Dynamic query without page refresh - possible?
Thanks everyone. Guess I better learn some JavaScript now. : ) The eternal slacker... === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Dynamic query without page refresh - possible?
Everyone: I'm wondering if the following is possible: Say you have a text field box where you can enter a model number. What I'm looking to do as soon as that text box looses focus, a query could be run to find that part number and display a description and other things WITHOUT the page needing to be refreshed or a form posted. Is it possible? And if so, any pointers or references would be greatly appreciated. Thanks. === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Sorry! CF Variables
If you're using studio, right-click and choose "Insert Expression". Then click on "Variables". They're listed there, as well. Just another way. === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ I might be looking in all the wrong places, but is there a reference someplace for CF variables? To clarify, I have found variables such as #REMOTE_ADDR# and #HTTP_USER_AGENT# in Ben Forta's CF Book, but can't seem to find any other reference to these or any other variables of this sort. Any help would be appreciated! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF and Search Engines Again.... =)
I "believe" the search engines use the same schemas OS's use. I'm not sure about Linux/Unix, but Windows won't allow ?'s in the name of a directory. So what I did was change the links so index.cfm?id=3&subid=4 is transformed so it reads index.cfm/id,3-subid,4.html I can't comment if it actually works because the site is still in progress. But as I've read in the forums, that's the way to index your dynamic content. My $.02. === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ > This question pop's up from time to time. I have a new slant on it though > that I want to see if would work. > > Suppose that I have a link that reads > > http://www.somedomain.com/somepage.cfm?something=somevalue&something2=someva > lue2 > > Everything I have found in the Allaire forums says that I need to replace > the ? and the & with / and then use a string replace method and etc. etc. > > How about just throwing a / at the very end and then striping it off. Would > the search engine then not treat everything that is in-between the / and the > / as a dir. instead of a page? The reason that I am asking is because on > two of my sites I kept noticing an error where people would add, or search > engines would add / at the end of the entire URL and it would throw an > error, so I started striping off that last trailing / and no I don't get any > more errors, but can we use this to our advantage and use it with search > engines? > > Any ideas, pro's, con's? > > Bill Killillay > ICQ @ 8425781 > > *~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~* > "An investment in Knowledge always pays the best interest." >-Benjamin Franklin- > *~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~* > > Get Paid to Surf the Web. It's free, easy and fun. > Sign up for AllAdvantage.com at > > http://alladvantage.com/go.asp?refid=FIB-034 > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CONVERT() for money datatype
Thanks. Dumb ol' me never looked to see that convert() wasn't a CF command. Worked like a charm. Thanks. === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ "Philip Arnold - ASP" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Everyone: > > > > I recently upsized an Access db to SQL 7. I'm having extreme frustrations > > trying to write to a money column. My code is: > > > > update ShipCost set productCost_beginRange = #convert(money, > > form.productCost_beginRange)#, > > productCost_endRange = #convert(money, > > form.productCost_endRange)#, > > shipCost = #convert(money, form.shipCost)# > > where shipOptID = #form.shipOptID# > > > > I have tried (I believe) every possible way to do it, with no success. The > > error I > > get is: > > > > Error resolving parameter MONEY > > > > Cold Fusion was unable to determine the value of the parameter. > > This problem > > is very > > likely due to the fact that either: > > > > 1. You have misspelled the parameter name, or > > 2. You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or > > CFTABLE tag. > > > > What do I need to do in order to update a money field? Any help would be > > GREATLY appreciated. > > OK, here's what you do, you let SQL Server convert it for you, not > ColdFusion > > update ShipCost > set productCost_beginRange=convert(money,#form.productCost_beginRange#), > productCost_endRange=convert(money,#form.productCost_endRange#), > shipCost=convert(money,#form.shipCost#) > where shipOptID = #form.shipOptID# > > this does 2 things; > 1, takes a bit (very tiny, but still a bit) of strain off of CF, > 2, lets SQL Server deal with everything in one go, which it'll do without > really noticing. > > Oh, and Convert is a SQL Server command, and not a CF command, so it > wouldn't really work anyway > > Philip Arnold > 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. > ** > > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CONVERT() for money datatype
Everyone: I recently upsized an Access db to SQL 7. I'm having extreme frustrations trying to write to a money column. My code is: update ShipCost set productCost_beginRange = #convert(money, form.productCost_beginRange)#, productCost_endRange = #convert(money, form.productCost_endRange)#, shipCost = #convert(money, form.shipCost)# where shipOptID = #form.shipOptID# I have tried (I believe) every possible way to do it, with no success. The error I get is: Error resolving parameter MONEY Cold Fusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: 1. You have misspelled the parameter name, or 2. You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. What do I need to do in order to update a money field? Any help would be GREATLY appreciated. === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Cost to attend CF Developer conference
This is a multi-part message in MIME format. --=_NextPart_000_00B8_01BFADEC.AF6E6D00 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable I "believe" it was $895 per person. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Joel Firestone - Developer Delmarva Online http://www.dmv.com/ > Does anyone remember what the cost per person was to attend last = year's CF > Developer conference in Boston? We are requesting funds to go to this = year's > conference in DC in November and I need a ballpark figure to submit. = (Looks > like this information isn't available yet at Allaire's site.) --=_NextPart_000_00B8_01BFADEC.AF6E6D00 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable I "believe" it was $895 per = person. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DJoe= l Firestone -=20 DeveloperDelmarva Onlinehttp://www.dmv.com/">http://www.dmv.com/ > Does anyone remember what the cost per person was to = attend last=20 year's CF> Developer conference in Boston? We are requesting = funds to go=20 to this year's> conference in DC in November and I need a = ballpark figure=20 to submit. (Looks> like this information isn't available yet at = Allaire's=20 site.) --=_NextPart_000_00B8_01BFADEC.AF6E6D00-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Perl script results
Everyone: I've been reading up on several comments about CF and Perl. I've resently been introduced to , which can really save me alot of time. What I need to know is if there's a way to save the results as a variable instead of a file? Or if there's any other way to capture it? Or is my only solution to use cfhttp passing it the text to run on, and then use the results to save as my variable? Thanks. === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: To and from Perl scripts
Thanks, guys. I also in my travels found CF_Perl, in case anyone ever needs a fix like we did in the future. === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ "Joel Firestone" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > CF-Talkers: > > Is there anyway to have a template run a Perl script, passing it a > variable, have the script do it's thing, and take what it did and > continue to process the request? I haven't messed with CGI in > 2 years, and even then, my experience was brief. > > Any help would be greatly appreciated. Thank you for your time. > > === > Joel Firestone - Developer > Delmarva Online > http://www.dmv.com/ > > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
To and from Perl scripts
CF-Talkers: Is there anyway to have a template run a Perl script, passing it a variable, have the script do it's thing, and take what it did and continue to process the request? I haven't messed with CGI in 2 years, and even then, my experience was brief. Any help would be greatly appreciated. Thank you for your time. === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
DES Encryption
Everyone: I've run across a requirement that we store passwords in a mySQL database with DES Encryption. Has anyone dealt with this that can point me in the right direction. Thanks. === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: newbie wants to pull tag list from allaire
Geo: I would "assume" they used to read the content in the table on the Developer's page showing the last 10 submissions. You would read the data, strip out the excess code, and display the info on your page. But this is my guess. === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ > I've seen on some CF sites where they've "pulled" Allaire's "Recent > Additions" top 10 list from the Developer's Exchange... How is this done? > > TIA > geo > > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: - CFStudio saves snippets where?
They're should be in UserData\Snippets in your Studio directory. And what I do is zip the folder up. Or simply copy it. It can't be the big unless you you have a gazillion snippets. === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ "Dave Wilson" <[EMAIL PROTECTED]> wrote in message 041301bf9f1d$54d9efa0$fe0aa8c0@davew">news:041301bf9f1d$54d9efa0$fe0aa8c0@davew... > Hi everyone, > > Can someone tell me where cfstudio stores the snippets which are stored in > the snippets library. Although I'm not about to move to a new machine, I'd > like to know how I can transfer my own library of snippets from one machine > to another and am too lazy to start looking through my Hard drive for these. > > Thanks in advance > Dave > > > Dave Wilson > Internet Technology Manager, > BizNet Solutions > > Co-Founder CFUG Ireland > http://www.cfug.ie > > 224, Lisburn Road > Belfast BT9 6GE > > Tel: 02890 225 776 > Fax: 02890 223 223 > web: http://www.biznet-solutions.com > > email: [EMAIL PROTECTED] > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Arrays or db storage?
Everyone: I would like your opinions, seeing that you all have experience with these scenarios. I would like your opinions on whether a shopping cart app should pass cart contents as arrays or stored in the database. I've been sampling several apps as I begin to build my own, and I just wanted to know what everyone seems to think. Personally I'm thinking of using arrays. I think it'll be faster and take a load off of the db. But I'm open to input. Thanks. === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Strange error - any ideas?
This is a multi-part message in MIME format. --=_NextPart_000_000F_01BF9594.BAF85AC0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Everyone: Thanks. Unfortunantly, this is a client we host. So I'm having check=20 the db on their end and re-upload. Once that happens, I'll try again.=20 But I know it's not a overload issue, as this site gets dismal page=20 views. Thanks again, guys. Joel "Alexander Lamon" <[EMAIL PROTECTED]> wrote in message = news:<[EMAIL PROTECTED]>... > Joel, >=20 > It's definitely a locking issue. I'll bet there's an Access .ldb file = in=20 > the same directory as your database file when this happens. I ran = into=20 > this myself. Access started to lock my DB file all by itself. Turns = out=20 > that the database had grown beyond Access capabilities and I had to = move=20 > to an enterprise platform (Oracle) If the cause is not someone=20 > physically having the database file open, you might want to check the=20 > integrity of your Access file. >=20 >=20 >=20 >=20 > >Everyone: > > > >I got this error today. It just started. And I haven't a clue why. = Here's > >what I get: > > > >ODBC Error Code =3D S1000 (General error) > > > >[Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet = database > >engine stopped the process because you and another user are = attempting to > >change the same data at the same time. > > > >And here's the code: > > > > > >select * from JobApps > > > > > >It doesn't get much simpler then that. I appreciate your input. And = there > >are no files included. > >Just this and a statement. > > > >Thanks. > > > >=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > >Joel Firestone - Developer > >Delmarva Online > >http://www.dmv.com/ > > > > > = >= -- > > > >Archives: http://www.eGroups.com/list/cf-talk > >To Unsubscribe visit=20 > = >http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_t= alk or=20 > >send a message to [EMAIL PROTECTED] with = 'unsubscribe' in=20 > >the body. > = -= - > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit = http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta= lk or send a message to [EMAIL PROTECTED] with = 'unsubscribe' in the body. --=_NextPart_000_000F_01BF9594.BAF85AC0 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Everyone: Thanks. Unfortunantly, this is a = client we=20 host. So I'm having check the db on their end and re-upload. = Once that=20 happens, I'll try again. But I know it's not a overload issue, = as this=20 site gets dismal page views. Thanks again, guys. Joel "Alexander Lamon" <mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]>= wrote in=20 message news:<;[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]">2324144= [EMAIL PROTECTED]>...>=20 Joel,> > It's definitely a locking issue. I'll bet there's = an=20 Access .ldb file in > the same directory as your database file = when this=20 happens. I ran into > this myself. Access started to lock = my DB=20 file all by itself. Turns out > that the database had grown = beyond=20 Access capabilities and I had to move > to an enterprise platform = (Oracle) If the cause is not someone > physically having = the=20 database file open, you might want to check the > integrity of = your=20 Access file.> > > > > = >Everyone:>=20 >> >I got this error today. It just started. And I haven't = a clue=20 why. Here's> >what I get:> >> >ODBC Error = Code =3D=20 S1000 (General error)> >> >[Microsoft][ODBC = Microsoft Access=20 97 Driver] The Microsoft Jet database> >engine stopped the = process=20 because you and another user are attempting to> >change the = same data=20 at the same time.> >> >And here's the code:>=20 >> ><cfquery name=3D"get" = datasource=3D"bayhealthDS">>=20 >select * from JobApps> ></cfquery>> = >>=20 >It doesn't get much simpler then that. I appreciate your input. And=20 there> >are no files included.> >Just this and a=20 <cfoutput> statement.> >> >Thanks.>=20 >> = >=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D&g
Strange error - any ideas?
Everyone: I got this error today. It just started. And I haven't a clue why. Here's what I get: ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. And here's the code: select * from JobApps It doesn't get much simpler then that. I appreciate your input. And there are no files included. Just this and a statement. Thanks. === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
