date:20070311

RE: [ACFUG Discuss] CFQuery Basics: HELP!

2007-03-11 Thread Charlie Arehart

Ah, good point, Doug. I guess my sense was that Robert might be reluctant to
make the investment (in time and money), but you're certainly right that it
would be a good thing for him and indeed any new CF Developer. In fact, as
I've mentioned at the CFUG a couple times, I do teach that class (called
"FastTrack to ColdFusion"), right there in the facility where the UG meeting
is held (the classrooms are in the front of the building). This is, of
course, the official Adobe curriculum, and I'll point out that it's also
offered by others in Atlanta. But if Robert or anyone else is interested in
attending my class in particular, the class description is at:
 
http://www.echoeleven.com/go.cfm?path=/go/macromedia-authorized-training/cla
ss-descriptions/coldfusion-courses/fast-track-to-coldfusion-mx-7/index.cfm
 
And the details and registration form, for the April 3-5 class are at:
 
http://www.echoeleven.com/go.cfm?path=/go/macromedia-authorized-training/reg
istration/index-cfm

&&method=home.ShowRegistrationForm&CourseID=104D36E1-9990-7A20-5365AA6FC616F
D93
 
Thanks for mentioning it, Doug.
 
/Charlie
http://www.carehart.org/  

 


  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Douglas Knudsen
Sent: Sunday, March 11, 2007 10:25 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] CFQuery Basics: HELP!


Certainly check into the FastStart ColdFusion class too.  I know you,
Robert, are a one man army, but the course could really jump start that
motor bike.

DK



-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

<>

Re: [ACFUG Discuss] CFQuery Basics: HELP!

2007-03-11 Thread Douglas Knudsen


Certainly check into the FastStart ColdFusion class too.  I know you,
Robert, are a one man army, but the course could really jump start that
motor bike.

DK

On 3/11/07, Charlie Arehart <[EMAIL PROTECTED]> wrote:


 Again, I can't stress enough that the gentle teacher could be the
"Getting Started Guide". I even recommend it over the WACK as a true first
step. No, it's not a teacher, but it's really written in a very gentle
hand-holding approach.

/Charlie
http://www.carehart.org/



 --
*From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Robert
Reil
*Sent:* Sunday, March 11, 2007 7:04 AM
*To:* discussion@acfug.org
*Subject:* RE: [ACFUG Discuss] CFQuery Basics: HELP!

 You are correct Charlie! it worked!

query
1

DESCRIPTION1
Fits SUZUKI GS750 Carburetor Repair Kit.

DESCRIPTION2
Suzuki GS750ET, GS750EX, GS750EZ (80-82), GS750LT, GS750LX (80-81),
GS750TZ, GS750TD (82-83) Carburetor Repair kit

VEND_NAME
K&L

As to why 2 CFOUTPUT? I really dont know? I thought I used one of Forta's
files as a starting point but must have overlooked something. I see my error
and have fixed that. Thanks.

Im not needing a query loop because I only want to know the data of the
SKU which should only show once but now I realize that since it's not a
primary key I probably should use a query loop. Will have to put that in
there.

I was going to reply to why copying into variables after the query but
basically I am trying to get this thing to just work. The copying to
variables was a test. I realize this is an example of how not to write code
and appreciate and welcome further poor structure criticism. I want to write
good code, I hope to write good code, and in reality this is the first page
I have ever tried to write from scratch. Im using the WACK book for
guidance, and guess I overlooked some stuff...

To me this CF journey is like trying to learn Calculus with a text book
and no teacher. I have occassional tutors, but no real teacher. I just have
to get through using the fundamentals now that I am aware of the
fundamentals before the fundamentals become part of the way I do things. Be
patient with me guys, Ill get there.

GO FRIDAY!


Robert P. Reil

-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink 
-





--
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?



-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform


For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

<>

Re: [ACFUG Discuss] Form Logic

2007-03-11 Thread Douglas Knudsen


look at the cfparam tag

example:


This effectively says, if form.sku is undefined, define it and set it to
somesku.

DK

On 3/11/07, Robert Reil <[EMAIL PROTECTED]> wrote:


 Here is a quickie:

I have a form.cfm
It posts to a formaction.cfm.
it works.

