RE: breaking a loop... need help

[Paul Ihrig]

still need help!
thx
-paul
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: What is the best variable scope?

[Andrew Scott]

Nice wording, but still what does that have to do with the original
thread?

-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] 
Sent: Sunday, 30 June 2002 12:52 AM
To: CF-Talk
Subject: RE: What is the best variable scope?

> Exactly my point, and as the user is not reading these
> emails then why make that a point when you and I both
> know otherwise :-)

Because it's important for us to think about the work that we do from
the
perspective of our users -- as entertaining as our tech-centric ways of
thinking may be, they don't help us communicate with our customers or
clients and if we don't make an active attempt to think about our work
the
way that our users will, we can (and often do) detract from the user
experience and ultimately injure our fiscal bottom line as a result.

Isaac

www.turnkey.to
954-776-0046


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Firewall configuration for CF and SQL (sort of OT)

[Mark A. Kruger - CFG]

Dave,

Can you speak to the possible vulnerabilities involved with setting up a
separate "web resource" domain for the hosts in the DMZ and using trust
relationships to specify access to internal resources?  I have a client set
up this way.  I thought the arrangement was fairly elegant with good ease of
management and an appropriate level of security (for what they were doing).
What do you think?

-mk

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 29, 2002 10:33 PM
To: CF-Talk
Subject: RE: Firewall configuration for CF and SQL (sort of OT)


> 1) Should the SQL Server be behind the firewall? The answer
> seems to me to be yes - if so, what port do I have to open
> to allow communication between the Web/CF Server and the
> SQL Server so that they can still talk to each other. Our
> intranet (LAN users) and website (WAN) users need to access
> the same database.

As several other people have already noted, your database should be behind
the firewall, and you'll need to open port 1433 to the database server from
the CF server. I'd like to add a couple of things to this, though. First, if
possible, you should limit your CF applications to using stored procedures,
if possible, and limit the rights of the accounts used by CF datasources as
much as you can. Second, you should prevent outbound traffic from your
database server through the firewall. That way, if you are vulnerable to SQL
injection attacks, the attacker won't be able to use the FTP client or
anything like that to put files onto, or push files from, your database
server.

> 2) For servers in the DMZ, is there any rational reason for
> them to be in the domain? Wouldn't it be more secure to keep
> those machines as standalone (non-domain) machines so that
> if they are compromised, all domain machines are still behind
> the firewall? The only benefit I can see to keeping them in
> the domain is group policy.

I think you'd be better off if the DMZ servers aren't part of your internal
domain. If you did make them part of the internal domain, you might as well
not put them in the DMZ, I think.

> 3)  For those running DNS servers in house, is it customary
> for you to actually have a dedicated DNS machine? Or do you,
> as we currently do, use a server for dual purpose (maybe it
> would be an FTP Server and a DNS Server). Also, are there
> any "plug and play" DNS "network appliances" available that
> wouldn't require a $1000+ license of Windows 2000 server?

DNS generally doesn't require a lot of resources or bandwidth; many
firewalls allow you to run DNS on the firewall itself. You should be able to
put a DNS service on an existing server. I don't know about DNS
"appliances", but I'd recommend that you look at putting together a Linux or
BSD server for DNS, if you do want a dedicated server.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Firewall configuration for CF and SQL (sort of OT)

[Dave Watts]

> 1) Should the SQL Server be behind the firewall? The answer 
> seems to me to be yes - if so, what port do I have to open 
> to allow communication between the Web/CF Server and the 
> SQL Server so that they can still talk to each other. Our 
> intranet (LAN users) and website (WAN) users need to access 
> the same database.

As several other people have already noted, your database should be behind
the firewall, and you'll need to open port 1433 to the database server from
the CF server. I'd like to add a couple of things to this, though. First, if
possible, you should limit your CF applications to using stored procedures,
if possible, and limit the rights of the accounts used by CF datasources as
much as you can. Second, you should prevent outbound traffic from your
database server through the firewall. That way, if you are vulnerable to SQL
injection attacks, the attacker won't be able to use the FTP client or
anything like that to put files onto, or push files from, your database
server.

> 2) For servers in the DMZ, is there any rational reason for 
> them to be in the domain? Wouldn't it be more secure to keep 
> those machines as standalone (non-domain) machines so that  
> if they are compromised, all domain machines are still behind 
> the firewall? The only benefit I can see to keeping them in 
> the domain is group policy.

I think you'd be better off if the DMZ servers aren't part of your internal
domain. If you did make them part of the internal domain, you might as well
not put them in the DMZ, I think.

> 3)  For those running DNS servers in house, is it customary 
> for you to actually have a dedicated DNS machine? Or do you, 
> as we currently do, use a server for dual purpose (maybe it 
> would be an FTP Server and a DNS Server). Also, are there 
> any "plug and play" DNS "network appliances" available that
> wouldn't require a $1000+ license of Windows 2000 server?

DNS generally doesn't require a lot of resources or bandwidth; many
firewalls allow you to run DNS on the firewall itself. You should be able to
put a DNS service on an existing server. I don't know about DNS
"appliances", but I'd recommend that you look at putting together a Linux or
BSD server for DNS, if you do want a dedicated server.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: trouble passing variables

[Sheila Handler]

Try scoping the variables in the cfparam tags to "attributes.x" since that's
what you use in your update statement.


Date: Sat, 29 Jun 2002 18:57:17 -0600
From: Kwang Suh <[EMAIL PROTECTED]>
Subject: RE: trouble passing variables
Message-ID: <[EMAIL PROTECTED]>

Well, you didn't scope the cfparam tags.  Try scoping them to form. and see
if that works.

