Re: How to make a select option tag selected in CF?

[Phillip Perry]

Thank you. I that helps alot. Totally missed the selected=selected
error . Can I use the same code for the radio options?

Phil

On Thu, May 27, 2010 at 4:22 PM, Yuliang Ruan yuliangr...@hotmail.com wrote:

 btw, it should be just selected not selected=selectedThan

 option value=clothes cfif form.choice is 
 clothesSELECTED/cfifClothes/option

 if your list of options is long and u need it to be hardcoded, u should put 
 it into a array of struct.   i.e.

 cfset myChoices=[{value=nothing, text=Please Choose from Below},
 {value=clothes, text=Clothes},
 {value=sports,text=Sporting Goods Store},
 etc etc etc ]

 select name=choice
 cfloop array=#myChoices# index=thisChoice
    option value=#thisChoice.value# cfif form.choice eq 
 thisChoice.valueSELECTED/cfif#thisChoice.text#/option
 /cfloop
 /select



 of course even better would be these in a lookup db table

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334108
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

transfering data from one part of same page to another?

[Phillip Perry]

Thanks for the help on the form problem I had, but now I have a new issue with 
the same form...

I did a search but I'm not having much luck. I have 1 page that has 3 parts to 
it. The first part is the form, the second part is a text only page that shows 
the answers to the form, the 3rd part is a cfmail tag that sends the 
information to me, and to the user who filled out the form. 

The problem is I can't get the answers from the 1st part or second part to the 
3rd part. In other words the form goes to the text only portion, but the 
answers will not go to the cfmail portion. I tried structs and arrays, but I'm 
not going anywhere. I'm thinking sessions would work but I'm not sure. Thank 
you 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334111
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

How to make a select option tag selected in CF?

[Phillip Perry]

Hi,

I am making a form and I would like to have the user review the form
answers before it gets sent to the processing template. I know how to
populate all the other things but the drop down list and the radio
buttons are confusing me. It's been a while since I used CF for this
so I forget. Below is the select and radio button form fields:

select name=choice class=baco
option value=nothing selected=selectedChoose
From Below/option
option value=clothesClothing Store/option
option value=sportsSporting Goods Store/option
option value=hobbiesHobby Shop/option
option value=computersComputer Related Sales/option
option value=medicalMedical Profession/option
option value=foodsGrocery Store/option
option value=publicationPrinted Publications/option
option value=accountingAccounting Firm/option
option value=utilityUtilities Company/option
option value=othersOther/option

/select

input type=radio name=pagetype value=personal /Personal
input type=radio name=pagetype value=business /Business
input type=radio name=pagetype value=notapplicable
checked=checked /Not Applicable

How do I make these 2 selected/checked when the user submits the form?

Thanks for the help.

Phil

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334037
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Phillip Perry wants to chat

[Phillip Perry]

---

Phillip Perry wants to stay in better touch using some of Google's coolest new
products.

If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-f23f08bf6f-4171d35757-ad4a8a9fd09d87fd
You'll need to click this link to be able to chat with Phillip Perry.

To get Gmail - a free email account from Google with over 2,800 megabytes of
storage - and chat with Phillip Perry, visit:
http://mail.google.com/mail/a-f23f08bf6f-4171d35757-ad4a8a9fd09d87fd

Gmail offers:
- Instant messaging right inside Gmail
- Powerful spam protection
- Built-in search for finding your messages and a helpful way of organizing
  emails into conversations
- No pop-up ads or untargeted banners - just text ads and related information
  that are relevant to the content of your messages

All this, and its yours for free. But wait, there's more! By opening a Gmail
account, you also get access to Google Talk, Google's instant messaging
service:

http://www.google.com/talk/

Google Talk offers:
- Web-based chat that you can use anywhere, without a download
- A contact list that's synchronized with your Gmail account
- Free, high quality PC-to-PC voice calls when you download the Google Talk
  client

Gmail and Google Talk are still in beta. We're working hard to add new features
and make improvements, so we might also ask for your comments and suggestions
periodically. We appreciate your help in making our products even better!

Thanks,
The Google Team

To learn more about Gmail and Google Talk, visit:
http://mail.google.com/mail/help/about.html
http://www.google.com/talk/about.html

(If clicking the URLs in this message does not work, copy and paste them into
the address bar of your browser).

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325171
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Debugging displays in lynx, but no visual browsers

[Phillip Perry]

I turned on all the debugging in the administrator but nothing
displayed until i viewed my site in lynx. Would anyone know why that
would happen?

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313443
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

FIXED: Debugging displays in lynx, but no visual browsers

[Phillip Perry]

I just had to delete the IP addresses and everything worked out.

Phil

On Fri, Oct 3, 2008 at 7:41 PM, Phillip Perry [EMAIL PROTECTED] wrote:
 I turned on all the debugging in the administrator but nothing
 displayed until i viewed my site in lynx. Would anyone know why that
 would happen?


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313444
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: cfcookie tempermental setting: Long Post

[Phillip Perry]

I apologize for the incomplete code before. Here is the code with the
form.remember stuff in it with some comments added in. The welcome
screen index.cfm is as follows:

cfif IsDefined(cookie.LoggedIn)
Welcome, your logged in as cfoutput#cookie.username# ID:
#cookie.ID#/cfoutput
/cfif
cfif Not IsDefined(cookie.LoggedIn)
Welcome, your logged in as cfoutput#session.Auth.username# ID
#session.Auth.ID#/cfoutput
/cfif

CHECKLOGIN.CFM

!--- set session variables from cookie if they chose remember me
last time ---
cfif IsDefined(cookie.LoggedIn)
cfset session.Auth = StructNew()
cfset Session.Auth.IsLoggedIn = Yes
cfset session.Auth.ID = cookie.id
cfset session.Auth.username = cookie.username
cflocation url=index.cfm addtoken=No
cfabort
/cfif

!--- we're not auto-logging in, so let's authenticate ---
cfparam name=form.UserLogin type=string
cfparam name=form.Password type=string
cfparam name=form.remember default=Off type=string

cfquery name=GetUser datasource=#mydbname#
SELECT *
FROM admin
WHERE username = cfqueryparam value=#Form.UserLogin# /
AND password =   cfqueryparam value=#Form.password# /
/cfquery

cfif GetUser.RecordCount EQ 1
cfset session.Auth = StructNew()
cfset Session.Auth.IsLoggedIn = Yes
cfset Session.Auth.ID = GetUser.ID
cfset Session.Auth.UserName = GetUser.username

cfif form.remember IS On
cfcookie name=LoggedIn value=Yes expires=NEVER
cfcookie name=username value=#GetUser.username# 
expires=NEVER
cfcookie name=ID value=#GetUser.ID# expires=NEVER
/cfif

cfdump var=#session#cfabort
cfoutput
script 
language=javascriptlocation.replace('index.cfm');/script
/cfoutput
cfabort
cfelse





On Thu, Oct 2, 2008 at 11:45 AM, Tom Chiverton
[EMAIL PROTECTED] wrote:
 On Thursday 02 Oct 2008, Phillip Perry wrote:
 with cfif #form.remember# IS on/cfif, that is when all goes down

 This doesn't appear in your example code.

 Welcome, you are logged in as #session.Auth.username# ID: #session.Auth.ID#

 You are not creating these in your example code.

 And, as side notes: cfqueryparam all your queries. Be aware that a user can
 create their own cookies.

 --
 Tom Chiverton
 Helping to autoschediastically enable back-end interactive wireless
 leading-edge relationships



 

 This email is sent for and on behalf of Halliwells LLP.

 Halliwells LLP is a limited liability partnership registered in England and 
 Wales under registered number OC307980 whose registered office address is at 
 Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
 of members is available for inspection at the registered office. Any 
 reference to a partner in relation to Halliwells LLP means a member of 
 Halliwells LLP.  Regulated by The Solicitors Regulation Authority.

 CONFIDENTIALITY

 This email is intended only for the use of the addressee named above and may 
 be confidential or legally privileged.  If you are not the addressee you must 
 not read it and must not use any information contained in nor copy it nor 
 inform any person other than Halliwells LLP or the addressee of its existence 
 or contents.  If you have received this email in error please delete it and 
 notify Halliwells LLP IT Department on 0870 365 2500.

 For more information about Halliwells LLP visit www.halliwells.com.

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313404
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

i'll pay through paypal anyone who can debug my code

[Phillip Perry]

Hi,

I have been over this cookie code for over a week and I can't get it
straight, even with the help of people who I feel (and know) are
experts. So now I'm offering $50 to the first person who can show me
where the problem is and come up with a workable solution. I'm not
looking for someone to write , or rewrite my code. Just tell me whats
wrong with mine and offer a solution. If you're interested please
contact me at [EMAIL PROTECTED] for further details and the code
as it currently stands.

Thanks,

Phil

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313410
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

cfcookie tempermental setting: Long Post

[Phillip Perry]

Hello,

Following is as detailed a description as i can give as to my problem:

Problem: I am making a sign in form that will allow my customers
access to a private page populated with information specifically
targeted toward them and their account info. Within this form I have a
set of 3 cookies that are being set which remembers the users
username, ID number, and the word Confirmed which, of course,
Confirms that the user wants to be remembered. Now this all happens,
at this point, whether the user wants to be remembered, or not (for
testing purposes). This version of the form works just fine. The
cookies all set, and the test information I want displayed after sign
in comes up with no problem. I have it so that the welcome page just
says Welcome, you are logged in as #cookie.username# ID:
#cookie.ID#.

The issue that comes up is when I try to put a conditional statement
within the cookie part of the template. When I surround the cookies
with cfif #form.remember# IS on/cfif, that is when all goes down
the drain. The form just refreshes itself. It will not display the
welcome page. I changed the welcome page to say the same as I wrote
above, but I write this as well:

cfif IsDefined(cookie.confirmed)
Welcome, you are logged in as #cookie.username# ID: #cookie.ID#
/cfif
cfif NOT IsDefined(cookie.confirmed)
Welcome, you are logged in as #session.Auth.username# ID: #session.Auth.ID#
/cfif

Unfortunately this does not show up. The form just resets itself and
refreshes the sign in form. I have no idea what I'm doing wrong or
what part of my code is wrong. Can someone see any obvious problems
with this code that I'm overlooking? I've been staring at this code
for a week and my eyes hurt. Any help would be very much appreciated.

The full code is below. Thank you for reading this long email, and I'm
sorry to have taken so much time explaining.

Phil

cfif IsDefined(cookie.Confirmed) EQ Yes
cfset session.Admin = StructNew()
cfset Session.Admin.Confirmed = Yes
cflocation url=index.cfm addtoken=No
cfabort
cfelseif NOT IsDefined(cookie.Confirmed)



cfparam name=form.UserLogin type=string
cfparam name=form.Password type=string
cfquery name=GetUser datasource=#mydbname#
SELECT *
FROM admin
WHERE username = '#Form.UserLogin#'
AND password =   '#Form.password#'
/cfquery

cfif GetUser.RecordCount EQ 1
cfset session.Admin = StructNew()
cfset Session.Admin.Confirmed = Yes
cfset Session.Admin.ID = GetUser.ID
cfset Session.Admin.UserName = GetUser.username

!---cfcookie name=Confirmed value=Yes expires=NEVER
 cfcookie name=username value=#GetUser.username# expires=NEVER
cfcookie name=ID value=#GetUser.ID# expires=NEVER ---
cfoutput
script 
language=javascriptlocation.replace('index.cfm');/script
/cfoutputcfabort
cfelse
cfset message = We apologize but that username / password does not
match our records. Please try again.
/cfif/cfif

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313366
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

(ot) need help offlist

[Phillip Perry]

Hi, Can someone please help me offlist. I'm stuck and its a bit off
topic but i'm in a real bind.

Thanks, Phil

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313240
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: (ot) need help offlist

[Phillip Perry]

I'm just having issues with my setting of cookies. In IE it sets the
wrong cookies and in firefox the form just gets refreshed over and
over again without going to the action page.