I copy the content of form.cfm to the top of formaction.cfm.
Save it.
using form.cfm puts me to formaction.cfm.
Another query using the form at the top of formaction.cfm works.
but if I close the browser and open it to formaction.cfm it errors with
 Element SKU is undefined in FORM.
  The error occurred in 
*C:\Inetpub\wwwroot\intranet.motorcyclecarbs.com\sales\search.cfm:
line 5*

3 : FROM carbs.products
4 : WHERE sku = *
6 : 
7 :
I understand this as a variable needs to be given to #form.sku# as it is passed 
from form.cfm to formaction.cfm and a closing of the browser breaks this 
variable having a value
The question is how would I assign an empty value to this variable to keep it 
from crashing upon opening the file?

Code snippet:
--

SELECT Product_ID, Name, SKU, Description1, Description2, Vend_Name, Image1, 
Image1Params
FROM carbs.products
WHERE sku = 
---
I would think that I should use a 


I hope that makes sence and IM sure im on the right track but not clear. Some 
help would be awesome.

Guys... Im writing code! Im excited!! Yeah I know... Dumb NOOB!

 Robert P. Reil

Managing Director,

Motorcyclecarbs.com, Inc.

4292 Country Garden Walk NW

Kennesaw, Ga. 30152

Office 770-974-8851

Fax 770-974-8852

www.motorcyclecarbs.com





--
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?



-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform


For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

[ACFUG Discuss] Form Logic

2007-03-11 Thread Robert Reil

Here is a quickie:
 
I have a form.cfm
It posts to a formaction.cfm.
it works.
 
I copy the content of form.cfm to the top of formaction.cfm.
Save it.
using form.cfm puts me to formaction.cfm.
Another query using the form at the top of formaction.cfm works.
but if I close the browser and open it to formaction.cfm it errors with 


Element SKU is undefined in FORM. 


 
The error occurred in
C:\Inetpub\wwwroot\intranet.motorcyclecarbs.com\sales\search.cfm: line 5


3 : FROM carbs.products

4 : WHERE sku = 

6 : 

7 : 



 
I understand this as a variable needs to be given to #form.sku# as it is
passed from form.cfm to formaction.cfm and a closing of the browser breaks
this variable having a value
The question is how would I assign an empty value to this variable to keep
it from crashing upon opening the file?
 
Code snippet:
--
 
SELECT Product_ID, Name, SKU, Description1, Description2, Vend_Name, Image1,
Image1Params
FROM carbs.products
WHERE sku = 
---
I would think that I should use a 

 
I hope that makes sence and IM sure im on the right track but not clear.
Some help would be awesome.
 
Guys... Im writing code! Im excited!! Yeah I know... Dumb NOOB!

Robert P. Reil

Managing Director,

Motorcyclecarbs.com, Inc.

4292 Country Garden Walk NW

Kennesaw, Ga. 30152

Office 770-974-8851

Fax 770-974-8852

www.motorcyclecarbs.com

RE: [ACFUG Discuss] Variable Undefined.

2007-03-11 Thread Robert Reil

No worries Charlie: Ironically when I wrote #products.description1# the
products was the table name not the query name. If I had gotten it right it
would have been a coinsidence. Now I KNOW how it works. and makes total
sence.
 
Thanks for bearing with me.
 

Robert P. Reil

Managing Director,

Motorcyclecarbs.com, Inc.

4292 Country Garden Walk NW

Kennesaw, Ga. 30152

Office 770-974-8851

Fax 770-974-8852

www.motorcyclecarbs.com   

 

  _  

From: Charlie Arehart [mailto:[EMAIL PROTECTED] 
Sent: Sunday, March 11, 2007 9:14 PM
To: Carbs Sales&Service
Subject: RE: [ACFUG Discuss] Variable Undefined.


Robert, this was what I meant when I first wrote:
 
... if the query returns multiple records, why are you not making the
CFOUTPUT a query loop? And if it returns only one, then even if you don't
choose to use a loop, you will need to name prefix the columns when you
refer to them after the query.
 
So while you can indeed use a CFOUTPUT QUERY loop, as Ajas points out, you
had sais:
 
I have tried #products.description1# also but that does not work either.
 
You were close. That was just a typo.You should have used product rather
than products. Just clarifying for future reference.
 
/Charlie
http://www.carehart.org/    

 


  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil
Sent: Sunday, March 11, 2007 8:46 AM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] Variable Undefined.