> -Original Message-
> From: Douglas Brown [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, June 29, 2002 1:37 PM
> To: CF-Talk
> Subject: Re: trouble passing variables
>
>
> Kwang,
>
> Thanks for the reply, but the form post back to itself and the
> param tags are still there. It just is not seeing them or
> something. I am lost!!!
>
>
>
>
> Douglas Brown
> Email: [EMAIL PROTECTED]
> - Original Message -
> From: "Kwang Suh" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Saturday, June 29, 2002 10:42 AM
> Subject: RE: trouble passing variables
>
>
> > Checkbox fields only exist upon submission if they are
> checked.
> >
> > I always create cfparams for checkbox fields on the action
> page.
> >
> > > -Original Message-
> > > From: Douglas Brown [mailto:[EMAIL PROTECTED]]
> > > Sent: Friday, June 28, 2002 3:46 PM
> > > To: CF-Talk
> > > Subject: trouble passing variables
> > >
> > >
> > > I have a form that is populated from a query, that has
> several
> > > checkboxes. The form posts back to itslef for update, but
> when I make
> > > modifications to the checkboxes, I get a expression
> evaluation error
> > > that it cannot find the checkbox form fields. I have enabled
> debugging
> > > and in fact the variables are not getting passed. I have
> pasted the form
> > > below, for some insight.
> > >
> > >
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > >
> > >
> > > 
> > >
> > > 
> > >
> > >  name="update_inventory">
> > > update inventory
> > > set  mfg_date   = '#mfg_date#',
> > >   stock_number = '#attributes.stock_number#',
> > >   vin= '#attributes.vin#',
> > >   make   = '#attributes.make#',
> > >   model   = '#attributes.model#',
> > >   mileage   = '#attributes.mileage#',
> > >   color   = '#attributes.color#',
> > >   condition  = '#attributes.condition#',
> > >   sale_price  = #attributes.sale_price#,
> > >   show_price  = '#attributes.show_price#'
> > > where  id = #attributes.inventory_id#
> > > 
> > >
> > > 
> > >
> > >  name="update_options">
> > > update options
> > > set  ac = #attributes.ac#,
> > >   convertible   = #attributes.convertible#,
> > >   d_airbag   = #attributes.d_airbag#,
> > >   p_airbag   = #attributes.p_airbag#,
> > >   hatchback   = #attributes.hatchback#,
> > >   anti_lock   = #attributes.anti_lock#,
> > >   am_fm= #attributes.am_fm#,
> > >   cass= #attributes.cass#,
> > >   power_seats   = #attributes.power_seats#,
> > >   power_windows   = #attributes.power_windows#,
> > >   power_locks   = #attributes.power_locks#,
> > >   power_brakes  = #attributes.power_brakes#,
> > >   power_steering  = #attributes.power_steering#
> > >   tilt_wheel   = #attributes.tilt_wheel#,
> > >   cruise_control  = #attributes.cruise_control#,
> > >   cd = #attributes.cd#,
> > >   four_wheel_drive = #attributes.four_wheel_drive#,
> > >   sunroof= #attributes.sunroof#,
> > >   leather= #attributes.leather#,
> > >   tow_pkg= #attributes.tow_pkg#,
> > >   classic= #attributes.classic#
> > > where inventory_id   = #attributes.inventory_id#
> > > 
> > > 
> > >
> > > 
> > >
> > >  > > name="get_inventory_for_update">
> > > select   inventory.id,
> > >inventory.mfg_date,
> > >inventory.stock_number,
> > >inventory.vin,
> > >inventory.make,
> > >inventory.model,
> > >inventory.mileage,
> > >inventory.color,
> > >inventory.condition,
> > >inventory.sale_price,
> > >inventory.show_price,
> > >options.ac,
> > >options.convertible,
> > >options.d_airbag,
> > >options.p_airbag,
> > >options.hatchback,
> > >options.anti_lock,
> > >options.am_fm,
> > >options.cass,
> > >options.power_seats,
> > >options.power_windows,
> > >options.power_locks,
> > >options.power_brakes,
> > >options.power_steering,
> > >options.tilt_wheel,
> > >options.cruise_control,
> > >options.cd,
> > >options.four_wheel_drive,
> > >options.sunroof,
> > >options.leather,
> > >options.tow_pkg,
> > >options.classic,
> > >photos.photo,
> > >photos.thumbnail
> > > from   inventory
> > > inner join  options on inventory.id = options.inventory_id
> > > inner join  photos on inventory.id  = photos.inventory_id
> > > where   inventory.id= #attributes.inventory_id#
> > > 
> > >  
> > >
> > >  > >
> action="index.cfm?fuseaction=updateInventory&inventory_id= put>#att
> > > ributes.inventory_id#&p

RE: CFMX / CFC / FLASH Books.

[Dave Watts]

> Also is there a way to print or download the livedocs for 
> CFMX in PDF form so I can print it instead of going to 
> each individual link which is a real pain?

You can download the CF MX documentation in PDF format here:
http://www.macromedia.com/support/coldfusion/documentation.html

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL Server Indexes

[Douglas Brown]

Never mind...I was not thinking, just delete it.




Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: "Bud" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, June 29, 2002 4:54 PM
Subject: OT: SQL Server Indexes


> Hi all. I've noticed when upsizing an Access database, I'll get
> duplicate indexes on the primary keys. For instance, if I have a
> Category_ID field which is the primary key and indexed in Access,
> after upsizing, I'll get an index named aCategory_ID_PK and also
> one named Category_ID in the SQL DB. Should I delete the Category_ID
> index? It seems redundant.
>
> Thanks.
> --
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL Server Indexes

[Douglas Brown]

Bud,


It depends on if the category_id is a field that is searched alot. If that is
the case, you might as well leave that index as it will help performance. If
not, then deleting it will harm nothing...




Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: "Bud" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, June 29, 2002 4:54 PM
Subject: OT: SQL Server Indexes


> Hi all. I've noticed when upsizing an Access database, I'll get
> duplicate indexes on the primary keys. For instance, if I have a
> Category_ID field which is the primary key and indexed in Access,
> after upsizing, I'll get an index named aCategory_ID_PK and also
> one named Category_ID in the SQL DB. Should I delete the Category_ID
> index? It seems redundant.
>
> Thanks.
> --
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL Server Indexes

[Kwang Suh]

Yes.  Duplicate indexes are not needed.

> -Original Message-
> From: Bud [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, June 29, 2002 5:55 PM
> To: CF-Talk
> Subject: OT: SQL Server Indexes
> 
> 
> Hi all. I've noticed when upsizing an Access database, I'll get 
> duplicate indexes on the primary keys. For instance, if I have a 
> Category_ID field which is the primary key and indexed in Access, 
> after upsizing, I'll get an index named aCategory_ID_PK and also 
> one named Category_ID in the SQL DB. Should I delete the Category_ID 
> index? It seems redundant.
> 
> Thanks.
> -- 
> 
> Bud Schneehagen - Tropical Web Creations
> 
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: trouble passing variables

[Kwang Suh]

Well, you didn't scope the cfparam tags.  Try scoping them to form. and see
if that works.

> -Original Message-
> From: Douglas Brown [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, June 29, 2002 1:37 PM
> To: CF-Talk
> Subject: Re: trouble passing variables
>
>
> Kwang,
>
> Thanks for the reply, but the form post back to itself and the
> param tags are still there. It just is not seeing them or
> something. I am lost!!!
>
>
>
>
> Douglas Brown
> Email: [EMAIL PROTECTED]
> - Original Message -
> From: "Kwang Suh" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Saturday, June 29, 2002 10:42 AM
> Subject: RE: trouble passing variables
>
>
> > Checkbox fields only exist upon submission if they are
> checked.
> >
> > I always create cfparams for checkbox fields on the action
> page.
> >
> > > -Original Message-
> > > From: Douglas Brown [mailto:[EMAIL PROTECTED]]
> > > Sent: Friday, June 28, 2002 3:46 PM
> > > To: CF-Talk
> > > Subject: trouble passing variables
> > >
> > >
> > > I have a form that is populated from a query, that has
> several
> > > checkboxes. The form posts back to itslef for update, but
> when I make
> > > modifications to the checkboxes, I get a expression
> evaluation error
> > > that it cannot find the checkbox form fields. I have enabled
> debugging
> > > and in fact the variables are not getting passed. I have
> pasted the form
> > > below, for some insight.
> > >
> > >
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > >
> > >
> > > 
> > >
> > > 
> > >
> > >  name="update_inventory">
> > > update inventory
> > > set  mfg_date   = '#mfg_date#',
> > >   stock_number = '#attributes.stock_number#',
> > >   vin= '#attributes.vin#',
> > >   make   = '#attributes.make#',
> > >   model   = '#attributes.model#',
> > >   mileage   = '#attributes.mileage#',
> > >   color   = '#attributes.color#',
> > >   condition  = '#attributes.condition#',
> > >   sale_price  = #attributes.sale_price#,
> > >   show_price  = '#attributes.show_price#'
> > > where  id = #attributes.inventory_id#
> > > 
> > >
> > > 
> > >
> > >  name="update_options">
> > > update options
> > > set  ac = #attributes.ac#,
> > >   convertible   = #attributes.convertible#,
> > >   d_airbag   = #attributes.d_airbag#,
> > >   p_airbag   = #attributes.p_airbag#,
> > >   hatchback   = #attributes.hatchback#,
> > >   anti_lock   = #attributes.anti_lock#,
> > >   am_fm= #attributes.am_fm#,
> > >   cass= #attributes.cass#,
> > >   power_seats   = #attributes.power_seats#,
> > >   power_windows   = #attributes.power_windows#,
> > >   power_locks   = #attributes.power_locks#,
> > >   power_brakes  = #attributes.power_brakes#,
> > >   power_steering  = #attributes.power_steering#
> > >   tilt_wheel   = #attributes.tilt_wheel#,
> > >   cruise_control  = #attributes.cruise_control#,
> > >   cd = #attributes.cd#,
> > >   four_wheel_drive = #attributes.four_wheel_drive#,
> > >   sunroof= #attributes.sunroof#,
> > >   leather= #attributes.leather#,
> > >   tow_pkg= #attributes.tow_pkg#,
> > >   classic= #attributes.classic#
> > > where inventory_id   = #attributes.inventory_id#
> > > 
> > > 
> > >
> > > 
> > >
> > >  > > name="get_inventory_for_update">
> > > select   inventory.id,
> > >inventory.mfg_date,
> > >inventory.stock_number,
> > >inventory.vin,
> > >inventory.make,
> > >inventory.model,
> > >inventory.mileage,
> > >inventory.color,
> > >inventory.condition,
> > >inventory.sale_price,
> > >inventory.show_price,
> > >options.ac,
> > >options.convertible,
> > >options.d_airbag,
> > >options.p_airbag,
> > >options.hatchback,
> > >options.anti_lock,
> > >options.am_fm,
> > >options.cass,
> > >options.power_seats,
> > >options.power_windows,
> > >options.power_locks,
> > >options.power_brakes,
> > >options.power_steering,
> > >options.tilt_wheel,
> > >options.cruise_control,
> > >options.cd,
> > >options.four_wheel_drive,
> > >options.sunroof,
> > >options.leather,
> > >options.tow_pkg,
> > >options.classic,
> > >photos.photo,
> > >photos.thumbnail
> > > from   inventory
> > > inner join  options on inventory.id = options.inventory_id
> > > inner join  photos on inventory.id  = photos.inventory_id
> > > where   inventory.id= #attributes.inventory_id#
> > > 
> > >  
> > >
> > >  > >
> action="index.cfm?fuseaction=updateInventory&inventory_id= put>#att
> > > ributes.inventory_id#&popup=true&action=update"
> > > method="post">
> > >  border="0"
> > > align="center">
> > >  
> > >   
> > >  border="0"
> > > align="center">
> > >   
> > >  class="consoleBlack"
> > > height="24">Update Inventory
> > >   
> > >   
> > > 
> > >  
> > >   

Re: INNER JOIN

[S . Isaac Dealey]

> What's the deal with ( tblEmployee.EmployeeID IS NOT NULL ) ?

> Shouldn't your ON clause be relating one row in one table
> to a row in another table?

It depends on what you're trying to accomplish with the query -- and it
turns out it doesn't work for him I _think_ because he's using Access ...
I've done this in MS SQL Server before -- rarely ... What it does is return
a cartesian result set, where there is no explicit relationship between the
two tables... so instead of getting

SERVICE EMPLOYEE
web peter
support paul
support mary

.. you get...

COMPANY EMPLOYEE
web peter
web paul
web mary
support peter
support paul
support mary

so using a join statement as above as a placeholder allows you to get this
cartesian and then the 3rd table which relates these 2 may be used to show
whether the given employee is related to the service or not -- that way you
get one record in the query per cell in the table, regarldess of
relationship -- it makes outputting the display a lot simpler ...

The problem with leaving the join statement out is that ime with SQL Server
it errors when you try to join the 3rd table to the 1st table if the 1st and
2nd table are separated only by a comma, i.e.

from tlb1, tbl2
left join tlb3 on ( tbl3.xid = tbl1.xid )

it returns an error message that says tbl1 doesn't exist in the query (which
it obviously does) so that's why the join statement is there ...

Isaac

www.turnkey.to
954-776-0046

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: INNER JOIN

[Matthew Walker]

What's the deal with ( tblEmployee.EmployeeID IS NOT NULL ) ?

Shouldn't your ON clause be relating one row in one table to a row in
another table?

- Original Message -
From: "Paul Ihrig" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, June 30, 2002 9:57 AM
Subject: INNER JOIN


> can you see whats wrong with this query?
> error below
> thanks
> -paul
>
> 
> SELECT tblRelations.Relation_ID,
> tblService.Service_ID, tblService.Service,
> tblEmployee.EmployeeID,
> LEFT(LTRIM(tblEmployee.LastName),1) + '.' +
> LEFT(LTRIM(tblEmployee.FirstName),1) + '.' AS
> employeeinitial
>
> FROM tblService
> INNER JOIN tblEmployee ON ( tblEmployee.EmployeeID IS NOT NULL )
> LEFT JOIN tblRelations ON (
> tblRelations.EmployeeID = tblEmployee.EmployeeID AND
> tblRelations.Service_ID = tblService.ServiceID )
> WHERE EXISTS (SELECT EmployeeID FROM tblRelations
> WHERE tblRelations.EmployeeID = tblEmployee.EmployeeID)
> ORDER BY tblService.Service, tblEmployee.LastName,
> tblEmployee.Firstname
>
> 
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression
> '( tblEmployee.EmployeeID NOT NULL ) LEFT JOIN tblRelations ON (
> tblRelations.EmployeeID = tblEmployee.EmployeeID AND
tblRelations.Service_ID
> = tblService.ServiceID )'.
>
>
>
> The error occurred while processing an element with a general identifier
of
> (CFQUERY), occupying document position (2:1) to (2:51).
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: SQL Server Indexes

[Bud]

Hi all. I've noticed when upsizing an Access database, I'll get 
duplicate indexes on the primary keys. For instance, if I have a 
Category_ID field which is the primary key and indexed in Access, 
after upsizing, I'll get an index named aCategory_ID_PK and also 
one named Category_ID in the SQL DB. Should I delete the Category_ID 
index? It seems redundant.

Thanks.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Deleting CFMX Files?

[Ken Wilson]

Thanks Stace, that got me where I needed to be.

Ken



-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 29, 2002 6:50 PM
To: CF-Talk
Subject: RE: Deleting CFMX Files?


I believe all the compiled classes are under WEB-INF/cfclasses

Stace

-Original Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 29, 2002 5:53 PM
To: CF-Talk
Subject: Deleting CFMX Files?

It's my first chance to play around with the release version of CFMX and I'm
puzzled. Here's what I did:

- created a test page, all works fine.
- mapped a custom file extension to the service
- delete the first test page
- created a new test page with the custom file extension, all works fine

Puzzling part is that the first page is still available even though it's
been deleted. Now I assume that's because it's been compiled but where is it
(physically) being called from and is there a programmatic way to delete it
from there?

RTFM is, of course, a fine response but including a reference to page number
of the manual would be helpful.  :)