On Mon, Sep 29, 2008 at 4:54 PM, Jake Churchill
[EMAIL PROTECTED] wrote:
 Maybe you'd like to describe your situation a bit so the right person
 can contact you off list...

 Phillip Perry wrote:
 Hi, Can someone please help me offlist. I'm stuck and its a bit off
 topic but i'm in a real bind.

 Thanks, Phil



 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313249
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFCookie trouble

[Phillip Perry]

Hi,

I'm trying to make a simple cookie for testing  but its not working
out. I use it for log in verification. The problem is the cookie gets
stored but the redirect is not happening. I use the  code below. The
second redirect is the problem. Instead of going to newindex.cfm its
loading the loginform.cfm file. Any ideas what i'm doing wrong?:

cfquery name=GetUser Datasource=#datasource# password=#pw#
SELECT *
FROM admin
WHERE username = '#Form.UserLogin#'
  AND password =   '#Form.password#'
/cfquery
cfif IsDefined(cookie.Confirmed) EQ Yes
cfset session.Admin = StructNew()
cfset Session.Admin.Confirmed = Yes
 cfheader name=location value=index.cfm
cfheader statusCode=302 statusText=Document Moved
cfabort
/cfif
cfparam name=form.UserLogin type=string
cfparam name=form.Password type=string
cfif GetUser.RecordCount EQ 1
cfset session.Admin = StructNew()
cfset Session.Admin.Confirmed = Yes
cfset Session.Admin.ContactID = GetUser.ID
cfset Session.Admin.UserName = GetUser.username
CFCOOKIE NAME=Check_Login VALUE=Yes EXPIRES=NEVER
cfheader name=location value=newindex.cfm
cfheader statusCode=302 statusText=Document Moved
cfabort

cfelse
cfset message=We apologize but that username / password does not
match our records. Please try again.
cflocation url=#cgi.script_name#?message=#message# ADDTOKEN=No
/cfif

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313187
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Phillip Perry has invited you to open a Google mail account

[Phillip Perry]

I've been using Gmail and thought you might like to try it out. Here's
an invitation to create an account.

---

Phillip Perry has invited you to open a free Gmail account.

To accept this invitation and register for your account, visit
http://mail.google.com/mail/a-f23f08bf6f-4bfc5ddc1f-e86d8607a5

Once you create your account, Phillip Perry will be notified with
your new email address so you can stay in touch with Gmail!

If you haven't already heard about Gmail, it's a new search-based webmail
service that offers:

- Over 2,700 megabytes (two gigabytes) of free storage
- Built-in Google search that instantly finds any message you want
- Automatic arrangement of messages and related replies into
  conversations
- Powerful spam protection using innovative Google technology
- No large, annoying ads--just small text ads and related pages that are
  relevant to the content of your messages

To learn more about Gmail before registering, visit:
http://mail.google.com/mail/help/benefits.html

And, to see how easy it can be to switch to a new email service, check
out our new switch guide: http://mail.google.com/mail/help/switch/

We're still working every day to improve Gmail, so we might ask for your
comments and suggestions periodically.  We hope you'll like Gmail.  We
do.  And, it's only going to get better.

Thanks,

The Gmail Team

(If clicking the URLs in this message does not work, copy and paste them
into the address bar of your browser).

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308435
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Naming Forms randomly

[Phillip Perry]

hello,

I use a form with a naming structure of formName#ID#. The CF
template ends up making multiple forms which is why i thought the #id#
part would be a good idea, to allow for identifying which form i want
to work on. The problem is that when i try to refer to the form name
in any CF template i get error messages. for instance if i try cfset
SomeVariable=formName#ID# I get an error referring to the #'s. Is
there a better way to name forms when you need each name to be unique
and still be able to refer to it in CF?

Thanks,

Phil

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300942
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Naming Forms randomly

[Phillip Perry]

I've tried the Evaluate() example you provided but now I'm getting an
error that my variable is undefined.

This is the code I've been using for testing...

cfparam name=thisOtherThing type=numeric default=1