THATS IT!
 
Thanks so much -->to infinity.!
 
Now I can move forward. Thank again to all on this list who have helped in
all my stumbles.

Robert P. Reil 


  _  

From: Ajas Mohammed [mailto:[EMAIL PROTECTED] 
Sent: Sunday, March 11, 2007 8:39 AM
To: Carbs Sales&Service
Subject: Re: [ACFUG Discuss] Variable Undefined.
 

 You got that error because when you write , you are not providing
the query name whose OUTPUT you want to display. The correct method is
. Replace your cfoutput with this and see what
happens. 

Ajas Mohammed.



- 
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform
  

For more info, see http://www.acfug.org/mailinglists
  
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
  
List hosted by FusionLink   
- 
<>

RE: [ACFUG Discuss] Variable Undefined.

2007-03-11 Thread Charlie Arehart

Robert, this was what I meant when I first wrote:
 
... if the query returns multiple records, why are you not making the
CFOUTPUT a query loop? And if it returns only one, then even if you don't
choose to use a loop, you will need to name prefix the columns when you
refer to them after the query.
 
So while you can indeed use a CFOUTPUT QUERY loop, as Ajas points out, you
had sais:
 
I have tried #products.description1# also but that does not work either.
 
You were close. That was just a typo.You should have used product rather
than products. Just clarifying for future reference.
 
/Charlie
http://www.carehart.org/  

 


  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil
Sent: Sunday, March 11, 2007 8:46 AM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] Variable Undefined.


THATS IT!
 
Thanks so much -->to infinity.!
 
Now I can move forward. Thank again to all on this list who have helped in
all my stumbles.

Robert P. Reil 


  _  

From: Ajas Mohammed [mailto:[EMAIL PROTECTED] 
Sent: Sunday, March 11, 2007 8:39 AM
To: Carbs Sales&Service
Subject: Re: [ACFUG Discuss] Variable Undefined.
 

 You got that error because when you write , you are not providing
the query name whose OUTPUT you want to display. The correct method is
. Replace your cfoutput with this and see what
happens. 

Ajas Mohammed.





-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

<>

RE: [ACFUG Discuss] CFQuery Basics: HELP!

2007-03-11 Thread Charlie Arehart

Again, I can't stress enough that the gentle teacher could be the "Getting
Started Guide". I even recommend it over the WACK as a true first step. No,
it's not a teacher, but it's really written in a very gentle hand-holding
approach.
 
/Charlie
http://www.carehart.org/  

 


  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil
Sent: Sunday, March 11, 2007 7:04 AM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] CFQuery Basics: HELP!


You are correct Charlie! it worked! 

query
 
 

1

 
DESCRIPTION1
Fits SUZUKI GS750 Carburetor Repair Kit.
 
DESCRIPTION2Suzuki GS750ET, GS750EX, GS750EZ (80-82), GS750LT, GS750LX
(80-81), GS750TZ, GS750TD (82-83) Carburetor Repair kit
 
VEND_NAME
K&L
 
As to why 2 CFOUTPUT? I really dont know? I thought I used one of Forta's
files as a starting point but must have overlooked something. I see my error
and have fixed that. Thanks.
 
Im not needing a query loop because I only want to know the data of the SKU
which should only show once but now I realize that since it's not a primary
key I probably should use a query loop. Will have to put that in there.
 
I was going to reply to why copying into variables after the query but
basically I am trying to get this thing to just work. The copying to
variables was a test. I realize this is an example of how not to write code
and appreciate and welcome further poor structure criticism. I want to write
good code, I hope to write good code, and in reality this is the first page
I have ever tried to write from scratch. Im using the WACK book for
guidance, and guess I overlooked some stuff...
 
To me this CF journey is like trying to learn Calculus with a text book and
no teacher. I have occassional tutors, but no real teacher. I just have to
get through using the fundamentals now that I am aware of the fundamentals
before the fundamentals become part of the way I do things. Be patient with
me guys, Ill get there.
 
GO FRIDAY!
 

Robert P. Reil




-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

<>

RE: [ACFUG Discuss] Slides or notes from recent meeting ACFUG