Any pointers appreciated.

Ken




__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Deleting CFMX Files?

[Stacy Young]

I believe all the compiled classes are under WEB-INF/cfclasses

Stace

-Original Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, June 29, 2002 5:53 PM
To: CF-Talk
Subject: Deleting CFMX Files?

It's my first chance to play around with the release version of CFMX and I'm
puzzled. Here's what I did:

- created a test page, all works fine.
- mapped a custom file extension to the service
- delete the first test page
- created a new test page with the custom file extension, all works fine

Puzzling part is that the first page is still available even though it's
been deleted. Now I assume that's because it's been compiled but where is it
(physically) being called from and is there a programmatic way to delete it
from there?

RTFM is, of course, a fine response but including a reference to page number
of the manual would be helpful.  :)

Any pointers appreciated.

Ken



__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: refresh parent after query update

[Douglas Brown]

ThanksPerfect. Dont know why I did not think of that




Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: "Marius Milosav" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, June 29, 2002 3:12 PM
Subject: Re: refresh parent after query update


> After the update is completed you can run the following code:
>
> 
>  opener.location.reload(true);
>  close ();
> 
>
>  This will also close the child window.
> Marius Milosav
> www.scorpiosoft.com
> It's not about technology, it's about people.
> Virtual Company (VICO) Application Demo
> www.scorpiosoft.com/vicodemo/login.cfm
>
>
> - Original Message -
> From: "Douglas Brown" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Saturday, June 29, 2002 5:51 PM
> Subject: refresh parent after query update
>
>
> > I am looking for some JS that will refresh the parent from a child after
> > an update and not before. I have a little snippet to do the refresh, but
> > it always reloads the parent before the update is complete on the child
> > window. Any help would be great...
> >
> >
> >
> >
> > Douglas Brown
> > Email: [EMAIL PROTECTED]
> >
> >
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: refresh parent after query update

[Marius Milosav]

After the update is completed you can run the following code:


 opener.location.reload(true);
 close ();


 This will also close the child window.
Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Company (VICO) Application Demo
www.scorpiosoft.com/vicodemo/login.cfm


- Original Message -
From: "Douglas Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, June 29, 2002 5:51 PM
Subject: refresh parent after query update


> I am looking for some JS that will refresh the parent from a child after
> an update and not before. I have a little snippet to do the refresh, but
> it always reloads the parent before the update is complete on the child
> window. Any help would be great...
>
>
>
>
> Douglas Brown
> Email: [EMAIL PROTECTED]
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

INNER JOIN

[Paul Ihrig]

can you see whats wrong with this query?
error below
thanks
-paul


SELECT tblRelations.Relation_ID,
tblService.Service_ID, tblService.Service,
tblEmployee.EmployeeID,
LEFT(LTRIM(tblEmployee.LastName),1) + '.' +
LEFT(LTRIM(tblEmployee.FirstName),1) + '.' AS
employeeinitial

FROM tblService
INNER JOIN tblEmployee ON ( tblEmployee.EmployeeID IS NOT NULL )
LEFT JOIN tblRelations ON (
tblRelations.EmployeeID = tblEmployee.EmployeeID AND
tblRelations.Service_ID = tblService.ServiceID )
WHERE EXISTS (SELECT EmployeeID FROM tblRelations
WHERE tblRelations.EmployeeID = tblEmployee.EmployeeID)
ORDER BY tblService.Service, tblEmployee.LastName,
tblEmployee.Firstname



[Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression
'( tblEmployee.EmployeeID NOT NULL ) LEFT JOIN tblRelations ON (
tblRelations.EmployeeID = tblEmployee.EmployeeID AND tblRelations.Service_ID
= tblService.ServiceID )'.



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (2:1) to (2:51).
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

refresh parent after query update

[Douglas Brown]

I am looking for some JS that will refresh the parent from a child after
an update and not before. I have a little snippet to do the refresh, but
it always reloads the parent before the update is complete on the child
window. Any help would be great...




Douglas Brown
Email: [EMAIL PROTECTED]

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Deleting CFMX Files?

[Ken Wilson]

It's my first chance to play around with the release version of CFMX and I'm
puzzled. Here's what I did:

