Vanishing variables
I have been developing a Fusebox app using the server on my machine (NT4
Server SP 5, CF Enterprise 4.5.1). Everything works when I route it through
localhost (127.0.0.1), but not when I try to use the hostname I have had set
up for testing. The problem is that the whole app seems to work, right up
to the point where the login sub-fuse (child of main fuse) passes back up to
the parent fuse. I have put stubs in my code to show me that the code is
working and setting the Session and Cookie variable, but when it passes back
up the tree, they disappear...
Here's the code:
~~
!--- act_dologin.cfm ---
!--- Rebellion Member Module ---
!--- If we didn't come from the login page, send the user there ---
CFIF NOT ISDEFINED("Form.Login") OR NOT ISDEFINED("Form.Password")
CFLOCATION URL="index.cfm?fuseaction=loginform"
/CFIF
!--- Lookup the login in the database ---
CFQUERY NAME="IsValidLogin" DATASOURCE="#request.MainDSN#"
SELECT IDENTIFIER, FIRSTNAME, MEMBERID
FROMREBEL.MEMBERS
WHERE (IDENTIFIER = '#Form.Login#') AND (LASTNAME = '#Form.Password#')
/CFQUERY
!---If it was an invalid login, send them back to the login page ---
CFIF ISVALIDLOGIN.RECORDCOUNT IS "0"
CFLOCATION URL="index.cfm?fuseaction=loginform"
/CFIF
!--- Otherwise setup personalization parameters and send the user on ---
!--- set Session variables ---
CFSCRIPT
Session.Member_ID = IsValidLogin.MemberID;
Session.Identifier = IsValidLogin.Identifier;
Session.FirstName = IsValidLogin.FirstName;
Session.NewsCount = 3;
/CFSCRIPT
!--- We'll need to include this in the Members table
// Session.NewsCount = IsValidLogin.NewsCount; ---
!--- set cookie ---
CFCOOKIE NAME="Member_ID" VALUE="#Evaluate("SESSION.MEMBER_ID")#"
EXPIRES="NEVER"
!--- Stub to test query and data
CFOUTPUT
Session.Member_ID #Session.Member_ID#BR
Session.Identifier #Session.Identifier#BR
Session.FirstName #Session.FirstName#BR
Session.NewsCount #Session.NewsCount#BR
Cookie Data #Cookie.Member_ID#BR
/CFOUTPUT ---
!---
Go to the home page
We have to do it this way as you can't CFLOCATION after a CFCOOKIE
See Allaire KnowledgeBase Article 467 at
http://www.allaire.com/Handlers/index.cfm?ID=1525Method=Full
---
META HTTP-EQUIV="Refresh" CONTENT="0 URL=../index.cfm?fuseaction=member"
CFABORT
~~
ANY help very appreciated.
Steve
| Stephen Collins|
| Senior Business Consultant - Powerlan |
|12/90 Barrier Street FYSHWICK ACT 2609 Australia|
| Ph +61 2 62800370 Fax +61 2 62800380 Cel +61 410 680722|
| [EMAIL PROTECTED] ICQ 56321783[EMAIL PROTECTED] |
| http://www.powerlan.com.au |
|~~~oOo~~|
| Before I got into triathlon, I was a normal person. |
||
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT (slightly): SA removed from US GPS
not quite cf but i know there's a fairly large gang of us dealing with GPS/GIS technologies: president clinton issued an executive order may 1st instructing the military to turn off the selective availability (simply put, SA is signal jamming) for the US's GPS satellites. this means that civilian GPS units are now about as accurate as military ones. by turning SA off, civilian GPS positioning errors are reduced from +/-120m to +/-5m! this is a milestone for the widespread adoption of GPS technology. whoopee! for more info see: http://www.igeb.gov/ Paul Hastings [EMAIL PROTECTED] Director Environmental Information Center Thailand Environment Institute Member Team Allaire http://www.tei.or.th/eic --- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Session variables
Thank you. But I want to add data while the visitor is browsing the site. So I need to keep the old data and to add new ones. I guess I cant use CFSET. Tibbs - Original Message - From: "Deanna L. Schneider" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 28, 2000 10:49 PM Subject: Re: Session variables It would seem that you're setting your cfparam tags on the wrong page You'll need to set them on the action page, after the user has entered their data. Then, it would be something like: cflock name="#session.sessionid#" timeout="30" cfset session.storeprod = prod#form.prodid# cfset session.storequan = quant#form.prodid# /cflock (cflock syntax varies by version.if you have cf 4.5 then use cflock scope="session"... Unless I'm misunderstanding the question, that should do it. -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: ATTENTION ALL OUTLOOK AND OUTLOOK EXPRESS USERS
With the Capital letters and the Exclamation marks and the screaming and the shouting and the... Taz -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: ATTENTION ALL OUTLOOK AND OUTLOOK EXPRESS USERS
Funny, I'm not sending any email in html and am using plain text, and I use both Outlook and OExpress. What about all those web based clients and Netscape's Mail reader. ?? why didn't you jump on them. If your going to ride someone for their mail client be a slut and ride them all. Fred - Original Message - From: "Reuben King" [EMAIL PROTECTED] Newsgroups: cf-talk To: [EMAIL PROTECTED] Sent: Tuesday, May 02, 2000 4:31 PM Subject: ATTENTION ALL OUTLOOK AND OUTLOOK EXPRESS USERS Please stop posting to the list in anything other than plain text. It is quite ugly and annoying for those of us who are using plain text newsreaders. Thanks, -RK -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: tag completion
It seems that certain tags do not have autotag completion I have my studio customized for auto insight But I notice certain tags do not auto completelike cfswitch any ideas how to edit this? In Studio 4.5.1... Options | Settings | Editor | Tag Completion | Add -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.co.uk/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Studio crashing with CFMLVALIDATOR.DLL
Can someone remind me how to re-register the CFMLVALIDATOR.DLL after a corrupt installation of Studio? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.co.uk/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: javscript mouseovers don't cache in .cfm pages
If you are using IE and are experiencing a delay in rollovers, check what the setting is under Tools | Internet Options | Settings | Check for newer versions of stored pages Two of those options (think it's the top 2 from memory) cause a delay in rollovers, even if the images haven't changed. Try altering the setting... might fix the problem for you. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.co.uk/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
System Colours in a drop down list
How to pop up colours in a list box in order to facilitate the user to select the appropriate colour KC -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Poping Colours in a drop down combo box/list
How can we pop up the colours in a drop down combo box/list so that the users can select the colour of thier choice KC -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Microsoft MSDN Bug RE-POST
http://msdn.microsoft.com/subscriptions/index/cdtable.asp - Try Ctrl+F and find the word "Key" Really unbelievable! Why is this a bug? Since M$ haven't use OEM numbers for products for about 2 years, they probably don't mind giving them out... Now, if they were to give out the new numbers, THAT would be a problem for them. Also, the OEM-IDs could be used on any product, the new ones are product specific. 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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Application Security
This is a multi-part message in MIME format. --=_NextPart_000_0023_01BFA810.1DB1D500 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi there, I'm trying to build a password protec system using = application.cfm and session variables. I tried the "Guide to Cf logins" (or whatever) from cftutorials Its not = working, so I tried by my self : Application.cfm -- CFAPPLICATION=20 NAME=3D"MyApplication" SESSIONMANAGEMENT=3D"Yes" SESSIONTIMEOUT=3D"#CreateTimeSpan(0,0,45,0)#"=20 APPLICATIONTIMEOUT=3D"#CreateTimeSpan(0,0,45,0)#" cfset application.dsn =3D "cadastro"=09 CFPARAM name=3D"session.LoggedIn" DEFAULT=3D"FALSE" !-- If the user is not yet logged in, and not currently on the login = pages, or the forgotten password page, -- CFIF #session.LoggedIn# IS "FALSE" cfif Cgi.scripName IS NOT "cadastro/adm/login.cfm" OR Cgi.ScriptName = IS NOT "cadastro/adm/validar.cfm" cflocation url=3D"../dcad2.html" addtoken=3D"No" cfelse =20 /cfif cfelse /CFIF login.cfm -- form action=3D"validate.cfm" method=3D"POST" table tr tdfont class=3DpadraoLogin/td tdinput type=3D"Text" name=3D"login" size=3D"10"/td /tr tr tdfont class=3DpadraoSenha/td tdinput type=3D"Password" name=3D"pwd" size=3D"10"/td /tr /table input type=3D"Submit" value=3D"Enviar" class=3D"padrao" /form cfset session.loggedin =3D false validate.cfm cfquery name=3D"checkuser" datasource=3D"#application.dsn#" = dbtype=3D"ODBC" SELECT Login, pwd FROM Usuarios WHERE Login =3D '#Form.Login#' AND pwd =3D '#Form.pwd#' /cfquery cfif checkuser.recordcount GT 0 cfset session.loggedin =3D true cflocation url=3D"adm/adm.cfm" addtoken=3D"No" cfelse cfset session.loggedin =3D false cflocation url=3D"login.cfm" addtoken=3D"No" /cfif What=B4s happening here is that the system will never a user get in the = dir adm, even if he enters the correct login/pwd. Could someone help me please? If you don=B4t want to correct this = horrible code, please send me one that works THANKS A LOT GUYS Vinicius --=_NextPart_000_0023_01BFA810.1DB1D500 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN" HTML HEAD META content=3Dtext/html;charset=3Diso-8859-1 = http-equiv=3DContent-Type META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR /HEAD BODY bgColor=3D#ff DIVFONT size=3D2Hi there, I'm trying to build a password protec = system using=20 application.cfm and session variables./FONT/DIV DIVFONT size=3D2I tried the quot;Guide to Cf loginsquot; (or = whatever) from=20 cftutorials Its not working, so I tried by my self :/FONT/DIV DIVFONT size=3D2/FONTnbsp;/DIV DIVFONT size=3D2Application.cfm/FONT/DIV DIVFONT size=3D2--/FONT/DIV DIVFONT size=3D2/FONTnbsp;/DIV DIVFONT size=3D2lt;CFAPPLICATION BRnbsp;nbsp;nbsp;=20 NAME=3Dquot;MyApplicationquot;BRnbsp;nbsp;nbsp;=20 SESSIONMANAGEMENT=3Dquot;Yesquot;BRnbsp;nbsp;nbsp;=20 SESSIONTIMEOUT=3Dquot;#CreateTimeSpan(0,0,45,0)#quot; = BRnbsp;nbsp;nbsp;=20 APPLICATIONTIMEOUT=3Dquot;#CreateTimeSpan(0,0,45,0)#quot;gt;/FONT/D= IV DIVFONT size=3D2/FONTnbsp;/DIV DIVFONT size=3D2/FONTnbsp;/DIV DIVFONT size=3D2/FONTnbsp;/DIV DIVFONT size=3D2lt;cfset application.dsn =3D=20 quot;cadastroquot;gt;/FONT/DIV DIVFONT size=3D2/FONTnbsp;/DIV DIVFONT size=3D2BRnbsp; lt;CFPARAM = name=3Dquot;session.LoggedInquot;=20 DEFAULT=3Dquot;FALSEquot;gt;/FONT/DIV DIVFONT size=3D2/FONTnbsp;/DIV DIVFONT size=3D2nbsp; lt;!-- If the user is not yet logged in, and = not=20 currently on the login = pages,BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; or=20 the forgotten password page, --gt;BRnbsp; lt;CFIF = #session.LoggedIn# IS=20 quot;FALSEquot;gt;BRnbsp;nbsp; lt;cfif Cgi.scripName IS NOT=20 quot;cadastro/adm/login.cfmquot; OR Cgi.ScriptName IS NOT=20 quot;cadastro/adm/validar.cfmquot;gt;BRnbsp;nbsp;nbsp;nbsp;=20 lt;cflocation url=3Dquot;../dcad2.htmlquot;=20 addtoken=3Dquot;Noquot;gt;BRnbsp;nbsp;nbsp;=20 lt;cfelsegt;BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20 BRnbsp;nbsp;nbsp; lt;/cfifgt;BRnbsp;nbsp;nbsp;=20 lt;cfelsegt;BRnbsp; lt;/CFIFgt;/FONT/DIV DIVFONT size=3D2/FONTnbsp;/DIV DIVFONT size=3D2login.cfm/FONT/DIV DIVFONT size=3D2--/FONT/DIV DIVFONT size=3D2lt;form action=3Dquot;validate.cfmquot;=20 method=3Dquot;POSTquot;gt;BRlt;tablegt;BRlt;trgt;BRnbsp;lt= ;tdgt;lt;font=20 class=3Dpadraogt;Loginlt;/tdgt;BRnbsp;lt;tdgt;lt;input=20 type=3Dquot;Textquot; name=3Dquot;loginquot;=20 size=3Dquot;10quot;gt;lt;/tdgt;BRlt;/trgt;BRlt;trgt;BRnbs= p;lt;tdgt;lt;font=20 class=3Dpadraogt;Senhalt;/tdgt;BRnbsp;lt;tdgt;lt;input=20 type=3Dquot;Passwordquot; name=3Dquot;pwdquot;=20 size=3Dquot;10quot;gt;lt;/tdgt;BRlt;/trgt;BRlt;/tablegt;BR= lt;input=20 type=3Dquot;Submitquot; value=3Dquot;Enviarquot;=20 class=3Dquot;padraoquot;gt;BRlt;/formgt;BRlt;cfset = session.loggedin =3D=20
URL Token
How to pass the URlToken to a form process template and how to refer to it in the template? Thank you in advance. Tibbs -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Getting Key Field after Insert
Hi, How can I sort the results of a query without using ORDER BY in my sql statement ? Thanks -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Charlotte CFUG 5.4.2000
This is a multi-part message in MIME format. --=_NextPart_000_000B_01BFB4D9.F43BDCD0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit To All Again... The meeting info below is correct. If you go to the web site, the map is to the place where the meetings were held last year. So please use the map attached to this email if you need directions. -Original Message- From: Eric Bradburn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 02, 2000 5:47 PM To: [EMAIL PROTECTED] Subject: Charlotte CFUG 5.4.2000 --A3ABB55E764949409BFCC182 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, All. The next meeting of the Charlotte CFUG is scheduled for next Thursday, 4 May at 6:30pm at the offices of iXL in uptown Charlotte. For more information go to www.charlotte-cfug.org Thanks, Eric Bradburn --A3ABB55E764949409BFCC182 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit !doctype html public "-//w3c//dtd html 4.0 transitional//en" html nbsp; brnbsp; brHi, All. pThe next meeting of the Charlotte CFUG is scheduled for next Thursday, 4 May brat 6:30pm at the offices of iXL in uptown Charlotte. For more information go to a href="http://www.charlotte-cfug.org"www.charlotte-cfug.org/a pThanks, brEric Bradburn/html --A3ABB55E764949409BFCC182-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --=_NextPart_000_000B_01BFB4D9.F43BDCD0 Content-Type: image/gif; name="IXL.gif" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="IXL.gif" R0lGODdhyAEDAYYAAP8AAAD//wAAAP8A/yKLIszMzICAgJnM/wDM ADPMzP//zP8AZsyZ///XAPDw8MyZMzKCMv//wDIAADMAZv/9//38/fn3+vHt9DUCZzYEaDkH aj4NbkQVckkcdlIqemdCjGxHkXFNlFtBdX9fn5J3rZh+sp6FtqWOu66awsO00su+2Me709vS5Ofh 7fTx9/b0+Pz7/fv6/EwieVs0hWI7inVTmHhXmoVnpIxwqdLH3lIqgYRdsODZ6Ozo8SwAanpcoj8g cPn4++vz38LamdXhwPb58ZO7SqLBZ73WjWyXFbDGg/X47fr79v7+/gAA ACwA yAEDAUAH/4AQgoOEhYUMhomKi4MMiIKPiZGGCIINEAYImpsIBoSTjouTjKQQjqGlkKmNq5Cj rYaOCqiwtY2ztoyvtQyziKPAqZWlvbS5prK+mJmcmccQw7G4z6m71KS/idGDDcycms6q1MbI18S8 1s+y5LrF6a3useLn1brKuqaHhcPbucUEKZ5AgVKkxECCOWToIEBgxo8fLThAQNHiBUMgKjq88MHw hQ4VOhAQUKEhBIgPLgjQGEFiCEMCLTSscKHBB4cOJDWI6EGDIQoNFono0EDAXD6j+CgpuoTpGzhB /a69O4qU3FRFV5HdwyrV1VZpxjwNEitWXlZi07gKozoPXjGs9//KLhNkQK5SUp0C6N3Lt69fvdXS Iv109ZRhwwoSK17MOPEmBZvsduV1iF2rsnVjZU1GLjPdudWmnjX19ZMizJQrC5ZXKqooSetGEyKr gG05fbYG6N7Nu7fv3bgHY+V81q4nTw6SK1++3JtzB4jkSibOKnV14YvIzpYcmvXsz6/htVtt2zSm scMFB1vlOuk6eoXqHvd+y7KoV69+6x/QjDv2y3RpZ94gzBXYXGSRJTeJfJ7RR5gvkchW3jhvuWKI fN/Vc9+F52Xn4IDjSZhNh6jJE80m2KQnIXrLGBBhLQC8JOOMNDIEAIgfZudUJ/4dk9l84DWIIyEG FumAc80w94j/dmXJ9s4pih1mX2jk2WKZdAH2GNx1QXYImnCxVZiKZ5okhc1boxm3pSSpABBjjXDK 6GZ4g3mDYobgkShkI6fAYuSfRzaTYANFdumlmZPB4oibb8Y5I6Or4PeKmodauSIyvUCo1lrQUFjl pnhadcxo1rwXKT2XYgXoqqy2eiA4zzlA6J+V0ondI/ZN0qiNbzL6kq+/2qrOghhamlifFg5yorJr 7tOWW6X9p6iVEyoq5pSnnunqttwmZ8CqSIIza7dGppqihtJqpWm6D65rTpnmndgeqmJ6CJq5RuFq 3blgRbfdcXuq+Aq5BHtr8LfMNcDUWE5pmUqBXjbosGbqREqq/7GlQemueIRpUya8jfCDqD1TMlDs WEKm41nA/og2arXxfabdp1ph22y7jpCLcHMFLhzfjhPfKrOh56Em4KGZLVnrsBZnimyIZ10FMsim zGslzRf2eClZP26I74A2xwdwgJWpyG6IRSK8c886NnyzP5ZKKffTwt7q9C5hDxstVPIeQnWOqkkY MCjDwczV0Vo6mQuDZT9bj6lnn9bL2gkzYmdkXI4T+eaw7V3VvsxSgkBtiHysjucxz5Uyl0dz7DrX LM/zNdx8rgkM6ubUpXBdSq4W1o6dGJ4t55HHNjLxQ7In8iHHwpX3yYCfixn0Qieysuu3Vcyv8PEY UjCgw3TfFP84mGeOLvLUSNzhW+qjj+n2xJReidWSQLg3pbZfqjLZeVaPMsrTwV5l9DWyFcXje8n5 iwIVGDSz0M0ccytevYwiJKOlrktAWtogMMBBDmYgABnoIAepJKLmmc86JuvftLKkwg29rW7wOx58 coFAB+znhr2Z4cvcBw+s8ZBNAzRMIkSIgRCdcHh88uELk1Wiz2zGAd9p3QqPGEMZVtFPNVQODnsz QeFp74eiUCIYqWg9BsWui+fz4n2+giEpvmZBJNLFtvDVxNrpD3Q0zKIDOgE0RVQCcomKHouIJi0z NlAY7eHHjkDkmjsZskGxwR2olkhJyKkvduEBkn8Y8D2bZfD/PJuBoShrUcPLPaVT1vLhHal1QTeS zIpRFFDXWtii/7HHeqFSZYWswTh6YImWrEHjybiDt0HuKWd6NFAKyUa9dkTNWkIURMHCFbxItQqQ xHtgx4xpKAOI0X/PoB/L0EhGbGbtkBlCZxIjUccpLmls2Ehm6jaJR1tsy07OiWcyFUROQVJyheyD nTphmQv6ie1k/RzlOpUGQPgRi4V1E18zyTgPV1YmmZP6pQ6Tp4hV9Q+Tu9jnn8wplRLKxi6hRIpB caknCKQlK2dU1GpWpk52qs5YeXucOmpoU2AakBEGMiWP8jS2iXZUpEUi6WCUikSuzG6lPcxpdTAz u2eJL0uD/0vK9KAnmqv600Gi6SQyoQOdzyXCW33kaPZaNExSIBViNTMXU9PI0loW1HLQSsczvSMZ erYMa71cBU2/hCpJKlSAdLrmXi/UjCtaLDuyhAC51Nq5UhmWoNuZJCOgiidPeLVxh41hO/9Zv9rE cqAMLZoaH7QezdEOqG9FLGxKyqHPJOerFK3PN4E4JmK2IipGBQt6LBraJ2mVpsVyWNQ+684oAnNI zB3lYmko29BW94u2YJSbaKTdM32qOFjNbehIwTUnipGdo90oVfC1i+up12y4pRhlsaGM2RkjpZRZ Jbvw61gI7OpX2pXTfwlwo8DYRzpN+u3paPEjgGGyce370v8DR4RZ6W21v6ZJqGNFtEap8naHqxVv 4T5XVfnGQrvdrdNg1wcLzq5Tp/xr8OuIq1kusde19XMZBEOMo7mW2IU1BuCKv5Q0wlaqr7XtrXLJ
SQL aggregation prob
I have a table called messages, the 3 columns I am working with are:- messageID, responseID, projectID I am trying to write a single query that will give me a total count of several columns:- Here is a pseudo code example of what I want variable = 1 select total messages (where responseID = 0) as threads select total messages (where responseID = messageID) as totalmessages where projectID = #variable# Here is what I have been playing with that doesn't work. I know what it is doing, it is comparing the messageID with responseID on each row individually and finding them not the same, rather than comparing every rows responseID against each messageID as I want. SELECT (select count(*) from messages where projectID = #URL.projectID# and responseID = 0) as threads, (select count(*) from messages where projectID = #URL.projectID# and responseID = messageID) as totalmsg FROM messages where projectID = #URL.projectID# Agghh help. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Query help
you need to add all the fields to which you are not applying an aggregate function to your GROUP BY clause to whit, add: GROUP BY ORDERID,CUSTOMERID,REPORTID,ORDERDATE,PRICE,TRANSAPPROVED,ORDER_TYPE to the end of the sql statement. Chris Olive DOHRS Website Administrator [EMAIL PROTECTED] -Original Message- From: stäs [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 02, 2000 5:02 PM To: [EMAIL PROTECTED] Subject: Query help Hello, I am getting the below message: [INTERSOLV][ODBC Oracle 8 driver][Oracle 8]ORA-00937: not a single-group group function SQL = "SELECT SUM(PRICE) AS tot_price,ORDERID,CUSTOMERID,REPORTID,ORDERDATE,PRICE,TRANSAPPROVED,ORDER_TY PE FROM REIS.ORDERS WHERE TRANSAPPROVED = 'Y' AND ORDERDATE BETWEEN '25-Apr-2000' AND '03-May-2000' AND ORDERS.ORDER_TYPE = 'F' ORDER BY ORDERS.ORDERDATE DESC" Thanks for any help. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: thumbnails
Hi does anyone know of any applications that creates thumbnail images of lots of different file formats (inluding formats like Word, PowerPoint, etc)? Any pointers much appreciated Thanks Steve Robson Consultant Planet Online Limited The White House Melbourne Street Leeds LS2 7PS Tel: 0113 2076164 Fax: 0113 2076360 Mob: 07967 048865 ICQ: 23832755 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
COLD FUSION DEVELOPER
Hi, We're looking for a Cold Fusion Developer for our San Diego CF web development studio. Fun East Village location, great atmosphere, flexible schedule. Send me a note off-line for more info, or send your resume, urls, sample code, etc. to [EMAIL PROTECTED] Thanks! Laura Wilber -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
encryption
Hi, Can anyone tell me howto encrypt a cfm file. what is the decryption method to decrypt this file? uday -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Visio - Spec tools
I plan the application out with it before I start coding. Excellent tool! -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 02, 2000 7:20 PM To: [EMAIL PROTECTED] Subject: Visio - Spec tools Any one here use Visio as a spec tool? Microsoft just bought them www.msn.visio.com. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Creating SQL tables from queries
cfquery name = "qry1" datasource="name" create table tablename(eno char(10), ename varchar(30), doj date) /cfquery ramesh -Original Message- From: Robert Flesher [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 2:30 AM To: [EMAIL PROTECTED] Subject: Creating SQL tables from queries Could someone please give me an example of how to create a table from a cfquery using CREATE TABLE. Thanx -Rob __ Do You Yahoo!? Send instant messages get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Popping Colours in a drop down combo box/list
This works in IE select option style="background-color: Red;" value="Red"nbsp;nbsp;nbsp; option style="background-color: Navy;" value="Navy"nbsp;nbsp;nbsp; option style="background-color: Olive;" value="Olive"nbsp;nbsp;nbsp; option style="background-color: Black;" value="Black"nbsp;nbsp;nbsp; option style="background-color: Blue;" value="Blue"nbsp;nbsp;nbsp; option style="background-color: Silver;" value="Silver"nbsp;nbsp;nbsp; option style="background-color: Magenta;" value="Magenta"nbsp;nbsp;nbsp; option style="background-color: Aqua;" value="Aqua"nbsp;nbsp;nbsp; /select -Original Message- From: Kalyan Chakravarthy Modali [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 5:26 AM To: [EMAIL PROTECTED] Subject: Poping Colours in a drop down combo box/list Importance: High Sensitivity: Confidential How can we pop up the colours in a drop down combo box/list so that the users can select the colour of thier choice KC -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: thumbnails
Steve, You may want to try the CF_AutoResizeor the cfx_gifgd custom tags. They both can create thumbnail images from both jpg and gif files. regards, larry -- Larry C. Lyons 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. -- "Steve Robson" [EMAIL PROTECTED] wrote in message 6BF1C330AF53D311BE5D00508B090810030957E2@PLANET01">news:6BF1C330AF53D311BE5D00508B090810030957E2@PLANET01... Hi does anyone know of any applications that creates thumbnail images of lots of different file formats (inluding formats like Word, PowerPoint, etc)? Any pointers much appreciated Thanks Steve Robson Consultant Planet Online Limited The White House Melbourne Street Leeds LS2 7PS Tel: 0113 2076164 Fax: 0113 2076360 Mob: 07967 048865 ICQ: 23832755 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Thank you for choosing Smart Web Tech .............
I would really appreciate this too. The main culprits are users of Outlook and Outlook Express. I would be a happy man if everyone would just post in plain-text. Hey, there are those of us who use Outlook who KNOW how to post in plain-text. It's rather like those damn signatures - now they annoy me as they look like attachments, so you click to look and it's nothing at all... what have I learned from this thread? Some people hate html text. Some people hate different fonts. Some people hate not clipping properly. Some people hate clipping too much. Some people hate sig's. Some people hate anything and everything that isn't done the way they want it. Me? I have a magic button that all I have to do is press it, and it deletes whatever I didn't want to read without forcing an entire list to have to follow my rules. Could we possibly remove intolerance from the list? Marcus (flame away... Delete works on those too :)) -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: encryption
Can anyone tell me howto encrypt a cfm file. what is the decryption method to decrypt this file? CFCrypt does the encryption for you, and you should never have to dcrypt it, as the server does it when you call the template. There are hacking tools which will break the encryption, but I wouldn't let them anywhere near my machine in case they contain deliberate viruses. 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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Working with dates
ya it is possible but u should specify dates with inthe quotes ramesh -Original Message- From: Tim Bahlke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 02, 2000 11:38 PM To: [EMAIL PROTECTED] Subject: RE: Working with dates I want to be able to search my DB by anything added since mm/dd/ date. So, I am hoping I can say in my query ... WHERE Personal.DateEntered=04/28/2000, for example. Is this possible? Tim Bahlke Graphica www.thinkcreate.com P: 336.230.0575 F: 336.230.0083 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Charlotte CFUG 5.4.2000
This more trouble than I thought:-) http://www.mapblast.com Search for Camden Rd. in Charlotte, NC and you will get the same map as the broken URL below Duh, Huh... -Original Message- From: Bill Plummer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 10:20 AM To: [EMAIL PROTECTED] Subject: RE: Charlotte CFUG 5.4.2000 Once Again... This URL will take you to the map to the Charlotte CFUG. http://www.mapblast.com/myblast/map.mb?CMD=GEOCT=IC=GMI=GAD1=GAD2=GAD3 =noPrefs=remLoc=AD4=USAAD2_street=Camden+Rd.AD3=Charlotte%2C+NCapmenu= apcode=AD2=Camden+Rd.req_action=crmap -Original Message- From: Bill Plummer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 8:31 AM To: [EMAIL PROTECTED] Subject: RE: Charlotte CFUG 5.4.2000 This is a multi-part message in MIME format. --=_NextPart_000_000B_01BFB4D9.F43BDCD0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit To All Again... The meeting info below is correct. If you go to the web site, the map is to the place where the meetings were held last year. So please use the map attached to this email if you need directions. -Original Message- From: Eric Bradburn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 02, 2000 5:47 PM To: [EMAIL PROTECTED] Subject: Charlotte CFUG 5.4.2000 --A3ABB55E764949409BFCC182 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, All. The next meeting of the Charlotte CFUG is scheduled for next Thursday, 4 May at 6:30pm at the offices of iXL in uptown Charlotte. For more information go to www.charlotte-cfug.org Thanks, Eric Bradburn --A3ABB55E764949409BFCC182 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit !doctype html public "-//w3c//dtd html 4.0 transitional//en" html nbsp; brnbsp; brHi, All. pThe next meeting of the Charlotte CFUG is scheduled for next Thursday, 4 May brat 6:30pm at the offices of iXL in uptown Charlotte. For more information go to a href="http://www.charlotte-cfug.org"www.charlotte-cfug.org/a pThanks, brEric Bradburn/html --A3ABB55E764949409BFCC182-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --=_NextPart_000_000B_01BFB4D9.F43BDCD0 Content-Type: image/gif; name="IXL.gif" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="IXL.gif" -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Microsoft MSDN Bug
and then i said "WOW THATS THE BEST CF SECRET EVER" and we went out for sodas! Orbitz. Bye! HAND! Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "The net interprets censorship as damage and routes around it." - John Gilmore -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Mail Queue Stuck
I solved this problem. The first email message in the queue had a corrupted email address. I also didn't notice that my CPU was being eaten up because apparently CF was trying to process this message and couldn't. I stopped CF, deleted the message, restarted and then my mail queue started processing (and my CPU usage went back to normal). -Original Message- From: Eron Cohen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 10:12 AM To: Cf-Talk Subject: Mail Queue Stuck Hi Folks, I seem to have a problem with my Cold Fusion 4.51 server's mail spool. I've had 400 messages sitting in the spool directory for over 10 hours now. I assume this means something is "stuck". I rebooted the Cold Fusion 4.51 server and I rebooted the Post.Office 3.51 server as well, but the jam seems to persist. Can anyone give me any ideas on how to go about resolving this. Eron -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Poping Colours in a drop down combo box/list
You can also set up a table for selecting colors...see a test URL for a project that I'm working on... http://itissrva.cpit.cua.edu/isadore/test.cfm If anybody wants it, I can forward you the module that I created to do this. + + Benjamin Smedberg + CUA Assistant Webmaster + [EMAIL PROTECTED] - http://computing.cua.edu/as/bds/ + + He is risen, as He said! Alleluia! + -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: custom tag - security based on user
We have a field in the database for the primary key of their entry in the user database. All the queries search based on that field, so each user only has access to records with their user id. At 06:58 PM 5/2/00 -0700, you wrote: I need to set up security so that a user enter's their user name and password (from a db table) then that user name is used in all queries so they only can see their own data from the database. Anyone know of a custom tag for this that's already done? I didn't see anything in the Allaire tag gallery and the custom tags link at forta.com has been broken for quite some time. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF Presentation for my class
At 07:24 AM 5/3/00 -0500, you wrote: Check out www.digitaltheater.com and www.carton.com and www.sync.com Depending on the interests of the students, they might be familiar with these. www.carton.com gave me a 403 Forbidden access error. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: encryption
The method I use is within the Project Deployment scripting. If you use the wizard, you will be able to select "Encrypt Pages" before you actually export it. Although the encryption is, in fact, a two-way algorithm, it is not intended to be decrypted by humans. The CF Server does the decryption internally, as it knows the routine well. I will bet that you could find a decryption script out there to do what you ask, but I would not recommend it. As CF evolves, the algorithm becomes undoubtedly more complex rendering the decryption script useless from time to time. This also promotes the use of such utilities, which fall into the category of script kiddie hacks. - Original Message - From: "Uday Pai" [EMAIL PROTECTED] Sent: Wednesday, May 03, 2000 11:24 AM Subject: encryption Can anyone tell me howto encrypt a cfm file. what is the decryption method to decrypt this file? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: cfmail and attachments
On Tue, 2 May 2000, Bud wrote: I know sending individual e-mails will send the attachment each time. I guess a better question would have been, does sending a cfmail using a query: cfmail query="myQuery" cause individual e-mails to be sent or does it work like BCC or CC? Hi, I'm just looking at cfmail at the moment... I *think* this will cause individual emails to be sent, assuming you use something from the query to populate the 'TO' attribute of cfmail. To use CC or BCC you will need to build a varible/string containing the addresses, separated by commas, and then 'hash' it into the CC or BCC field. (Sorry, I can't give you a code snippet, CF is still quite new to me. Perhaps in a day or two when I get to this too...) hth, Brett Payne-Rhodes Eaglehawk Computing [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
string to list???
hello everybody, is there a way to convert a string into a list?? the delimeter in string list to be space. is this possible?? plzz help me, i am stuck with it. thanx in advance nag -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: string to list???
Can you give an example of what your trying to do? Like: "I'm trying to turn 1,2,3 into 123" --Katrina Katrina Chapman Consultant Ameriquest Mortgage Nagesh Kumar Deva To: "Cold Fusion (E-mail)" [EMAIL PROTECTED] Nagesh@aptitucc: de.com.sgSubject: string to list??? 05/03/00 09:05 AM Please respond to cf-talk hello everybody, is there a way to convert a string into a list?? the delimeter in string list to be space. is this possible?? plzz help me, i am stuck with it. thanx in advance nag -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF 4.5.0 ( 4.5.1) WinNT FTP service
Hi, Recently we installed CF Pro 4.5.0 on a brand new WinNT SBS machine "Whoop for you!" you might say, cynically.. But ever since we did so, the FTP service on that machine is none existent, we can't find it to start it up in the IIS console. We patched CF to 4.5.1 (we were going to anyway) and whilst everything is cool with CF, we still can't get the FTP service going. Now it may not be CF that caused the problem - but its the collared suspect at the moment... Has anyone else had any similar problems, or does anyone know of a possible solution? Any help would be most gratefully welcomed... -- 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 --- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Forcing a query refresh
Hi Folks, What's the best way of forcing a query to always run instead of it being cached? I am pulling a record from a DB and displaying it, but when I do a refresh/reload it doesn't run the query again. What's the best way of doing that? Thanks, Doug -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: string to list???
You can have a list with a space as the delimeter. If you have punctuation or double spaces you would simply do a replace on them with a single space. HTH, Steve -Original Message- From: Nagesh Kumar Deva [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 12:06 PM To: Cold Fusion (E-mail) Subject: string to list??? hello everybody, is there a way to convert a string into a list?? the delimeter in string list to be space. is this possible?? plzz help me, i am stuck with it. thanx in advance nag -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Forcing a query refresh
This may be a simplistic answer, but don't cache the query and it will run everytime the page is accessed. Look for "cachedwithin" or "cachedafter" in the cfquery tag. Or if the query is named something like "SESSION.queryName" or "APPLICATION.queryName", change the name to just "queryName". Sharon At 09:33 AM 5/3/2000 -0700, Doug Ford wrote: Hi Folks, What's the best way of forcing a query to always run instead of it being cached? I am pulling a record from a DB and displaying it, but when I do a refresh/reload it doesn't run the query again. What's the best way of doing that? Thanks, Doug -- Archives: http://www.egroups.com/list/cf-talkhttp://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talkh ttp://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
help with the cf listget function
This is a multi-part message in MIME format. --=_NextPart_000_0019_01BE95D8.30ABE9C0 Content-Type: text/plain; charset="windows-1257" Content-Transfer-Encoding: quoted-printable using cfselect I am wanting to be able to extract the values for the id = number of the record as well as the value of the main field name for = that record. let me explain I have a tables that contains all the geographical = regions of a state in the table using the cf select function in a form I want the user to be able to = select the region of their choice but by doing so it will pass the = region name as well as the regionid number for that particular record I believe I can do this using cf list get function however I am not = sure how to use the code exactly nor the correct syntax the current code I ma using without the cf list get function is: cfquery name=3D"RegionDropDown" datasource=3D"australianaccomm" Select Distinct Region FROM Regions Order By Region /cfquery cfselect name=3D"Region" value=3D"RegionDropDown.Region" size=3D"1" option/option cfoutput query=3D"RegionDropDown" option#Region#/option /cfoutput /cfselect/td =20 i look forward to your assistance Kind Regards Claude Raiola E-Mail: [EMAIL PROTECTED] Website: www.internetgoldcoastproperties.com.au --=_NextPart_000_0019_01BE95D8.30ABE9C0 Content-Type: text/html; charset="windows-1257" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Dwindows-1257" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3013.2600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT color=3D#ff size=3D2using cfselect I am wanting to be = able to=20 extract the values for the id number of the record as well as the value = of the=20 main field name for that record./FONT/DIV DIVnbsp;/DIV DIVFONT color=3D#ff size=3D2let me explain I have a tables that = contains all=20 the geographical regions of a state in the table/FONT/DIV DIVnbsp;/DIV DIVFONT color=3D#ff size=3D2using the cf select function in a = form I want=20 the user to be able to select the region of their choice but by doing so = it will=20 pass the region name as well as the regionid number for that particular=20 record/FONT/DIV DIVFONT color=3D#ff size=3D2/FONTnbsp;/DIV DIVFONT color=3D#ff size=3D2I believe I can do this usingnbsp; = cf list get=20 function however I am not sure how to use the code exactly nor the = correct=20 syntax/FONT/DIV DIVnbsp;/DIV DIVFONT color=3D#ff size=3D2the current code I ma using without = the cf list=20 get function is:/FONT/DIV DIVnbsp;/DIV DIVFONT color=3D#ff size=3D2lt;cfquery name=3D"RegionDropDown"=20 datasource=3D"australianaccomm"gt;BRSelect Distinct RegionBRFROM=20 RegionsBROrder By RegionBRlt;/cfquerygt;/FONT/DIV DIVnbsp;/DIV DIVFONT color=3D#ff size=3D2lt;cfselect name=3D"Region"=20 value=3D"RegionDropDown.Region"=20 size=3D"1"gt;BRnbsp;nbsp;nbsp;lt;optiongt;lt;/optiongt;BRnbs= p;nbsp;nbsp;lt;cfoutput=20 query=3D"RegionDropDown"gt;BRnbsp;nbsp;nbsp;lt;optiongt;#Region#= lt;/optiongt;BRnbsp;nbsp;lt;/cfoutputgt;BR/FONTFONT=20 color=3D#ff = size=3D2nbsp;nbsp;lt;/cfselectgt;lt;/tdgt;/FONT/DIV DIVnbsp;/DIV DIVnbsp;/DIV DIVnbsp;/DIV DIVFONT color=3D#ff size=3D2i look forward to your = assistance/FONT/DIV DIVFONT color=3D#ff size=3D2BRKind Regards/FONT/DIV DIVnbsp;/DIV DIVFONT color=3D#ff size=3D2Claude RaiolaBRE-Mail: A=20 href=3D"mailto:[EMAIL PROTECTED]"info@internetgold= coastproperties.com.au/ABRWebsite:=20 A=20 href=3D"http://www.internetgoldcoastproperties.com.au"www.internetgoldco= astproperties.com.au/A/FONT/DIV DIVnbsp;/DIV DIVFONT color=3D#ff size=3D2/FONTnbsp;/DIV/BODY/HTML --=_NextPart_000_0019_01BE95D8.30ABE9C0-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SQL Query Error
Can anyone tell me why i'd be getting the following
error when trying to execute this code???
code:
INSERT INTO tlbtables (nameoftable, name)
VALUES ('value1', 'value2')
error:couldn't find output table tbltables
I have verified that the table tbltables is there and
does have data in it. Can anyone help me out?
-Rob
__
Do You Yahoo!?
Send instant messages get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
MS SQL 7 Data connection using OLEDB
This is a multi-part message in MIME format. --=_NextPart_000_000B_01BFB4FE.1F964D60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello all. We have had no success attempting to set up our MS SQL 7 database for = access from ColdFusion through OLEDB. I have two questions: 1. Does anyone know how to do this? 2. The specific problem is that ODBC doesn't like the command "GO" = within a query string. Does anyone know an ODBC-friendly command which = will accomplish the same end? Thanks! Brian - Brian P. Cusack [EMAIL PROTECTED] --=_NextPart_000_000B_01BFB4FE.1F964D60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Dwindows-1252" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT size=3D2Hello all./FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2We have had no success attempting to set up our MS = SQL 7=20 database for access from ColdFusion through OLEDB./FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2I have two questions:/FONT/DIV DIVFONT size=3D21. Does anyone know how to do this?/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D22. The specific problem is that ODBC doesn't like = the command=20 "GO" within a query string.nbsp; Does anyone know an ODBC-friendly = command=20 which will accomplish the same end?/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2Thanks!/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2Brian/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2-BRBrian P. = CusackBRA=20 href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/A/FONT/DIV/BOD= Y/HTML --=_NextPart_000_000B_01BFB4FE.1F964D60-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Forcing a query refresh
One way is to turn the "Trusted Cache" setting off within the CF Server settings. - Original Message - From: "Doug Ford" [EMAIL PROTECTED] Sent: Wednesday, May 03, 2000 12:33 PM Subject: Forcing a query refresh What's the best way of forcing a query to always run instead of it being cached? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL Query Error
I've had problems before with naming a column 'name'. Try changing the name
of the column to something other than 'name'. It also looks like there's
either a typo in your post or in your code. The code refers to 'tlbtables'
and you refer to 'tbltables'.
Josh
- Original Message -
From: "Robert Flesher" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 03, 2000 9:46 AM
Subject: SQL Query Error
Can anyone tell me why i'd be getting the following
error when trying to execute this code???
code:
INSERT INTO tlbtables (nameoftable, name)
VALUES ('value1', 'value2')
error:couldn't find output table tbltables
I have verified that the table tbltables is there and
does have data in it. Can anyone help me out?
-Rob
__
Do You Yahoo!?
Send instant messages get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Query Error
In the example you posted, tbltables is spelled tlbtables. That could be
it.
I hope that helps,
Rob
___
Robert M. Saxon, Jr. (Rob), Senior Web Developer
Mercer University
Department of Web Management
-Original Message-
From: Robert Flesher [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 03, 2000 12:46 PM
To: [EMAIL PROTECTED]
Subject: SQL Query Error
Can anyone tell me why i'd be getting the following
error when trying to execute this code???
code:
INSERT INTO tlbtables (nameoftable, name)
VALUES ('value1', 'value2')
error:couldn't find output table tbltables
I have verified that the table tbltables is there and
does have data in it. Can anyone help me out?
-Rob
__
Do You Yahoo!?
Send instant messages get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Forcing a query refresh
Olaf, Thanks for the idea but the problem is that I want only this one particular query not to be cached... other queries can be to improve performance. But not this one. Thanks, Doug -Original Message- From: Olaf Gradin [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 9:53 AM To: [EMAIL PROTECTED] Subject:Re: Forcing a query refresh One way is to turn the "Trusted Cache" setting off within the CF Server settings. - Original Message - From: "Doug Ford" [EMAIL PROTECTED] Sent: Wednesday, May 03, 2000 12:33 PM Subject: Forcing a query refresh What's the best way of forcing a query to always run instead of it being cached? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Query Error
Could it be this typo:
INSERT INTO
tlbtables -- you mean tbltables..
-Original Message-
From: Robert Flesher [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 03, 2000 12:46 PM
To: [EMAIL PROTECTED]
Subject: SQL Query Error
Can anyone tell me why i'd be getting the following
error when trying to execute this code???
code:
INSERT INTO tlbtables (nameoftable, name)
VALUES ('value1', 'value2')
error:couldn't find output table tbltables
I have verified that the table tbltables is there and
does have data in it. Can anyone help me out?
-Rob
__
Do You Yahoo!?
Send instant messages get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Studio crashing with CFMLVALIDATOR.DLL
Hi Adrian, I haven't found a definite fix for the same problem yet...here's a thread to several link's at the Allaire support forums, some of them have a couple of dozen threads http://forums1.allaire.com/DevConf/Search_Results.cfm?#Message439148 Can someone remind me how to re-register the CFMLVALIDATOR.DLL after a corrupt installation of Studio? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.co.uk/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
How To Land Contracts/WebSite Contracts?
I have a question for you guys... a friend of mine has been running a webhosting and development company for about a year now. It's very much a Cold Fusion type environment. He wants me to start trying to land more development jobs for his company and what not. My question which is not related to coding is this: Do you know of any resources or books I can pick up that shows you strategies on how to show companies the advantages of having their sites redeveloped dynamically rather than static html? Why they should use e-commerce etc etc... I want to start a marketing blitz to get more business for his company and there are a tonne of local businesses here we feel would benefit. If anyone here has any resources or books that we can read up on that shows effective strategies on grabbing the attention of these companies, please let me know! Thanks again! Marco -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF and Search Engines Again.... =)
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=somevaluesomething2=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: MSIE 4.01
I ran into exactly this problem a year or two ago. The easiest solution I found was to rename the "region" variable to something else. Alternatively, you could put region as the first item in your query string -- ie. somefile.cfm?region=xyzotherparam=q, etc. Leave it to Microsoft to make it so the escaped HTML entities are essentially reserved words. Pretty pathetic. -Original Message- From: Brian Peddle [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 6:50 AM To: [EMAIL PROTECTED] Subject: MSIE 4.01 Iassing the following in a QueryString: QSTRING: ID=1career=8,10,12,28,31,33,41region=2keyword=none ege converts the region into ÿAEion taking the reg and seeing it as a specharacter. This is only happening in MSIE 4.01. Anyone have any insight ts problem. s -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/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?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Thank you for choosing Smart Web Tech .............
what have I learned from this thread? good points, but snipped Could we possibly remove intolerance from the list? So what you're saying is, you can't tolerate intolerance? :) Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "The net interprets censorship as damage and routes around it." - John Gilmore -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: string to list???
Thanx josh now it is working fine bai nagesh -Original Message- From: Josh Black [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 04, 2000 12:39 AM To: [EMAIL PROTECTED] Subject: Re: string to list??? Any string with spaces in it can automatically be treated as a space delimited list. No conversion is necessary. Example: cfset myString = "This is my test string" cfloop list="#myString#" index="loopindex" delimiters=" " cfoutput #loopindex#br /cfoutput /cfloop This will produce the output of: This is my test string HTH Josh - Original Message - From: "Nagesh Kumar Deva" [EMAIL PROTECTED] To: "Cold Fusion (E-mail)" [EMAIL PROTECTED] Sent: Wednesday, May 03, 2000 9:05 AM Subject: string to list??? hello everybody, is there a way to convert a string into a list?? the delimeter in string list to be space. is this possible?? plzz help me, i am stuck with it. thanx in advance nag -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Forcing a query refresh
I am not sure if this would do the trick, but it's worth the try. Stick it in your HEAD tag space: META HTTP-EQUIV="Expires" CONTENT="Tues, 01 Jan 1980 00:00:01 GMT" - Original Message - From: "Doug Ford" [EMAIL PROTECTED] Sent: Wednesday, May 03, 2000 1:02 PM Subject: RE: Forcing a query refresh Thanks for the idea but the problem is that I want only this one particular query not to be cached... other queries can be to improve performance. But not this one. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
[OT] JSP?!
Hy! Sorry for posting another OFF-TOPIC question. I just have some questions about JSP. I'm looking for a good book (something like CF books from Ben Forta) on JSP? Do I have to develop my own tags (beans) to do the things which were in CF common (cfhttp tags for instance)? Bye, Iztok -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: ATTENTION ALL OUTLOOK AND OUTLOOK EXPRESS USERS
In 00b201bfb48b$8140e1b0$[EMAIL PROTECTED], Dave Hannum ([EMAIL PROTECTED]) in a fit of unbridled passion, wrote: Hey Ruub! DON'T lump ALL Outlook and Outlook Express Users into the group that uses HTML!!! I use OE and DO NOT USE HTML! I agree that it should not be used but just because somebody uses OE or Outlook does not, in and of itself, make one out to be the kind of slime the tone of your post proposes! Besides, statistics show that you are part of a minority that is becoming smaller and smaller all the time. I use Outlook myself as well. I posted this to the attention of Outlook users because of its default settings.. By the way, your OE is not wrapping its text at 73 chars as per the popular standard. Tsk tsk. :) -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: ATTENTION ALL OUTLOOK, OUTLOOK EXPRESS, AND ANY OTHER HTML MAILER USERS
In 01d601bfb4d8$9a4c71e0$5ccc8ad1@satan, Fred T. Sanders ([EMAIL PROTECTED]) in a fit of unbridled passion, wrote: Funny, I'm not sending any email in html and am using plain text, and I use both Outlook and OExpress. What about all those web based clients and Netscape's Mail reader. ?? why didn't you jump on them. If your going to ride someone for their mail client be a slut and ride them all. Ok. It's not the HTML that drives me as nuts as multi-part MIME postings with all sorts of weird characters (like "=20" all over the place). It makes the posts more of a pain to read and respond to that I personally feel I have the time to deal with, therefore I ignore them. So, if someone has a legit question that maybe I know the answer to, they will most likely not receive a response from me because their posts are too difficult to read. Fred - Original Message - From: "Reuben King" [EMAIL PROTECTED] Newsgroups: cf-talk To: [EMAIL PROTECTED] Sent: Tuesday, May 02, 2000 4:31 PM Subject: ATTENTION ALL OUTLOOK AND OUTLOOK EXPRESS USERS Please stop posting to the list in anything other than plain text. It is quite ugly and annoying for those of us who are using plain text newsreaders. Thanks, -RK -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF for Solaris
Has anyone seen the error "CFSPClient::rpc(): Connect to server failed, no such file or directory". Our server thinks it is started but when I run a .cfm template I just see the cfm code not the actualy WYSIWYG version. When I looked in the server.log file the above error shows up twice just before "The Cold Fusion Application server was started". Has anyone seen this before? I looked in the allaire forums and a few other people are having the same problem but there isn't a posted solution. Is cfx_j still supported in CF 4.5 for Solaris, I have heard that it isn't? Dottie Swanson MEI Software Systems, Inc. Web Developer [EMAIL PROTECTED] (703) 620-9600 ext. 2097 http://www.meisoft.com 11720 Sunrise Valley Drive Reston, Virginia 20191-1413 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF Presentation for my class
Oops. My bad. It's www.thecarton.com -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Accessing same document form field
Hello there, I have a problem that I can't figure out why it won't work...I have a cfquery that uses a form field defined as "hidden" to retrieve some data, the field is defined inside a cfform tag in the same document as the cfquery, but when it hits the cfquery it is telling me that it can't find the field... it woks well if I define the field using cfset or cfparam, but it won't work if I defined it as a hidden field, the bad part about it is that I need that field in the next document as a formfield. TIA Bismarck Perez *1-617-563-2896 * G10H * [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: MSIE 4.01
At 10:55 AM 5/3/2000 -0700, chris wrote: Leave it to Microsoft to make it so the escaped HTML entities are essentially reserved words. Pretty pathetic. To be completely fair, the W3C specs for HTML say that if you are going to use in the url, you are supposed to use the character entity. If you run their validator against CFML pages, every single one of them that passes variables in the url will fail validation because of the issue. So I.E. is actually doing it correctly, but is perhaps too correct. The correct way to code the region variable would be amp;region= we are just program out of habit and because it usually works. Took me forever to figure out the problem with section=... same issue. Judah -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Forcing a query refresh
Then you should cache the queries with the CACHEDWITHIN attribute. Queries are, by default, not cached. Cached templates are different than cached queries. If you have not set up query caching for this problem query, it may actually be your browser cache causing the problem that you are seeing. At 10:02 AM 5/3/00 -0700, you wrote: Olaf, Thanks for the idea but the problem is that I want only this one particular query not to be cached... other queries can be to improve performance. But not this one. Thanks, Doug -Original Message- From: Olaf Gradin [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 9:53 AM To: [EMAIL PROTECTED] Subject:Re: Forcing a query refresh One way is to turn the "Trusted Cache" setting off within the CF Server settings. - Original Message - From: "Doug Ford" [EMAIL PROTECTED] Sent: Wednesday, May 03, 2000 12:33 PM Subject: Forcing a query refresh What's the best way of forcing a query to always run instead of it being cached? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Thank you for choosing Smart Web Tech .............
or into rating lances So what you're saying is, you can't tolerate intolerance? :) -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Forcing a query refresh
How do you know that it's not running the query again? What browser are you using. If you hold control while you click refresh that will force it to make the call back to your server for the latest information. --Katrina Katrina Chapman Consultant Ameriquest Mortgage dford@midrangecom puting.com (Doug To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Ford)cc: Subject: Forcing a query refresh 05/03/00 09:33 AM Please respond to cf-talk Hi Folks, What's the best way of forcing a query to always run instead of it being cached? I am pulling a record from a DB and displaying it, but when I do a refresh/reload it doesn't run the query again. What's the best way of doing that? Thanks, Doug -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
counting the number of users
Hi there, My boss asked me to restrict the access of a certain page to a number of users how do I do it? I tried to count the session but its tied to a single user right? thanks vinicius -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [OT] JSP?!
You might try HOF's JSP talk list... http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/JSP_talk HTH, Steve - Original Message - From: "Iztok Polanic" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 03, 2000 2:50 PM Subject: [OT] JSP?! Hy! Sorry for posting another OFF-TOPIC question. I just have some questions about JSP. I'm looking for a good book (something like CF books from Ben Forta) on JSP? Do I have to develop my own tags (beans) to do the things which were in CF common (cfhttp tags for instance)? Bye, Iztok -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Forcing a query refresh
Jennifer, Thanks for the advice. That's what I figured was the problem, but I was hoping to find a way that would guarantee a reload of the query every time without worrying about the browser and force it at the level of the query. Thanks, Doug -Original Message- From: Jennifer [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 10:31 AM To: [EMAIL PROTECTED] Subject:RE: Forcing a query refresh Then you should cache the queries with the CACHEDWITHIN attribute. Queries are, by default, not cached. Cached templates are different than cached queries. If you have not set up query caching for this problem query, it may actually be your browser cache causing the problem that you are seeing. At 10:02 AM 5/3/00 -0700, you wrote: Olaf, Thanks for the idea but the problem is that I want only this one particular query not to be cached... other queries can be to improve performance. But not this one. Thanks, Doug -Original Message- From: Olaf Gradin [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 9:53 AM To: [EMAIL PROTECTED] Subject:Re: Forcing a query refresh One way is to turn the "Trusted Cache" setting off within the CF Server settings. - Original Message - From: "Doug Ford" [EMAIL PROTECTED] Sent: Wednesday, May 03, 2000 12:33 PM Subject: Forcing a query refresh What's the best way of forcing a query to always run instead of it being cached? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: ATTENTION ALL OUTLOOK AND OUTLOOK EXPRESS USERS
At 01:46 PM 5/3/00 -0500, you wrote: In 00b201bfb48b$8140e1b0$[EMAIL PROTECTED], Dave Hannum ([EMAIL PROTECTED]) in a fit of unbridled passion, wrote: Hey Ruub! DON'T lump ALL Outlook and Outlook Express Users into the group that uses HTML!!! I use OE and DO NOT USE HTML! I agree that it should not be used but just because somebody uses OE or Outlook does not, in and of itself, make one out to be the kind of slime the tone of your post proposes! Besides, statistics show that you are part of a minority that is becoming smaller and smaller all the time. I use Outlook myself as well. I posted this to the attention of Outlook users because of its default settings.. By the way, your OE is not wrapping its text at 73 chars as per the popular standard. Tsk tsk. :) 73? I could swear that pine takes 72... -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Forcing a query refresh
Katrina, The reason I say it's not running the query again is because of the same information that is being presented to me. I am using a query to grab and pull a web banner for my Home page. What I do is grab the top most banner from the list of banners, store the info in a variable, put that banner to the bottom of the list and then display the variable as the banner. So if I hit refresh, a new banner should appear. Since it doesn't always work, I am trying to figure it out. Thanks. Doug -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 9:42 AM To: [EMAIL PROTECTED] Subject:Re: Forcing a query refresh How do you know that it's not running the query again? What browser are you using. If you hold control while you click refresh that will force it to make the call back to your server for the latest information. --Katrina Katrina Chapman Consultant Ameriquest Mortgage dford@midrangecom puting.com (Doug To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Ford)cc: Subject: Forcing a query refresh 05/03/00 09:33 AM Please respond to cf-talk Hi Folks, What's the best way of forcing a query to always run instead of it being cached? I am pulling a record from a DB and displaying it, but when I do a refresh/reload it doesn't run the query again. What's the best way of doing that? Thanks, Doug -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Troff
Hi: Has anyone worked with Troff and ColdFusion? Is there a CF custom tag that can do Troff -- HTML conversion? For my application, I need to upload a file with troff notation, parse and translate the file to HTML and then save to a database. For those who are curious, troff is a Unix based program for formatting. Thanks, Nicole Lane -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Forcing a query refresh
Trusted cache has nothing to do with queries. It relates only to the physical copy of .cfm files. -Original Message- From: Olaf Gradin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 12:53 PM To: [EMAIL PROTECTED] Subject: Re: Forcing a query refresh One way is to turn the "Trusted Cache" setting off within the CF Server settings. - Original Message - From: "Doug Ford" [EMAIL PROTECTED] Sent: Wednesday, May 03, 2000 12:33 PM Subject: Forcing a query refresh What's the best way of forcing a query to always run instead of it being cached? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Forcing a query refresh
Doug- If the browser doesn't request the page, then the query won't be run regardless of what you've done for "work-arounds" on the server side. The meta tag is just about the only way to guarantee that every pageview will result in the query being run. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 3:39 PM To: '[EMAIL PROTECTED]' Subject: RE: Forcing a query refresh Jennifer, Thanks for the advice. That's what I figured was the problem, but I was hoping to find a way that would guarantee a reload of the query every time without worrying about the browser and force it at the level of the query. Thanks, Doug -Original Message- From: Jennifer [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 10:31 AM To: [EMAIL PROTECTED] Subject:RE: Forcing a query refresh Then you should cache the queries with the CACHEDWITHIN attribute. Queries are, by default, not cached. Cached templates are different than cached queries. If you have not set up query caching for this problem query, it may actually be your browser cache causing the problem that you are seeing. At 10:02 AM 5/3/00 -0700, you wrote: Olaf, Thanks for the idea but the problem is that I want only this one particular query not to be cached... other queries can be to improve performance. But not this one. Thanks, Doug -Original Message- From: Olaf Gradin [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 9:53 AM To: [EMAIL PROTECTED] Subject:Re: Forcing a query refresh One way is to turn the "Trusted Cache" setting off within the CF Server settings. - Original Message - From: "Doug Ford" [EMAIL PROTECTED] Sent: Wednesday, May 03, 2000 12:33 PM Subject: Forcing a query refresh What's the best way of forcing a query to always run instead of it being cached? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Forcing a query refresh
Doug- If I were in your shoes, I would load the data into an application structure. Hitting your db for every banner request will quickly bring the system to its knees. You could simply create an array in the application scope, and use that as your database "table". -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 3:48 PM To: '[EMAIL PROTECTED]' Subject: RE: Forcing a query refresh Katrina, The reason I say it's not running the query again is because of the same information that is being presented to me. I am using a query to grab and pull a web banner for my Home page. What I do is grab the top most banner from the list of banners, store the info in a variable, put that banner to the bottom of the list and then display the variable as the banner. So if I hit refresh, a new banner should appear. Since it doesn't always work, I am trying to figure it out. Thanks. Doug -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 9:42 AM To: [EMAIL PROTECTED] Subject:Re: Forcing a query refresh How do you know that it's not running the query again? What browser are you using. If you hold control while you click refresh that will force it to make the call back to your server for the latest information. --Katrina Katrina Chapman Consultant Ameriquest Mortgage dford@midrangecom puting.com (Doug To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Ford)cc: Subject: Forcing a query refresh 05/03/00 09:33 AM Please respond to cf-talk Hi Folks, What's the best way of forcing a query to always run instead of it being cached? I am pulling a record from a DB and displaying it, but when I do a refresh/reload it doesn't run the query again. What's the best way of doing that? Thanks, Doug -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Forcing a query refresh
If you dont set a cache within the query it shouldnt be cached. But also go to the admin part of Cold Fusion find the Datasource for that database and UNCHECK maintain database connection in the cfsettings but trusted cache has nothing to do with it. As long as you dont put a CACHEDWITHIN or any other cache tag in the query line and as long as you have maintain connection OFF then it should query it everytime. Correct me if i'm wrong. Kelly -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 4:03 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Forcing a query refresh Trusted cache has nothing to do with queries. It relates only to the physical copy of .cfm files. -Original Message- From: Olaf Gradin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 12:53 PM To: [EMAIL PROTECTED] Subject: Re: Forcing a query refresh One way is to turn the "Trusted Cache" setting off within the CF Server settings. - Original Message - From: "Doug Ford" [EMAIL PROTECTED] Sent: Wednesday, May 03, 2000 12:33 PM Subject: Forcing a query refresh What's the best way of forcing a query to always run instead of it being cached? -- -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
How to debug a CF program
Can someone let me know how to debug the program, so that I can see each step in the program flow. I know how to do it in Microsoft Visual Studio. Is there a utility in CF? Appreciate. A.B. __ Do You Yahoo!? Send instant messages get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Upgrade 4.01 - 4.5 (and patch) Enterprise trouble?
Has anyone had any trouble, recommendations precautions going from 4.01 server 4.01 studio to 4.5 Enterprise 4.5 Studio? (I'll apply the 4.5.1 patch after install) I just want to make sure something like snippets don't get lost.. or will I have to uninstall my 4.01 server first ? Any unforeseen stuff ? Sincerely, Rob Sherman -- Developer / Allaire Certified Instructor Email:[EMAIL PROTECTED] ICQ:_3266081 AIM:__RobSSherm Yahoo!:RobSherman_CFDev Office:__(310) 543-1622 Office Fax:__(310) 543-0512 VMail/Fax:__(310) 754-6016 ext. 5630 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Forcing a query refresh
Kelly Doug- I wouldn't suggest unchecking the maintain database connection box. You'll already be taking a performance hit with this query being run on each page, by unchecking that box you'll be telling coldfusion to: Connect to the db Run the SQL DisConnect from the db Are you not concerned with performance, AT ALL?!?!? -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 4:06 PM To: '[EMAIL PROTECTED]' Cc: [EMAIL PROTECTED] Subject: RE: Forcing a query refresh If you dont set a cache within the query it shouldnt be cached. But also go to the admin part of Cold Fusion find the Datasource for that database and UNCHECK maintain database connection in the cfsettings but trusted cache has nothing to do with it. As long as you dont put a CACHEDWITHIN or any other cache tag in the query line and as long as you have maintain connection OFF then it should query it everytime. Correct me if i'm wrong. Kelly -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 4:03 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Forcing a query refresh Trusted cache has nothing to do with queries. It relates only to the physical copy of .cfm files. -Original Message- From: Olaf Gradin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 12:53 PM To: [EMAIL PROTECTED] Subject: Re: Forcing a query refresh One way is to turn the "Trusted Cache" setting off within the CF Server settings. - Original Message - From: "Doug Ford" [EMAIL PROTECTED] Sent: Wednesday, May 03, 2000 12:33 PM Subject: Forcing a query refresh What's the best way of forcing a query to always run instead of it being cached? -- -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Setting a variable
Hi! Is there a way to set a variable with the content of another variable as part of the name. Something like this, but that works. CFSet tempcat=#Cat.a#ID## -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Help with CFHTTP Frameset
Hello, I am trying to use CFHTTP to get and output a html page which uses framesets. Unfortunately, it does not work. Can anyone help? Nancy Silverstein Web Developer Cooley Godward, LLP phone 415.693.2714 fax 415.693.2915 [EMAIL PROTECTED] === This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How to debug a CF program
At 01:13 PM 5/3/00 -0700, you wrote: Can someone let me know how to debug the program, so that I can see each step in the program flow. I know how to do it in Microsoft Visual Studio. Is there a utility in CF? Have you discovered the Tag Inspector tab of CF Studio? It makes me very happy. There is a "Flow Control" setting. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT - SQL question
Hey ... How do you do a query where all rows returned except in the case of duplicates, based on a name column, in which only the first is returned. So the query run against the following rows: NameOrderNum Fred21 Beth36 Fred76 Would return : NameOrderNum Fred 21 Beth 36 Much thanks!! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Setting a variable
Try:
CFSet tempcat=#evaluate("Cat.a" #ID#)#
Howie
- Original Message -
From: Michel Gagnon [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Sent: Wednesday, May 03, 2000 4:42 PM
Subject: Setting a variable
Hi!
Is there a way to set a variable with the content of
another variable as part of the name.
Something like this, but that works.
CFSet tempcat=#Cat.a#ID##
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to debug a CF program
Funny you should mention it... I am preparing a presentation on how to use the debugger for the Charlotte CFUG. The outline will be a MS Word doc. If you are interested, I'll email it to you. Please remind me if I forget. It should be ready by tomorrow AM. By the way, it ain't MS Visual Studio quality, but I think it's pretty good considering the stateless nature of the Webb. -Original Message- From: aslam bajaria [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 4:14 PM To: [EMAIL PROTECTED] Subject: How to debug a CF program Can someone let me know how to debug the program, so that I can see each step in the program flow. I know how to do it in Microsoft Visual Studio. Is there a utility in CF? Appreciate. A.B. __ Do You Yahoo!? Send instant messages get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: SQL! i'm losing it
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFB542.15933410 Content-Type: text/plain; charset="iso-8859-1" I have checked and checked this but I cannot see anything wrong with this code: cfquery name="adduser" datasource="#DSN#" insert into users (user_id,Group,firstname,lastname,Title,email,Password,UserID,ClientID) values (#max_ID#,'#trim(attributes.Group)#','#trim(attributes.firstname)#','#trim(a ttributes.lastname)#','#trim(attributes.Title)#','#trim(attributes.email)#', '#trim(attributes.Password)#','#trim(attributes.userid)#',#trim(attributes.C lientID)#) /cfquery But I keep getting this error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. SQL = "insert into users (user_id,Group,firstname,lastname,Title,email,Password,UserID,ClientID) values (2,'External','Shawn','Regan','Webmaster','[EMAIL PROTECTED]','kick','597',2)" Anyone see what I am missing? Shawn Regan --_=_NextPart_001_01BFB542.15933410 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLEOT: SQL! i'm losing it/TITLE /HEAD BODY PFONT SIZE=3D2I have checked and checked this but I cannot see = anything wrong with this code:/FONT /P PFONT SIZE=3D2lt;cfquery name=3Dquot;adduserquot; = datasource=3Dquot;#DSN#quot;gt;/FONT BRFONT SIZE=3D2insert into users = (user_id,Group,firstname,lastname,Title,email,Password,UserID,ClientID) = values = (#max_ID#,'#trim(attributes.Group)#','#trim(attributes.firstname)#','#tr= im(attributes.lastname)#','#trim(attributes.Title)#','#trim(attributes.e= mail)#','#trim(attributes.Password)#','#trim(attributes.userid)#',#trim(= attributes.ClientID)#)/FONT/P PFONT SIZE=3D2lt;/cfquerygt;/FONT /P PFONT SIZE=3D2But I keep getting this error:/FONT /P PFONT SIZE=3D2ODBC Error Code =3D 37000 (Syntax error or access = violation)/FONT /P BR PFONT SIZE=3D2[Microsoft][ODBC Microsoft Access Driver] Syntax = error in INSERT INTO statement./FONT /P BR PFONT SIZE=3D2SQL =3D quot;insert into users = (user_id,Group,firstname,lastname,Title,email,Password,UserID,ClientID) = values = (2,'External','Shawn','Regan','Webmaster','[EMAIL PROTECTED]','kick','597'= ,2)quot;/FONT/P PFONT SIZE=3D2Anyone see what I am missing?/FONT /P PFONT SIZE=3D2Shawn Regan/FONT /P /BODY /HTML --_=_NextPart_001_01BFB542.15933410-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Setting a variable
You may need to do something like this. The Evaluate function should give
it to you. The extra code is to explain, I hope it's clear, what I'm
evaluating.
!--- Query for 1 record ---
CFQUERY NAME="qGet" MAXROWS="1" DATASOURCE="#Application.DataSource#"
SELECT #Variables.FieldList# FROM SomeTable
WHERE company_id = '#Variables.Company_ID#'
AND transaction_complete = 0
/CFQUERY
!--- Create output reply to ERA.ColumnList:EfinData ---
CFLOOP INDEX="i" FROM="1" TO="#ListLen(Variables.FieldList)#"
!--- Set e-fin field name as EfinKey ---
CFSET Variables.EfinKey = ListGetAt(Variables.FieldList, i)
!--- Set ERA field name as ERAField ---
CFSET Variables.ERAField = StructFind(Application.Efin_To_ERA, EfinKey)
!--- Set individual field data as qGet query data ---
CFSET Variables.EfinData = Evaluate("qGet.#Variables.EfinKey#")
CFOUTPUT
#Variables.ERAField#:#Variables.EfinData##Variables.ASC13#
/CFOUTPUT
/CFLOOP
-Original Message-
From: Michel Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 03, 2000 4:43 PM
To: [EMAIL PROTECTED]
Subject: Setting a variable
Hi!
Is there a way to set a variable with the content of
another variable as part of the name.
Something like this, but that works.
CFSet tempcat=#Cat.a#ID##
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: 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=3subid=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=somevaluesomething2=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
locking application and session variables
We just had a nasty crash. We got this error: An error occurred while evaluating the expression: application.errorAdmin = "[EMAIL PROTECTED]" Error near line 9, column 8. Symbol application.errorAdmin is in a scope that contains data shared across threads and cannot be accessed without an active lock The error occurred while processing an element with a general identifier of (CFSET), occupying document position (9:2) to (9:57) in the template file /www/htdocs/Application.cfm. So we instituted locks around the variables in the Application.cfm file. But we got the same error message. One of our guys determined that if we took out the session variables from the application variable lock, we didn't get the error message. We weren't even using those session variables anymore, so I deleted them and now the problem is gone. The server in question is running 4.5.1 for Solaris (and had already been live load tested without a problem). Has it always been a problem locking application and session variables in the same lock or is this new to 4.5? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Using Excel as a Data Source
I'm having some problems using an ODBC connection to a an Excel spreadsheet. The main thing I haven't gotten to work is the naming of tables. I read a prior post saying to list the field names along the top row, but where does the table name come from? If anyone could send me a sample Excel file that is properly formatted as a database, I'd greatly appreciate it. Thanks. -- Pete Miller GOTech, Inc. http://www.gotech.net -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL! i'm losing it
Your USERID field is a number, but you use the single quotesis it a number field or a text field in the database? '' = text field -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL! i'm losing it
Shawn, It may be parsing the field Group and confusing it with GROUP BY, a reserved phrase. I'd try changing the name of the field. I have checked and checked this but I cannot see anything wrong with this code: cfquery name="adduser" datasource="#DSN#" insert into users (user_id,Group,firstname,lastname,Title,email,Password,UserID,ClientID) values (#max_ID#,'#trim(attributes.Group)#','#trim(attributes.firstname)#','#trim(a ttributes.lastname)#','#trim(attributes.Title)#','#trim(attributes.email)#', '#trim(attributes.Password)#','#trim(attributes.userid)#',#trim(attributes.C lientID)#) /cfquery But I keep getting this error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. SQL = "insert into users (user_id,Group,firstname,lastname,Title,email,Password,UserID,ClientID) values (2,'External','Shawn','Regan','Webmaster','[EMAIL PROTECTED]','kick','597',2)" Anyone see what I am missing? Shawn Regan -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL! i'm losing it
Shawn, Group is an ODBC Reserved Word. Change it in the table to a different name. -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 3:57 PM To: '[EMAIL PROTECTED]' Subject: OT: SQL! i'm losing it This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFB542.15933410 Content-Type: text/plain; charset="iso-8859-1" I have checked and checked this but I cannot see anything wrong with this code: cfquery name="adduser" datasource="#DSN#" insert into users (user_id,Group,firstname,lastname,Title,email,Password,UserID,ClientID) values (#max_ID#,'#trim(attributes.Group)#','#trim(attributes.firstname)#','#trim(a ttributes.lastname)#','#trim(attributes.Title)#','#trim(attributes.email)#', '#trim(attributes.Password)#','#trim(attributes.userid)#',#trim(attributes.C lientID)#) /cfquery But I keep getting this error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. SQL = "insert into users (user_id,Group,firstname,lastname,Title,email,Password,UserID,ClientID) values (2,'External','Shawn','Regan','Webmaster','[EMAIL PROTECTED]','kick','597',2)" Anyone see what I am missing? Shawn Regan --_=_NextPart_001_01BFB542.15933410 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLEOT: SQL! i'm losing it/TITLE /HEAD BODY PFONT SIZE=3D2I have checked and checked this but I cannot see = anything wrong with this code:/FONT /P PFONT SIZE=3D2lt;cfquery name=3Dquot;adduserquot; = datasource=3Dquot;#DSN#quot;gt;/FONT BRFONT SIZE=3D2insert into users = (user_id,Group,firstname,lastname,Title,email,Password,UserID,ClientID) = values = (#max_ID#,'#trim(attributes.Group)#','#trim(attributes.firstname)#','#tr= im(attributes.lastname)#','#trim(attributes.Title)#','#trim(attributes.e= mail)#','#trim(attributes.Password)#','#trim(attributes.userid)#',#trim(= attributes.ClientID)#)/FONT/P PFONT SIZE=3D2lt;/cfquerygt;/FONT /P PFONT SIZE=3D2But I keep getting this error:/FONT /P PFONT SIZE=3D2ODBC Error Code =3D 37000 (Syntax error or access = violation)/FONT /P BR PFONT SIZE=3D2[Microsoft][ODBC Microsoft Access Driver] Syntax = error in INSERT INTO statement./FONT /P BR PFONT SIZE=3D2SQL =3D quot;insert into users = (user_id,Group,firstname,lastname,Title,email,Password,UserID,ClientID) = values = (2,'External','Shawn','Regan','Webmaster','[EMAIL PROTECTED]','kick','597'= ,2)quot;/FONT/P PFONT SIZE=3D2Anyone see what I am missing?/FONT /P PFONT SIZE=3D2Shawn Regan/FONT /P /BODY /HTML --_=_NextPart_001_01BFB542.15933410-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Sorting without order by Was: [Re: Getting Key Field after Insert]
Use a clustered index. best, paul At 10:30 AM 5/3/00 -0500, you wrote: At 01:58 PM 5/3/00 +0200, you wrote: Hi, How can I sort the results of a query without using ORDER BY in my sql statement ? Anyone? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Setting a variable
You mean like cfset tempcat = evaluate("Cat.a#id#")
Sharon
At 05:42 PM 5/3/2000 -0300, Michel Gagnon wrote:
Hi!
Is there a way to set a variable with the content of
another variable as part of the name.
Something like this, but that works.
CFSet tempcat=#Cat.a#ID##
---
---
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF Variables
This is a multi-part message in MIME format. --=_NextPart_000_009C_01BFB517.24F53C30 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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! Joshua P Starr President Creative Director, =C6lana Evenings (719) 268-1588 Day (719) 310-3030 Email: [EMAIL PROTECTED] =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Please visit us on the web at http://www.aelana.com=20 or contact me on AOL Instant Messenger at AelanaWeb =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D --=_NextPart_000_009C_01BFB517.24F53C30 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2I might be looking in all the wrong = places, but is=20 there a reference someplace for CF variables? To clarify, I have found = variables=20 such as #REMOTE_ADDR# and #HTTP_USER_AGENT# in Ben Forta's CF Book, but = can't=20 seem to find any other reference to these or any other variables of this = sort.=20 Any help would be appreciated!/FONT/DIV DIVFONT face=3DArial size=3D2BRBRJoshua P StarrBRPresident = amp; Creative=20 Director, =C6lanaBREvenings (719) 268-1588nbsp; Day (719) = 310-3030BREmail: A=20 href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/ABR=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DBRPlease=20 visit us on the web at A = href=3D"http://www.aelana.com"http://www.aelana.com/A=20 BRor contact me on AOL Instant Messenger at=20 AelanaWebBR=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= /FONT/DIV/BODY/HTML --=_NextPart_000_009C_01BFB517.24F53C30-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Sorry! CF Variables
SORRY EVERYONE FOR THE HTML! 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! Joshua P Starr President Creative Director, Ælana Evenings (719) 268-1588 Day (719) 310-3030 Email: [EMAIL PROTECTED] Please visit us on the web at http://www.aelana.com or contact me on AOL Instant Messenger at AelanaWeb -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
IDL/ION and CF
Greetings: I am starting to experiment with combining ColdFusion and IDL (Interactive Data Language, a program used heavily in several fields of scientific research, not Interface Definition Language). IDL On the Net (ION) now has both scripting and fullscale Java API tools for delivering IDL data, including plots, dynamically over the Web. So far, I'm pretty impressed with the potential usefulness of this product as another tool in the CF developer's toolkit, but as I'm just getting started I'd like to hear from anyone else using ION in a Web application. Thanks, bruce -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SSL, Formfields, and IE 5
Afternoon all, Is anyone out there aware of problems posting forms to an SSL processing page? I've got a form page that accepts input, and passes some hidden variables to an SSL secure processing page which works fine in Netscape (imagine that :) but fails in IE. The formfields aren't being passed in the initial request but if I refresh the processing page, the formfields magically appear. The real kicker - if I make up a plain test form passing arbitrary values and a processor page that simply outputs the formfields and then I place those two files in the exact same directory structure, it works in SSL. The original pages also work if I call the form processor page without SSL... Anyone have any ideas? I've been pulling my hair out on this for 3 days... and it hurts! Thanks, Ryan Ryan Hill, MCSE Director, Systems Integration Market Matrix, Inc. http://www.marketmatrix.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Forcing a query refresh
Sharon,
Just to answer your questions:
1) I don't think it's showing up in the debugging code.
2) The query is not cached anywhere else on the site.
50% uses this code and it's all in one location.
3) I am not pulling a random record only because after watching
the random numbers being generated, it doesn't always produce
the best results. So I created a database with the name of the banner,
a position number, and a begin date and end date.
Let's say that I have 20 banners. They are given a position number
of 100 through 120.
My query reads the DB, grabs the record at position 100, and also finds out the last
record.
I then add 1 to the last position number (120 - making the new number 121) and resave
the
record.
It does it pretty quickly.. sometimes there are a few glitches because of multiple
reads at
the same time but this way I can guarantee that all the banners will be evenly
distributed.
Looking at your code, do you take any kind of performance hit when a lot of people
hit your site at one time and the information is held by the CFLOCK?
Thanks,
Doug
-Original Message-
From: Sharon DiOrio [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 03, 2000 2:13 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject:RE: Forcing a query refresh
A couple of questions.
1. Is the query showing up in the debugging code?
2. Is the query cached anywhere else on the site?
3. Are you pulling a random record from the query, or does the query
change everytime?
Just an option, when we do randomized bannerads, we usually build an
APPLICATION scope array. The code looks something like this:
!--- Initialize the array in the application.cfm ---
cfif NOT IsDefined("APPLICATION.BannerArray")
cfquery name="getBanners" datasource="#APPLICATION.dsn#"
SELECT *
FROM Banners
/cfquery
cfset BannerArray = ArrayNew(1)
cfloop query="getBanners"
cfset BannerArray[CurrentRow] = BannerPath
/cfloop
cflock name="#APPLICATION.ApplicationName#" timeout="10"
cfset APPLICATION.BannerArray= BannerArray
cfset APPLICATION.BannerNumber = getBanners.RecordCount
/cflock
/cfif
!---Display a random banner on any page ---
cfoutput
img src="#APPLICATION.BannerArray[RandRange(1,APPLICATION.BannerNumber)]#"
/cfoutput
Sharon
At 12:47 PM 5/3/2000 -0700, Doug Ford wrote:
Katrina,
The reason I say it's not running the query again is because of the same
information
that is being presented to me.
I am using a query to grab and pull a web banner for my Home page.
What I do is grab the top most banner from the list of banners,
store the info in a variable, put that banner to the bottom of the list
and then display the variable as the banner.
So if I hit refresh, a new banner should appear. Since it doesn't
always work, I am trying to figure it out.
Thanks.
Doug
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 03, 2000 9:42 AM
To:[EMAIL PROTECTED]
Subject: Re: Forcing a query refresh
How do you know that it's not running the query again? What browser are
you using. If you hold control while you click refresh that will force it
to make the call back to your server for the latest information.
--Katrina
Katrina Chapman
Consultant
Ameriquest Mortgage
dford@midrangecom
puting.com (Doug To:
"'[EMAIL PROTECTED]'" [EMAIL PROTECTED]
Ford)cc:
Subject: Forcing a query
refresh
05/03/00 09:33 AM
Please respond to
cf-talk
Hi Folks,
What's the best way of forcing a query to always
run instead of it being cached?
I am pulling a record from a DB and displaying it,
but when I do a refresh/reload it doesn't
run the query again.
What's the best way of doing that?
Thanks,
Doug
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
---
---
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