2007-03-11 Thread Steve Drucker

www.gotswf.com   (for Flash/Flex)
 
www.gotadobe.com   (for CF)
 
The lecture is going to be given again on Tuesday, March 13th. The Google
part of the lecture will start around 10:00 AM EST and be broadcast at
 
http://figleaf.mmalliance.acrobat.com/useadobe/
 
 
Audio will be broadcast via VOIP.
 
Regards,
Steve Drucker
CEO
Fig Leaf Software
www.figleaf.com  
Adobe / Google / Paperthin Premier Consulting & Training Partners
 

  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Caillier
Sent: Sunday, March 11, 2007 10:43 AM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Slides or notes from recent meeting ACFUG


Did anyone write down the "got" site addresses that were presented during
the google sitemap and coop presentations?
-Scott C.


On 3/9/07, Charlie Arehart <[EMAIL PROTECTED]
 > wrote: 

I got word back from Steve. I just sent notice to the announcements list,
but since the question has come up here as well, I will answer both Ajas and
Teddy:
 
Sadly, Steve has told me that they will not be offering the slides.
 
And while he attempted a recording, he says it ended up not being usable. 
 
Instead, he says that they will be presenting it again next week and will
share the URL for that recording then. When he does, I'll announce and post
it.

 
 /Charlie
http://www.carehart.org/    



 


  _  

From: [EMAIL PROTECTED]   [mailto: [EMAIL PROTECTED]
 ] On Behalf Of Teddy Payne
Sent: Friday, March 09, 2007 9:41 AM
To: discussion@acfug.org  
Subject: Re: [ACFUG Discuss] Slides or notes from recent meeting ACFUG



I also noticed that Steve was recording on his own Adobe Connect.  Is his
audio/video going to be available on UGTV?

Teddy

- 
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform
  

For more info, see http://www.acfug.org/mailinglists
  
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
  
List hosted by FusionLink   
- 



- 
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform
  

For more info, see http://www.acfug.org/mailinglists
  
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
  
List hosted by FusionLink   
- 


This email has been processed by SmoothZap - www.smoothwall.net
<>

RE: [ACFUG Discuss] Slides or notes from recent meeting ACFUG

2007-03-11 Thread Robert Reil

gotadobe.com
gotswf.com
 

Robert P. Reil

Managing Director,

Motorcyclecarbs.com, Inc.

4292 Country Garden Walk NW

Kennesaw, Ga. 30152

Office 770-974-8851

Fax 770-974-8852

www.motorcyclecarbs.com   

 

  _  