- created a test page, all works fine.
- mapped a custom file extension to the service
- delete the first test page
- created a new test page with the custom file extension, all works fine

Puzzling part is that the first page is still available even though it's
been deleted. Now I assume that's because it's been compiled but where is it
(physically) being called from and is there a programmatic way to delete it
from there?

RTFM is, of course, a fine response but including a reference to page number
of the manual would be helpful.  :)

Any pointers appreciated.

Ken


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFMX / CFC / FLASH Books.

[Mike Chambers]

oops, i read your message wrong. same birdy.

btw, there should more more information on this at flash forward in a
week and a half in nyc.

mike chambers

[EMAIL PROTECTED]



> -Original Message-
> From: Dick Applebaum [mailto:[EMAIL PROTECTED]] 
> Sent: Saturday, June 29, 2002 3:58 PM
> To: CF-Talk
> Subject: Re: CFMX / CFC / FLASH Books.
> 
> 
> Nah, same birdy... I could cc them, if you like!
> 
> Dick
> 

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFMX / CFC / FLASH Books.

[Dick Applebaum]

Nah, same birdy... I could cc them, if you like!

Dick

On Saturday, June 29, 2002, at 12:44  PM, Mike Chambers wrote:

> i think we are talking to different birdies.
>
> mike chambers
>
> [EMAIL PROTECTED]
>
>> -Original Message-
>> From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
>> Sent: Saturday, June 29, 2002 3:24 PM
>> To: CF-Talk
>> Subject: Re: CFMX / CFC / FLASH Books.
>>
>>
>> I think I know that birdy too -- and know of the Author(s) --
>> and that
>> at least one on them is developing the content on A Mac running CFMX
>> under Mac OS X.%^)>
>>
>> Dick
>>
>> On Saturday, June 29, 2002, at 12:12  PM, Mike Chambers wrote:
>>
>>> a little birdy has told me that O'Reilly is working on a
>> Flash Remoting
>>> book that, among other things, will cover working with CFMX.
>>>
>>> not eta though.
>>>
>>> mike chambers
>>>
>>> [EMAIL PROTECTED]
>>>
 -Original Message-
 From: Neil H. [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, June 29, 2002 12:29 PM
 To: CF-Talk
 Subject: CFMX / CFC / FLASH Books.


 I would like to see a programmers guide to the subject.  Is
 there anything
 available now?  I know Kevin Towes is involved in a Flash MX
 book but how
 technical does that get?'

 Thanks,

>>>
>>>
>>
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFMX / CFC / FLASH Books.

[Mike Chambers]

i think we are talking to different birdies.

mike chambers

[EMAIL PROTECTED]

> -Original Message-
> From: Dick Applebaum [mailto:[EMAIL PROTECTED]] 
> Sent: Saturday, June 29, 2002 3:24 PM
> To: CF-Talk
> Subject: Re: CFMX / CFC / FLASH Books.
> 
> 
> I think I know that birdy too -- and know of the Author(s) -- 
> and that 
> at least one on them is developing the content on A Mac running CFMX 
> under Mac OS X.%^)>
> 
> Dick
> 
> On Saturday, June 29, 2002, at 12:12  PM, Mike Chambers wrote:
> 
> > a little birdy has told me that O'Reilly is working on a 
> Flash Remoting
> > book that, among other things, will cover working with CFMX.
> >
> > not eta though.
> >
> > mike chambers
> >
> > [EMAIL PROTECTED]
> >
> >> -Original Message-
> >> From: Neil H. [mailto:[EMAIL PROTECTED]]
> >> Sent: Saturday, June 29, 2002 12:29 PM
> >> To: CF-Talk
> >> Subject: CFMX / CFC / FLASH Books.
> >>
> >>
> >> I would like to see a programmers guide to the subject.  Is
> >> there anything
> >> available now?  I know Kevin Towes is involved in a Flash MX
> >> book but how
> >> technical does that get?'
> >>
> >> Thanks,
> >>
> >
> > 
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: trouble passing variables

[Douglas Brown]

Kwang,

Thanks for the reply, but the form post back to itself and the
param tags are still there. It just is not seeing them or
something. I am lost!!!




Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: "Kwang Suh" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, June 29, 2002 10:42 AM
Subject: RE: trouble passing variables


> Checkbox fields only exist upon submission if they are
checked.
>
> I always create cfparams for checkbox fields on the action
page.
>
> > -Original Message-
> > From: Douglas Brown [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, June 28, 2002 3:46 PM
> > To: CF-Talk
> > Subject: trouble passing variables
> >
> >
> > I have a form that is populated from a query, that has
several
> > checkboxes. The form posts back to itslef for update, but
when I make
> > modifications to the checkboxes, I get a expression
evaluation error
> > that it cannot find the checkbox form fields. I have enabled
debugging
> > and in fact the variables are not getting passed. I have
pasted the form
> > below, for some insight.
> >
> >
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >
> >
> > 
> >
> > 
> >
> > 
> > update inventory
> > set  mfg_date   = '#mfg_date#',
> >   stock_number = '#attributes.stock_number#',
> >   vin= '#attributes.vin#',
> >   make   = '#attributes.make#',
> >   model   = '#attributes.model#',
> >   mileage   = '#attributes.mileage#',
> >   color   = '#attributes.color#',
> >   condition  = '#attributes.condition#',
> >   sale_price  = #attributes.sale_price#,
> >   show_price  = '#attributes.show_price#'
> > where  id = #attributes.inventory_id#
> > 
> >
> > 
> >
> > 
> > update options
> > set  ac = #attributes.ac#,
> >   convertible   = #attributes.convertible#,
> >   d_airbag   = #attributes.d_airbag#,
> >   p_airbag   = #attributes.p_airbag#,
> >   hatchback   = #attributes.hatchback#,
> >   anti_lock   = #attributes.anti_lock#,
> >   am_fm= #attributes.am_fm#,
> >   cass= #attributes.cass#,
> >   power_seats   = #attributes.power_seats#,
> >   power_windows   = #attributes.power_windows#,
> >   power_locks   = #attributes.power_locks#,
> >   power_brakes  = #attributes.power_brakes#,
> >   power_steering  = #attributes.power_steering#
> >   tilt_wheel   = #attributes.tilt_wheel#,
> >   cruise_control  = #attributes.cruise_control#,
> >   cd = #attributes.cd#,
> >   four_wheel_drive = #attributes.four_wheel_drive#,
> >   sunroof= #attributes.sunroof#,
> >   leather= #attributes.leather#,
> >   tow_pkg= #attributes.tow_pkg#,
> >   classic= #attributes.classic#
> > where inventory_id   = #attributes.inventory_id#
> > 
> > 
> >
> > 
> >
> >  > name="get_inventory_for_update">
> > select   inventory.id,
> >inventory.mfg_date,
> >inventory.stock_number,
> >inventory.vin,
> >inventory.make,
> >inventory.model,
> >inventory.mileage,
> >inventory.color,
> >inventory.condition,
> >inventory.sale_price,
> >inventory.show_price,
> >options.ac,
> >options.convertible,
> >options.d_airbag,
> >options.p_airbag,
> >options.hatchback,
> >options.anti_lock,
> >options.am_fm,
> >options.cass,
> >options.power_seats,
> >options.power_windows,
> >options.power_locks,
> >options.power_brakes,
> >options.power_steering,
> >options.tilt_wheel,
> >options.cruise_control,
> >options.cd,
> >options.four_wheel_drive,
> >options.sunroof,
> >options.leather,
> >options.tow_pkg,
> >options.classic,
> >photos.photo,
> >photos.thumbnail
> > from   inventory
> > inner join  options on inventory.id = options.inventory_id
> > inner join  photos on inventory.id  = photos.inventory_id
> > where   inventory.id= #attributes.inventory_id#
> > 
> >  
> >
> >  >
action="index.cfm?fuseaction=updateInventory&inventory_id=#att
> > ributes.inventory_id#&popup=true&action=update"
> > method="post">
> >  > align="center">
> >  
> >   
> >  > align="center">
> >   
> >  > height="24">Update Inventory
> >   
> >   
> > 
> >  
> > 
> >> border="0" cellpadding="5" cellspacing="0">
> >   
> >  > src="images/details.gif">
> >   
> >   
> >  
> >   
> >   
> >  > class="consoleBlack">MFG
> >   Date
> > 
> >  >
value="#dateFormat(get_inventory_for_update.mfg_date,
> > "")#">
> >   
> >   
> >  > class="consoleBlack">Make
> > 
> >  >
value="#get_inventory_for_update.make#">
> >   
> >   
> >  > class="consoleBlack">Model
> > 
> >  >
value="#get_inventory_for_update.model#">
> >   