cfset thisOtherThing=Evaluate(qty_adjust#theid#.current_qty.value)

form name=qty_adjust#theid#
action=#cgi.script_name#?co=enableaction=recalc method=post

input size=1 type=Text value=#thisOtherThing# 
name=current_qty /

Thanks for the help,

Phil

On Tue, Mar 11, 2008 at 11:42 AM, Dominic Watson
[EMAIL PROTECTED] wrote:
 I think this problem stems from CF syntax being too loose with regards its #
 symbols which leads to misunderstanding and confusion.

 If you want to set someVariable to the value pointed to by the variable
 someForm234 you could do:
 cfset someVariable = Evaluate(someform#ID#) or cfset someVariable =
 variables[someForm#ID#]

 If you want to set someVariable to the literal string someForm234. You
 should do:
 cfset someVariable = someForm#ID# or cfset someVariable = someForm 
 ID

 Does anyone else agree that cfset someVariable = #ID# should be invalid
 syntax?


 HTH

 Dominic

 --
 Blog it up: http://fusion.dominicwatson.co.uk


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300971
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Naming Forms randomly

[Phillip Perry]

Thanks, but now it says that qty_adjust1, which is what its supposed
to be, is undefined. qty_adjust1 is the name of the first form.

On Tue, Mar 11, 2008 at 2:30 PM, Rob Parkhill [EMAIL PROTECTED] wrote:
 Phillip,

 Your bracket is in the wrong spot

 cfset this otherthing = evaluate(qty_adjusttheid).current_qty

 That should work.

 Rob

 I've tried the Evaluate() example you provided but now I'm getting an
 error that my variable is undefined.
 
 This is the code I've been using for testing...
 
 cfparam name=thisOtherThing type=numeric default=1
 
 cfset thisOtherThing=Evaluate(qty_adjust#theid#.current_qty.value)
 
 form name=qty_adjust#theid#
 action=#cgi.script_name#?co=enableaction=recalc method=post
 
input size=1 type=Text value=#thisOtherThing# 
  name=current_qty /
 
 Thanks for the help,
 
 Phil
 
 On Tue, Mar 11, 2008 at 11:42 AM, Dominic Watson
 [EMAIL PROTECTED] wrote:
 

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300978
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Naming Forms randomly

[Phillip Perry]

Thank you. This is the answer I was looking for. I knew there was
another way to refer to the separate forms but I haven't been coding
for quite a while so my mind got caught wrapped around the naming form
idea. Thanks again.

On Tue, Mar 11, 2008 at 1:39 PM, Claude Schneegans
[EMAIL PROTECTED] wrote:
  The problem is that when i try to refer to the form name
 in any CF template

 I may be wrong, but AFAIK, the form name is not transmitted by HTTP, it
 is only available to
 Javascript on client side.
 Even if a page contains several forms, only one can be submitted at a time,
 and all its fields are referred in the form scope in the action template.

 So there is no use to name forms differently (is necessary at all).
 If you need to know which form was submitted, include the id in a hidden
 field.

 --
 ___
 REUSE CODE! Use custom tags;
 See http://www.contentbox.com/claude/customtags/tagstore.cfm
 (Please send any spam to this address: [EMAIL PROTECTED])
 Thanks.


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300981
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Naming Forms randomly

[Phillip Perry]

Something just occured to me. If i make a hidden field and put the ID
value in there, Wouldn't the name of the field be the same for every
form? so naming the hidden field somevar wouldn't work. cfset
myvar=form.somevar would have a value of whatever the last form has
correct?

On Tue, Mar 11, 2008 at 1:47 PM, Dominic Watson
[EMAIL PROTECTED] wrote:
 
  I may be wrong, but AFAIK, the form name is not transmitted by HTTP, it
  is only available to
  Javascript on client side.
  Even if a page contains several forms, only one can be submitted at a
  time,
  and all its fields are referred in the form scope in the action template.
 
  So there is no use to name forms differently (is necessary at all).
  If you need to know which form was submitted, include the id in a hidden
  field.


 What he said. If you want to differentiate between different forms being
 submitted, a good way is by passing a hidden form field with the form so:

 form action= method=post
  input type=hidden name=someId value=#someId#/
  input type=text name=hello/
 /form

 Then you can use the value in the page processing the form:

 cfset someId = form.someId
 cfset hello = form.hello

 HTH

 Dominic


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300984
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Naming Forms randomly

[Phillip Perry]

 Keep in mind that only ONE form gets to the action page.


This helps, kinda. The way i have the form now 1 form is made for each
item in the session. I guess I need to remake my form so that only one
gets made and separate buttons/submit buttons get sent to the action
page.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301021
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Naming Forms randomly

[Phillip Perry]

Well, I figured it out. Thank you for all the replys. What i needed to
do is add a hidden field to the form and then just manipulate the
information passed through that. I'm making a shopping cart. I was
trying to dynamically update the qty value if a user clicked +/-. I
was having a hard time trying to find out how to +/- the qty's while
at the same time updateing the totals. a few lines of code did the
trick...

cfif IsDefined(form.add_to_qty)
cfset session.cart[#prodID#].quantity=session.cart[#form.prodID#].quantity+1
cfelseif IsDefined(form.take_away_from_qty)
cfset session.cart[#prodID#].quantity=session.cart[#form.prodID#].quantity-1
/cfif

Actually, cfset session.cart[#prodID#] was a typo. I was going to put
form.prodID but when i did that earlier it was +/- 2 instead of one
because i was inside a loop.

I'm not sure if any of this makes sense but that was my solution.
Thanks again for the help. It really helped when it was pointed out
that only 1 form gets processed.

Phil
On Tue, Mar 11, 2008 at 6:43 PM, Aaron Rouse [EMAIL PROTECTED] wrote:
 Yes, the same people I  have seen do it also only allow the form to be
 submitted via JS.  I have even seen where they only allow it to be submitted
 from JS then they populate a hidden form value with a label, which again
 seems flawed because then in the processing code they check for specific
 labels.  Change the label and the processing code fails to run as expected.

 On Tue, Mar 11, 2008 at 3:33 PM, Dominic Watson 
 [EMAIL PROTECTED] wrote:

  

   I have seen some people just do it off the value of the Submit button.
   Although kind of sucks when they change the value in the button but
  forget
   to change  their switch/case or if/else on the processing end of things.
 
 
  You can do that, but if your user hits return to submit the form, the
  submit
  button name will not be posted. While you can't hit return to submit all
  forms, I think it preferable to use one technique throughout your code.
 
  Here is a demo template, run it by hitting the submit button and then
  again by hitting return after entering some text (if it works, try it in
  another browswer, I think this is a broswer issue).
 
  cfif StructKeyExists(form,myButton)
   h1Hello world/h1
  /cfif
 
  form action= method=post
   input name=foo value=bar/
   input type=submit value=Go go gadget legs name=myButton /
  /form
 
  The code will do what you expect in Firefox but not in IE.
 
  Dom
 
  --
  Blog it up: http://fusion.dominicwatson.co.uk
 
 
 

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301033
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Forms And Coldfusion

[Phillip Perry]

Hello,

I'm building a shopping cart and I've hit a bit of a snag. I'm using ±
buttons on a form to increase/decrease the qty of the item(s) in the
cart before purchase. Now I know how to access the new quantity of
items, but I don't know how to display them properly on the screen. If
i pass the number in the form post it actually shows the previous qty
on the url, not the current one (i.e. if you change from 1 item to 3
when you click recalculate it displays 1 until you reload the page
again). Also, I can put the new qty in a cfoutput and output it there
but I cant replace the forms text box. The code I'm using is below.
Any help would be appreciated. I'm sorry if I didn't explain it well
enough.

..

cfset TheNewQuan=#session.cart[theid].quantity# /
cfif IsDefined(url.action) AND url.action IS recalc
cfset thisThing=session.cart[theid].quantity
cfset thisOtherThing=form.current_qty
cfoutput#thisOtherThing#/cfoutput
cfoutput#thisThing#/cfoutput
cfoutputcfset thisThing EQ thisOtherThing
#thisThing#
/cfoutput
/cfif
form name=qty_adjust#theid#
action=#cgi.script_name#?co=enableaction=recalcqty=#thisOtherThing#
method=post

input size=1 type=Text value=#form.WhateverDude#
name=current_qty /

input type=button value=+ name=qty_up
onclick=a=parseFloat(document.qty_adjust#theid#.current_qty.value);b=a+1;document.qty_adjust#theid#.current_qty.value=b;if(b=#getinfo.units_in_stock#){document.qty_adjust#theid#.current_qty.value=#getinfo.units_in_stock#;alert('You
can only have #getinfo.units_in_stock# items at this time.');} /

input type=button value=- name=qty_down
onclick=a=parseFloat(document.qty_adjust#theid#.current_qty.value);b=a-1;document.qty_adjust#theid#.current_qty.value=b;if(b1){document.qty_adjust#theid#.current_qty.value=1;alert('You
cannot have less then 1 item. To remove this item from your cart
please push the DELETE button');}
input type=Hidden value=#theid# name=prodID /
input type=Hidden value=#form.current_qty# name=WhateverDude
INPUT TYPE=SUBMIT VALUE=RECALCULATE THE WHOLE TOTAL NAME=QTY_SUBMIT
/tdtd

...

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300815
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: [CFUGCNY] Struct not persistant

[Phillip Perry]

Hi,

I have  3 pages for a checkout for a shopping cart. First collects
shipping/billing info, second collects cc#, last is a confirmation page. In
a separate template that i cfinclude i have made a 2nd struct named
addressinfo that collects the shipping/billing info in the hopes that i can
use it to fill in an email that confirms  to the user that  I recieved the
order. The problem is the struct doesn't persist through  all the templates
.. It works on the same page as the  cc# page (via cfdump)  but on my
confirmation template where i have an email to the user setup my struct
disappears ,  so to speak. I do a dump of the struct in the last section but
i get the error message that  address info doesnt exist.  I hope that makes
sense.

Thanks,

Phil



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238966
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Struct not persistant

[Phillip Perry]

yeah thats just what I did but for some reaason its not staying persistant.
When i get to the confirmation page it says my struct is empty, but on the
cc# page its clearly defined via cfdump. Its very confusing for me.

as an example:

cfset addressinfo.firstname=form.firstname


which is usable until I actually need it then its struct is empty.

Phil


-Original Message-
From: Josh Nathanson [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 27, 2006 5:09 PM
To: CF-Talk
Subject: Re: [CFUGCNY] Struct not persistant


If you are using session management you can scope your struct to the
session --

cfset session.mystruct = #mystruct#

Then it will persist over your pages as you desire.  You would access the
information like so --

session.mystruct.address
session.mystruct.name
etc.

-- Josh


- Original Message -
From: Phillip Perry [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, April 27, 2006 1:56 PM
Subject: RE: [CFUGCNY] Struct not persistant


 Hi,

 I have  3 pages for a checkout for a shopping cart. First collects
 shipping/billing info, second collects cc#, last is a confirmation page.
 In
 a separate template that i cfinclude i have made a 2nd struct named
 addressinfo that collects the shipping/billing info in the hopes that i
 can
 use it to fill in an email that confirms  to the user that  I recieved the
 order. The problem is the struct doesn't persist through  all the
 templates
 .. It works on the same page as the  cc# page (via cfdump)  but on my
 confirmation template where i have an email to the user setup my struct
 disappears ,  so to speak. I do a dump of the struct in the last section
 but
 i get the error message that  address info doesnt exist.  I hope that
 makes
 sense.

 Thanks,

 Phil







~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238971
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Struct not persistant

[Phillip Perry]

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 27, 2006 5:29 PM
To: CF-Talk
Subject: RE: Struct not persistant


Can you show more of your code?


---

Here's the top portion...

cfparam name=session.addressinfo TYPE=struct default=#structnew()# /

cfset addressinfo.firstname=FORM.firstname
cfset addressinfo.lastname=FORM.lastname
cfset addressinfo.telephone=FORM.telephone
cfset addressinfo.telephone=FORM.fax
cfset addressinfo.email=FORM.email

.etc. etc. etc.

Thats my include template. There is more obviously but the rest is pretty
much the same.


Phil



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238983
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Struct not persistant

[Phillip Perry]

Thanks everyone putting session. before addressinfo did the trick.

Phil

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 27, 2006 5:55 PM
To: CF-Talk
Subject: RE: Struct not persistant


 cfparam name=session.addressinfo TYPE=struct
 default=#structnew()# /

   cfset addressinfo.firstname=FORM.firstname

These do not equal each other.  In the first cfparam line you are creating a
addressinfo structure in the session scope.  But all the cfset lines you are
reference an addressinfo structure in the local variables scope.  You need
to be using session.addressinfo in each cfset line to distinguish that the
data goes into the session scope, not the local variables scope.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-

C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments 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 and
delete any copies of this message.






~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239006
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

CFOUTPUT query not working inside cfmail?

[Phillip Perry]

Hi,

I have another issue with the same cart. For some reason when i put the
shopping cart display code inside the cfmail tag it tells me that i'm
nesting cfoutput query= tags but I'm not. If I move the code to an area
just before the cfmail tag the code works just fine. Has anyone else had
this problem or know of a work-around?

thanks
Phil



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239007
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFOUTPUT query not working inside cfmail?

[Phillip Perry]

Thanks, this is a new one on me. I used a cfinclude to work around the
problem and I think its working out ok.

Thanks again,

Phil

-Original Message-
From: Josh Nathanson [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 27, 2006 8:16 PM
To: CF-Talk
Subject: Re: CFOUTPUT query not working inside cfmail?


In cfmail you don't need the cfoutput tags, the cfoutput is assumed.

For that same reason, if you have any hex colors defined within the cfmail
contents you'll need to double up the pound signs (##FFF instead of
#FF).

-- Josh




- Original Message -
From: Phillip Perry [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, April 27, 2006 5:07 PM
Subject: CFOUTPUT query not working inside cfmail?


 Hi,

 I have another issue with the same cart. For some reason when i put the
 shopping cart display code inside the cfmail tag it tells me that i'm
 nesting cfoutput query= tags but I'm not. If I move the code to an area
 just before the cfmail tag the code works just fine. Has anyone else had
 this problem or know of a work-around?

 thanks
 Phil







~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239011
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Shopping Cart qty problems.

[Phillip Perry]

Well my Internet was shut down yesterday for the whole day so I had to work
on this myself. I decided it would be easier to just let ppl adjust the qty
during checkout via up and down arrows that add or subtract one to the qty
(or del the item if 1 item is left) and I got it to work fine that way.
Thanks for the effort anyways and sorry I wasnt clear enough on what I was
doing.

Phil

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Friday, February 17, 2006 8:32 AM
To: CF-Talk
Subject: RE: Shopping Cart qty problems.


Sorry, can't do anything with that either. There's more to it.

...:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 7:36 PM
To: CF-Talk
Subject: RE: Shopping Cart qty problems.

here is the code...

Quantity: select name=quantity
   cfloop from=1 to=#recommend.units_in_stock# index=idx
  option value=#idx##idx#/option
   /cfloop
   /select

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 3:38 PM
To: CF-Talk
Subject: RE: Shopping Cart qty problems.


Going to need a little more than that :)

It sounds like you are only outputting the last qty value for all of them
though. -or- you are updating them all to the last qty's value somewhere.

.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com


-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 3:27 PM
To: CF-Talk
Subject: Shopping Cart qty problems.

Hi,

I have a cart that displays the qty in a drop down list. The list is from
1 - max qty in the DB. The problem is that if the user chooses more than one
item, all items qty's become the same as the last item chosen.

Example:

item 1qty chosen 4; qty after item 2 = 2
item 2qty chosen 2; qty stays the same.

and the qty for each item goes to 1 when the user decides to checkout also.

Any help is appreciated.

Phil












~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232794
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Shopping Cart qty problems.

[Phillip Perry]

Hi,

I have a cart that displays the qty in a drop down list. The list is from
1 - max qty in the DB. The problem is that if the user chooses more than one
item, all items qty's become the same as the last item chosen.

Example:

item 1qty chosen 4; qty after item 2 = 2
item 2qty chosen 2; qty stays the same.

and the qty for each item goes to 1 when the user decides to checkout also.

Any help is appreciated.

Phil




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232572
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Shopping Cart qty problems.

[Phillip Perry]

here is the code...

Quantity: select name=quantity
   cfloop from=1 to=#recommend.units_in_stock# index=idx
  option value=#idx##idx#/option
   /cfloop
   /select

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 3:38 PM
To: CF-Talk
Subject: RE: Shopping Cart qty problems.


Going to need a little more than that :)

It sounds like you are only outputting the last qty value for all of them
though. -or- you are updating them all to the last qty's value somewhere.

...:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com


-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 3:27 PM
To: CF-Talk
Subject: Shopping Cart qty problems.

Hi,

I have a cart that displays the qty in a drop down list. The list is from
1 - max qty in the DB. The problem is that if the user chooses more than one
item, all items qty's become the same as the last item chosen.

Example:

item 1qty chosen 4; qty after item 2 = 2
item 2qty chosen 2; qty stays the same.

and the qty for each item goes to 1 when the user decides to checkout also.

Any help is appreciated.

Phil








~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232653
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Homesite 5.5 and external browsers (one more thing)

[Phillip Perry]

To be honest I dont know anything about IIS. It was on XP Pro when i bought
it. Would that hinder other browsers except IE to work?

Phil

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 09, 2006 6:34 PM
To: CF-Talk
Subject: RE: Homesite 5.5 and external browsers (one more thing)


Do you have integrated windows authentication set in the directory
security setting of the IIS properties of the website?


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-

C code. C code run. Run code run. Please!
- Cynthia Dunning





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231959
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

OT:Can't use any browsers besides IE (was Homesite external browsers)

[Phillip Perry]

OK,

So this isnt a homesite thing this is a browsers thing. When i type the
address in physically it doesnt show the web page in any browser except IE.
I changed the subject just so that its understood its not a HS thing.

Thanks,

Phil




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231962
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

SOLVED: RE: Can't use any browsers besides IE

[Phillip Perry]

Well I took a crash course in IIS and found that I had my site in a virtual
directory. When I changed it to a physical directory it works on all
browsers. Thanks for everyones help
Phil

-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Friday, February 10, 2006 2:17 PM
To: CF-Talk
Subject: OT:Can't use any browsers besides IE (was Homesite external
browsers)


OK,

So this isnt a homesite thing this is a browsers thing. When i type the
address in physically it doesnt show the web page in any browser except IE.
I changed the subject just so that its understood its not a HS thing.

Thanks,

Phil






~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231988
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Homesite 5.5 and external browsers (one more thing)

[Phillip Perry]

no actually its just a plain html doc with just an empty table in it and
..cfm as an extention.

-Original Message-
From: Munson, Jacob [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 09, 2006 10:15 AM
To: CF-Talk
Subject: RE: Homesite 5.5 and external browsers (one more thing)


Are you using cgi.auth_user?

 -Original Message-
 From: Phillip Perry [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, February 08, 2006 9:01 PM
 To: CF-Talk
 Subject: RE: Homesite 5.5 and external browsers (one more thing)

 OK, now I switched the mapping to localhost and it works in
 IE but opera NS
 and FF all want username and password still. I haven't a clue
 what this
 could be

 Phil


 -Original Message-
 From: Phillip Perry [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, February 08, 2006 10:33 PM
 To: CF-Talk
 Subject: OT: Homesite 5.5 and external browsers


 Hi,

 Does anyone know why viewing the pages locally on localhost
 or 127.0.0.1
 both ask me for a username and password? it happens in every browser I
 use.

 Thanks

This transmission may contain information that is privileged, confidential
and/or exempt from disclosure under applicable law. If you are not the
intended recipient, you are hereby notified that any disclosure, copying,
distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission
in error, please immediately contact the sender and destroy the material in
its entirety, whether in electronic or hard copy format. Thank you. A1.





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231848
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

OT: Homesite 5.5 and external browsers

[Phillip Perry]

Hi,

Does anyone know why viewing the pages locally on localhost or 127.0.0.1
both ask me for a username and password? it happens in every browser I use.

Thanks

Phil




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231704
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Homesite 5.5 and external browsers (one more thing)

[Phillip Perry]

The site is viewable if i type either address in the bar physically just not
when I use HS view in external browser button. The default is IE
Phil

-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 08, 2006 10:33 PM
To: CF-Talk
Subject: OT: Homesite 5.5 and external browsers


Hi,

Does anyone know why viewing the pages locally on localhost or 127.0.0.1
both ask me for a username and password? it happens in every browser I use.

Thanks

Phil






~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231705
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Homesite 5.5 and external browsers (one more thing)

[Phillip Perry]

No nothings secure

Phil

-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 08, 2006 10:44 PM
To: CF-Talk
Subject: RE: Homesite 5.5 and external browsers (one more thing)


Are there any references (CSS/Images/etc) that are, themselves, secured?


-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 08, 2006 9:40 PM
To: CF-Talk
Subject: RE: Homesite 5.5 and external browsers (one more thing)

The site is viewable if i type either address in the bar physically just
not when I use HS view in external browser button. The default is IE
Phil

-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 08, 2006 10:33 PM
To: CF-Talk
Subject: OT: Homesite 5.5 and external browsers


Hi,

Does anyone know why viewing the pages locally on localhost or 127.0.0.1
both ask me for a username and password? it happens in every browser I
use.

Thanks

Phil










~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231707
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Homesite 5.5 and external browsers (one more thing)

[Phillip Perry]

OK, now I switched the mapping to localhost and it works in IE but opera NS
and FF all want username and password still. I haven't a clue what this
could be

Phil


-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 08, 2006 10:33 PM
To: CF-Talk
Subject: OT: Homesite 5.5 and external browsers


Hi,

Does anyone know why viewing the pages locally on localhost or 127.0.0.1
both ask me for a username and password? it happens in every browser I
use.

Thanks

Phil












~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231708
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

CF 7 startup ?

[Phillip Perry]

I just downloaded the trial version of 7 but for the life of me cant find
how to start the server. I'm sorry if this is discussed before but I dont
have time to search the archives

Phil




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229618
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Currency data type in access

[Phillip Perry]

Hi,

When I display the dollar amount in a web page the values come with extra
0's (ex: 19.9500). How do I get rid of the extra 0's? I tried replace() but
that didn't pan out.

Thanks,

Phil




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208845
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Hey. About your access post.

[Phillip Perry]

Hi,

How've you been. I just read your post on fusion about supporting access and
I noticed you said that sql server has a free version. Would you happen to
know where I can get my hands on it? I cant find one on the Microsoft
website.

Thanks
Phil




~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208847
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Hey. About your access post.

[Phillip Perry]

sorry that was supposed to be a direct question to someone. Dont know why it
went right to this list, my apologies again

Phil

-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 07, 2005 1:36 PM
To: CF-Talk
Subject: Hey. About your access post.


Hi,

How've you been. I just read your post on fusion about supporting access and
I noticed you said that sql server has a free version. Would you happen to
know where I can get my hands on it? I cant find one on the Microsoft
website.

Thanks
Phil






~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208849
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

My attempt at a shopping cart

[Phillip Perry]

Hi,

just 2 lines of code and i'm already hitting a wall. I'm using the following
lines

cfparam name=session.cart default=arrayNew()
cfset session.cart = arrayAppend(session.cart, structnew())

and getting the error code:

Object of type class java.lang.String cannot be used as an array

What am i doing wrong?

Thanks,

Phil




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208863
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: My attempt at a shopping cart

[Phillip Perry]

I tried that but it gives me a validation error function takes 1 parameter
error.

Phil
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 07, 2005 3:29 PM
To: CF-Talk
Subject: Re: My attempt at a shopping cart


cfparam name=session.cart default=#arrayNew()#

poundage makes it an array.  lack of poundage makes it a string.

On 6/7/05, Phillip Perry [EMAIL PROTECTED] wrote:
 Hi,

 just 2 lines of code and i'm already hitting a wall. I'm using the
following
 lines

 cfparam name=session.cart default=arrayNew()
 cfset session.cart = arrayAppend(session.cart, structnew())

 and getting the error code:

 Object of type class java.lang.String cannot be used as an array

 What am i doing wrong?

 Thanks,

 Phil








~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208865
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: My attempt at a shopping cart

[Phillip Perry]

I've been trying that, among other things but i keep getting basically the
same error. if it isnt an error for line 1 its an error for line 2. if i do
the (1) on the array it gives me the java.string error for structNew() but
it also says parameter takes 1 parameter. When I put structNew(1) it gives
me paramater takes 0 parameters as an error. with or without #'s.  I'm
really confused on this one.

Phil

-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 07, 2005 3:52 PM
To: CF-Talk
Subject: Re: My attempt at a shopping cart


gah.

sorry, arrayNew() takes one argument (the dimension of the array).
assuming a 1d array:

cfparam name=session.cart default=#arrayNew(1)#  :|

On 6/7/05, Phillip Perry [EMAIL PROTECTED] wrote:
 I tried that but it gives me a validation error function takes 1 parameter
 error.

 Phil
 -Original Message-
 From: Charlie Griefer [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, June 07, 2005 3:29 PM
 To: CF-Talk
 Subject: Re: My attempt at a shopping cart


 cfparam name=session.cart default=#arrayNew()#

 poundage makes it an array.  lack of poundage makes it a string.

 On 6/7/05, Phillip Perry [EMAIL PROTECTED] wrote:
  Hi,
 
  just 2 lines of code and i'm already hitting a wall. I'm using the
 following
  lines
 
  cfparam name=session.cart default=arrayNew()
  cfset session.cart = arrayAppend(session.cart, structnew())
 
  and getting the error code:
 
  Object of type class java.lang.String cannot be used as an array
 
  What am i doing wrong?
 
  Thanks,
 
  Phil
 
 
 
 
 







~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208869
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

what is this?

[Phillip Perry]

Hi,

can someone tell me why the # is showing up in the following lines?


cfoutput query=GetInfo2
A HREF=process_path.cfm?LID=#couponhref# TARGET=_blank

For some reason It's showing the value of couponhref but its also displaying
the #. So the link looks like this on the page...

a href=process_path.cfm?LID=#http://www.blah.com#; Target=_blank

Any thoughts? I tried to put the couponhref in a separate variable name but
that didnt work either.

Thanks

Phil




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189683
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: what is this?

[Phillip Perry]

Thanks, actually it was a DB problem. I'm using access and it automatically
assigned the value of the field to a hyperlink. For some reason the DB puts
in #'s by itself when using a hyperlink data type. All I had to do was
switch it to a text field and things fixed itself.

Thanks again,

Phil

-Original Message-
From: Joe Rinehart [mailto:[EMAIL PROTECTED]
Sent: Friday, January 07, 2005 3:22 PM
To: CF-Talk
Subject: Re: what is this?


Phillip,

Are you sure you've put the file on a ColdFusion server, that the
ColdFusion server is running, and that you're viewing the page via
http:// and not file://?

Would you mind posting both the URL in your location bar and the
result of doing View Source?

-joe


On Fri, 7 Jan 2005 15:08:01 -0500, Phillip Perry
[EMAIL PROTECTED] wrote:
 Hi,

 can someone tell me why the # is showing up in the following lines?

 cfoutput query=GetInfo2
 A HREF=process_path.cfm?LID=#couponhref# TARGET=_blank

 For some reason It's showing the value of couponhref but its also
displaying
 the #. So the link looks like this on the page...

 a href=process_path.cfm?LID=#http://www.blah.com#; Target=_blank

 Any thoughts? I tried to put the couponhref in a separate variable name
but
 that didnt work either.

 Thanks

 Phil





~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189685
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

cfif issues

[Phillip Perry]

Hi,

assuming all variables are correct what is wrong with this code?

cfif IsDefined(url.directory)
a href=testftp.cfm?directory=#url.directory#/#ListFiles.name#
cfelse
a href=testftp.cfm?directory=#ListFiles.name#/cfif#ListFiles.name#/a
/cfif

When i click on the very first link the path looks similar to this..

testftp.cfm?directory=wwwroot

So the next page would have links that should now look similar to this..

testftp.cfm?directory=wwwroot/images

however something is failing with the IsDefined statement becauase I'm
getting this..

testftp.cfm?directory=images

Does anyone have any thoughts?

Phil




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187920
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cffile error confusion.

[Phillip Perry]

Thanks Mark but I can't use it. The problem is that I need the file
uncompiled. Using cfhttp compiles it first.

Thanks anyway

Phil

-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 14, 2004 11:13 AM
To: CF-Talk
Subject: RE: cffile error confusion.


Phil,


You need an absolute file path (as in C:\blah\blah.txt) to use CF File. What
you may be looking for is CFHTTP. Try

cfhttp url=http://www.applewoodcommunity.com/index.cfm/

cfset content = cfhttp.filecontent

-Mark

Mark A. Kruger, CFG, MSCE
www.cfwebtools.com
www.necfug.com
http://blog.mxconsulting.com


-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 14, 2004 10:07 AM
To: CF-Talk
Subject: cffile error confusion.


Hi,

Does anyone know why i'm getting this error? It's coming from my local
machine...

Error Occurred While Processing Request
An error occurred when performing a file operation READ on file
C:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\http://www.
applewoodcommunity.com/index.cfm.
The cause of this exception was: java.io.FileNotFoundException:
C:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\http:\www.a
pplewoodcommunity.com\index.cfm (The filename, directory name, or volume
label syntax is incorrect).

This is my cffile example..

cffile ACTION=READ FILE=http://www.applewoodcommunity.com/index.cfm;
VARIABLE=content

Thanks

Phil








~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187610
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

cffile error confusion.

[Phillip Perry]

Hi,

Does anyone know why i'm getting this error? It's coming from my local
machine...

Error Occurred While Processing Request
An error occurred when performing a file operation READ on file
C:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\http://www.
applewoodcommunity.com/index.cfm.
The cause of this exception was: java.io.FileNotFoundException:
C:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\http:\www.a
pplewoodcommunity.com\index.cfm (The filename, directory name, or volume
label syntax is incorrect).

This is my cffile example..

cffile ACTION=READ FILE=http://www.applewoodcommunity.com/index.cfm;
VARIABLE=content

Thanks

Phil




~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187550
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

cfftp exception error

[Phillip Perry]

Hi,

Does anyone know why I would get this error?

An exception occurred when establishing a FTP connection.
The cause of this exception was that: java.net.UnknownHostException:
http://ftp.applewoodcommunity.com/.


Phil




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187211
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Picky delete statement?

[Phillip Perry]

Hi,

I've read my sql book but I cant find what i'm looking for. According to the
book (as far as my understanding is) you cant specify which columns to
delete, you can only delete the whole record. Is this true?

Phil




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186921
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

OT: Strange title in pop up windows

[Phillip Perry]

Can anyone explain why I would get the url included in the title of my pop
up page? There is a valid title in the pop up. Everything validates on that
section. I'm a bit stumped here.

Phil




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186939
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: todays ramblings

[Phillip Perry]

I went to that website but i dont see anything for a win4lin I do however
do see the html candy which doesn't support cfm files.

Phil

-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 09, 2004 9:39 PM
To: CF-Talk
Subject: todays ramblings


anyone ever tried win4lin?

look at this potentially nifty program for cleaning up  validating your
code
http://www.anetto.com.ru/ahc.php
please note it does support coldfusion but the authors missed a few things
and i just sent them back the answers (rut roh!)
when u see version 2 then it will be fixed, he said 5 minutes to fix
finally one that will work with cfm:)


Anetto HTML Candy 1.0

Anetto HTML Candy is new-age software for final preparation of HTML pages.
It is able to fix up a wide range of problems with HTML syntax, including
tags, styles, attributes and attributes' values. Each found item is listed
with warning type, the line number so that you can see where the problem
lies in your markup. Moreover, it recommends you possible solution, so it
will be useful for newcomers especially. Also, it helps you check your page
to HTML 4.01 recommendations to make your pages more accessible to people
using other browsers and OS. Validate your document objects: images, links,
external scripts and css before uploading. Anetto HTML Candy helps you
beautify hard-to-read HTML code, generated by specialized HTML editors and
conversion tools. Work with HTML Candy will be pleasant due to nice Windows
XP like interface, back-up system and HTML syntax highlighting.

Make your web page a candy with HTML Candy!

* PHP, ASP, SSI support
* Powerful optimization, including:

  o checking

+ tags names
+ tags attributes names
+ tags attributes values
+ tags required attributes
+ tags style attributes names
+ tags style attributes values
+ tags, attributes and values on compability between
browsers
+ optional and required closing tags
  o validating

+ anchors
+ images
+ css
+ external scripts
+ forms actions
+ frames
  o beautifying

+ elements case
+ tabs before and after element
+ structurize (tags tree)
  o tunable options
* Detailed results, including:

  o message type (information, warning, error)
  o position in source text (with selection)
  o possible solution
* Extremely simple work (in despite of power)
* Adjustable back-up system
* Built-in editor
* External editors and browsers support
* User friendly Windows XP like interface
* Drag'n'drop and command-line support
* Adjustable HTML syntax highlight






~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186941
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

determining if 8 columns of 1 record are populated

[Phillip Perry]

Hi,

ok here is the situation. I'm allowing users to enter up to 8 urls into a
form to put into a favorites section of my site. To determine if the user
has entered at least one url in the db I have a column called uselink
updated to YES. The problem is I can't find an easy way to detect if the
user has deleted ALL of the urls from their list. If they did that I want
the uselink column to be NO. Any clues on an easy solution?


Phil




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186646
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Strange error message

[Phillip Perry]

Hi,

I'm getting this error message during an insert attempt...

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Missing semicolon (;) at end of SQL statement.

I've never used a semicolon before and things worked ok. here is my
statement...

cfquery datasource=#mydbname# name=linkinsert
  INSERT INTO users
(
 link1,
 link2,
 link3,
 link4,
 link5,
 link6,
 link7,
 link8
)
  Values
(
 '#form.link1#',
 '#form.link2#',
 '#form.link3#',
 '#form.link4#',
 '#form.link5#',
 '#form.link6#',
 '#form.link7#',
 '#form.link8#'
)
  WHERE uid = #user_var#
/cfquery



~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186539
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Strange error message

[Phillip Perry]

ok you solved my problem. figures the only problems I cant figure out are
the ones that I screw up.

Thanks
phil

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 07, 2004 3:19 PM
To: CF-Talk
Subject: Re: Strange error message


How can you have a WHERE clause in an insert statement?  are u trying to do
an update?  or am i missing something?

Ray

  At 03:13 PM 12/7/2004, Phillip Perry wrote:
Hi,

I'm getting this error message during an insert attempt...

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Missing semicolon (;) at end of SQL statement.

I've never used a semicolon before and things worked ok. here is my
statement...

cfquery datasource=#mydbname# name=linkinsert
   INSERT INTO users
 (
 link1,
 link2,
 link3,
 link4,
 link5,
 link6,
 link7,
 link8
 )
   Values
 (
 '#form.link1#',
 '#form.link2#',
 '#form.link3#',
 '#form.link4#',
 '#form.link5#',
 '#form.link6#',
 '#form.link7#',
 '#form.link8#'
 )
   WHERE uid = #user_var#
/cfquery







~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186543
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: PostgreSQL database size

[Phillip Perry]

I checked for query builder in access 2000 and cant seem to find it. How do
i access query builder?

Phil

-Original Message-
From: NZERN National Office [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 28, 2004 9:06 PM
To: CF-Talk
Subject: PostgreSQL database size


Hi there

How large a database can PostgreSQL reliably support. I need something that
can store about 100GB

Cheers

Mike Peters
---
NZERN National Office
New Zealand Ecological Restoration Network
PO Box 9000, Christchurch
Ph (03) 338-5451
Fax (03) 338-5481
[EMAIL PROTECTED]
www.bush.org.nz


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185476
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

cfmail sending 1 too many emails

[Phillip Perry]

I have a cfmail that is supposed to send 2 emails to 1 person based on an
ID#. I have confirmed that the output is showing only 2 id numbers but it is
repeating 1 of them. This is what I have for code. I'm surrounding the
cfmail tags with cfloop query=myquery to get the email address(among other
things). Here's the jist of it.

cfquery datasource=#mydbname# name=GetUsers
SELECT *
FROM contacts,ImageList
WHERE contacts.contact_id = ImageList.contact_id
/cfquery

cfif GetUsers.RecordCount IS NOT 0
CFLOOP QUERY=GetUsers BRcfmail FROM=[EMAIL PROTECTED]
SERVER=mail.applewoodcommunity.com SUBJECT=The Applewood Community - Your
Monthly Statement TO=#GetUsers.email_address# TYPE=HTML
WRAPTEXT=45...yadda yadda yadda.../cfmail/cfloop/cfif

cfquery datasource=#mydbname# name=GetUsers2
SELECT *
FROM contacts,coupons
WHERE contacts.contact_id = coupons.contact_id
/cfquery
cfif GetUsers2.RecordCount IS NOT  0
CFLOOP QUERY=GetUsers2cfmail FROM=[EMAIL PROTECTED]
QUERY=GetUsers SERVER=mail.applewoodcommunity.com SUBJECT=The Applewood
Community - Your Monthly Statement TO=#GetUsers2.email_address#
TYPE=HTML WRAPTEXT=45  ...yadda yadda yadda.../cfmail/cfloop/cfif

Thanks

Phil









~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185488
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

WRONG POST RE: PostgreSQL database size

[Phillip Perry]

sorry i hit the wrong message for reply

-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 28, 2004 10:24 PM
To: CF-Talk
Subject: RE: PostgreSQL database size


I checked for query builder in access 2000 and cant seem to find it. How do
i access query builder?

Phil

-Original Message-
From: NZERN National Office [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 28, 2004 9:06 PM
To: CF-Talk
Subject: PostgreSQL database size


Hi there

How large a database can PostgreSQL reliably support. I need something that
can store about 100GB

Cheers

Mike Peters
---
NZERN National Office
New Zealand Ecological Restoration Network
PO Box 9000, Christchurch
Ph (03) 338-5451
Fax (03) 338-5481
[EMAIL PROTECTED]
www.bush.org.nz




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185495
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cfmail sending 1 too many emails

[Phillip Perry]

I figured it out

phil

-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 27, 2004 5:42 PM
To: CF-Talk
Subject: cfmail sending 1 too many emails


I have a cfmail that is supposed to send 2 emails to 1 person based on an
ID#. I have confirmed that the output is showing only 2 id numbers but it is
repeating 1 of them. This is what I have for code. I'm surrounding the
cfmail tags with cfloop query=myquery to get the email address(among other
things). Here's the jist of it.

cfquery datasource=#mydbname# name=GetUsers
SELECT *
FROM contacts,ImageList
WHERE contacts.contact_id = ImageList.contact_id
/cfquery

cfif GetUsers.RecordCount IS NOT 0
CFLOOP QUERY=GetUsers BRcfmail FROM=[EMAIL PROTECTED]
SERVER=mail.applewoodcommunity.com SUBJECT=The Applewood Community - Your
Monthly Statement TO=#GetUsers.email_address# TYPE=HTML
WRAPTEXT=45...yadda yadda yadda.../cfmail/cfloop/cfif

cfquery datasource=#mydbname# name=GetUsers2
SELECT *
FROM contacts,coupons
WHERE contacts.contact_id = coupons.contact_id
/cfquery
cfif GetUsers2.RecordCount IS NOT  0
CFLOOP QUERY=GetUsers2cfmail FROM=[EMAIL PROTECTED]
QUERY=GetUsers SERVER=mail.applewoodcommunity.com SUBJECT=The Applewood
Community - Your Monthly Statement TO=#GetUsers2.email_address#
TYPE=HTML WRAPTEXT=45  ...yadda yadda yadda.../cfmail/cfloop/cfif

Thanks

Phil











~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185496
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

3 tables of information needed

[Phillip Perry]

Hi,

I have 3 tables that I want to get information out of in 1 query. The
problem is that 2 of the tables may or may not have information in them. All
3 tables have a relationship called contact_id. How do I do a query that
checks to see if table 2 has the same id as table 1 and table 3 has the same
id as table 1? I hope that makes sense because I have totally confused
myself with this one (not very hard to do:). This is a sample query..


cfquery datasource=mydb name=TheName
SELECT *
FROM contacts,image_list,coupons
WHERE contacts.contact_id = image_list.contact_id
AND contacts.contact_id = coupons.contact_id
/cfquery

Now the AND will not work because image_list or coupons could have 0 records
with that id.

Any thoughts?

Phil




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185458
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: 3 tables of information needed

[Phillip Perry]

Thanks for the explaination. I wasn't too sure how joins (inner or outer)
worked...in the technical sense that is. Anyways I'm using access as the db.
I have to do some digging to see what is acceptable for joins. It appears
that (+) doesn't work with access.

Thanks again

Phil

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Friday, November 26, 2004 3:12 PM
To: CF-Talk
Subject: RE: 3 tables of information needed


cfquery datasource=mydb name=TheName
SELECT *
FROM contacts,image_list,coupons
WHERE contacts.contact_id = image_list.contact_id
AND contacts.contact_id = coupons.contact_id
/cfquery


To expand on the previous response, here are a couple of ways to do outer
joins.

You can do the joins in the where clause, as your example does with outer
join characters, but I understand these are DBMS specific.  For the Oracle
systems I use at work I would code your query like such.

cfquery datasource=mydb name=TheName
SELECT *
FROM contacts,image_list,coupons
WHERE contacts.contact_id = image_list.contact_id(+)
AND contacts.contact_id = coupons.contact_id(+)
/cfquery

The (+) beside the fields that can have 0 or more matches does what you
want.

You can also do the joins in the where clause.  Then your quiry would look
something like this.

cfquery datasource=mydb name=TheName
SELECT *
FROM contacts
LEFT JOIN image_list ON contacts.contact_id = image_list.contact_id,coupons
LEFT JOIN Coupons ON contacts.contact_id = coupons.contact_id
/cfquery


None of this syntax is tested so errors may exist, but HTH.

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

C code. C code run. Run code run. Please!
- Cynthia Dunning



Confidentiality Notice:  This message including any
attachments 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 and
delete any copies of this message.





~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185462
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Session Issue

[Phillip Perry]

Hi,

I'm using both session vars. and cookies to help with login. Session is used
only for people who dont want to stay logged in permanently and the cookie
is used only if they want to stay permanently logged in. The problem I'm
having is that when the session times out the user has to log in again
whether or not they have the cookie. How do I make sure the user can get the
content they want if they have the cookie regardless of the session timeing
out. Below is my code. Any help is appreciated.

Phil

!--- my code ---

cfif IsDefined(cookie.LoggedIn) EQ Yes
cflocation url=#cgi.script_name# ADDTOKEN=No
cfabort
/cfif
cfparam name=form.UserLogin type=string
cfparam name=form.Password type=string
cfparam name=form.remember_me type=string default=Off
cfquery name=GetUser Datasource=#mydbname#
SELECT *
FROM users
WHERE username = '#Form.UserLogin#'
  AND password =   '#Form.password#'
/cfquery
cfif GetUser.RecordCount EQ 1
cfset session.Auth = StructNew()
cfset Session.Auth.IsLoggedIn = Yes
cfset Session.Auth.ContactID = GetUser.user_id
cfset Session.Auth.UserName = GetUser.username
cfif #form.remember_me# IS On
CFCOOKIE NAME=LoggedIn VALUE=Yes EXPIRES=NEVER
/cfif
cflocation url=#cgi.script_name# ADDTOKEN=No
cfelse
cfset message=We apologize but that username / password does not match our
records. Please try again.
cflocation url=#cgi.script_name#?message=#message# ADDTOKEN=No
/cfif




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185025
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

OT Javascript Problem

[Phillip Perry]

Hi,

Sorry for the ot but i'm in a bit of a pickle. Can someone tell me why the
following code doesnt work?

script LANGUAGE=JavaScript TYPE=text/javascript
function CheckPass()
{
if (document.process_member.pass.value !=
document.process_member.confirmit.value)
{
alert('The passwords you entered do not match each 
other. Please try
again.)return false;
}

}
/script

form ...blah... OnSubmit=return CheckPass(); name=process_member


pass and confirmit both exist. I'm not getting any error codes. It's just
processing the form without doing the JS first. What am I doing wrong?

Thanks,

Phil




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185063
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: OT Javascript Problem

[Phillip Perry]

Thanks,

I made the corrections you and Douglas sent me and that worked out. Didnt
catch the double and single quote and put in the semicolon and that seemed
to work.

Thanks again,

Phil

-Original Message-
From: Ron Gowen [mailto:[EMAIL PROTECTED]
Sent: Monday, November 22, 2004 3:49 PM
To: CF-Talk
Subject: Re: OT Javascript Problem


script LANGUAGE=JavaScript TYPE=text/javascript
function CheckPass() {

   if ((document.process_member.pass.value) !=
(document.process_member.confirmit.value)){
 alert(The passwords you entered do not match each
other. Please try again.)
return false;
   }else{
alert('hello');
}
return true;
}

/script
/head

body
form name=process_member action= onSubmit=CheckPass();
input type=text name=pass /br /
input type=test name=confirmit value=ok/br /
input type=submit value=test


/form


On Mon, 22 Nov 2004 13:39:43 -0700, Ron Gowen [EMAIL PROTECTED] wrote:
 you have a single and a double qoute opening your alert message? and a
 double closing it




 On Mon, 22 Nov 2004 13:35:53 -0700, Charlie Griefer
 [EMAIL PROTECTED] wrote:
  might want to try throwing an else in the function to alert('foo'); or
  something...just to see if the function -is- being called but not
  catching the mismatched values for some reason.
 
  is this page online somewhere i can take a look at the full page?
 
  On Mon, 22 Nov 2004 15:29:56 -0500, Phillip Perry
 
 
  [EMAIL PROTECTED] wrote:
   Hi,
  
   Sorry for the ot but i'm in a bit of a pickle. Can someone tell me why
the
   following code doesnt work?
  
   script LANGUAGE=JavaScript TYPE=text/javascript
   function CheckPass()
   {
   if (document.process_member.pass.value !=
   document.process_member.confirmit.value)
   {
   alert('The passwords you entered do not match
each other. Please try
   again.)return false;
   }
  
   }
   /script
  
   form ...blah... OnSubmit=return CheckPass(); name=process_member
  
   pass and confirmit both exist. I'm not getting any error codes. It's
just
   processing the form without doing the JS first. What am I doing wrong?
  
   Thanks,
  
   Phil
  
  
 
 



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185069
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Session giving me headaches.

[Phillip Perry]

Hi,

I've done all I can think of to get rid of the session. I've done
structclear(session) I've done cfapplication timeouts and
loginstorage=storage. but no matter what I'm doing the session is staying
on. I cfdumped it and the cookie info. The cookie is gone (which is right)
but the session remains. I would appreciate any help that can be given. I'll
provide my code again.

Phil


cflogout
cfif IsDefined(cookie.ISTHISPERSONLOGGEDINORWHAT) EQ Yes OR
IsDefined(Session.Auth)
cfcookie NAME=ISTHISPERSONLOGGEDINORWHAT VALUE=Yes EXPIRES=NOW
cfapplication name=applewoodcommunity sessionmanagement=yes
sessiontimeout=#createTimeSpan(0,0,0,0)# LOGINSTORAGE=Session
#StructClear(Auth)# !--- I've tried different variations ---
/cfif
cflocation url=http://localhost/applewood/mycommunity/index.cfm;
ADDTOKEN=No




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183560
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Session giving me headaches.

[Phillip Perry]

OK I found a section on StructDelete. All I had to do is delete Auth in
session.auth and everything seems to work ok.

Phil

-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 06, 2004 3:04 PM
To: CF-Talk
Subject: Session giving me headaches.


Hi,

I've done all I can think of to get rid of the session. I've done
structclear(session) I've done cfapplication timeouts and
loginstorage=storage. but no matter what I'm doing the session is staying
on. I cfdumped it and the cookie info. The cookie is gone (which is right)
but the session remains. I would appreciate any help that can be given. I'll
provide my code again.

Phil


cflogout
cfif IsDefined(cookie.ISTHISPERSONLOGGEDINORWHAT) EQ Yes OR
IsDefined(Session.Auth)
cfcookie NAME=ISTHISPERSONLOGGEDINORWHAT VALUE=Yes EXPIRES=NOW
cfapplication name=applewoodcommunity sessionmanagement=yes
sessiontimeout=#createTimeSpan(0,0,0,0)# LOGINSTORAGE=Session
#StructClear(Auth)# !--- I've tried different variations ---
/cfif
cflocation url=http://localhost/applewood/mycommunity/index.cfm;
ADDTOKEN=No






~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183561
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

CFLOGOUT

[Phillip Perry]

Hi,

I'm using the cflogout tag but I don't think the session was logged out. I
managed to delete the cookie but the user can still get into the protected
area after logout. This is the code for logout i'm using...


cflogout
cfif IsDefined(cookie.ISTHISPERSONLOGGEDINORWHAT) EQ Yes
cfcookie NAME=ISTHISPERSONLOGGEDINORWHAT VALUE=Yes EXPIRES=NOW
/cfif
cflocation url=http://localhost/applewood/mycommunity/index2.cfm;


I thought that the cflogout was supposed to get rid of the session. Can
someone shed some light on this please?

Thanks

Phil




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183437
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFLOGOUT

[Phillip Perry]

I dont know if they fixed anything but the cookie does get deleted

{Phil

-Original Message-
From: Jeff Congdon [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 04, 2004 7:41 PM
To: CF-Talk
Subject: Re: CFLOGOUT


have they fixed the problem where if you write a cookie, and then
cflocate, the cookie never gets written?  If not, that's probably your
problem.  Try using a meta-refresh instead of a cflocation.

-jc

Phillip Perry wrote:

Hi,

I'm using the cflogout tag but I don't think the session was logged out. I
managed to delete the cookie but the user can still get into the protected
area after logout. This is the code for logout i'm using...


cflogout
cfif IsDefined(cookie.ISTHISPERSONLOGGEDINORWHAT) EQ Yes
cfcookie NAME=ISTHISPERSONLOGGEDINORWHAT VALUE=Yes EXPIRES=NOW
/cfif
cflocation url=http://localhost/applewood/mycommunity/index2.cfm;


I thought that the cflogout was supposed to get rid of the session. Can
someone shed some light on this please?

Thanks

Phil








~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183441
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFLOGOUT

[Phillip Perry]

I think that worked. I got sent back to the login form.

Thanks

Phil

-Original Message-
From: Figy, Kam [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 04, 2004 7:46 PM
To: CF-Talk
Subject: RE: CFLOGOUT


To make sure the session is cleared, you could always call StructClear(
session )

Kam

-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 04, 2004 4:34 PM
To: CF-Talk
Subject: CFLOGOUT

Hi,

I'm using the cflogout tag but I don't think the session was logged out.
I managed to delete the cookie but the user can still get into the
protected area after logout. This is the code for logout i'm using...


cflogout
cfif IsDefined(cookie.ISTHISPERSONLOGGEDINORWHAT) EQ Yes cfcookie
NAME=ISTHISPERSONLOGGEDINORWHAT VALUE=Yes EXPIRES=NOW /cfif
cflocation url=http://localhost/applewood/mycommunity/index2.cfm;


I thought that the cflogout was supposed to get rid of the session. Can
someone shed some light on this please?

Thanks

Phil








~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183442
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

OT: Need Javascript Help

[Phillip Perry]

Hi,

I need some advice about javascript. Could someone contact me offline to
discuss it?

Thanks.
PHil




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183131
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Cfhttp and displaying links

[Phillip Perry]

Hi,

I've parsed some links from a website but the links are bad. The links are
being parsed as a href=../folder/file.htmlblah/a but that poses a
problem. I need it to show the whole proper url. I know where ../ leads so I
can replace it but how do I display the right path? What I need to do is get
rid of the ../ and replace it with http://www.thesite.com/


I'm inlcuding the code so you can see what i'm doing.

Thanks

Phil

cfhttp URL=http://www.someurl.com/subfolder/file.html
method=get/cfhttp
cfset start=find(content to start on,CFHTTP.FileContent,1)
cfset EndOfFile=find(end of content,CFHTTP.FileContent,1)
cfloop from=1 to=5 index=whatever
cfif FindNoCase(a,CFHTTP.FileContent,start) GT 0
cfif FindNoCase(a,CFHTTP.FileContent,start) GTE EndOfFile

cfbreak
/cfif
cfset start=FindNoCase(a,CFHTTP.FileContent,start)
cfset end=FindNoCase(/a,CFHTTP.FileContent,start)+4
cfset length=end-start
cfoutput
#Mid(CFHTTP.FileContent,start,length)#br
/cfoutput
cfset start=end
/cfif
/cfloop




~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183023
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

another cfhttp issue

[Phillip Perry]

Along with the links i'm also parsing some inline css. Is there a way I can
get rid of those css lines?

Phil

-Original Message-
From: Cold Fusion User Group CNY [mailto:[EMAIL PROTECTED]
Behalf Of Gregory Lewis
Sent: Sunday, October 31, 2004 4:02 PM
To: [EMAIL PROTECTED]
Subject: Re: [CFUGCNY] Cfhttp and displaying links


Hi Phillip,

You need to use the RESOLVEURL=YES attribute in your CFHTTP tag, like so:

CFHTTP URL=http://www.someurl.com/subfolder/file.html; METHOD=GET
RESOLVEURL=YES/CFHTTP

Then, all your worldly problems will melt away like butter.

-Gregory


Phillip Perry wrote:

Hi,

I've parsed some links from a website but the links are bad. The links are
being parsed as a href=../folder/file.htmlblah/a but that poses a
problem. I need it to show the whole proper url. I know where ../ leads so
I
can replace it but how do I display the right path? What I need to do is
get
rid of the ../ and replace it with http://www.thesite.com/


I'm inlcuding the code so you can see what i'm doing.

Thanks

Phil

cfhttp URL=http://www.someurl.com/subfolder/file.html
method=get/cfhttp
cfset start=find(content to start on,CFHTTP.FileContent,1)
cfset EndOfFile=find(end of content,CFHTTP.FileContent,1)
cfloop from=1 to=5 index=whatever
cfif FindNoCase(a,CFHTTP.FileContent,start) GT 0
cfif FindNoCase(a,CFHTTP.FileContent,start) GTE EndOfFile

cfbreak
/cfif
cfset start=FindNoCase(a,CFHTTP.FileContent,start)
cfset end=FindNoCase(/a,CFHTTP.FileContent,start)+4
cfset length=end-start
cfoutput
#Mid(CFHTTP.FileContent,start,length)#br
/cfoutput
cfset start=end
/cfif
/cfloop


To unsubscribe: send a message to [EMAIL PROTECTED] with
'Unsubscribe CFUGCNY' in the body.
To send a message to the list: [EMAIL PROTECTED]

List archives:
http://www.mail-archive.com/[EMAIL PROTECTED]/index.html
Visit our website: http://www.cfugcny.org






--
#include Inter_Galactic_Library
invokeHuman('Gregory','Lewis');
doDomain('www.earthboar.com');


To unsubscribe: send a message to [EMAIL PROTECTED] with
'Unsubscribe CFUGCNY' in the body.
To send a message to the list: [EMAIL PROTECTED]

List archives:
http://www.mail-archive.com/[EMAIL PROTECTED]/index.html
Visit our website: http://www.cfugcny.org


To unsubscribe: send a message to [EMAIL PROTECTED] with
'Unsubscribe CFUGCNY' in the body.
To send a message to the list: [EMAIL PROTECTED]

List archives:
http://www.mail-archive.com/[EMAIL PROTECTED]/index.html
Visit our website: http://www.cfugcny.org





~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183025
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Cfhttp and displaying links

[Phillip Perry]

Thanks Michael that works

-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 31, 2004 4:30 PM
To: CF-Talk
Subject: RE: Cfhttp and displaying links




 From: Phillip Perry [mailto:[EMAIL PROTECTED]
 I've parsed some links from a website but the links are bad. The links are
 being parsed as a href=../folder/file.htmlblah/a but that poses a
 problem. I need it to show the whole proper url. I know where ../ leads so
I
 can replace it but how do I display the right path? What I need to do is
get
 rid of the ../ and replace it with http://www.thesite.com/

Try adding the resolveURL attribute and setting it to yes

cfhttp
URL=http://www.someurl.com/subfolder/file.html
method=get
resolveURL=yes
/cfhttp

HTH.


Mike




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183026
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: another cfhttp issue

[Phillip Perry]

I've got it. I just did a replacenocase() on it and it worked fine.

Phil

-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 31, 2004 4:34 PM
To: CF-Talk
Subject: another cfhttp issue


Along with the links i'm also parsing some inline css. Is there a way I can
get rid of those css lines?

Phil

-Original Message-
From: Cold Fusion User Group CNY [mailto:[EMAIL PROTECTED]
Behalf Of Gregory Lewis
Sent: Sunday, October 31, 2004 4:02 PM
To: [EMAIL PROTECTED]
Subject: Re: [CFUGCNY] Cfhttp and displaying links


Hi Phillip,

You need to use the RESOLVEURL=YES attribute in your CFHTTP tag, like so:

CFHTTP URL=http://www.someurl.com/subfolder/file.html; METHOD=GET
RESOLVEURL=YES/CFHTTP

Then, all your worldly problems will melt away like butter.

-Gregory


Phillip Perry wrote:

Hi,

I've parsed some links from a website but the links are bad. The links are
being parsed as a href=../folder/file.htmlblah/a but that poses a
problem. I need it to show the whole proper url. I know where ../ leads so
I
can replace it but how do I display the right path? What I need to do is
get
rid of the ../ and replace it with http://www.thesite.com/


I'm inlcuding the code so you can see what i'm doing.

Thanks

Phil

cfhttp URL=http://www.someurl.com/subfolder/file.html
method=get/cfhttp
cfset start=find(content to start on,CFHTTP.FileContent,1)
cfset EndOfFile=find(end of content,CFHTTP.FileContent,1)
cfloop from=1 to=5 index=whatever
cfif FindNoCase(a,CFHTTP.FileContent,start) GT 0
cfif FindNoCase(a,CFHTTP.FileContent,start) GTE EndOfFile

cfbreak
/cfif
cfset start=FindNoCase(a,CFHTTP.FileContent,start)
cfset end=FindNoCase(/a,CFHTTP.FileContent,start)+4
cfset length=end-start
cfoutput
#Mid(CFHTTP.FileContent,start,length)#br
/cfoutput
cfset start=end
/cfif
/cfloop


To unsubscribe: send a message to [EMAIL PROTECTED] with
'Unsubscribe CFUGCNY' in the body.
To send a message to the list: [EMAIL PROTECTED]

List archives:
http://www.mail-archive.com/[EMAIL PROTECTED]/index.html
Visit our website: http://www.cfugcny.org






--
#include Inter_Galactic_Library
invokeHuman('Gregory','Lewis');
doDomain('www.earthboar.com');


To unsubscribe: send a message to [EMAIL PROTECTED] with
'Unsubscribe CFUGCNY' in the body.
To send a message to the list: [EMAIL PROTECTED]

List archives:
http://www.mail-archive.com/[EMAIL PROTECTED]/index.html
Visit our website: http://www.cfugcny.org


To unsubscribe: send a message to [EMAIL PROTECTED] with
'Unsubscribe CFUGCNY' in the body.
To send a message to the list: [EMAIL PROTECTED]

List archives:
http://www.mail-archive.com/[EMAIL PROTECTED]/index.html
Visit our website: http://www.cfugcny.org







~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183027
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

target for cflocation?

[Phillip Perry]

Hi,

I'm using a link that opens a pop up with a fill in form (1 text field). The
info is passed through a processing page with 1 line of code...

cflocation url=www.url.com/variable=fieldname

But I want the new page to load up in the parent page not the popup. Can
this be accomplished with cf or do I have to do it in javascript?

Thanks

Phil




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183004
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

using cfabort in an include....

[Phillip Perry]

I'm using cfinclude. inside the included file that has some code that I want
to stop being processed if there is an error. Like this,

cfif records IS 0
some code...
/cfabort
/cfif
more code

But the problem is that the cfabort not only stops that code in the include
file its stopping the code in the calling template. Is there a way to
confine the abort to the included file only and leave the template thats
calling it alone?




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182506
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Getting 4 results where there should be only 2

[Phillip Perry]

When I do something like this...

cfquery datasource=#mydbname# name=getinfo
SELECT *
FROM Table1,Table2
/cfquery

and there are only 2 records to show, the output shows those 2 records
twice. I'm assuming that its becuase there are 2 tables so it shows it
twice. How do I get around this? This page is independant and has no
variables passed to it from urls or forms.




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182518
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: using cfabort in an include....

[Phillip Perry]

thanks I went with cfexit. I'm using the code as a custom tag so this works
great. I just didnt know there were other types of abort type tags.

Phil

-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 2:59 PM
To: CF-Talk
Subject: RE: using cfabort in an include


 From: Bert Dawson [mailto:[EMAIL PROTECTED]
 In a custom tag you could use cfexit, but since you're in a
 cfinclude you'll need to put everything in a cfelse:
 cfif records IS 0
 some code...
 cfelse
 more code
 /cfif


Read here:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p26.htm#wp10
98252

In particular, this note If this tag is encountered outside the
context of a custom tag, for example in the base page or an included
page, it executes in the same way as cfabort. The cfexit tag can help
simplify error checking and validation logic in custom tags. 


Michael T. Tangorre



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182523
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Getting 4 results where there should be only 2

[Phillip Perry]

I tried this and I'm getting an error saying too few parameters expecting 2.
Dont know what that means though.

-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 2:59 PM
To: CF-Talk
Subject: Re: Getting 4 results where there should be only 2


You need to join the two tables on whatever value they share:

SELECTt1.* from
FROM table1 t1, table2 t2
WHEREt1.primarykey = t2.foreignkey

- Original Message -
From: Phillip Perry [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, October 25, 2004 1:45 PM
Subject: Getting 4 results where there should be only 2


 When I do something like this...

 cfquery datasource=#mydbname# name=getinfo
 SELECT *
 FROM Table1,Table2
 /cfquery

 and there are only 2 records to show, the output shows those 2 records
 twice. I'm assuming that its becuase there are 2 tables so it shows it
 twice. How do I get around this? This page is independant and has no
 variables passed to it from urls or forms.








~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182529
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Getting 4 results where there should be only 2

[Phillip Perry]

Yes I adjusted it for my purpose and I even spelled out every single
fieldname in the select clause, but doing that just gave me the same error
except now its missing 3 parameters instead of 2. Here is the code as it was
adjusted per your code example..

cfquery datasource=#mydbname# name=GetUsers
SELECT *
FROM contacts,ImageList
WHERE contacts.ContactID = ImageList.ContactID
/cfquery

Which gives the error

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Too few parameters. Expected 2.

There you have it. Nothing is misspelled. and ContactID is in both tables
spelled the same way.
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 3:33 PM
To: CF-Talk
Subject: Re: Getting 4 results where there should be only 2


Um, that was totally pseudocode. You did modify it for your table structure,
right? It might help to actually post the table structure.

- Original Message -
From: Phillip Perry
I tried this and I'm getting an error saying too few parameters expecting
2.
 Dont know what that means though.





~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182534
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SOLVED Getting 4 results where there should be only 2

[Phillip Perry]

Dont know if this is common but, using MS Access, the ContactID foreign key
is spelled differently when looked at in design view as opposed to its
regular display. When I switched the spelling it worked out.

Thanks for the help

Phil

-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 3:38 PM
To: CF-Talk
Subject: RE: Getting 4 results where there should be only 2


Yes I adjusted it for my purpose and I even spelled out every single
fieldname in the select clause, but doing that just gave me the same error
except now its missing 3 parameters instead of 2. Here is the code as it was
adjusted per your code example..

cfquery datasource=#mydbname# name=GetUsers
SELECT *
FROM contacts,ImageList
WHERE contacts.ContactID = ImageList.ContactID
/cfquery

Which gives the error

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Too few parameters. Expected 2.

There you have it. Nothing is misspelled. and ContactID is in both tables
spelled the same way.
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 3:33 PM
To: CF-Talk
Subject: Re: Getting 4 results where there should be only 2


Um, that was totally pseudocode. You did modify it for your table structure,
right? It might help to actually post the table structure.

- Original Message -
From: Phillip Perry
I tried this and I'm getting an error saying too few parameters expecting
2.
 Dont know what that means though.







~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182538
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

The final stretch...

[Phillip Perry]

OK so I thought I had this thing licked but now its messed up again. I took
out the date thing becuase its not that important anymore. I added 2 fields
to my imagelist table called count and clicks. Everything was working fine
when i had 4 records to look up. When I deleted the 4 test records from the
database and inserted 1 new record, the image doesnt show up at all. I put 2
records in the db and neither of them show up. Can anyone see whats wrong
with it?

cfquery datasource=#mydbname# NAME=GetInfo
SELECT *
FROM ImageList
/cfquery

cfset MyImageList = #ValueList(GetInfo.ImageID)#/
cfset MaxListLen = #ListLen(MyImageList)#
cfset ListRandImage = randRange(1, maxlistlen)/
cfquery datasource=#mydbname# NAME=GetInfo2
SELECT *
FROM ImageList
WHERE ImageID = #ListRandImage#
/cfquery
cfoutput query=GetInfo2
A HREF=process_path.cfm?LID=#LinkText#IID=#ListRandImage#
TARGET=_blankimg src=../#ImageSource# alt=#AltText#
WIDTH=#ImageWidth# HEIGHT=#ImageHeight# BORDER=0/A
/cfoutput
cfdump VAR=#Variables#
cfquery datasource=#mydbname# name=pageviews
UPDATE ImageList
SET ImageList.Count = (ImageList.Count + 1)
WHERE ImageID = #ListRandImage#
/cfquery

Thanks,

Phil




~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182438
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: The final stretch...ANSWERED

[Phillip Perry]

I figured it out. I used ListGetAt. For some reason my brain doesn't want to
give me the answer until I hit the send button. :)

Phil

-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 24, 2004 12:35 AM
To: CF-Talk
Subject: The final stretch...


OK so I thought I had this thing licked but now its messed up again. I took
out the date thing becuase its not that important anymore. I added 2 fields
to my imagelist table called count and clicks. Everything was working fine
when i had 4 records to look up. When I deleted the 4 test records from the
database and inserted 1 new record, the image doesnt show up at all. I put 2
records in the db and neither of them show up. Can anyone see whats wrong
with it?

cfquery datasource=#mydbname# NAME=GetInfo
SELECT *
FROM ImageList
/cfquery

cfset MyImageList = #ValueList(GetInfo.ImageID)#/
cfset MaxListLen = #ListLen(MyImageList)#
cfset ListRandImage = randRange(1, maxlistlen)/
cfquery datasource=#mydbname# NAME=GetInfo2
SELECT *
FROM ImageList
WHERE ImageID = #ListRandImage#
/cfquery
cfoutput query=GetInfo2
A HREF=process_path.cfm?LID=#LinkText#IID=#ListRandImage#
TARGET=_blankimg src=../#ImageSource# alt=#AltText#
WIDTH=#ImageWidth# HEIGHT=#ImageHeight# BORDER=0/A
/cfoutput
cfdump VAR=#Variables#
cfquery datasource=#mydbname# name=pageviews
UPDATE ImageList
SET ImageList.Count = (ImageList.Count + 1)
WHERE ImageID = #ListRandImage#
/cfquery

Thanks,

Phil






~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182441
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Problem With Insert

[Phillip Perry]

I'm trying to update the pageviews + 1 every time a banner is shown on the
browser. But for some reason my code stopped at 2. It wont go any higher.
The first and second times the code updated correctly. It went from 1
pageview to 2 pageviews..now everything is 2 pageviews even though there are
at least 3 in the db. Here is my code...The highlighted portion of the code
is my addition statement. I seem to think its about my calling pageviews
from getinfo3 but i cant wrap my noggin around it.

cfquery datasource=applewood name=Getinfo3
SELECT *
FROM ImageData
WHERE ImageID = #ListRandImage#
/cfquery
cfquery DATASOURCE=#mydbname# NAME=UpdateData
INSERT INTO ImageData
 (
  PageViews,
  ImageID,
  ImageShowDate
 )
VALUES
 (
  (#Getinfo3.PageViews# + 1),
   #ListRandImage#,
  #createodbcdate(DateFormat(now(), mm/dd/))#
 )
/cfquery

Any thoughts?

Phil




~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182407
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Can someone tell me why this doesn't work?

[Phillip Perry]

I have this query...

cfquery DATASOURCE=#mydbname# NAME=UpdateData
UPDATE ImageData
SET PageViews = (PageViews + 1),
ImageID = ListRandImage
WHERE ImageID = ListRandImage
/cfquery

With this error code...

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Too few parameters. Expected 1.

The error occurred in E:\_Applewood\admin\testbanner\showbanner.cfm: line 45

45 : cfquery DATASOURCE=applewood NAME=UpdateData
46 : UPDATE ImageData
47 :SET PageViews = (PageViews + 1),

Every variable in there is valid. Would it be because PageViews is empty at
the moment?

Thanks

Phil




~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182296
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Can someone tell me why this doesn't work?

[Phillip Perry]

I got it never mind :)

-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Friday, October 22, 2004 12:34 AM
To: CF-Talk
Subject: Can someone tell me why this doesn't work?


I have this query...

cfquery DATASOURCE=#mydbname# NAME=UpdateData
UPDATE ImageData
SET PageViews = (PageViews + 1),
ImageID = ListRandImage
WHERE ImageID = ListRandImage
/cfquery

With this error code...

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Too few parameters. Expected 1.

The error occurred in E:\_Applewood\admin\testbanner\showbanner.cfm: line 45

45 : cfquery DATASOURCE=applewood NAME=UpdateData
46 : UPDATE ImageData
47 :SET PageViews = (PageViews + 1),

Every variable in there is valid. Would it be because PageViews is empty at
the moment?

Thanks

Phil






~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182298
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

BannerMan custom tag from cfhub..

[Phillip Perry]

Has anyone used this custom tag and if so could I ask some questions about
it?

Thanks

Phil




~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182048
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Subtracting From a List

[Phillip Perry]

OK I wrote this email 10 times trying to word it right. All I want to know
is how to delete an ImageID from the list after it is displayed on the
browser using the following variables.

cfset ImageList = #ValueList(testSQL.contactID)#/
cfset MaxListLen = #ListLen(ImageList)#
cfset ListRandImage =
#RandRange(ListFirst(ImageList),ListLast(ImageList))#/
cfset FindImagePos = #ListFind(ImageList,ListRandImage)#
cfset NewImageList = #ListDeleteAt(ImageList , ListRandImage)#
cfset ImageList = NewImageList

I'm so close but I cant get the ListLen to get smaller.

Any help is much appreciated,

Phil




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182092
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: custom tag help

[Phillip Perry]

No i'm using cfmx. I just got on so I haven't tested anything yet.

Phil

-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 3:10 AM
To: CF-Talk
Subject: RE: custom tag help


Phillip,

If you are using CF5, this wont work because variables wasn't a
structure back then. I'm just telling you this, not to correct James,
but because you are using CT and not CFC (so I think you might be on pre
CFMX).

Before CFMX you would have to (reluctantly) use Evaluate():

#Evaluate(attributes.queryname  .  attributes.fieldname)#

Pascal

 -Original Message-
 From: James Holmes [mailto:[EMAIL PROTECTED]
 Sent: 19 October 2004 06:40
 To: CF-Talk
 Subject: RE: custom tag help

 The variables scope should work within the custom tag:

 cfoutput query=#ATTRIBUTES.QUERYNAME#
 #VARIABLES[ATTRIBUTES.QUERYNAME][attributes.fieldname][currentrow]#
 /cfoutput

 Note that I dropped the query name from currentrow as it's now a
dynamic
 name and you can rely on CF to figure out what currentrow means inside
a
 cfoutput tag.

 -Original Message-
 From: Phillip Perry [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, 19 October 2004 11:26
 To: CF-Talk
 Subject: RE: custom tag help

 Thanks James. That does work if you assume that display is the query
name,
 but what if the query name is stored in an attributes.queryname value?
 I've
 played around with what you gave me but I can't seem to get it to
work.
 any
 thoughts?



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181828
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

cflock

[Phillip Perry]

Hi,

First, thanks to James and everyone else for the solutions to the custom
tag. Now I'm into CFLOCK. I'm trying to make a custom tag for a banner
rotation and I am using cflock. But when I execute my code it gives this
error...

Cannot lock APPLICATION scope.
CFLock cannot be used to lock the application or session shared scopes
without these scopes being established through the use of the CFApplication
tag. If you want to use the session scope you need to enable session
management. Application and/or Session variables must also be enabled in the
ColdFusion Administrator.

I'm assuming I have to fiddle with the admin settings, but what exactly am I
looking for..or is it even an admin problem in the first place?

Thanks

Phil




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181877
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cflock

[Phillip Perry]

Great thanks. I made a new folder in the main directory so I hadn't thought
about making an app.cfm inside it. I guess that shows how important a
app.cfm file really is

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 12:52 PM
To: CF-Talk
Subject: Re: cflock


You just need to add a CFAPPLICATION tag to you app, and you'll be set.

cheers,
barneyb

On Tue, 19 Oct 2004 12:42:47 -0400, Phillip Perry
[EMAIL PROTECTED] wrote:
 Hi,

 First, thanks to James and everyone else for the solutions to the custom
 tag. Now I'm into CFLOCK. I'm trying to make a custom tag for a banner
 rotation and I am using cflock. But when I execute my code it gives this
 error...

 Cannot lock APPLICATION scope.
 CFLock cannot be used to lock the application or session shared scopes
 without these scopes being established through the use of the
CFApplication
 tag. If you want to use the session scope you need to enable session
 management. Application and/or Session variables must also be enabled in
the
 ColdFusion Administrator.

 I'm assuming I have to fiddle with the admin settings, but what exactly am
I
 looking for..or is it even an admin problem in the first place?

 Thanks

 Phil





~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181891
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Strange variable showing up...

[Phillip Perry]

In doing my banner rotation template I'm now getting an undefined error. The
error itself is not whats made me confused. Its the Application variables
list in the debugger thats got me confused. It refers to a variable called
movierotation which does not exist in my code anywhere. I did a find 3 times
on the file but its not there. Have any of you had similar problems with
variables you dont use showing up for no reason?

Phil




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181909
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

custom tag help

[Phillip Perry]

Hi,

I'm messing with custom tags and am doing pretty basic stuff (i think) to
get used to using them. the tag does the following query

cfquery datasource=dataname name=display
SELECT *
FROM table_name
/cfquery

I've determined this works, but obviously this isn't very useful as is. I
added an attribute that gets the field name and displays the info from the
field to the screen something like this...

cfoutput query=display#feildname#/cfoutput

but that doesnt work. I put the field name in a variable and instead of
displaying the value of the field its displaying the variable name. How can
I make this display the value of the field instead of the value of the
attribute?

THanks

Phil




~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181803
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: custom tag help

[Phillip Perry]

Thanks James. That does work if you assume that display is the query name,
but what if the query name is stored in an attributes.queryname value? I've
played around with what you gave me but I can't seem to get it to work. any
thoughts?

-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 10:30 PM
To: CF-Talk
Subject: RE: custom tag help


Assuming the attribute is ATTRIBUTES.FIELDNAME,

cfoutput
query=display#display[attributes.fieldname][display.currentrow]#/cfoutpu
t

will do the job.

-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 19 October 2004 10:12
To: CF-Talk
Subject: custom tag help

Hi,

I'm messing with custom tags and am doing pretty basic stuff (i think) to
get used to using them. the tag does the following query

cfquery datasource=dataname name=display SELECT * FROM table_name
/cfquery

I've determined this works, but obviously this isn't very useful as is. I
added an attribute that gets the field name and displays the info from the
field to the screen something like this...

cfoutput query=display#feildname#/cfoutput

but that doesnt work. I put the field name in a variable and instead of
displaying the value of the field its displaying the variable name. How can
I make this display the value of the field instead of the value of the
attribute?



~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181805
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

application.cfm and headers

[Phillip Perry]

I'm using application.cfm to put the header on all my pages via cfinclude so
i dont have to do a cfinclude on every page. But sometimes I dont want a
page in that same folder to show the headers. For example a pop up that
shows directions on how to use a form. There is no referrer to a pop up so I
cant use that variable. Is there anything else I can do?

Thanks

Phil
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: application.cfm and headers

[Phillip Perry]

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 17, 2004 4:56 PM
To: CF-Talk
Subject: Re: application.cfm and headers

or perhaps use something like Fusebox

I downloaded fusebox the other day to see what it was about and my head
almost exploded with confusion :)

Thanks though
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

HTTP_REFERER

[Phillip Perry]

Thanks for answering my last question. Too many issues kept coming up so I
abandoned using application.cfm for headers and went back to just including
templates into each page. Now I have another problem. When I have people log
in I want them to go to the page that they wanted to go to right after the
login info is confirmed. Doing this with the HTTP_REFERER variable gives me
an error stating that http://www.blah.com/blah/blah.cfm is syntactically
incorrect. I'm assuming its becuase of all the /'s and :'s and the like. How
do I go about doing this?

Thanks

Phil
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: I need a quick response please

[Phillip Perry]

I fixed it. I had 2 different processing pages and one of them was an old
copy that was being used.
-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 16, 2004 1:49 AM
To: CF-Talk
Subject: I need a quick response please

Hi,

I was just checking my newsletter signup form before i went to bed and the
damn thing isnt working. It always says that the email address is already
in
the system...but the db is empty. It was fine when i first made it so I
dont
know what i did. Here is the code:

cfquery name=check_email datasource=#mydbname#
SELECT *
FROM newsletter
where lcase(email_address)=cfqueryparam cfsqltype=cf_sql_varchar
value=#lcase(form.email_address)#
/cfquery

cfif check_email.recordcount neq 0
Your email address is already in our system. If you feel this is in error
please contact a href="" PROTECTED]the support
team/a.

cfelse

cfquery datasource=#mydbname# name=newsletter
INSERT INTO newsletter (email_address)
VALUES('#form.email_address#')
/cfquery

You are now registered to The Applewood Community Newsletter. You should
recieve a confimation in an e-mail shortly. You will redirected to the
home
page shortly.

Whats wrong with it?

Thanks Phil
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]