From: Scott Caillier [mailto:[EMAIL PROTECTED] 
Sent: Sunday, March 11, 2007 11:44 AM
To: Carbs Sales&Service
Subject: Re: [ACFUG Discuss] Slides or notes from recent meeting ACFUG


Did anyone write down the "got" site addresses that were presented during
the google sitemap and coop presentations?
-Scott C.


On 3/9/07, Charlie Arehart <[EMAIL PROTECTED]
 > wrote: 

I got word back from Steve. I just sent notice to the announcements list,
but since the question has come up here as well, I will answer both Ajas and
Teddy:
 
Sadly, Steve has told me that they will not be offering the slides.
 
And while he attempted a recording, he says it ended up not being usable. 
 
Instead, he says that they will be presenting it again next week and will
share the URL for that recording then. When he does, I'll announce and post
it.

 
 /Charlie
http://www.carehart.org/    



 


  _  

From: [EMAIL PROTECTED]   [mailto: [EMAIL PROTECTED]
 ] On Behalf Of Teddy Payne
Sent: Friday, March 09, 2007 9:41 AM
To: discussion@acfug.org  
Subject: Re: [ACFUG Discuss] Slides or notes from recent meeting ACFUG



I also noticed that Steve was recording on his own Adobe Connect.  Is his
audio/video going to be available on UGTV?

Teddy

- 
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform
  

For more info, see http://www.acfug.org/mailinglists
  
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
  
List hosted by FusionLink   
- 



- 
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform
  

For more info, see http://www.acfug.org/mailinglists
  
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
  
List hosted by FusionLink   
- 
<>

Re: [ACFUG Discuss] Slides or notes from recent meeting ACFUG

2007-03-11 Thread Scott Caillier


Did anyone write down the "got" site addresses that were presented during
the google sitemap and coop presentations?
-Scott C.

On 3/9/07, Charlie Arehart <[EMAIL PROTECTED]> wrote:


 I got word back from Steve. I just sent notice to the announcements list,
but since the question has come up here as well, I will answer both Ajas and
Teddy:

Sadly, Steve has told me that they will not be offering the slides.

And while he attempted a recording, he says it ended up not being usable.

Instead, he says that they will be presenting it again next week and will
share the URL for that recording then. When he does, I'll announce and post
it.

/Charlie
http://www.carehart.org/



 --
*From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Teddy
Payne
*Sent:* Friday, March 09, 2007 9:41 AM
*To:* discussion@acfug.org
*Subject:* Re: [ACFUG Discuss] Slides or notes from recent meeting ACFUG

I also noticed that Steve was recording on his own Adobe Connect.  Is his
audio/video going to be available on UGTV?

Teddy

-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink 
-





-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform


For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

<>

RE: [ACFUG Discuss] Variable Undefined.

2007-03-11 Thread Robert Reil

THATS IT!
 
Thanks so much -->to infinity.!
 
Now I can move forward. Thank again to all on this list who have helped in
all my stumbles.
 

Robert P. Reil

Managing Director,

Motorcyclecarbs.com, Inc.

4292 Country Garden Walk NW

Kennesaw, Ga. 30152

Office 770-974-8851

Fax 770-974-8852

www.motorcyclecarbs.com   

 

  _  

From: Ajas Mohammed [mailto:[EMAIL PROTECTED] 
Sent: Sunday, March 11, 2007 8:39 AM
To: Carbs Sales&Service
Subject: Re: [ACFUG Discuss] Variable Undefined.


You got that error because when you write , you are not providing
the query name whose OUTPUT you want to display. The correct method is
. Replace your cfoutput with this and see what
happens. 

Ajas Mohammed.


On 3/11/07, Robert Reil <[EMAIL PROTECTED]
 > wrote: 

After all of you guys tutulage I have revised and am having still one
problem.
 
Doing a 
 


the data shows. under the following columns:

DESCRIPTION1 DESCRIPTION2   VEND_NAME   
 
With this code though:
***
 
SELECT Description1, Description2, Vend_Name 
FROM carbs.products
WHERE sku = 

 


Product Search Results
 



SKU: 


   
   
   Products
   
  

   
   
:
#sku#


#Description1#
   
   
#Vend_Name#
   
  
  

 #Description2# 
  
  





I get:

SKU: 
Products
: 1234 





Error Occurred While Processing Request 



Variable DESCRIPTION1 is undefined. 




The error occurred in
C:\Inetpub\wwwroot\intranet.motorcyclecarbs.com\sales\form1_action.cfm: line
30


28 : 
29 : 
30 : #Description1#

31 :

32 :

  _  

Please try the following: 



*   Check the ColdFusion documentation
  to verify that you are using
the correct syntax. 

*   Search the Knowledge Base
  to find a solution to your
problem.


Browser  Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.10
 ) Gecko/20070216 Firefox/1.5.0.10 
Remote Address   10.34.129.103    
Referrer http://intranet.motorcyclecarbs.com/sales/form1.cfm
   
Date/Time11-Mar-07 06:58 AM 
Stack Trace 
at
cfform1_action2ecfm1129753331.runPage(C:\Inetpub\wwwroot\intranet.motorcycle
carbs.com\sales\form1_action.cfm:30) 



coldfusion.runtime.UndefinedVariableException: Variable DESCRIPTION1 is
undefined.
**
I have looked at plenty of examples and I can not figure out why
#Description1# is not pulling the data.
The cfdump shows the data What gives?
 
I have tried #products.description1# also but that does not work either.
 
Any ideas?
 

Robert P. Reil

Managing Director,

Motorcyclecarbs.com  , Inc.

4292 Country Garden Walk NW

Kennesaw, Ga. 30152

Office 770-974-8851

Fax 770-974-8852

www.motorcyclecarbs.com    

 




-- 

http://ajashadi.blogspot.com   
- 
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform
  

For more info, see http://www.acfug.org/mailinglists
  
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
  
List hosted by FusionLink   
-

Re: [ACFUG Discuss] Variable Undefined.

2007-03-11 Thread Ajas Mohammed

You got that error because when you write , you are not providing
the query name whose OUTPUT you want to display. The correct method is
. Replace your cfoutput with this and see what
happens.

Ajas Mohammed.

On 3/11/07, Robert Reil <[EMAIL PROTECTED]> wrote:

After all of you guys tutulage I have revised and am having still one
problem.

Doing a

the data shows. under the following columns:
DESCRIPTION1DESCRIPTION2VEND_NAME

With this code though:
***

SELECT Description1, Description2, Vend_Name
FROM carbs.products
WHERE sku =

Product Search Results

SKU:

Products

:
#sku#

#Description1#

#Vend_Name#

#Description2#

I get:

*SKU:*
Products *: 1234 *

Error Occurred While Processing RequestVariable DESCRIPTION1 is
undefined.
The error occurred in
*C:\Inetpub\wwwroot\intranet.motorcyclecarbs.com\sales\form1_action.cfm:
line 30*

28 :
29 :
*30 : #Description1#*
31 :
32 :

--
Please try the following:

- Check the ColdFusion
documentationto verify that you
are using the correct syntax.
- Search the Knowledge Baseto
find a solution to your problem.

Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.10)
Gecko/20070216 Firefox/1.5.0.10 Remote Address 10.34.129.103 Referrer
http://intranet.motorcyclecarbs.com/sales/form1.cfm Date/Time 11-Mar-07
06:58 AM Stack Trace at
cfform1_action2ecfm1129753331.runPage(C:\Inetpub\wwwroot\intranet.motorcyclecarbs.com\sales\form1_action.cfm:30)