Re: CFMX / CFC / FLASH Books.

[Dick Applebaum]

I think I know that birdy too -- and know of the Author(s) -- and that 
at least one on them is developing the content on A Mac running CFMX 
under Mac OS X.%^)>

Dick

On Saturday, June 29, 2002, at 12:12  PM, Mike Chambers wrote:

> a little birdy has told me that O'Reilly is working on a Flash Remoting
> book that, among other things, will cover working with CFMX.
>
> not eta though.
>
> mike chambers
>
> [EMAIL PROTECTED]
>
>> -Original Message-
>> From: Neil H. [mailto:[EMAIL PROTECTED]]
>> Sent: Saturday, June 29, 2002 12:29 PM
>> To: CF-Talk
>> Subject: CFMX / CFC / FLASH Books.
>>
>>
>> I would like to see a programmers guide to the subject.  Is
>> there anything
>> available now?  I know Kevin Towes is involved in a Flash MX
>> book but how
>> technical does that get?'
>>
>> Thanks,
>>
>
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFMX / CFC / FLASH Books.

[Jason Miller]

I have embarkeed on finding some stuff on Flash Remoting and CFMX - some
resources definately need to be done. THis would be great if O'Reilly
is..

If you do a search on 
DataProviderClass() on MACR"s site - you will come up with a few flash
remoting tutorials - one in particular seems to lay down a good base - I
just read it this a.m.   It is was by Kevin Towes as mentioned
below...  
http://www.macromedia.com/desdev/mx/coldfusion/articles/remoting.html
 

I would be interested in anyone forwarding any information about this -
I had posted on an advanced Flash list with only 1 response.
hope the link is helpful.
jay miller

Mike Chambers wrote:


a little birdy has told me that O'Reilly is working on a Flash Remoting
book that, among other things, will cover working with CFMX.

not eta though.

mike chambers

[EMAIL PROTECTED]  


-Original Message-
From: Neil H. [ mailto:[EMAIL PROTECTED]
 ] 
Sent: Saturday, June 29, 2002 12:29 PM
To: CF-Talk
Subject: CFMX / CFC / FLASH Books.


I would like to see a programmers guide to the subject.  Is 
there anything
available now?  I know Kevin Towes is involved in a Flash MX 
book but how
technical does that get?'

Thanks,




__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFMX / CFC / FLASH Books.

[Mike Chambers]

a little birdy has told me that O'Reilly is working on a Flash Remoting
book that, among other things, will cover working with CFMX.

not eta though.

mike chambers

[EMAIL PROTECTED]

> -Original Message-
> From: Neil H. [mailto:[EMAIL PROTECTED]] 
> Sent: Saturday, June 29, 2002 12:29 PM
> To: CF-Talk
> Subject: CFMX / CFC / FLASH Books.
> 
> 
> I would like to see a programmers guide to the subject.  Is 
> there anything
> available now?  I know Kevin Towes is involved in a Flash MX 
> book but how
> technical does that get?'
> 
> Thanks,
> 

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: trouble passing variables

[Kwang Suh]

Checkbox fields only exist upon submission if they are checked.

I always create cfparams for checkbox fields on the action page.

> -Original Message-
> From: Douglas Brown [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 28, 2002 3:46 PM
> To: CF-Talk
> Subject: trouble passing variables
> 
> 
> I have a form that is populated from a query, that has several
> checkboxes. The form posts back to itslef for update, but when I make
> modifications to the checkboxes, I get a expression evaluation error
> that it cannot find the checkbox form fields. I have enabled debugging
> and in fact the variables are not getting passed. I have pasted the form
> below, for some insight.
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> update inventory
> set  mfg_date   = '#mfg_date#',
>   stock_number = '#attributes.stock_number#',
>   vin= '#attributes.vin#',
>   make   = '#attributes.make#',
>   model   = '#attributes.model#',
>   mileage   = '#attributes.mileage#',
>   color   = '#attributes.color#',
>   condition  = '#attributes.condition#',
>   sale_price  = #attributes.sale_price#,
>   show_price  = '#attributes.show_price#'
> where  id = #attributes.inventory_id#
> 
> 
> 
> 
> 
> update options
> set  ac = #attributes.ac#,
>   convertible   = #attributes.convertible#,
>   d_airbag   = #attributes.d_airbag#,
>   p_airbag   = #attributes.p_airbag#,
>   hatchback   = #attributes.hatchback#,
>   anti_lock   = #attributes.anti_lock#,
>   am_fm= #attributes.am_fm#,
>   cass= #attributes.cass#,
>   power_seats   = #attributes.power_seats#,
>   power_windows   = #attributes.power_windows#,
>   power_locks   = #attributes.power_locks#,
>   power_brakes  = #attributes.power_brakes#,
>   power_steering  = #attributes.power_steering#
>   tilt_wheel   = #attributes.tilt_wheel#,
>   cruise_control  = #attributes.cruise_control#,
>   cd = #attributes.cd#,
>   four_wheel_drive = #attributes.four_wheel_drive#,
>   sunroof= #attributes.sunroof#,
>   leather= #attributes.leather#,
>   tow_pkg= #attributes.tow_pkg#,
>   classic= #attributes.classic#
> where inventory_id   = #attributes.inventory_id#
> 
> 
> 
> 
> 
>  name="get_inventory_for_update">
> select   inventory.id,
>inventory.mfg_date,
>inventory.stock_number,
>inventory.vin,
>inventory.make,
>inventory.model,
>inventory.mileage,
>inventory.color,
>inventory.condition,
>inventory.sale_price,
>inventory.show_price,
>options.ac,
>options.convertible,
>options.d_airbag,
>options.p_airbag,
>options.hatchback,
>options.anti_lock,
>options.am_fm,
>options.cass,
>options.power_seats,
>options.power_windows,
>options.power_locks,
>options.power_brakes,
>options.power_steering,
>options.tilt_wheel,
>options.cruise_control,
>options.cd,
>options.four_wheel_drive,
>options.sunroof,
>options.leather,
>options.tow_pkg,
>options.classic,
>photos.photo,
>photos.thumbnail
> from   inventory
> inner join  options on inventory.id = options.inventory_id
> inner join  photos on inventory.id  = photos.inventory_id
> where   inventory.id= #attributes.inventory_id#
> 
>  
> 
>  action="index.cfm?fuseaction=updateInventory&inventory_id=#att
> ributes.inventory_id#&popup=true&action=update"
> method="post">
>  align="center">
>  
>   
>  align="center">
>   
>  height="24">Update Inventory
>   
>   
> 
>  
> 
>border="0" cellpadding="5" cellspacing="0">
>   
>  src="images/details.gif">
>   
>   
>  
>   
>   
>  class="consoleBlack">MFG
>   Date
> 
>  value="#dateFormat(get_inventory_for_update.mfg_date,
> "")#">
>   
>   
>  class="consoleBlack">Make
> 
>  value="#get_inventory_for_update.make#">
>   
>   
>  class="consoleBlack">Model
> 
>  value="#get_inventory_for_update.model#">
>   
>   
>  class="consoleBlack">Mileage
> 
>  value="#get_inventory_for_update.mileage#">
>   
>   
>  class="consoleBlack">Vin
> 
>  value="#get_inventory_for_update.vin#">
>   
>   
>  class="consoleBlack">Stock
>   #
> 
>  value="#get_inventory_for_update.stock_number#"> d>
>   
>   
>  class="consoleBlack">Color
> 
>  value="#get_inventory_for_update.color#">
>   
>   
>  class="consoleBlack">Condition
> 
>  value="#get_inventory_for_update.condition#">
>   

Re: trouble passing variables

[Douglas Brown]

Well the first time through, it populates the checkboxes from
the DB and then it posts back to itself for the update. The
person may add another option and I would prefer thaat they do
not have to enter all the options over again by leaving the
valur blank




Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: "Larry Juncker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, June 29, 2002 5:43 AM
Subject: RE: trouble passing variables


> Doug-
>
> If I am not mistaken, you do not need a value statement
> on your edit form for the checkboxes.  Just the if statement,
that will set
> the value of the checkbox.  Try removing the value statement
of your
> checkboxes and try again.
>
> -Original Message-
> From: Douglas Brown [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 28, 2002 4:46 PM
> To: CF-Talk
> Subject: trouble passing variables
>
>
> I have a form that is populated from a query, that has several
> checkboxes. The form posts back to itslef for update, but when
I make
> modifications to the checkboxes, I get a expression evaluation
error
> that it cannot find the checkbox form fields. I have enabled
debugging
> and in fact the variables are not getting passed. I have
pasted the form
> below, for some insight.
>
>
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>
>
> 
>
> 
>
> 
> update inventory
> set  mfg_date   = '#mfg_date#',
>   stock_number = '#attributes.stock_number#',
>   vin= '#attributes.vin#',
>   make   = '#attributes.make#',
>   model   = '#attributes.model#',
>   mileage   = '#attributes.mileage#',
>   color   = '#attributes.color#',
>   condition  = '#attributes.condition#',
>   sale_price  = #attributes.sale_price#,
>   show_price  = '#attributes.show_price#'
> where  id = #attributes.inventory_id#
> 
>
> 
>
> 
> update options
> set  ac = #attributes.ac#,
>   convertible   = #attributes.convertible#,
>   d_airbag   = #attributes.d_airbag#,
>   p_airbag   = #attributes.p_airbag#,
>   hatchback   = #attributes.hatchback#,
>   anti_lock   = #attributes.anti_lock#,
>   am_fm= #attributes.am_fm#,
>   cass= #attributes.cass#,
>   power_seats   = #attributes.power_seats#,
>   power_windows   = #attributes.power_windows#,
>   power_locks   = #attributes.power_locks#,
>   power_brakes  = #attributes.power_brakes#,
>   power_steering  = #attributes.power_steering#
>   tilt_wheel   = #attributes.tilt_wheel#,
>   cruise_control  = #attributes.cruise_control#,
>   cd = #attributes.cd#,
>   four_wheel_drive = #attributes.four_wheel_drive#,
>   sunroof= #attributes.sunroof#,
>   leather= #attributes.leather#,
>   tow_pkg= #attributes.tow_pkg#,
>   classic= #attributes.classic#
> where inventory_id   = #attributes.inventory_id#
> 
> 
>
> 
>
>  name="get_inventory_for_update">
> select   inventory.id,
>inventory.mfg_date,
>inventory.stock_number,
>inventory.vin,
>inventory.make,
>inventory.model,
>inventory.mileage,
>inventory.color,
>inventory.condition,
>inventory.sale_price,
>inventory.show_price,
>options.ac,
>options.convertible,
>options.d_airbag,
>options.p_airbag,
>options.hatchback,
>options.anti_lock,
>options.am_fm,
>options.cass,
>options.power_seats,
>options.power_windows,
>options.power_locks,
>options.power_brakes,
>options.power_steering,
>options.tilt_wheel,
>options.cruise_control,
>options.cd,
>options.four_wheel_drive,
>options.sunroof,
>options.leather,
>options.tow_pkg,
>options.classic,
>photos.photo,
>photos.thumbnail
> from   inventory
> inner join  options on inventory.id = options.inventory_id
> inner join  photos on inventory.id  = photos.inventory_id
> where   inventory.id= #attributes.inventory_id#
> 
>  
>
> 
action="index.cfm?fuseaction=updateInventory&inventory_id=#att
> ributes.inventory_id#&popup=true&action=update"
> method="post">
>  align="center">
>  
>   
>  align="center">
>   
>  height="24">Update Inventory
>   
>   
> 
>  
> 
>border="0" cellpadding="5" cellspacing="0">
>   
>  src="images/details.gif">
>   
>   
>  
>   
>   
>  class="consoleBlack">MFG
>   Date
> 
> 
value="#dateFormat(get_inventory_for_update.mfg_date,
> "")#">
>   
>   
>  class="consoleBlack">Make
> 
> 
value="#get_inventory_for_update.make#">
>   
>   
>  class="consoleBlack">Model
> 
> 
value="#get_inventory_for_update.model#">
>   
>   
>  class="consoleBlack">Mileage
> 
> 
value="#get_inventory_for_update.mileage#">

>   
>   
> 

RE: breaking a loop... need help

[Paul Ihrig]

this is as close as i can get...
http://www.columbus.nbbj.com/IS/internalsupport/InteEmpGrid07.cfm
not quiet there..
i know it has to be something relatively simple!

any more help would be fantastic!

-paul



SELECT EmployeeID, LastName, FirstName
FROM tblEmployee
ORDER BY LastName;



SELECT Relation_ID, tblRelations.Service_ID, tblRelations.EmployeeID,
tblService.Service_ID, tblService.Service,  tblEmployee.EmployeeID,
LastName, FirstName
FROM tblRelations, tblService, tblEmployee
WHERE tblRelations.Service_ID = tblService.Service_ID
AND tblRelations.EmployeeID IN (tblEmployee.EmployeeID)
ORDER BY Service, LastName;


rsEmployee_NumRows = 0;
rsEmployee_Index = 1;
HLooper1_NumRows = 20;
rsEmployee_NumRows = rsEmployee_NumRows + HLooper1_NumRows;



 
Service

 

#LEFT(rsEmployee.FirstName, 1)#.#LEFT(rsEmployee.LastName, 1)#.
#rsEmployee.EmployeeID#

 




 
#Trim(myRelations.Service)#


#myRelations.EmployeeID#




#EmployeeID# 


 

#EmployeeID#




 
  
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFMX / CFC / FLASH Books.

[Neil H.]

Also is there a way to print or download the livedocs for CFMX in PDF form
so I can print it instead of going to each individual link which is a real
pain?

Neil

- Original Message -
From: "Neil H." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, June 29, 2002 12:28 PM
Subject: CFMX / CFC / FLASH Books.


> I would like to see a programmers guide to the subject.  Is there anything
> available now?  I know Kevin Towes is involved in a Flash MX book but how
> technical does that get?'
>
> Thanks,
>
> Neil Heuer
> [EMAIL PROTECTED]
>
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFMX / CFC / FLASH Books.

[Neil H.]

I would like to see a programmers guide to the subject.  Is there anything
available now?  I know Kevin Towes is involved in a Flash MX book but how
technical does that get?'

Thanks,

Neil Heuer
[EMAIL PROTECTED]

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Help Displaying results that loop

[Paul Ihrig]

ok came into the office to try it out...
mucked about a bit...

and wasn't able to float it...
Isaac you can see a your modified example here...
http://www.columbus.nbbj.com/IS/internalsupport/InteEmpGrid06.cfm

im going home now..
bringing my laptop to hopefully get this working this weekend..

thanks again
-paul


SELECT EmployeeID, LastName, FirstName
FROM tblEmployee
ORDER BY LastName;



SELECT Relation_ID, tblRelations.Service_ID, tblRelations.EmployeeID,
tblService.Service_ID, tblService.Service,  tblEmployee.EmployeeID,
LastName, FirstName
FROM tblRelations, tblService, tblEmployee
WHERE tblRelations.Service_ID = tblService.Service_ID
AND tblRelations.EmployeeID IN (tblEmployee.EmployeeID)
ORDER BY Service, LastName;


SELECT tblRelations.Relation_ID, tblRelations.Service_ID,
tblRelations.EmployeeID, tblService.Service_ID, tblService.Service,
tblEmployee.EmployeeID, tblEmployee.LastName, tblEmployee.FirstName
FROM (tblRelations LEFT JOIN tblService ON tblService.Service_ID =
tblRelations.Service_ID)
INNER JOIN tblEmployee ON tblEmployee.EmployeeID IN
(tblRelations.EmployeeID) 




rsEmployee_NumRows = 0;
rsEmployee_Index = 1;
HLooper1_NumRows = 20;
rsEmployee_NumRows = rsEmployee_NumRows + HLooper1_NumRows;



   
Service
  
 
  
  #LEFT(rsEmployee.FirstName, 1)#.#LEFT(rsEmployee.LastName,
1)#.
  #rsEmployee.EmployeeID#
  
 
  
  



 
 
  #Trim(myRelations.Service)#
  
  
  #myRelations.EmployeeID#
  
  


 





#rsEmployee.EmployeeID#

#rsEmployee.EmployeeID#




  
  
   
 
   

  



Isaac Dealey [code]


#Service#

#EmployeeID#   


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF5 and MySQL

[Jochem van Dieten]

Peter Tilbrook wrote:
> I've used it in the past so I'm mind boggled as to why it isn't available
> now. I can use MSSQL which I have a licence for but wanted to write a
> freeware application. Looks like I'll be developing under SQL Server.

There isn't one available for PostgreSQL either so I just wrote my own.

What's the big deal? We build web applications for a living (most of us 
at least), so why not just write this little plug-in? Set a few dozen 
registry parameters, call cfusion_settings_refresh() and you have a new 
datasource.

Jochem

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: What is the best variable scope?

[S . Isaac Dealey]

> Exactly my point, and as the user is not reading these
> emails then why make that a point when you and I both
> know otherwise :-)

Because it's important for us to think about the work that we do from the
perspective of our users -- as entertaining as our tech-centric ways of
thinking may be, they don't help us communicate with our customers or
clients and if we don't make an active attempt to think about our work the
way that our users will, we can (and often do) detract from the user
experience and ultimately injure our fiscal bottom line as a result.