coldfusion.runtime.UndefinedVariableException: Variable DESCRIPTION1 is
undefined.

*I have looked at plenty of examples and I can not figure out why
#Description1# is not pulling the data.*
*The cfdump shows the data What gives?*

I have tried #products.description1# also but that does not work either.

Any ideas?

Robert P. Reil

Managing Director,

Motorcyclecarbs.com, Inc.

4292 Country Garden Walk NW

Kennesaw, Ga. 30152

Office 770-974-8851

Fax 770-974-8852

www.motorcyclecarbs.com

http://ajashadi.blogspot.com

-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

[ACFUG Discuss] Variable Undefined.

2007-03-11 Thread Robert Reil

After all of you guys tutulage I have revised and am having still one
problem.
 
Doing a 
 


the data shows. under the following columns:
DESCRIPTION1DESCRIPTION2VEND_NAME
 
With this code though:
***
 
SELECT Description1, Description2, Vend_Name 
FROM carbs.products
WHERE sku = 

 


Product Search Results
 



SKU: 


   
   
   Products
   
  

   
   
:
#sku#


#Description1#
   
   
#Vend_Name#
   
  
  

 #Description2# 
  
  





I get:

SKU: 
Products
: 1234 


Error Occurred While Processing Request 



Variable DESCRIPTION1 is undefined. 



The error occurred in
C:\Inetpub\wwwroot\intranet.motorcyclecarbs.com\sales\form1_action.cfm: line
30


28 : 

29 : 

30 : #Description1#

31 :

32 :

  _  

Please try the following: 



*   Check the ColdFusion documentation
  to verify that you are using
the correct syntax.
*   Search the Knowledge Base
  to find a solution to your
problem.


Browser  Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
rv:1.8.0.10) Gecko/20070216 Firefox/1.5.0.10
Remote Address   10.34.129.103  
Referrer http://intranet.motorcyclecarbs.com/sales/form1.cfm
Date/Time11-Mar-07 06:58 AM 
Stack Trace 
at
cfform1_action2ecfm1129753331.runPage(C:\Inetpub\wwwroot\intranet.motorcycle
carbs.com\sales\form1_action.cfm:30) 



coldfusion.runtime.UndefinedVariableException: Variable DESCRIPTION1 is
undefined.
**
I have looked at plenty of examples and I can not figure out why
#Description1# is not pulling the data.
The cfdump shows the data What gives?
 
I have tried #products.description1# also but that does not work either.
 
Any ideas?
 

Robert P. Reil

Managing Director,

Motorcyclecarbs.com, Inc.

4292 Country Garden Walk NW

Kennesaw, Ga. 30152

Office 770-974-8851

Fax 770-974-8852

www.motorcyclecarbs.com

[ACFUG Discuss] CF Coding NOOB. :(

2007-03-11 Thread Robert Reil

Charlie:
 
This whole time I have been an observer. I and Daniel have gone along for
the WACK ride weekly for a few hours to get a grasp on the big picture. Now
we know what CF is, have an idea of how it works, have tweaked it a little
in WACK form and now we are actually doing our FIRST bit of code.
 
Honestly we were estatic when we took a chapter 10 piece of code and just
changed some of the cfquery data and got it to hook to my DB. (Gosh what a
NOOB!)
 
I know I sound like an idiot on here with these stupid rudimentary
questions. Its just after all these months the data in my/our mind is not
fresh. I will scan your suggested document and I hope that will be a
condensed version of the 15 chapters I have read in the past what must be 6
months.
 
Bottom line: I have to build a sales and purchasing intranet for my company.
The funds at this time are not there till we get more efficient. More
efficiency will come with this intranet which forces me to do this myself.
 
Thanks for your harshness, and advise.
 

Robert P. Reil

Managing Director,

Motorcyclecarbs.com, Inc.

4292 Country Garden Walk NW

Kennesaw, Ga. 30152

Office 770-974-8851

Fax 770-974-8852

www.motorcyclecarbs.com   

 

  _  

From: Charlie Arehart [mailto:[EMAIL PROTECTED] 
Sent: Sunday, March 11, 2007 12:35 AM
To: Carbs Sales&Service
Subject: RE: [ACFUG Discuss] CFQuery Basics: HELP!


Robert, the problem is as that you don't want to be doing that dump and
abort inside the cfquery.
 
And as long as you're showing the code, it seems worth asking why you have
two cfoutputs (one nested inside the other), and if the query returns
multiple records, why are you not making the CFOUTPUT a query loop? And if
it returns only one, then even if you don't choose to use a loop, you will
need to name prefix the columns when you refer to them after the query. And
why are you bothering to copy them into variables after the query?
 
To be honest, I'm quite surprised to see you struggling with these sort of
issues, after all these months you've been using CF. Have you been writing
code all this time? Or just managing those who do? I think you may have said
that you had someone doing work and now you have to do it.  
 
If that's the case, it may really pay to revisit something fundamental like
the "Getting Started Guide" for CF. It would be great for you both in
covering the fundamentals of CFML as well as showing all the great
code-generating and time-saving features of Dreamweaver for working with CF.
Check it out at:
 
http://download.macromedia.com/pub/documentation/en/coldfusion/mx7/cfmx7_get
_started.pdf
 
 
I'm sorry if that sounds a bit harsh. I don't mean it to be. Just being
frank. Really, it's in your interest, if you're going to be coding, to get
firmer fundamentals before trying to edit your code for business use. You'll
just be chasing your tail. Even one day (or just a few hours) spent with
that book will pay enormous dividends for you.
 
/Charlie
http://www.carehart.org/    

 


  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil
Sent: Saturday, March 10, 2007 10:37 PM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] CFQuery Basics: HELP!



Boy now I am REALLY CONFUSED!

Based on Doug and Teddy's email replies I modied as suggested, 

 

I don't understand what I am looking for. Or really what you are doing with
the cfdump/cfabort.

I know you are trying to see the status of things but the error makes not a
bit of sence to me.

 

 



- 
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform
  

For more info, see http://www.acfug.org/mailinglists
  
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
  
List hosted by FusionLink   
- 
<>

RE: [ACFUG Discuss] CFQuery Basics: HELP!

2007-03-11 Thread Robert Reil

You are correct Charlie! it worked! 

query
 
 

1

 
DESCRIPTION1
Fits SUZUKI GS750 Carburetor Repair Kit.
 
DESCRIPTION2Suzuki GS750ET, GS750EX, GS750EZ (80-82), GS750LT, GS750LX
(80-81), GS750TZ, GS750TD (82-83) Carburetor Repair kit
 
VEND_NAME
K&L
 
As to why 2 CFOUTPUT? I really dont know? I thought I used one of Forta's
files as a starting point but must have overlooked something. I see my error
and have fixed that. Thanks.
 
Im not needing a query loop because I only want to know the data of the SKU
which should only show once but now I realize that since it's not a primary
key I probably should use a query loop. Will have to put that in there.
 
I was going to reply to why copying into variables after the query but
basically I am trying to get this thing to just work. The copying to
variables was a test. I realize this is an example of how not to write code
and appreciate and welcome further poor structure criticism. I want to write
good code, I hope to write good code, and in reality this is the first page
I have ever tried to write from scratch. Im using the WACK book for
guidance, and guess I overlooked some stuff...
 
To me this CF journey is like trying to learn Calculus with a text book and
no teacher. I have occassional tutors, but no real teacher. I just have to
get through using the fundamentals now that I am aware of the fundamentals
before the fundamentals become part of the way I do things. Be patient with
me guys, Ill get there.
 
GO FRIDAY!
 

Robert P. Reil

Managing Director,

Motorcyclecarbs.com, Inc.

4292 Country Garden Walk NW

Kennesaw, Ga. 30152

Office 770-974-8851

Fax 770-974-8852

www.motorcyclecarbs.com   

 


  _  

From: Charlie Arehart [mailto:[EMAIL PROTECTED] 
Sent: Sunday, March 11, 2007 12:35 AM
To: Carbs Sales&Service
Subject: RE: [ACFUG Discuss] CFQuery Basics: HELP!


Robert, the problem is as that you don't want to be doing that dump and
abort inside the cfquery.
 
And as long as you're showing the code, it seems worth asking why you have
two cfoutputs (one nested inside the other), and if the query returns
multiple records, why are you not making the CFOUTPUT a query loop? And if
it returns only one, then even if you don't choose to use a loop, you will
need to name prefix the columns when you refer to them after the query. And
why are you bothering to copy them into variables after the query?
 
To be honest, I'm quite surprised to see you struggling with these sort of
issues, after all these months you've been using CF. Have you been writing
code all this time? Or just managing those who do? I think you may have said
that you had someone doing work and now you have to do it.  
 
If that's the case, it may really pay to revisit something fundamental like
the "Getting Started Guide" for CF. It would be great for you both in
covering the fundamentals of CFML as well as showing all the great
code-generating and time-saving features of Dreamweaver for working with CF.
Check it out at:
 
http://download.macromedia.com/pub/documentation/en/coldfusion/mx7/cfmx7_get
_started.pdf
 
 
I'm sorry if that sounds a bit harsh. I don't mean it to be. Just being
frank. Really, it's in your interest, if you're going to be coding, to get
firmer fundamentals before trying to edit your code for business use. You'll
just be chasing your tail. Even one day (or just a few hours) spent with
that book will pay enormous dividends for you.
 
/Charlie
http://www.carehart.org/    

 


  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil
Sent: Saturday, March 10, 2007 10:37 PM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] CFQuery Basics: HELP!



Boy now I am REALLY CONFUSED!

Based on Doug and Teddy's email replies I modied as suggested, 

 

I don't understand what I am looking for. Or really what you are doing with
the cfdump/cfabort.

I know you are trying to see the status of things but the error makes not a
bit of sence to me.

<>

RE: [ACFUG Discuss] CFQuery Basics: HELP!

Re: [ACFUG Discuss] CFQuery Basics: HELP!

Re: [ACFUG Discuss] Form Logic

[ACFUG Discuss] Form Logic

RE: [ACFUG Discuss] Variable Undefined.

RE: [ACFUG Discuss] Variable Undefined.

RE: [ACFUG Discuss] CFQuery Basics: HELP!

RE: [ACFUG Discuss] Slides or notes from recent meeting ACFUG

RE: [ACFUG Discuss] Slides or notes from recent meeting ACFUG

Re: [ACFUG Discuss] Slides or notes from recent meeting ACFUG

RE: [ACFUG Discuss] Variable Undefined.

Re: [ACFUG Discuss] Variable Undefined.

[ACFUG Discuss] Variable Undefined.

[ACFUG Discuss] CF Coding NOOB. :(

RE: [ACFUG Discuss] CFQuery Basics: HELP!

15 matches

Site Navigation

Mail list logo

Footer information