Isaac

www.turnkey.to
954-776-0046

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Monitor active requests on CF Linux?

[Lawrence B. Afrin, M.D.]

Howdy --

Does anybody know of a method within CF, or a third-party tool, whereby I can monitor 
or otherwise determine which Linux
process (or which Windows process, for that matter) is handling which active CF 
request?

Some of my developers occasionally write code which runs away, hangs, or otherwise 
fails to terminate as expected.  When
I do a "ps -Af | fgrep coldfusion" on the Linux box hosting my CF 5 Pro server, I 
usually get back at least a couple
dozen CF processes, all of them of course owned by "nobody", and I don't have a clue 
which process is the troublesome
one that needs to be killed, so I usually don't have any choice but to be rude to 
everybody else who's using the site
and do a .../bin/stop and .../bin/start on the whole CF server.

Ick.

What I want, I guess, is sort of a "ps -coldfusion" that tells me, for each CF 
process, which .cfm it's executing and
which IP address made the request.  Then I can easily identify the troublemaker and 
issue a "kill" (unless there's some
more graceful way to do this that I don't know about).

I only have CF Pro, but from what I can see from the docs about the performance 
monitoring tools available with CF
Enterprise, it still doesn't look like I would get the level of detail that I need 
even if I upgraded.

I tried running .../bin/cfstat for the heck of it, to see what it would output, but 
all it said was "Couldn't get access
to shared memory area.  Perhaps CFAS is not running on this machine?  Perhaps 
performance monitoring is not enabled from
the CFAS administrator?  Perhaps CFAS was not restarted after enabling performance 
monitoring?"  This, in spite of the
fact that CFAS is running, performance monitoring is enabled, and CFAS was restarted 
after PM was enabled.

If anybody knows of a solution, I'd sure appreciate a pointer.  Thanks!

-- LBA

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF5 and MySQL

[Mike Alberts]

CF 5 and MySQL work fine together (and beats the heck out of using Access 
IMO)  as long as you have installed MyODBC that is. You have to set up 
the DSN with the Windows Control Panel (not CF administrator).

HTH

Mike

_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: breaking a loop... need help

[Paul Ihrig]

Bud --- 
i pasted your code here
http://www.columbus.nbbj.com/IS/internalsupport/InteEmpGrid05.cfm

at the bottom of the page...
still no luck..

-paul
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Dynamic Checkboxes

[David Schmidt]

Well, the isDefined statement would be a good thing to use here.







and then test for remove for processing (assuming you are processing it
inside the loop).  By the way, I typically use conditional looping
instead of indexed looping for things like this.  This way you don't
have to know how many records to start/end with.  Here's how it goes...

 <--- To start the index off --->

To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, June 29, 2002 6:27 AM
Subject: Dynamic Checkboxes


: I am having some trouble with dynamically named checkboxes. This is
what I
: am trying to do
:
:
: On a form I have some dynamically named form variables. like
:
: 
: 
: 
: 
: 
: 
: 
: 
: 
:
: I submit to
:
: 
: 
: 
: 
: 
: 
: 
: 
:
: #evaluate(vAnswer_ID)#
: #evaluate(vAnswer_Display_sequence)#
: #evaluate(vObject_Type_ID)#
: #evaluate(vAnswer_Text)#
: #evaluate(vAnswer_Field_Name)#
: #evaluate(vAnswer_Code)#
: #evaluate(vRemove)#
:
: 
:
:
:
: All of these work except for the checkbox. The reason is because
checkboxes
: aren't submitted of they aren't checked. So I would think that I
should use
: some thing like this to verify that the variable exists before setting
the
: variable to it's value.
:
: 
: 
: 
: 
:
: but this doesn't work either.
:
:
:
: Any Suggestions.
:
: Thanks,
:
: Dave
:
:
:
: 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Dynamic Checkboxes

[Dave Watts]

> I am having some trouble with dynamically named checkboxes.
> 
> On a form I have some dynamically named form variables. like
> 
> 
>   ...
>   
> 
> 
> I submit to
> 
> 
>   ...
>   
> 
> All of these work except for the checkbox. The reason is 
> because checkboxes aren't submitted of they aren't checked. 
> So I would think that I should use some thing like this to 
> verify that the variable exists before setting the variable 
> to it's value.
> 
> 
>   
>cfset vremove="0">
> 
> 
> but this doesn't work either.

You can fix your problem by putting this directly after your CFLOOP in your
action page:



The reason that your ParameterExists test isn't working is that you're
checking for vRemove, which isn't your checkbox but rather a local variable
that you're trying to create within the CFLOOP in your action page, based on
the value of the variable from the checkbox. But, if the variable from the
checkbox doesn't exist, you'll get an error when you reference it.

Also, you might want to use IsDefined instead of ParameterExists, generally,
since ParameterExists has been deprecated for some time. To use IsDefined to
test for the existence of Form.foo, you'd use something like this:



Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Dynamic Checkboxes

[David Jones]

I am having some trouble with dynamically named checkboxes. This is what I
am trying to do


On a form I have some dynamically named form variables. like











I submit to










#evaluate(vAnswer_ID)#
#evaluate(vAnswer_Display_sequence)#
#evaluate(vObject_Type_ID)#
#evaluate(vAnswer_Text)#
#evaluate(vAnswer_Field_Name)#
#evaluate(vAnswer_Code)#
#evaluate(vRemove)#





All of these work except for the checkbox. The reason is because checkboxes
aren't submitted of they aren't checked. So I would think that I should use
some thing like this to verify that the variable exists before setting the
variable to it's value.






but this doesn't work either.



Any Suggestions.

Thanks,

Dave



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: trouble passing variables

[Larry Juncker]

Doug-

If I am not mistaken, you do not need a value statement
on your edit form for the checkboxes.  Just the if statement, that will set
the value of the checkbox.  Try removing the value statement of your
checkboxes and try again.

-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 28, 2002 4:46 PM
To: CF-Talk
Subject: trouble passing variables


I have a form that is populated from a query, that has several
checkboxes. The form posts back to itslef for update, but when I make
modifications to the checkboxes, I get a expression evaluation error
that it cannot find the checkbox form fields. I have enabled debugging
and in fact the variables are not getting passed. I have pasted the form
below, for some insight.












































update inventory
set  mfg_date   = '#mfg_date#',
  stock_number = '#attributes.stock_number#',
  vin= '#attributes.vin#',
  make   = '#attributes.make#',
  model   = '#attributes.model#',
  mileage   = '#attributes.mileage#',
  color   = '#attributes.color#',
  condition  = '#attributes.condition#',
  sale_price  = #attributes.sale_price#,
  show_price  = '#attributes.show_price#'
where  id = #attributes.inventory_id#





update options
set  ac = #attributes.ac#,
  convertible   = #attributes.convertible#,
  d_airbag   = #attributes.d_airbag#,
  p_airbag   = #attributes.p_airbag#,
  hatchback   = #attributes.hatchback#,
  anti_lock   = #attributes.anti_lock#,
  am_fm= #attributes.am_fm#,
  cass= #attributes.cass#,
  power_seats   = #attributes.power_seats#,
  power_windows   = #attributes.power_windows#,
  power_locks   = #attributes.power_locks#,
  power_brakes  = #attributes.power_brakes#,
  power_steering  = #attributes.power_steering#
  tilt_wheel   = #attributes.tilt_wheel#,
  cruise_control  = #attributes.cruise_control#,
  cd = #attributes.cd#,
  four_wheel_drive = #attributes.four_wheel_drive#,
  sunroof= #attributes.sunroof#,
  leather= #attributes.leather#,
  tow_pkg= #attributes.tow_pkg#,
  classic= #attributes.classic#
where inventory_id   = #attributes.inventory_id#






select   inventory.id,
   inventory.mfg_date,
   inventory.stock_number,
   inventory.vin,
   inventory.make,
   inventory.model,
   inventory.mileage,
   inventory.color,
   inventory.condition,
   inventory.sale_price,
   inventory.show_price,
   options.ac,
   options.convertible,
   options.d_airbag,
   options.p_airbag,
   options.hatchback,
   options.anti_lock,
   options.am_fm,
   options.cass,
   options.power_seats,
   options.power_windows,
   options.power_locks,
   options.power_brakes,
   options.power_steering,
   options.tilt_wheel,
   options.cruise_control,
   options.cd,
   options.four_wheel_drive,
   options.sunroof,
   options.leather,
   options.tow_pkg,
   options.classic,
   photos.photo,
   photos.thumbnail
from   inventory
inner join  options on inventory.id = options.inventory_id
inner join  photos on inventory.id  = photos.inventory_id
where   inventory.id= #attributes.inventory_id#

 



 
  

  
Update Inventory
  
  

 

  
  

  
  
 
  
  
MFG
  Date

">
  
  
Make


  
  
Model


  
  
Mileage


  
  
Vin


  
  
Stock
  #


  
  
Color


  
  
Condition


  
  
Price



checked> Display [Ask Dealer] to public

  
  
image_1


  
  
image_2


  
  
image_3


  
  
image_4


  

  
  

  
  
 
  
  
A/C

checked>

Cruise

checked>

  
  
Power
Brakes

 checked>

Tilt
Wheel

checked>
  
  
Power
Locks

checked>

Leather

checked>
  
  
Power
  Steering

checked>
AM/FM

checked>

SKU Forecasting Formula's

[Andy Ousterhout]

Has anyone written any sku forecasting code?  If so, can you point me to
some information that I can use to create my algorthyms?  I'm currently
trying to create a process in Excel which I'll then port to Coldfusion.
Goal is to provide wholesale customers with recommended buy based off of
previous years sales and current purchase trends.  May  even add a variable
so that buyer can add a percentage for growth or shrinkage.

Andy




__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF5 and MySQL

[Douglas Williams]

Have you downloaded and installed myODBC drivers from mySQL.com?

I have a similar setup as you and have no problems setting up mySQL as a
datasource.

-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 29, 2002 4:18 AM
To: CF-Talk
Subject: CF5 and MySQL


Why would I not be able to select MySQL as a data provider under CF Admin
(version 5 - MX was even worse)?

I'm running Windows 2000 Advanced Server with IIS (fully patched - Broadband
is a godsend for that) and CF5 Professional.

Thanks!

==
Peter Tilbrook
Macromedia ColdFusion Applications Developer
4/73 Tharwa Road
Queanbeyan, NSW, 2620
AUSTRALIA

Phone: (02) 6284 2727
Mobile: 0401 973 415
Email: [EMAIL PROTECTED]
ICQ#: http://wwp.icq.com/666275
WWW: http://www.coldfusion.dns2go.com/

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Saturday, 29 June 2002 12:18 PM
To: CF-Talk
Subject: RE: Important security patch for CFMX


> > If you are using CFMX with IIS, please download and apply
> > this security patch.
> >
> > http://www.macromedia.com/v1/handlers/index.cfm?ID=23161
> > 
> >
> > To receive security bulletins automatically, you can
> > subscribe in the security zone.
> > http://www.macromedia.com/v1/developer/securityzone/
> > 
>
> Does the version of wsconfig.jar in the patch to support Apache
> 2.0.39 supersede the version of wsconfig.jar in this patch?

Oh, never mind, the answer is yes. It's right there in the Apache patch
release notes.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF5 and MySQL

[Paul Hastings]

> Can't affor MX as yet - I did try the trial version - not impressed enough

well from my i18n standpoint, this is the greatest thing since sliced bread.
what it doesn't do, with a few measly lines of newbie java i can get the
rest.

> yet for the upgrade. The MM staff at the recent Australian launch were
> arrogant also. Much more so than anyone else I've met from Microsoft,

don't know those folks. i'd almost suggest contacting contact mm singapore,
very nice, eyes-wide open guys.

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF5 and MySQL

[Peter Tilbrook]

It seems the belief at MM is that everyone who has used CF since, say like
myself, version 1 are commited by default to upgrade to the MX family of
products. ColdFusion MX has problems and in my opinion the decision to
discontinue development of HomeSite/ColdFusion Studio in its current form is
not a good idea. There must be many thousands of code writers - who may have
tried MM's poor attempt at code writing with Dreamweaver MX - who will stick
with Studio 5. Strewth! (Aussie slang) it took years to get a decent code
development/maintenance tool like Studio/HomeSite 5! Dreamweaver is going
down the Microsoft (nee Vermeer) FrontPage path and screwing up a toll that
has an honest and well respected pedigree of solutions delivered by
ColdFusion developers world-wide without the added flab of an expensive
replacement like Dreamweaver (any version including MX).

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF5 and MySQL

[Peter Tilbrook]

Can't affor MX as yet - I did try the trial version - not impressed enough
yet for the upgrade. The MM staff at the recent Australian launch were
arrogant also. Much more so than anyone else I've met from Microsoft,
Novell, Oracle and even Allaire.

==
Peter Tilbrook
Macromedia ColdFusion Applications Developer
4/73 Tharwa Road
Queanbeyan, NSW, 2620
AUSTRALIA

Phone: (02) 6284 2727
Mobile: 0401 973 415
Email: [EMAIL PROTECTED]
ICQ#: http://wwp.icq.com/666275
WWW: http://www.coldfusion.dns2go.com/

-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]]
Sent: Saturday, 29 June 2002 7:58 PM
To: CF-Talk
Subject: Re: CF5 and MySQL


> > Why would I not be able to select MySQL as a data provider under CF
Admin
> > (version 5 - MX was even worse)?

last time i looked cfmx had native mySQL. i don't imagine thats "worse".


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF5 and MySQL

[Peter Tilbrook]

I've used it in the past so I'm mind boggled as to why it isn't available
now. I can use MSSQL which I have a licence for but wanted to write a
freeware application. Looks like I'll be developing under SQL Server.

==
Peter Tilbrook
Macromedia ColdFusion Applications Developer
4/73 Tharwa Road
Queanbeyan, NSW, 2620
AUSTRALIA

Phone: (02) 6284 2727
Mobile: 0401 973 415
Email: [EMAIL PROTECTED]
ICQ#: http://wwp.icq.com/666275
WWW: http://www.coldfusion.dns2go.com/

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Saturday, 29 June 2002 7:48 PM
To: CF-Talk
Subject: Re: CF5 and MySQL


Peter Tilbrook wrote:
> Why would I not be able to select MySQL as a data provider under CF Admin
> (version 5 - MX was even worse)?

Because nobody ever bothered to write a plugin to add that option.

Jochem


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF5 and MySQL

[Paul Hastings]

> > Why would I not be able to select MySQL as a data provider under CF
Admin
> > (version 5 - MX was even worse)?

last time i looked cfmx had native mySQL. i don't imagine thats "worse".

__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF5 and MySQL

[Jochem van Dieten]

Peter Tilbrook wrote:
> Why would I not be able to select MySQL as a data provider under CF Admin
> (version 5 - MX was even worse)?

Because nobody ever bothered to write a plugin to add that option.

Jochem

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF5 and MySQL

[Peter Tilbrook]

Why would I not be able to select MySQL as a data provider under CF Admin
(version 5 - MX was even worse)?

I'm running Windows 2000 Advanced Server with IIS (fully patched - Broadband
is a godsend for that) and CF5 Professional.

Thanks!

==
Peter Tilbrook
Macromedia ColdFusion Applications Developer
4/73 Tharwa Road
Queanbeyan, NSW, 2620
AUSTRALIA

Phone: (02) 6284 2727
Mobile: 0401 973 415
Email: [EMAIL PROTECTED]
ICQ#: http://wwp.icq.com/666275
WWW: http://www.coldfusion.dns2go.com/

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Saturday, 29 June 2002 12:18 PM
To: CF-Talk
Subject: RE: Important security patch for CFMX


> > If you are using CFMX with IIS, please download and apply
> > this security patch.
> >
> > http://www.macromedia.com/v1/handlers/index.cfm?ID=23161
> > 
> >
> > To receive security bulletins automatically, you can
> > subscribe in the security zone.
> > http://www.macromedia.com/v1/developer/securityzone/
> > 
>
> Does the version of wsconfig.jar in the patch to support Apache
> 2.0.39 supersede the version of wsconfig.jar in this patch?

Oh, never mind, the answer is yes. It's right there in the Apache patch
release notes.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: What is the best variable scope?

[Andrew Scott]

Exactly my point, and as the user is not reading these emails then why
make that a point when you and I both know otherwise :-)


-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, 29 June 2002 8:44 AM
To: CF-Talk
Subject: RE: What is the best variable scope?

> Yes websites as in a website application, yours is
> different because as I said you have 1 website
> application that is pretending to be 1. And
> there is a difference!

Well, it's a semantic difference and liable to be confusing in
reference...
To IIS (or whatever webserver you're running) it's multiple sites ... To
the
DNS Server, it's multiple sites... To the visitors, it's multiple
sites...
It's only ever a single site or "website application" to the
programmer(s) /
developer(s) who build and maintain it. Which really makes the reference
to
it/them being a single site or "website application" useful to those
privileged few who happen to be on the inside of that loop. To anyone
else
viewing the sites it would be confusing.

Isaac

www.turnkey.to
954-776-0046


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists