Dynamic Stored Procedure

[BT]

I guys we have a cfquery that represents the below but it has  inner joins
with CF conditional logic in it...



I was wondering if there is a way in SQL on SQL7 to say if this variable is
passed the add a where clause or something..




 SELECT Jobs.JobID, Jobs.DateLastUpdated, Jobs.Title, Jobs.EID,
Jobs.DisplayEmployerName,
 Jobs.Country, Jobs.EmpJobID, Jobs.Description, Jobs.City,
Jobs.Image AS Image,
 JobListMSA.MSA AS MSA, JobListMSA.JobID AS JobID2,
JobsMSALookup.MSA AS MSA2
 FROM JobsMSALookup INNER JOIN
 JobListMSA ON
 JobsMSALookup.ID = JobListMSA.MSA INNER JOIN
 Jobs ON JobListMSA.JobID = Jobs.JobID
  WHERE #sitequal#

 AND (DateLastUpdated >= #Dates#)
  

AND ((Classification IN
(#PreserveSingleQuotes(Attributes.class)#))
 OR (Class2 IN (#PreserveSingleQuotes(Attributes.class)#))
 OR (Class3 IN (#PreserveSingleQuotes(Attributes.class)#))
 OR (Class4 IN (#PreserveSingleQuotes(Attributes.class)#)))


AND (JobListMSA.MSA IN (#PreserveSingleQuotes(Attributes.MSA)#))
 

AND (Country IN (#PreserveSingleQuotes(Attributes.Country)#))

AND (Country IN (#PreserveSingleQuotes(Attributes.Country)#))



 AND (Country <> 'United States')


 AND (#PreserveSingleQuotes(Querystring)#)

 ORDER BY eid desc, datelastupdated desc








~~
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: CF 5.0 Installation Problems...

[Lawrence B. Afrin, M.D.]

Philip --

Just wanted to say a big "thank you!" for your July 27th tip I found in
the archive about getting around a hang in the upgrade from 4.5 to 5.0.
I was kind of nervous about trying the uninstall 4.5/install 5.0 route,
so I tried stopping all nonessential services, and bingo, InstallShield
finally was able to run the installation.

-- Larry Afrin
   Med. Univ. of S.C.
   [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

Where best to embed META tag?

[JAIME HOI]

hi
   i am not sure where would be the best place to embed the META tag. I am
using FUSEBOX methodology. I also have a header template and a separate file
to store my global and and local variables. Presently i embed the tag in my
header template. Is it correct? 

  This is the tag :






 

  i tried to log in twice using 2 different user_ids. The data from user_1
can be seen by user_2. It seems like they are still retriving my local disk
instead of from the server. Why is this so ?? 



~~
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: [Run a CF page from a mail link??]

[Alex]

have the mailto:";>  be  with
redirect.cfm updateing the DB



"Rich Tretola" <[EMAIL PROTECTED]> wrote:
Is there anyway to run a CF page when a mail link is open?

I want to log the usage of an mailto:";> link by running a cf action
page that will update the db.

Thanks,
Rich
~~
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

Inexact Duplicate queries

[mistmp1]

 
I'm trying to merge 2 databases together, an having problem with the inexact
duplicates. 
I have no experience in this area, so anyone have any idea on how to do it?
 
 
Thanks in advance
 
Thanh
 


~~
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: Shopping Cart Software?

[John Anderson]

NetReady
http://www.aloha-webdesign.com

$350
Open source, fusebox, compatible with Access, Sql Server and Oracle.


John Anderson



-Original Message-
From: John Bowering [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 11:10 AM
To: CF-Talk
Subject: RE: Shopping Cart Software?


www.ecommercedemos.com

$99.00 - Open Source




-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 11:43 AM
To: CF-Talk
Subject: Shopping Cart Software?


Looking for a robust, full featured Shopping Cart system to integrate into
ColdFusion. I've heard a little about AbleCommerce, is this the best option?
It's a little on the pricey side at $3000 and $495 per additional store.

Anyone know of a good CF Cart application that won't bust the wallet?

Joshua Miller
Web Development::Programming
Eagle Technologies Group, Inc.
www.eagletgi.com
[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: and E-mail

[Kwang Suh]

Nope.

-Original Message-
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
Sent: August 1, 2001 11:28 AM
To: CF-Talk
Subject:  and E-mail


I'm going to send an e-mail with a text file attached.  Then I'm going to
delete the file.  With the file deletion, I know that I should use .
Should I lock the e-mail tag as well?

Thanks,

Eric Carlisle
ColdFusion Developer
~~
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: can't connect to mail server

[jeff]

Is this your mail server?
If not, the mail server administrator may have decided you are sending too
much email and shut you off.:o))
Sounds like the most likely thing if you haven't changed anything on your CF
Server.
I just recently installed CF 5 and could not connect to my own mail server
that was connected by a cross over cable. After trying everything 'I' could
think of, re-installing CF 5 fixed the problem.

Jeff Craig

- Original Message -
From: "S R" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, July 31, 2001 3:38 PM
Subject: can't connect to mail server


> Are there any ideas as to why Cold Fusion cannot connect to a mail server?
> You can rule out the mail server being down or change of address because I
> just tested it using a non-cold fusion program and I received an email.
When
> I go to the CF Admin and 'verify' the mail server connection I get 'Unable
> to connect to server'. It was working last week and today all of a sudden
I
> send any emails via CFmail or Cf_aspmail
>
~~
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: Stored Procedures

[Dave Watts]

> Sounds like you may be confusing Stored Procedures, which can't be 
> done in Access (actually, you can save a query in Access and call it 
> using cfstoredproc, but I don't believe you can pass variables to 
> it), with Scheduled Tasks.

You can pass parameters to Access parameter queries with CFSTOREDPROC.

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: Stored Procedures

[Bud]

On 8/1/01, Bruce, Rodney penned:
>I am using ACCESS, NT and IIS.   I am trying to run a set of queries
>as a stored procedure. 
>   I have created a page of all the queries and have tried to add it to
>the CF Administrator Scheduled tasks.  But when I try to run it,  CF admin
>gives me a  long list of possible reasons it can't run the task,  all
>dealing with URL. it can't be resolved, needs the / at the end of domain
>(which it is not :   /website/subd/cfpage.cfm),  URL is SSL.  and others. 
>
>Hope someone can help, I am lost!

Sounds like you may be confusing Stored Procedures, which can't be 
done in Access (actually, you can save a query in Access and call it 
using cfstoredproc, but I don't believe you can pass variables to 
it), with Scheduled Tasks.

If you put a full URL (https://secure.mydomain.com/page.cfm) in the 
the Scheduled task window it should work fine. Maybe I'm missing 
something?
-- 

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

AHH: CF Server Single User version

[Matt Brown]

I promised an answer to when this would be available and while I am glad
to say there is a solution coming, I don't have the details yet to post.
Stay tuned and hopefully in a few days or a week at most I will post a
detailed announcement.

We realize that there are a lot of folks that are running into this
issue and we are doing our best to get it solved.

Thanks for your patience.
~~
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

Run a CF page from a mail link??

[Rich Tretola]

Is there anyway to run a CF page when a mail link is open?

I want to log the usage of an mailto:";> link by running a cf action
page that will update the db.

Thanks,
Rich


~~
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: Cf code with ActivePDf

[Steve Aylor]

Ok ... so then you are able to fill in and open your pdf form with your cf
query data  but you just cant get this toolkit method for formatting
[Tlkt.SetDBMultiRowSeparator] to work with CF?

I may be misinterpretting what your doing - but I dont beleive the ActivePDf
com object is intuitive enuff to fill in your form correctly with your db
data just because the pdf form's field names coincide with with the names of
your columns in the database.

As I recall from memory and how the Adobe Active X FDF Toolkit works, you
need to use a method for "setting" the values of the fields.

See anything in the active pdf docs like :


To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 1:57 PM
Subject: RE: Cf code with ActivePDf


> Yes I have a pdf form with form fields with a #query.fieldname#-
> REportCard.pdf is my pdf file that I want to open/fill in.
>
> Tlkt.SetDBMultiRowSeparator- this is just a formatting thing that can be
> done...
>
> -Original Message-
> From: Steve Aylor [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 01, 2001 4:44 PM
> To: CF-Talk
> Subject: Re: Cf code with ActivePDf
>
>
>
> Where's your code to set the values of the fields in your pdf form?
>
> to confirm:
>
> You have created an actual pdf "FORM" using the full version of acrobat
and
> added the fields to the pdf and named the fields appropriately?  I presume
> that ReportCard.pdf is such a file?
>
> No idea what this is needed for - sorry
>
> 
>
>
> Steve
>
>
>
> - Original Message -
> From: "Janine Jakim" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 01, 2001 1:22 PM
> Subject: OT: Cf code with ActivePDf
>
>
> > Sorry for the OT post, but activepdf forums is down (and has been so
> > for over a month) and I'm tired of hitting my head against the wall.  I
am
> > trying to use active pdf toolkit to send my database query to a pdf
> form
> > I found an example in their docs but haven't been able to implement it
> > correctly.  Here's the cf page I put together.  I either get a plain
blank
> > screen or an error  message.
> >
> > The error msg I get is from the lines of code that have *** and states:
> > "attempting to call a method as a Propertyget assignment.  CF has
> determined
> > that this is actually a method with zero or more arguments.  If the
method
> > is expecting no arguments please use emptyp parenthesis"
> > The comment section states what I'm trying to achieve, the other part is
> the
> > cf.  Any/all comments would be greatly appreciated. Thanks in advance!
> >
> > 
> > 
> >  >
>
Tlkt.OpenOutputFile(ExpandPath("http://Server/Fusebox/PDFForms/ReportCard.pd
> > f"))>
> > 
> >  >
>
Tlkt.OpenInputFile(ExpandPath("http://Server/Fusebox/PDFForms/ReportCard.pdf
> > "))>
> > 
> > 
> > 
> > 
> > SELECT FIRSTNAME, LASTNAME
> > From ASTU_AllSchools
> > Order by LASTNAME, FIRSTNAME
> > 
> > 
> > 
> > #LASTNAME#, #FIRSTNAME#
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > is that setting it to null??
> >
> >
> >
> > Janine M. Jakim
> > Database Programmer/Analyst
> > Albemarle County Public Schools
> > Department of Technology
> > Phone: (804) 975-9443
> > Fax:   (804) 975-9442
> >
> >
> >
>
~~
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

ANN: SF area Gathering Today

[Matt Brown]

You are invited to a gathering tonight at the Thirsty
Bear in San Francisco from 6 to 8.

The goal of the gatherings is to get Macromedia users together in an
informal, non-marketing setting where we can all talk and just share war
stories about the Web. Macromedia takes care of the non-alcoholic
bevvies and appetizers and you take care of the beer.

See you there!
~~
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: new error

[Bruce Sorge]

>From the Allaire Site, Article 8849:

You receive PCode errors when browsing ColdFusion pages.

You may be receiving errors like the one below when browsing pages in your
ColdFusion application:

Error Occurred While Processing Request
Error Diagnostic Information
CMemoryException: unknown cause
pCodeRuntimeContextImp::executeSQLTagCFQuery::endTag

These errors can be caused by many different things. Here are two potential
resolutions to the error:

Using CFLOCK around all SESSION, APPLICATION and SERVER variables

Any time you set any SESSION, APPLICATION or SERVER variables in your
application, you should use CFLOCK. The CFLOCK tag provides locks to ensure
the integrity of shared data. Use CFLOCK to guarantee that multiple
concurrently executing requests do not manipulate shared data structures,
files, or CFXs in an inconsistent manner. For more information and syntax on
how to use CFLOCK, check out the CFML Tag Reference, which is included in
your ColdFusion Server documentation (both printed and online).

Upgrading Microsoft's ODBC Drivers

The ODBC drivers that Microsoft shipped with SQL Server 7.0 are not
compatible with ODBC Jet 3.5 applications (including Access). They have
since released a Service Pack which resolves this issue. Go to Microsoft's
web site for more information and to download MDAC 2.1, Service Pack 2 (GA).
You should also download and install the ColdFusion 4.01 update available
from http://www.allaire.com/download.

- Original Message -
From: "Douglas Jordon" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 4:27 PM
Subject: new error


> Has anyone ever seen this error:
>
> PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
>
> I'm getting it from: SELECT * FROM TABLE WHERE ID = #PASSED_ID#
>
> There are a lot of fields(54, to be exact). It works when I ask for less
> data.
>
> Any ideas?
>
> TIA,
>
> Doug Jordon
>
>
>
~~
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

Stored Procedures

[Bruce, Rodney]

Hello all

Hope you can tell me what I am doing wrong or if its even close.

I am using ACCESS, NT and IIS.   I am trying to run a set of queries
as a stored procedure.  
I have created a page of all the queries and have tried to add it to
the CF Administrator Scheduled tasks.  But when I try to run it,  CF admin
gives me a  long list of possible reasons it can't run the task,  all
dealing with URL. it can't be resolved, needs the / at the end of domain
(which it is not :   /website/subd/cfpage.cfm),  URL is SSL.  and others.  

Hope someone can help, I am lost!

Rodney


~~
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

new error

[Douglas Jordon]

Has anyone ever seen this error:

PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag

I'm getting it from: SELECT * FROM TABLE WHERE ID = #PASSED_ID#

There are a lot of fields(54, to be exact). It works when I ask for less
data.

Any ideas?

TIA,

Doug Jordon


~~
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: How can I insert a new record with no values?

[Dina Hess]

Thank you, Dave...but that didn't work either. Meanwhile, I've discovered the 
solution! Here it is, for all who come after:

INSERT INTO Table default values

Dina
  - Original Message - 
  From: Bosky, Dave 
  To: CF-Talk 
  Sent: Wednesday, August 01, 2001 3:37 PM
  Subject: RE: How can I insert a new record with no values?


  Insert ' ' as itemname

  -Original Message-
  From: Guy M. Saenger [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, August 01, 2001 4:24 PM
  To: CF-Talk
  Subject: Re: How can I insert a new record with no values?


  Sorry.  I am pretty sure that it works in SQL Server.  Was not sure about
  Access.

  --
  Guy M. Saenger
  [EMAIL PROTECTED]
  214.448.8887

  - Original Message -
  From: "Dina Hess" <[EMAIL PROTECTED]>
  To: "CF-Talk" <[EMAIL PROTECTED]>
  Sent: Wednesday, August 01, 2001 3:00 PM
  Subject: Re: How can I insert a new record with no values?


  > Guy,
  >
  > Thanks for your input...unfortunately, that query produces a row that
  overrides the autonumber with the value 0...
  >
  > back to the drawing board... :-)
  >
  > Dina
  >   - Original Message -
  >   From: Guy M. Saenger
  >   To: CF-Talk
  >   Sent: Wednesday, August 01, 2001 1:03 PM
  >   Subject: Re: How can I insert a new record with no values?
  >
  >
  >   Dina,
  >
  >   I think that you can do the following
  >
  >   insert into TableName (AutoNumberField) values (0)
  >
  >   I think that will create a row, assign the autonumber value, and
  populate
  >   the
  >   default value for the expiration date.
  >
  >   --
  >   Guy M. Saenger
  >   [EMAIL PROTECTED]
  >   214.448.8887
  >
  >   - Original Message -
  >   From: "Dina Hess" <[EMAIL PROTECTED]>
  >   To: "CF-Talk" <[EMAIL PROTECTED]>
  >   Sent: Wednesday, August 01, 2001 12:20 PM
  >   Subject: How can I insert a new record with no values?
  >
  >
  >   > Hello all,
  >   >
  >   > Would anyone be able to tell me how I can insert a row into a 
  > table
  that
  >   requires no values. My MS Access table stores only an auto number and an
  >   expiration date. The auto number, of course, is generated by the 
  > dbms
  and
  >   the expiration date, which is set to a default value, is also 
  > generated
  by
  >   the dbms, so there's no need for a field list or a values list in 
  > the
  SQL
  >   statement. CF doesn't like my syntax as follows:
  >   >
  >   > INSERT INTO Table ( )
  >   > VALUES ( )
  >   >
  >   > I've also tried a few other approaches---all to no avail. Your 
  > help
  would
  >   be much appreciated.
  >   >
  >   > TYIA,
  >   > Dina
  >   > Official Member of the CF Newbie Club :-)
  >   >
  >   >
  >   >
  >   >
  >
~~
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: Cf code with ActivePDf

[Janine Jakim]

Yes I have a pdf form with form fields with a #query.fieldname#-
REportCard.pdf is my pdf file that I want to open/fill in.

Tlkt.SetDBMultiRowSeparator- this is just a formatting thing that can be
done...

-Original Message-
From: Steve Aylor [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 4:44 PM
To: CF-Talk
Subject: Re: Cf code with ActivePDf



Where's your code to set the values of the fields in your pdf form?

to confirm:

You have created an actual pdf "FORM" using the full version of acrobat and
added the fields to the pdf and named the fields appropriately?  I presume
that ReportCard.pdf is such a file?

No idea what this is needed for - sorry




Steve



- Original Message -
From: "Janine Jakim" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 1:22 PM
Subject: OT: Cf code with ActivePDf


> Sorry for the OT post, but activepdf forums is down (and has been so
> for over a month) and I'm tired of hitting my head against the wall.  I am
> trying to use active pdf toolkit to send my database query to a pdf
form
> I found an example in their docs but haven't been able to implement it
> correctly.  Here's the cf page I put together.  I either get a plain blank
> screen or an error  message.
>
> The error msg I get is from the lines of code that have *** and states:
> "attempting to call a method as a Propertyget assignment.  CF has
determined
> that this is actually a method with zero or more arguments.  If the method
> is expecting no arguments please use emptyp parenthesis"
> The comment section states what I'm trying to achieve, the other part is
the
> cf.  Any/all comments would be greatly appreciated. Thanks in advance!
>
> 
> 
> 
Tlkt.OpenOutputFile(ExpandPath("http://Server/Fusebox/PDFForms/ReportCard.pd
> f"))>
> 
> 
Tlkt.OpenInputFile(ExpandPath("http://Server/Fusebox/PDFForms/ReportCard.pdf
> "))>
> 
> 
> 
> 
> SELECT FIRSTNAME, LASTNAME
> From ASTU_AllSchools
> Order by LASTNAME, FIRSTNAME
> 
> 
> 
> #LASTNAME#, #FIRSTNAME#
> 
> 
> 
> 
> 
> 
> 
> is that setting it to null??
>
>
>
> Janine M. Jakim
> Database Programmer/Analyst
> Albemarle County Public Schools
> Department of Technology
> Phone: (804) 975-9443
> Fax:   (804) 975-9442
>
>
>
~~
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: Cf code with ActivePDf

[Steve Aylor]

Where's your code to set the values of the fields in your pdf form?

to confirm:

You have created an actual pdf "FORM" using the full version of acrobat and
added the fields to the pdf and named the fields appropriately?  I presume
that ReportCard.pdf is such a file?

No idea what this is needed for - sorry




Steve



- Original Message -
From: "Janine Jakim" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 1:22 PM
Subject: OT: Cf code with ActivePDf


> Sorry for the OT post, but activepdf forums is down (and has been so
> for over a month) and I'm tired of hitting my head against the wall.  I am
> trying to use active pdf toolkit to send my database query to a pdf
form
> I found an example in their docs but haven't been able to implement it
> correctly.  Here's the cf page I put together.  I either get a plain blank
> screen or an error  message.
>
> The error msg I get is from the lines of code that have *** and states:
> "attempting to call a method as a Propertyget assignment.  CF has
determined
> that this is actually a method with zero or more arguments.  If the method
> is expecting no arguments please use emptyp parenthesis"
> The comment section states what I'm trying to achieve, the other part is
the
> cf.  Any/all comments would be greatly appreciated. Thanks in advance!
>
> 
> 
> 
Tlkt.OpenOutputFile(ExpandPath("http://Server/Fusebox/PDFForms/ReportCard.pd
> f"))>
> 
> 
Tlkt.OpenInputFile(ExpandPath("http://Server/Fusebox/PDFForms/ReportCard.pdf
> "))>
> 
> 
> 
> 
> SELECT FIRSTNAME, LASTNAME
> From ASTU_AllSchools
> Order by LASTNAME, FIRSTNAME
> 
> 
> 
> #LASTNAME#, #FIRSTNAME#
> 
> 
> 
> 
> 
> 
> 
> is that setting it to null??
>
>
>
> Janine M. Jakim
> Database Programmer/Analyst
> Albemarle County Public Schools
> Department of Technology
> Phone: (804) 975-9443
> Fax:   (804) 975-9442
>
>
>
~~
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: How can I insert a new record with no values?

[Bosky, Dave]

Insert ' ' as itemname

-Original Message-
From: Guy M. Saenger [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 01, 2001 4:24 PM
To: CF-Talk
Subject: Re: How can I insert a new record with no values?


Sorry.  I am pretty sure that it works in SQL Server.  Was not sure about
Access.

--
Guy M. Saenger
[EMAIL PROTECTED]
214.448.8887

- Original Message -
From: "Dina Hess" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 3:00 PM
Subject: Re: How can I insert a new record with no values?


> Guy,
>
> Thanks for your input...unfortunately, that query produces a row that
overrides the autonumber with the value 0...
>
> back to the drawing board... :-)
>
> Dina
>   - Original Message -
>   From: Guy M. Saenger
>   To: CF-Talk
>   Sent: Wednesday, August 01, 2001 1:03 PM
>   Subject: Re: How can I insert a new record with no values?
>
>
>   Dina,
>
>   I think that you can do the following
>
>   insert into TableName (AutoNumberField) values (0)
>
>   I think that will create a row, assign the autonumber value, and
populate
>   the
>   default value for the expiration date.
>
>   --
>   Guy M. Saenger
>   [EMAIL PROTECTED]
>   214.448.8887
>
>   - Original Message -
>   From: "Dina Hess" <[EMAIL PROTECTED]>
>   To: "CF-Talk" <[EMAIL PROTECTED]>
>   Sent: Wednesday, August 01, 2001 12:20 PM
>   Subject: How can I insert a new record with no values?
>
>
>   > Hello all,
>   >
>   > Would anyone be able to tell me how I can insert a row into a 
> table
that
>   requires no values. My MS Access table stores only an auto number and an
>   expiration date. The auto number, of course, is generated by the 
> dbms
and
>   the expiration date, which is set to a default value, is also 
> generated
by
>   the dbms, so there's no need for a field list or a values list in 
> the
SQL
>   statement. CF doesn't like my syntax as follows:
>   >
>   > INSERT INTO Table ( )
>   > VALUES ( )
>   >
>   > I've also tried a few other approaches---all to no avail. Your 
> help
would
>   be much appreciated.
>   >
>   > TYIA,
>   > Dina
>   > Official Member of the CF Newbie Club :-)
>   >
>   >
>   >
>   >
>
~~
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: Form question

[Braver, Ben]

Susan,

Thanks for the info.

In this case, somebody has a one-time paper form they want put on our
intranet, and they would like to electronically collect the info.

And of course they want it right away.  And they want it to look like the
paper form.  Obviously, I don't want to have to re-do the form from scratch.
But I don't want to invest a lot of time or resources into building
functionality that may rarely get used.

Was just fishing for shortcuts...

Ben


-Original Message-
From: Susan Allen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 1:13 PM
To: CF-Talk
Subject: RE: Form question


I've done a lot of converting Word docs to .pdf and building the form
functionality into the .pdf.  You can add a button (and code it NOT to show
on the form if it is printed) that will call a .cfm and do whatever: write
to the database, etc.  You can also fill the .pdf form automatically from a
database.  Is that too clungy for you?  I've used it very successfully for
an app that required a lot of mathematical calculations based on a few
inputs; the .pdf does all the math, and then the results are written to the
db.  It takes some time to get the form the way you want, but it looks like
the users' "paper" they were used to, and you can build a good deal of
functionality into it via java.

Susan Hamilton Allen
Information Technology Manager
MEVATEC Corporation
White Sands Missile Range, NM

>>> Braver, Ben 8/1/2001 11:54:50 AM >>>
Mike,

That's exactly the mental image I had, thanks!
i.e. having the HTML doc on the screen and "painting" fields over it.
Hadn't thought of it as a background, good idea :-)

Yes, users make odd requests because they just know what they want, they
don't know the limitations or quirks of the technology you're stuck with
using to make it happen .

Thanks.

Ben Braver
Information Technology
Ultramar Inc.
Golden Eagle Refinery
150 Solano Way
Martinez, CA  94553-1487
(925) 370-3673 voice
(925) 370-3393 fax
(510) 716-2557 pager
[EMAIL PROTECTED] 


-Original Message-
From: Tangorre, Mike [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 01, 2001 10:31 AM
To: CF-Talk
Subject: RE: Form question


Well you could save the word doc as HTML, then open the document up and add
the HTML for the fields. BE WARNED, Microsoft HTML is nasty to work in...
all kinds of crazy things going on.

My other suggestion: take a creen shot of the form. set the back ground to a
new page with the pic you just saved. Build the form... 

Kinda odd request bu I think I know what you are trying to do.  :-)

Mike

-Original Message-
From: Braver, Ben [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 01, 2001 1:06 PM
To: CF-Talk
Subject: OT: Form question


Hi gang,

I have no problem with using HTML forms or CFFORM to create forms.
But I'm being asked to convert an existing "paper-style" MS Word document to
a web form where info can be captured and emailed.

My question is: is there a way to "overlay" form elements onto an existing
doc saved as HTML without doing the form over from scratch?
Thanks.

Ben Braver
Information Technology
Ultramar Inc.
Golden Eagle Refinery
150 Solano Way
Martinez, CA  94553-1487
(925) 370-3673 voice
(925) 370-3393 fax
(510) 716-2557 pager
[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

OT: Cf code with ActivePDf

[Janine Jakim]

Sorry for the OT post, but activepdf forums is down (and has been so
for over a month) and I'm tired of hitting my head against the wall.  I am
trying to use active pdf toolkit to send my database query to a pdf form
I found an example in their docs but haven't been able to implement it
correctly.  Here's the cf page I put together.  I either get a plain blank
screen or an error  message.  

The error msg I get is from the lines of code that have *** and states:
"attempting to call a method as a Propertyget assignment.  CF has determined
that this is actually a method with zero or more arguments.  If the method
is expecting no arguments please use emptyp parenthesis"  
The comment section states what I'm trying to achieve, the other part is the
cf.  Any/all comments would be greatly appreciated. Thanks in advance!



http://Server/Fusebox/PDFForms/ReportCard.pd
f"))>

http://Server/Fusebox/PDFForms/ReportCard.pdf
"))>




SELECT FIRSTNAME, LASTNAME
>From ASTU_AllSchools
Order by LASTNAME, FIRSTNAME



#LASTNAME#, #FIRSTNAME#






 
is that setting it to null??



Janine M. Jakim
Database Programmer/Analyst
Albemarle County Public Schools
Department of Technology 
Phone: (804) 975-9443
Fax:   (804) 975-9442


~~
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: Random in SQL

[Kwang Suh]

The newid function is similar to the createUUID function in CF.  It
basically uses the MAC address of the network card in your server as a seed.
MAC addresses are guarateed to be unique to your network card.  Hah, and
they say we have privacy.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: August 1, 2001 1:41 PM
To: CF-Talk
Subject: RE: Random in SQL


I think I just had a page and a half of coldfusion code which generated 5
random numbers reduced to a single SQL statement.  Before I choke on a
green pepper from my subway sandwhich, can you tell me how the newid
function in SQL works?  I ran a test of select top 1000 and did not get any
duplicates (verified in access).  Will the SQL statement below always be
unique values? If it did not generate unique values for some reason I would
assume select distinct top 1000 would ensure uniqueness.  My real question
is: How does the newid function in SQL always know to pull 5 random numbers
each time.  It seems as though if you ran the query twice in a row you
would get the same top 5, but you dont.

CC




"Cruz, Joseph" <[EMAIL PROTECTED]> on 08/01/2001 01:58:17 PM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk <[EMAIL PROTECTED]>
cc:
Subject:  RE: Random in SQL



-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hey, BT.

If you're just interested in a random 5 items from a straight SELECT
statement,
try:

SELECT TOP 5 item_id
FROM base_table
ORDER BY NEWID()

:)

Or, a more ANSI-SQL compliant syntax:

SELECT TOP 5 item_id, newid() as new_id
FROM base_table
ORDER BY new_id

Either way, SQL server creates an aliased column of data type
uniqueidentifier.

HTH!

Joe


> -Original Message-
> From: BT [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 01, 2001 10:47 AM
> To: CF-Talk
> Subject: Random in SQL
>
>
>
>
>
>
> I am trying to get a random 5 items in SQL on SQL7 instead of
> on the cf side
>
>
>
> Anyone know?

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 7.0.3 for non-commercial use 

iQA/AwUBO2hSB9CGp5RuWHIBEQJbfQCg+Xwx9sIm8z0lwTJrIgmjjyh9B1cAoKgL
/6k1hXmONZY8Sr7C1h5npV8r
=tEQO
-END PGP SIGNATURE-
~~
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: Form question

[Susan Allen]

I've done a lot of converting Word docs to .pdf and building the form functionality 
into the .pdf.  You can add a button (and code it NOT to show on the form if it is 
printed) that will call a .cfm and do whatever: write to the database, etc.  You can 
also fill the .pdf form automatically from a database.  Is that too clungy for you?  
I've used it very successfully for an app that required a lot of mathematical 
calculations based on a few inputs; the .pdf does all the math, and then the results 
are written to the db.  It takes some time to get the form the way you want, but it 
looks like the users' "paper" they were used to, and you can build a good deal of 
functionality into it via java.

Susan Hamilton Allen
Information Technology Manager
MEVATEC Corporation
White Sands Missile Range, NM

>>> Braver, Ben 8/1/2001 11:54:50 AM >>>
Mike,

That's exactly the mental image I had, thanks!
i.e. having the HTML doc on the screen and "painting" fields over it.
Hadn't thought of it as a background, good idea :-)

Yes, users make odd requests because they just know what they want, they
don't know the limitations or quirks of the technology you're stuck with
using to make it happen .

Thanks.

Ben Braver
Information Technology
Ultramar Inc.
Golden Eagle Refinery
150 Solano Way
Martinez, CA  94553-1487
(925) 370-3673 voice
(925) 370-3393 fax
(510) 716-2557 pager
[EMAIL PROTECTED] 


-Original Message-
From: Tangorre, Mike [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 01, 2001 10:31 AM
To: CF-Talk
Subject: RE: Form question


Well you could save the word doc as HTML, then open the document up and add
the HTML for the fields. BE WARNED, Microsoft HTML is nasty to work in...
all kinds of crazy things going on.

My other suggestion: take a creen shot of the form. set the back ground to a
new page with the pic you just saved. Build the form... 

Kinda odd request bu I think I know what you are trying to do.  :-)

Mike

-Original Message-
From: Braver, Ben [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 01, 2001 1:06 PM
To: CF-Talk
Subject: OT: Form question


Hi gang,

I have no problem with using HTML forms or CFFORM to create forms.
But I'm being asked to convert an existing "paper-style" MS Word document to
a web form where info can be captured and emailed.

My question is: is there a way to "overlay" form elements onto an existing
doc saved as HTML without doing the form over from scratch?
Thanks.

Ben Braver
Information Technology
Ultramar Inc.
Golden Eagle Refinery
150 Solano Way
Martinez, CA  94553-1487
(925) 370-3673 voice
(925) 370-3393 fax
(510) 716-2557 pager
[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: How can I insert a new record with no values?

[Guy M. Saenger]

Sorry.  I am pretty sure that it works in SQL Server.  Was not sure about
Access.

--
Guy M. Saenger
[EMAIL PROTECTED]
214.448.8887

- Original Message -
From: "Dina Hess" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 3:00 PM
Subject: Re: How can I insert a new record with no values?


> Guy,
>
> Thanks for your input...unfortunately, that query produces a row that
overrides the autonumber with the value 0...
>
> back to the drawing board... :-)
>
> Dina
>   - Original Message -
>   From: Guy M. Saenger
>   To: CF-Talk
>   Sent: Wednesday, August 01, 2001 1:03 PM
>   Subject: Re: How can I insert a new record with no values?
>
>
>   Dina,
>
>   I think that you can do the following
>
>   insert into TableName (AutoNumberField) values (0)
>
>   I think that will create a row, assign the autonumber value, and
populate
>   the
>   default value for the expiration date.
>
>   --
>   Guy M. Saenger
>   [EMAIL PROTECTED]
>   214.448.8887
>
>   - Original Message -
>   From: "Dina Hess" <[EMAIL PROTECTED]>
>   To: "CF-Talk" <[EMAIL PROTECTED]>
>   Sent: Wednesday, August 01, 2001 12:20 PM
>   Subject: How can I insert a new record with no values?
>
>
>   > Hello all,
>   >
>   > Would anyone be able to tell me how I can insert a row into a table
that
>   requires no values. My MS Access table stores only an auto number and an
>   expiration date. The auto number, of course, is generated by the dbms
and
>   the expiration date, which is set to a default value, is also generated
by
>   the dbms, so there's no need for a field list or a values list in the
SQL
>   statement. CF doesn't like my syntax as follows:
>   >
>   > INSERT INTO Table ( )
>   > VALUES ( )
>   >
>   > I've also tried a few other approaches---all to no avail. Your help
would
>   be much appreciated.
>   >
>   > TYIA,
>   > Dina
>   > Official Member of the CF Newbie Club :-)
>   >
>   >
>   >
>   >
>
~~
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: /// Unable to use wildcard in Verity search

[Hinojosa, Robert A]

the search is done with *'s on both sides of the search, not % signs.  You
might also want to make the criteria lowercase or uppercase to kill case
sensitivity.




HTH,

Robert

-Original Message-
From: Jason Blum [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 12:37 PM
To: CF-Talk
Subject: /// Unable to use wildcard in Verity search


Hi everyone!  

Here is my simple query for data with which to refresh my collection:


SELECT PERSON_ID, FIRST_NAME, LAST_NAME
FROM TBL_PERSON




And here is the search



...all pretty straightforward - and searching is fine.  I can search for
John Doe, John, Doe, John AND Doe, John OR Mary, etc...

But for some reason, I cannot search for %ohn or Jo*

Anybody know if I am missing something?

Thanks!

-J
~~
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

Cybersource

[Guy M. Saenger]

A company I am doing work for is looking at Cybersource at the payment
processor and all development is
being done in Cold Fusion.  The business rules call for authorization of the
credit card to happen both
through a Web interface and through weekly recurring batches.  In addition,
the settlement for both
types of authorization will have to be done in batch later during the week.
I was starting to look
at the CFX_Cybersource tag but wanted to see what the experience with it
was.  I am thinking about
possibly using the CFX tag for even the batch processing by scheduling a job
to run and pass a
.cfm file straight to the Cold Fusion executable to query to the database
and loop through the entries
processing each one through the tag.  Has anyone encountered any speed
issues or other problems
with this tag?

Thanks,

--
Guy M. Saenger
[EMAIL PROTECTED]
214.448.8887


- Original Message -
From: "Jon Gage" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 2:56 PM
Subject: RE: Random in SQL


> What do you mean?  I've used the tag and it's pretty straightforward.
>
> > -Original Message-
> > From: Guy M. Saenger [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, August 01, 2001 4:00 PM
> > To: CF-Talk
> > Subject: Re: Random in SQL
> >
> >
> > Anyone ever built a commerce site in Cold Fusion to use Cybersource?
Any
> > recommendations for tags to
> > use, things to watch out for, etc.?
> >
> > --
> > Guy M. Saenger
> > [EMAIL PROTECTED]
> > 214.448.8887
> >


~~
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: How can I insert a new record with no values?

[Dina Hess]

Pete,

I thought your suggestion would be the answer...the syntax seemed familiar...but, 
alas, CF Server balks again...thank you for the suggestion...

Dina
  - Original Message - 
  From: Pete Freitag 
  To: CF-Talk 
  Sent: Wednesday, August 01, 2001 1:07 PM
  Subject: RE: How can I insert a new record with no values?


  Have you tried just: INSERT INTO Table  ?


  Pete Freitag ([EMAIL PROTECTED])
  CFDEV.COM
  ColdFusion Developers Resources
  http://www.cfdev.com/

  -Original Message-
  From: Dina Hess [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, August 01, 2001 1:20 PM
  To: CF-Talk
  Subject: How can I insert a new record with no values?


  Hello all,

  Would anyone be able to tell me how I can insert a row into a table that
  requires no values. My MS Access table stores only an auto number and an
  expiration date. The auto number, of course, is generated by the dbms and
  the expiration date, which is set to a default value, is also generated by
  the dbms, so there's no need for a field list or a values list in the SQL
  statement. CF doesn't like my syntax as follows:

  INSERT INTO Table ( )
  VALUES ( )

  I've also tried a few other approaches---all to no avail. Your help would be
  much appreciated.

  TYIA,
  Dina
  Official Member of the CF Newbie Club :-)
~~
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: How can I insert a new record with no values?

[Dina Hess]

I may have to do that! Thanks for the suggestion.
  - Original Message - 
  From: Costas Piliotis 
  To: CF-Talk 
  Sent: Wednesday, August 01, 2001 12:54 PM
  Subject: RE: How can I insert a new record with no values?


  Create a garbage field.  It's the only way.  I know in sql server, you just
  set identity insert off, but I don't think Access has that.

  Isn't it easier to just insert a null value into a garbage field and be done
  with it?



  -Original Message-
  From: Dina Hess [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, August 01, 2001 10:20 AM
  To: CF-Talk
  Subject: How can I insert a new record with no values?


  Hello all,

  Would anyone be able to tell me how I can insert a row into a table that
  requires no values. My MS Access table stores only an auto number and an
  expiration date. The auto number, of course, is generated by the dbms and
  the expiration date, which is set to a default value, is also generated by
  the dbms, so there's no need for a field list or a values list in the SQL
  statement. CF doesn't like my syntax as follows:

  INSERT INTO Table ( )
  VALUES ( )

  I've also tried a few other approaches---all to no avail. Your help would be
  much appreciated.

  TYIA,
  Dina
  Official Member of the CF Newbie Club :-)
~~
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: How can I insert a new record with no values?

[Dina Hess]

Philip,

The autonumber field in my query does not accept nulls...but thank you for your 
input...

Dina
  - Original Message - 
  From: Philip Arnold - ASP 
  To: CF-Talk 
  Sent: Wednesday, August 01, 2001 12:50 PM
  Subject: RE: How can I insert a new record with no values?


  > Would anyone be able to tell me how I can insert a row into a
  > table that requires no values. My MS Access table stores only an
  > auto number and an expiration date. The auto number, of course,
  > is generated by the dbms and the expiration date, which is set to
  > a default value, is also generated by the dbms, so there's no
  > need for a field list or a values list in the SQL statement. CF
  > doesn't like my syntax as follows:
  >
  > INSERT INTO Table ( )
  > VALUES ( )
  >
  > I've also tried a few other approaches---all to no avail. Your
  > help would be much appreciated.

  INSERT INTO Table (Field1)
  VALUES (NULL)

  That should do it as long as the field can accept NULL values

  Philip Arnold
  Director
  Certified ColdFusion Developer
  ASP Multimedia Limited
  T: +44 (0)20 8680 1133

  "Websites for the real world"

  **
  This email and any files transmitted with it are confidential and
  intended solely for the use of the individual or entity to whom they
  are addressed. If you have received this email in error please notify
  the system manager.
  **
~~
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: How can I insert a new record with no values?

[Dina Hess]

Guy,

Thanks for your input...unfortunately, that query produces a row that overrides the 
autonumber with the value 0...

back to the drawing board... :-)

Dina
  - Original Message - 
  From: Guy M. Saenger 
  To: CF-Talk 
  Sent: Wednesday, August 01, 2001 1:03 PM
  Subject: Re: How can I insert a new record with no values?


  Dina,

  I think that you can do the following

  insert into TableName (AutoNumberField) values (0)

  I think that will create a row, assign the autonumber value, and populate
  the
  default value for the expiration date.

  --
  Guy M. Saenger
  [EMAIL PROTECTED]
  214.448.8887

  - Original Message -
  From: "Dina Hess" <[EMAIL PROTECTED]>
  To: "CF-Talk" <[EMAIL PROTECTED]>
  Sent: Wednesday, August 01, 2001 12:20 PM
  Subject: How can I insert a new record with no values?


  > Hello all,
  >
  > Would anyone be able to tell me how I can insert a row into a table that
  requires no values. My MS Access table stores only an auto number and an
  expiration date. The auto number, of course, is generated by the dbms and
  the expiration date, which is set to a default value, is also generated by
  the dbms, so there's no need for a field list or a values list in the SQL
  statement. CF doesn't like my syntax as follows:
  >
  > INSERT INTO Table ( )
  > VALUES ( )
  >
  > I've also tried a few other approaches---all to no avail. Your help would
  be much appreciated.
  >
  > TYIA,
  > Dina
  > Official Member of the CF Newbie Club :-)
  >
  >
  >
  >
~~
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

/// Unable to use wildcard in Verity search

[Jason Blum]

Hi everyone!  

Here is my simple query for data with which to refresh my collection:


SELECT PERSON_ID, FIRST_NAME, LAST_NAME
FROM TBL_PERSON




And here is the search



...all pretty straightforward - and searching is fine.  I can search for
John Doe, John, Doe, John AND Doe, John OR Mary, etc...

But for some reason, I cannot search for %ohn or Jo*

Anybody know if I am missing something?

Thanks!

-J


~~
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: Random in SQL

[Jon Gage]

What do you mean?  I've used the tag and it's pretty straightforward.

> -Original Message-
> From: Guy M. Saenger [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 01, 2001 4:00 PM
> To: CF-Talk
> Subject: Re: Random in SQL
>
>
> Anyone ever built a commerce site in Cold Fusion to use Cybersource?  Any
> recommendations for tags to
> use, things to watch out for, etc.?
>
> --
> Guy M. Saenger
> [EMAIL PROTECTED]
> 214.448.8887
>
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 01, 2001 2:40 PM
> Subject: RE: Random in SQL
>
>
> > I think I just had a page and a half of coldfusion code which
> generated 5
> > random numbers reduced to a single SQL statement.  Before I choke on a
> > green pepper from my subway sandwhich, can you tell me how the newid
> > function in SQL works?  I ran a test of select top 1000 and did not get
> any
> > duplicates (verified in access).  Will the SQL statement below always be
> > unique values? If it did not generate unique values for some reason I
> would
> > assume select distinct top 1000 would ensure uniqueness.  My
> real question
> > is: How does the newid function in SQL always know to pull 5 random
> numbers
> > each time.  It seems as though if you ran the query twice in a row you
> > would get the same top 5, but you dont.
> >
> > CC
> >
> >
> >
> >
> > "Cruz, Joseph" <[EMAIL PROTECTED]> on 08/01/2001 01:58:17 PM
> >
> > Please respond to [EMAIL PROTECTED]
> >
> > To:   CF-Talk <[EMAIL PROTECTED]>
> > cc:
> > Subject:  RE: Random in SQL
> >
> >
> >
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > Hey, BT.
> >
> > If you're just interested in a random 5 items from a straight SELECT
> > statement,
> > try:
> >
> > SELECT TOP 5 item_id
> > FROM base_table
> > ORDER BY NEWID()
> >
> > :)
> >
> > Or, a more ANSI-SQL compliant syntax:
> >
> > SELECT TOP 5 item_id, newid() as new_id
> > FROM base_table
> > ORDER BY new_id
> >
> > Either way, SQL server creates an aliased column of data type
> > uniqueidentifier.
> >
> > HTH!
> >
> > Joe
> >
> >
> > > -Original Message-
> > > From: BT [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, August 01, 2001 10:47 AM
> > > To: CF-Talk
> > > Subject: Random in SQL
> > >
> > >
> > >
> > >
> > >
> > >
> > > I am trying to get a random 5 items in SQL on SQL7 instead of
> > > on the cf side
> > >
> > >
> > >
> > > Anyone know?
> >
> > -BEGIN PGP SIGNATURE-
> > Version: PGPfreeware 7.0.3 for non-commercial use 
> >
> > iQA/AwUBO2hSB9CGp5RuWHIBEQJbfQCg+Xwx9sIm8z0lwTJrIgmjjyh9B1cAoKgL
> > /6k1hXmONZY8Sr7C1h5npV8r
> > =tEQO
> > -END PGP SIGNATURE-
> >
>
~~
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

Icalendar doesn't work after server security patches?

[Paul Ihrig]

ok just found out that the icalendar button i added to my forms to allow
users to add info to there calendars in outlook no longer works after i did
all the standard security patches & upgrades to the web server.

does any one know what i can do about this?

the error i get is

HTTP Error 405
405 Method Not Allowed

The method specified in the Request Line is not allowed for the resource
identified by the request. Please ensure that you have the proper MIME type
set up for the resource you are requesting.

Please contact the server's administrator if this problem persists.

so can i still use this or is it considered a security risk?

thanks

-paul

~~
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: Random in SQL

[Guy M. Saenger]

Anyone ever built a commerce site in Cold Fusion to use Cybersource?  Any
recommendations for tags to
use, things to watch out for, etc.?

--
Guy M. Saenger
[EMAIL PROTECTED]
214.448.8887


- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 2:40 PM
Subject: RE: Random in SQL


> I think I just had a page and a half of coldfusion code which generated 5
> random numbers reduced to a single SQL statement.  Before I choke on a
> green pepper from my subway sandwhich, can you tell me how the newid
> function in SQL works?  I ran a test of select top 1000 and did not get
any
> duplicates (verified in access).  Will the SQL statement below always be
> unique values? If it did not generate unique values for some reason I
would
> assume select distinct top 1000 would ensure uniqueness.  My real question
> is: How does the newid function in SQL always know to pull 5 random
numbers
> each time.  It seems as though if you ran the query twice in a row you
> would get the same top 5, but you dont.
>
> CC
>
>
>
>
> "Cruz, Joseph" <[EMAIL PROTECTED]> on 08/01/2001 01:58:17 PM
>
> Please respond to [EMAIL PROTECTED]
>
> To:   CF-Talk <[EMAIL PROTECTED]>
> cc:
> Subject:  RE: Random in SQL
>
>
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hey, BT.
>
> If you're just interested in a random 5 items from a straight SELECT
> statement,
> try:
>
> SELECT TOP 5 item_id
> FROM base_table
> ORDER BY NEWID()
>
> :)
>
> Or, a more ANSI-SQL compliant syntax:
>
> SELECT TOP 5 item_id, newid() as new_id
> FROM base_table
> ORDER BY new_id
>
> Either way, SQL server creates an aliased column of data type
> uniqueidentifier.
>
> HTH!
>
> Joe
>
>
> > -Original Message-
> > From: BT [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, August 01, 2001 10:47 AM
> > To: CF-Talk
> > Subject: Random in SQL
> >
> >
> >
> >
> >
> >
> > I am trying to get a random 5 items in SQL on SQL7 instead of
> > on the cf side
> >
> >
> >
> > Anyone know?
>
> -BEGIN PGP SIGNATURE-
> Version: PGPfreeware 7.0.3 for non-commercial use 
>
> iQA/AwUBO2hSB9CGp5RuWHIBEQJbfQCg+Xwx9sIm8z0lwTJrIgmjjyh9B1cAoKgL
> /6k1hXmONZY8Sr7C1h5npV8r
> =tEQO
> -END PGP SIGNATURE-
>
~~
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: Random in SQL

[ccook22]

I think I just had a page and a half of coldfusion code which generated 5
random numbers reduced to a single SQL statement.  Before I choke on a
green pepper from my subway sandwhich, can you tell me how the newid
function in SQL works?  I ran a test of select top 1000 and did not get any
duplicates (verified in access).  Will the SQL statement below always be
unique values? If it did not generate unique values for some reason I would
assume select distinct top 1000 would ensure uniqueness.  My real question
is: How does the newid function in SQL always know to pull 5 random numbers
each time.  It seems as though if you ran the query twice in a row you
would get the same top 5, but you dont.

CC




"Cruz, Joseph" <[EMAIL PROTECTED]> on 08/01/2001 01:58:17 PM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk <[EMAIL PROTECTED]>
cc:
Subject:  RE: Random in SQL



-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hey, BT.

If you're just interested in a random 5 items from a straight SELECT
statement,
try:

SELECT TOP 5 item_id
FROM base_table
ORDER BY NEWID()

:)

Or, a more ANSI-SQL compliant syntax:

SELECT TOP 5 item_id, newid() as new_id
FROM base_table
ORDER BY new_id

Either way, SQL server creates an aliased column of data type
uniqueidentifier.

HTH!

Joe


> -Original Message-
> From: BT [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 01, 2001 10:47 AM
> To: CF-Talk
> Subject: Random in SQL
>
>
>
>
>
>
> I am trying to get a random 5 items in SQL on SQL7 instead of
> on the cf side
>
>
>
> Anyone know?

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 7.0.3 for non-commercial use 

iQA/AwUBO2hSB9CGp5RuWHIBEQJbfQCg+Xwx9sIm8z0lwTJrIgmjjyh9B1cAoKgL
/6k1hXmONZY8Sr7C1h5npV8r
=tEQO
-END PGP SIGNATURE-
~~
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

CfmlValidator exception

[Christian Abad]

Hello, All!

Has anyone else ever experienced the following error when Validating
(Shift+F6) a CFML/HTML document in CF Studio 4.5.2?

"CfmlValidator exception. Please contact support with the template that gave
this message."

Nothing I do seems to remedy this problem.

Even after searching the MacroAllaire Knowledge Base and Forums, I still
have no ideas...

Any Help?

Thanks,

Christian N. Abad
ColdFusion Web Developer
Bank of America, eCommerce Technology


~~
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: storing random generated data as a textfile.

[Scott Weikert]

You just need to build up a string variable with the HTML code in it, then
write it out with CFFILE. Like...



" & Color & "" & Type &
"">

etc etc.

- Original Message -
From: "BT" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 12:28 PM
Subject: storing random generated data as a textfile.


> Please not flames from car owners... This question is nothing personal...
> But if you do own a brown pinto; I'm sorry.
>
>
> I have a column which has several cars as such:
> ID Color Type
> 1 Blue Chrysler
> 2 Black Ford
> 3 Red Diablo
> 4 Brown Pinto
>
> I want to generate 2 different text files that have 2 different items  and
> HTML in each file so maybe #Color#Chrysler
>
> How to I store the output WITH HTML in a text file?
> Or I could set it as a variable then how do I set a variable with "<"'s in
> it?
>
>
>
~~
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: storing random generated data as a textfile.

[DeWitt, Steve]

to write html to a file:






-Original Message-
From: BT [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 11:29 AM
To: CF-Talk
Subject: storing random generated data as a textfile.


Please not flames from car owners... This question is nothing personal...
But if you do own a brown pinto; I'm sorry.


I have a column which has several cars as such:
ID  Color   Type
1   BlueChrysler
2   Black   Ford
3   Red Diablo
4   Brown   Pinto

I want to generate 2 different text files that have 2 different items  and
HTML in each file so maybe #Color#Chrysler

How to I store the output WITH HTML in a text file?
Or I could set it as a variable then how do I set a variable with "<"'s in
it?
~~
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: Random in SQL

[Cruz, Joseph]

 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hey, BT.

If you're just interested in a random 5 items from a straight SELECT statement,
try:

SELECT TOP 5 item_id
FROM base_table
ORDER BY NEWID()

:)

Or, a more ANSI-SQL compliant syntax:

SELECT TOP 5 item_id, newid() as new_id
FROM base_table
ORDER BY new_id

Either way, SQL server creates an aliased column of data type uniqueidentifier.

HTH!

Joe


> -Original Message-
> From: BT [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 01, 2001 10:47 AM
> To: CF-Talk
> Subject: Random in SQL
> 
> 
> 
> 
> 
> 
> I am trying to get a random 5 items in SQL on SQL7 instead of 
> on the cf side
> 
> 
> 
> Anyone know?

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 7.0.3 for non-commercial use 

iQA/AwUBO2hSB9CGp5RuWHIBEQJbfQCg+Xwx9sIm8z0lwTJrIgmjjyh9B1cAoKgL
/6k1hXmONZY8Sr7C1h5npV8r
=tEQO
-END PGP SIGNATURE-

~~
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

storing random generated data as a textfile.

[BT]

Please not flames from car owners... This question is nothing personal...
But if you do own a brown pinto; I'm sorry.


I have a column which has several cars as such:
ID  Color   Type
1   BlueChrysler
2   Black   Ford
3   Red Diablo
4   Brown   Pinto

I want to generate 2 different text files that have 2 different items  and
HTML in each file so maybe #Color#Chrysler

How to I store the output WITH HTML in a text file?
Or I could set it as a variable then how do I set a variable with "<"'s in
it?


~~
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: Random in SQL

[DeWitt, Steve]

there is a rand function but I have never used it.

-Original Message-
From: BT [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 10:47 AM
To: CF-Talk
Subject: Random in SQL






I am trying to get a random 5 items in SQL on SQL7 instead of on the cf
side



Anyone know?
~~
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

Apache 1.3.20

[Justin Greene]

Is anyone running CF with Apache 1.3.20?  We have just upgraded and
everything appears OK but an Apache -S shows the error:

[Wed Aug 01 14:04:07 2001] [warn] Loaded DSO
modules/ApacheModuleColdFusion.dll
uses plain Apache 1.3 API, this module might crash under EAPI! (please
recompile
 it with -DEAPI)

Anyone know if there is a -DEAPI build of the Cold Fusion DLL?

Justin




~~
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: Question: Creating a primary key field

[Joseph Thompson]

I have found that you can "rollback" transactions in Access 2000 Access
97 doesn't support transactions though.


> scratch the , Access does not support it
>
>
> 
> INSERT INTO Contact( the fields... )
> VALUES ( the values... )
> 
>
> 
> SELECT MAX(ID) AS TheID
> FROM ContactInfo
> 
>
> 
> INSERT INTO ContactInfo ( ContactID, the fields... )
> VALUES (#qry_getnewid.TheID#, the values..)
> 
>
>
>
> The cftransaction tag will ensure that no other records will be inserted
> into these tables while processing the queries between the start and end
of
> the transaction.
>
> -s
>
> Stuart Miller
> Rocom New Media
> t: 01937 487492
> e: [EMAIL PROTECTED]
> w: http://www.rocom.co.uk
>
>
>
> -Original Message-
> From: Shannon Rhodes [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 01, 2001 2:41 PM
> To: CF-Talk
> Subject: Question: Creating a primary key field
>
>
> Is it possible to query which was the last ID number created (autonumber
> field in Access) for the purpose of adding 1 to explicitly state the new
ID
> number for a newly created record?
>
> The reason why I ask is that I'm having trouble inserting my new info into
> two separate tables because I need the newly created ID number for table A
> to be inserted into table B.  If I can't "guess" what the number will be,
> I'm stuck trying to take the user through a second page where I insert
into
> table A then turn around and query the new record to insert the new field
> into table B.  That leaves me with the problem of what to do if the user
> abandons the application on the second page, leaving no new record created
> in table B.
>
> This may sound like screwy application design (and maybe it is, I'm still
> pretty new at this), but the problem is that table A contains contact
> information, while table B contains all other information (class
> registration, payment methods, etc), and they have a one-to-one
relationship
> because I may need to change which person the info is associated with
(it's
> possible that a person will register and pay for a class, but a co-worker
> will attend in their place).  I can't make the classID a primary key in
> table B either (the person could decide to switch classes) so I just have
an
> autonumber as a primary key.  Argh!  All suggestions welcomed.
>
> TIA,
> Shannon
> [EMAIL PROTECTED]
>
>
>
> 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
>
~~
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: Shopping Cart Software?

[John Bowering]

www.ecommercedemos.com

$99.00 - Open Source




-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 11:43 AM
To: CF-Talk
Subject: Shopping Cart Software?


Looking for a robust, full featured Shopping Cart system to integrate into
ColdFusion. I've heard a little about AbleCommerce, is this the best option?
It's a little on the pricey side at $3000 and $495 per additional store.

Anyone know of a good CF Cart application that won't bust the wallet?

Joshua Miller
Web Development::Programming
Eagle Technologies Group, Inc.
www.eagletgi.com
[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: How can I insert a new record with no values?

[Pete Freitag]

Have you tried just: INSERT INTO Table  ?


Pete Freitag ([EMAIL PROTECTED])
CFDEV.COM
ColdFusion Developers Resources
http://www.cfdev.com/

-Original Message-
From: Dina Hess [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 1:20 PM
To: CF-Talk
Subject: How can I insert a new record with no values?


Hello all,

Would anyone be able to tell me how I can insert a row into a table that
requires no values. My MS Access table stores only an auto number and an
expiration date. The auto number, of course, is generated by the dbms and
the expiration date, which is set to a default value, is also generated by
the dbms, so there's no need for a field list or a values list in the SQL
statement. CF doesn't like my syntax as follows:

INSERT INTO Table ( )
VALUES ( )

I've also tried a few other approaches---all to no avail. Your help would be
much appreciated.

TYIA,
Dina
Official Member of the CF Newbie Club :-)
~~
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: Sort by 1st three letters of month?

[Carlisle, Eric]

Maybe ParseDateTime() would save you some time.

-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 4:23 PM
To: CF-Talk
Subject: Sort by 1st three letters of month?


Ok, I'm an idiot.  I have my users putting in text strings for months.

I need 

Jan. 12

to be ordered ahead of 

Aug. 9

These are text records.  Is there any way to do this?  I guess I could parse
out the first three characters of whatever my user entered, run it through a
big cfswitch to assign numerical values to the months, add a leading zero to
the day part...

Is there any easier way?

Willy
~~
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

ActivePdf - Support List

[Gordon Burns]

I am using Active PDF and finding the product is good but support 
is not fantastic.

Slow responses by email and no support forum or list.

I was thinking of starting a list for those of us using it with CF 
as a lot of the examples etc are based around ASP.

Would anyone be interested?

If so mail me off list and I will sort something out.

Regards

Gordon



At 12:11 01/08/01 -0400 Janine Jakim said
>has anyone used the active pdf?  How do you set the master query/related
>query in CF???  I've been going through all the examples that they have and
>I haven't come across how they do a db to form in  cf.  All their examples
>that have to do with db are in asp.  Any help would be greatly appreciated.
>Thanks,
>janine
>
>
~~
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: Image Resizing tags

[Pete Freitag]

I think all of them can deal with compression when they are decoded, but
after they are resized most image libraries allow you to specify a
compression ratio for compressing JPEGs, perhaps not all tags implemented
this feature, so you want to look for a tag that will let you specify a
compression ratio.

The reason the resize creates a larger file, is because most compression
algorithms for JPEG default at 75% where you might have made the file with
50 or 25%

I am currently working on a Resize tag, it will be written in Java, and the
source will be available.


Pete Freitag ([EMAIL PROTECTED])
CFDEV.COM
ColdFusion Developers Resources
http://www.cfdev.com/

-Original Message-
From: Scott Weikert [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 1:05 PM
To: CF-Talk
Subject: Image Resizing tags


Hey gang -

Does anyone out there who's messed with tags like "CF_ImageSize" have any
info on the nature of the files these tags produce, especially when it comes
to running pre-compressed images through them? I'm digging around trying to
settle on one of these tags, but I don't want to end up tossing, say, a 3k
JPG through one of these tags, trimming it down width/height-wise, and end
up with a larger file than I started with because the tag couldn't deal with
compression.

Thanks in adavance,
--Scott
~~
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: Form question

[Braver, Ben]

Mike,

That's exactly the mental image I had, thanks!
i.e. having the HTML doc on the screen and "painting" fields over it.
Hadn't thought of it as a background, good idea :-)

Yes, users make odd requests because they just know what they want, they
don't know the limitations or quirks of the technology you're stuck with
using to make it happen .

Thanks.

Ben Braver
Information Technology
Ultramar Inc.
Golden Eagle Refinery
150 Solano Way
Martinez, CA  94553-1487
(925) 370-3673 voice
(925) 370-3393 fax
(510) 716-2557 pager
[EMAIL PROTECTED]


-Original Message-
From: Tangorre, Mike [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 10:31 AM
To: CF-Talk
Subject: RE: Form question


Well you could save the word doc as HTML, then open the document up and add
the HTML for the fields. BE WARNED, Microsoft HTML is nasty to work in...
all kinds of crazy things going on.

My other suggestion: take a creen shot of the form. set the back ground to a
new page with the pic you just saved. Build the form... 

Kinda odd request bu I think I know what you are trying to do.  :-)

Mike

-Original Message-
From: Braver, Ben [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 1:06 PM
To: CF-Talk
Subject: OT: Form question


Hi gang,

I have no problem with using HTML forms or CFFORM to create forms.
But I'm being asked to convert an existing "paper-style" MS Word document to
a web form where info can be captured and emailed.

My question is: is there a way to "overlay" form elements onto an existing
doc saved as HTML without doing the form over from scratch?
Thanks.

Ben Braver
Information Technology
Ultramar Inc.
Golden Eagle Refinery
150 Solano Way
Martinez, CA  94553-1487
(925) 370-3673 voice
(925) 370-3393 fax
(510) 716-2557 pager
[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: How can I insert a new record with no values?

[Costas Piliotis]

Create a garbage field.  It's the only way.  I know in sql server, you just
set identity insert off, but I don't think Access has that.

Isn't it easier to just insert a null value into a garbage field and be done
with it?



-Original Message-
From: Dina Hess [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 01, 2001 10:20 AM
To: CF-Talk
Subject: How can I insert a new record with no values?


Hello all,

Would anyone be able to tell me how I can insert a row into a table that
requires no values. My MS Access table stores only an auto number and an
expiration date. The auto number, of course, is generated by the dbms and
the expiration date, which is set to a default value, is also generated by
the dbms, so there's no need for a field list or a values list in the SQL
statement. CF doesn't like my syntax as follows:

INSERT INTO Table ( )
VALUES ( )

I've also tried a few other approaches---all to no avail. Your help would be
much appreciated.

TYIA,
Dina
Official Member of the CF Newbie Club :-)
~~
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

Random in SQL

[BT]

I am trying to get a random 5 items in SQL on SQL7 instead of on the cf
side



Anyone know?





~~
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: How can I insert a new record with no values?

[Philip Arnold - ASP]

> Would anyone be able to tell me how I can insert a row into a
> table that requires no values. My MS Access table stores only an
> auto number and an expiration date. The auto number, of course,
> is generated by the dbms and the expiration date, which is set to
> a default value, is also generated by the dbms, so there's no
> need for a field list or a values list in the SQL statement. CF
> doesn't like my syntax as follows:
>
> INSERT INTO Table ( )
> VALUES ( )
>
> I've also tried a few other approaches---all to no avail. Your
> help would be much appreciated.

INSERT INTO Table (Field1)
VALUES (NULL)

That should do it as long as the field can accept NULL values

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



~~
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: How can I insert a new record with no values?

[Guy M. Saenger]

Dina,

I think that you can do the following

insert into TableName (AutoNumberField) values (0)

I think that will create a row, assign the autonumber value, and populate
the
default value for the expiration date.

--
Guy M. Saenger
[EMAIL PROTECTED]
214.448.8887

- Original Message -
From: "Dina Hess" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 12:20 PM
Subject: How can I insert a new record with no values?


> Hello all,
>
> Would anyone be able to tell me how I can insert a row into a table that
requires no values. My MS Access table stores only an auto number and an
expiration date. The auto number, of course, is generated by the dbms and
the expiration date, which is set to a default value, is also generated by
the dbms, so there's no need for a field list or a values list in the SQL
statement. CF doesn't like my syntax as follows:
>
> INSERT INTO Table ( )
> VALUES ( )
>
> I've also tried a few other approaches---all to no avail. Your help would
be much appreciated.
>
> TYIA,
> Dina
> Official Member of the CF Newbie Club :-)
>
>
>
>
~~
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: Form question

[Tangorre, Mike]

Well you could save the word doc as HTML, then open the document up and add
the HTML for the fields. BE WARNED, Microsoft HTML is nasty to work in...
all kinds of crazy things going on.

My other suggestion: take a creen shot of the form. set the back ground to a
new page with the pic you just saved. Build the form... 

Kinda odd request bu I think I know what you are trying to do.  :-)

Mike

-Original Message-
From: Braver, Ben [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 1:06 PM
To: CF-Talk
Subject: OT: Form question


Hi gang,

I have no problem with using HTML forms or CFFORM to create forms.
But I'm being asked to convert an existing "paper-style" MS Word document to
a web form where info can be captured and emailed.

My question is: is there a way to "overlay" form elements onto an existing
doc saved as HTML without doing the form over from scratch?
Thanks.

Ben Braver
Information Technology
Ultramar Inc.
Golden Eagle Refinery
150 Solano Way
Martinez, CA  94553-1487
(925) 370-3673 voice
(925) 370-3393 fax
(510) 716-2557 pager
[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: Form question

[Costas Piliotis]

I think you can at best get the layout though.  Dumb suggestion, but why not
just save the word document as html and work with it from there?

-Original Message-
From: Braver, Ben [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 01, 2001 10:06 AM
To: CF-Talk
Subject: OT: Form question


Hi gang,

I have no problem with using HTML forms or CFFORM to create forms. But I'm
being asked to convert an existing "paper-style" MS Word document to a web
form where info can be captured and emailed.

My question is: is there a way to "overlay" form elements onto an existing
doc saved as HTML without doing the form over from scratch? Thanks.

Ben Braver
Information Technology
Ultramar Inc.
Golden Eagle Refinery
150 Solano Way
Martinez, CA  94553-1487
(925) 370-3673 voice
(925) 370-3393 fax
(510) 716-2557 pager
[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

and E-mail

[Carlisle, Eric]

I'm going to send an e-mail with a text file attached.  Then I'm going to
delete the file.  With the file deletion, I know that I should use .
Should I lock the e-mail tag as well?

Thanks,

Eric Carlisle
ColdFusion Developer

~~
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

How can I insert a new record with no values?

[Dina Hess]

Hello all,

Would anyone be able to tell me how I can insert a row into a table that requires no 
values. My MS Access table stores only an auto number and an expiration date. The auto 
number, of course, is generated by the dbms and the expiration date, which is set to a 
default value, is also generated by the dbms, so there's no need for a field list or a 
values list in the SQL statement. CF doesn't like my syntax as follows:

INSERT INTO Table ( )
VALUES ( )

I've also tried a few other approaches---all to no avail. Your help would be much 
appreciated.

TYIA,
Dina
Official Member of the CF Newbie Club :-)
 


~~
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: OpenSource Image Library

[Tangorre, Mike]

Check out Developers area on allaire's website

Michael T. Tangorre

Web Applications Developer
Office Phone: 703-558-4746
Cellular Phone: 607-426-9277
AIM: CrazyFlash4
Personal Email: [EMAIL PROTECTED]
Work Email: [EMAIL PROTECTED]
School Email: [EMAIL PROTECTED]

This Email contains MillenniuM Information
Systems, LLC Privileged Information which
is Customer or Business Sensitive.



-Original Message-
From: Raley, Scott [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 12:49 PM
To: CF-Talk
Subject: OpenSource Image Library






Does anyone know if there is an opensource CF based Image/File Library
available? Or does anyone want to share the code for one?  I don't want to
reinvent the wheel if I don't have to.

TIA
Scott
~~
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 Question - Complex

[Guy M. Saenger]

Andy,

You are correct.  My oversite in that the dbo was included.
Sorry.

--
Guy M. Saenger
[EMAIL PROTECTED]
214.448.8887

- Original Message -
From: "Andy Ewings" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 11:37 AM
Subject: RE: SQL Question - Complex


> I don't think this is right..you only need 2 dots if you don't specify
> an owner.
>
> In fact we are all saying .dbo. but it all depends on who owns the table
in
> the db.
>
> --
> Andrew Ewings
> Project Manager
> Thoughtbubble Ltd
> http://www.thoughtbubble.net
> --
> United Kingdom
> http://www.thoughtbubble.co.uk/
> Tel: +44 (0) 20 7387 8890
> --
> New Zealand
> http://www.thoughtbubble.co.nz/
> Tel: +64 (0) 9 488 9131
> --
> The information in this email and in any attachments is confidential and
> intended solely for the attention and use of the named addressee(s). Any
> views or opinions presented are solely those of the author and do not
> necessarily represent those of Thoughtbubble. This information may be
> subject to legal, professional or other privilege and further distribution
> of it is strictly prohibited without our authority. If you are not the
> intended recipient, you are not authorised to disclose, copy, distribute,
or
> retain this message. Please notify us on +44 (0)207 387 8890.
>
>
>
> -Original Message-
> From: Guy M. Saenger [mailto:[EMAIL PROTECTED]]
> Sent: 01 August 2001 17:28
> To: CF-Talk
> Subject: Re: SQL Question - Complex
>
>
> What Stuart says below is correct.  However, you need to separate the
> database name from the table name with 2 dots in TSQL.  Therefore,
> it becomes ...
>
> INSERT INTO TableOnDB1 (fields...)
> SELECT fields...
> FROM DB2..dbo.TableOnDB1
>
> --
> Guy M. Saenger
> [EMAIL PROTECTED]
> 214.448.8887
>
> - Original Message -
> From: "Stuart Miller" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 01, 2001 9:19 AM
> Subject: RE: SQL Question - Complex
>
>
> > You want to do a cross database join with an INSERT SELECT query:
> >
> > INSERT INTO TableOnDB1 (fields...)
> > SELECT fileds...
> > FROM DB2.dbo.TableOnDB1
> >
> > The "DB2" in the FROM clause needs to be the name of the database (not
the
> > datasource name).
> >
> > -s
> >
> > Stuart Miller
> > Rocom New Media
> > t: 01937 487492
> > e: [EMAIL PROTECTED]
> > w: http://www.rocom.co.uk
> >
> >
> >
> > -Original Message-
> > From: Tangorre, Mike [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, August 01, 2001 3:01 PM
> > To: CF-Talk
> > Subject: SQL Question - Complex
> >
> >
> > Does anyone know if it is possible to pull from two different databases
in
> a
> > stored procedure?
> > What I have is DB1 and DB2, I need to take values from DB1 and insert
them
> > into DB2...this is
> > just the cut and dry of what I am doing... I am actually doing a lot
more
> > but this is the foundation.
> >
> > Any ideas?
> > T-SQL?
> >
> > mike
> >
>
~~
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: Form question

[Braver, Ben]

Hi gang,

I have no problem with using HTML forms or CFFORM to create forms.
But I'm being asked to convert an existing "paper-style" MS Word document to
a web form where info can be captured and emailed.

My question is: is there a way to "overlay" form elements onto an existing
doc saved as HTML without doing the form over from scratch?
Thanks.

Ben Braver
Information Technology
Ultramar Inc.
Golden Eagle Refinery
150 Solano Way
Martinez, CA  94553-1487
(925) 370-3673 voice
(925) 370-3393 fax
(510) 716-2557 pager
[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: CF Server stopped responding

[Mike Brunt]

Will, check the settings in the document area of IIS settings, make sure
that is set up to recognize Index.CFM files.  Also, look in the
Webserver.log in the ColdFusion logs area to see if anything is logged
there.

Kind Regards - Mike Brunt, EmbeeMedia
Tel: 562.790.8631
http://www.embeemedia.com
Instant Messaging Handles: -
AIM (AOL): MediaEmbee
MSN: [EMAIL PROTECTED]
Yahoo: MediaEmbeeYH

-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 9:26 AM
To: CF-Talk
Subject: CF Server stopped responding

On my local test machine (Win2k, IIS, CF 4.5), none of the pages can be
viewed.  In IE it connects to the server, but just "Waits for a reply"
forever - is this an IIS problem, or a CF problem?  I've tried restarting
CFAS, and the machine itself, but no joy.

Any help appreciated.

Will
~~
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

Image Resizing tags

[Scott Weikert]

Hey gang -

Does anyone out there who's messed with tags like "CF_ImageSize" have any
info on the nature of the files these tags produce, especially when it comes
to running pre-compressed images through them? I'm digging around trying to
settle on one of these tags, but I don't want to end up tossing, say, a 3k
JPG through one of these tags, trimming it down width/height-wise, and end
up with a larger file than I started with because the tag couldn't deal with
compression.

Thanks in adavance,
--Scott


~~
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: CF Server stopped responding

[Al Musella, DPM]

the easiest way to tell is to try to lead a html page.  IF it works, the 
problem is with CF, if it doesn't, the problem is with IIS.

IF it is a cf problem, try re-installing it.

IF you are connected to the internet, and didn't apply the code red patch, 
you are probably infected.
Al


At 05:25 PM 8/1/2001 +0100, you wrote:
>On my local test machine (Win2k, IIS, CF 4.5), none of the pages can be
>viewed.  In IE it connects to the server, but just "Waits for a reply"
>forever - is this an IIS problem, or a CF problem?  I've tried restarting
>CFAS, and the machine itself, but no joy.
>
>Any help appreciated.


~~
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

OpenSource Image Library

[Raley, Scott]

Does anyone know if there is an opensource CF based Image/File Library
available? Or does anyone want to share the code for one?  I don't want to
reinvent the wheel if I don't have to.

TIA
Scott

~~
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: ActivePdf

[Clint Tredway]

The only way that I got ActivePDF to work is to run the query make an html file of the 
results and then send the file to active pdf.

Its not pretty but it works

-- Original Message --
from: Janine Jakim <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Wed, 01 Aug 2001 12:11:19 -0400

has anyone used the active pdf?  How do you set the master query/related
query in CF???  I've been going through all the examples that they have and
I haven't come across how they do a db to form in  cf.  All their examples
that have to do with db are in asp.  Any help would be greatly appreciated.
Thanks,
janine
~~
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

CFSCHEDULE

[Bruce Holm]

I was playing around trying to learn how to get CFSCHEDULE tag to work and found 
something interesting that suggests a bug.

The INTERVAL parameter is Required for Updates.  The list of possible parameter values:
DAILY, WEEKLY, MONTHLY, NOW, EXECUTE, x
where x is number of minutes.

I wanted a Once-Only event so I tried an Interval value of Execute and then Now.  
Neither one set the interval correctly.  By that I mean, when I went into CF 
Administrator Scheduled Events and opened the event I had just created, none of the 
three radio buttons (One time, Repeating, Delay minutes) were set!  If I specified an 
Interval of Daily it set the radio button for repeating Daily.  I tried over and over, 
trying different variations and could not get the One time radio button to be 
selected.  If I left it in that state, it would NOT run my scheduled URL template.  It 
acted like it was scheduling an event that never ran.  I made sure I scheduled events 
longer than the 15 min. lead time interval.

I finally decided to try an Interval value of "ONCE" and voila...it set the radio 
button to One time and the list of events in the CF Administrator showed a Intervale 
of "Once-Only" and it scheduled the event and executed my template.  But ONCE is not a 
documented value.  In fact EXECUTE and NOW are barely documented anywhere and are not 
very clearly defined.  Ben Forta's book talks about it but he says EXECUTE seems to 
set to DAILY, while NOW sets the operation to execute immediately.  I could get 
neither to do as he describes.

To top it all off, the CF Reference manual doesn't even have CFSCHEDULE tag in it!!!

Any comments, experiences that would enlighten me more on this strange semi-documented 
tag?

-
Bruce Holm - Web Programmer
Lattice Semiconductor Corp.
[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: ActivePdf

[Stephen M Aylor]

Here's a cf example that was on there site - zipped.







blah 

Steve

- Original Message -
From: "Janine Jakim" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 9:11 AM
Subject: ActivePdf


> has anyone used the active pdf?  How do you set the master query/related
> query in CF???  I've been going through all the examples that they have
and
> I haven't come across how they do a db to form in  cf.  All their examples
> that have to do with db are in asp.  Any help would be greatly
appreciated.
> Thanks,
> janine
>
>
~~
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 Question - Complex

[Andy Ewings]

I don't think this is right..you only need 2 dots if you don't specify
an owner.

In fact we are all saying .dbo. but it all depends on who owns the table in
the db.

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131 
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.



-Original Message-
From: Guy M. Saenger [mailto:[EMAIL PROTECTED]]
Sent: 01 August 2001 17:28
To: CF-Talk
Subject: Re: SQL Question - Complex


What Stuart says below is correct.  However, you need to separate the
database name from the table name with 2 dots in TSQL.  Therefore,
it becomes ...

INSERT INTO TableOnDB1 (fields...)
SELECT fields...
FROM DB2..dbo.TableOnDB1

--
Guy M. Saenger
[EMAIL PROTECTED]
214.448.8887

- Original Message -
From: "Stuart Miller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 9:19 AM
Subject: RE: SQL Question - Complex


> You want to do a cross database join with an INSERT SELECT query:
>
> INSERT INTO TableOnDB1 (fields...)
> SELECT fileds...
> FROM DB2.dbo.TableOnDB1
>
> The "DB2" in the FROM clause needs to be the name of the database (not the
> datasource name).
>
> -s
>
> Stuart Miller
> Rocom New Media
> t: 01937 487492
> e: [EMAIL PROTECTED]
> w: http://www.rocom.co.uk
>
>
>
> -Original Message-
> From: Tangorre, Mike [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 01, 2001 3:01 PM
> To: CF-Talk
> Subject: SQL Question - Complex
>
>
> Does anyone know if it is possible to pull from two different databases in
a
> stored procedure?
> What I have is DB1 and DB2, I need to take values from DB1 and insert them
> into DB2...this is
> just the cut and dry of what I am doing... I am actually doing a lot more
> but this is the foundation.
>
> Any ideas?
> T-SQL?
>
> mike
>
~~
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: Concatenate 2 Queries

[Scott Van Vliet]

When I want to merge data between to SQL SELECT statements, I do the
following:

/*
Create the temporary table to match the data types
of the SELECT statements below
*/

CREATE TABLE #TEMP_TABLE (
FIELD_A int,
FIELD_B varchar(50)
)

/*
Assuming that FIELD_1 & FIELD_3 are of type int
and FIELD_2 & FIELD_4 are of type varchar(50)
*/

INSERT #TEMP_TABLE(FIELD_A,FIELD_B)
SELECT FIELD_1, FIELD_2
FROM TABLE_1
WHERE CONDITION

INSERT #TEMP_TABLE(FIELD_A,FIELD_B)
SELECT FIELD_3, FIELD_4
FROM TABLE_2
WHERE CONDITION

/*
Now we can query the two merged queries with
any condition and/or order
*/


SELECT FIELD_A, FIELD_B
FROM TEMP_TABLE
ORDER BY FIELD_A

DROP TABLE #TEMP_TABLE


Hope this might help!

- SVV

- Original Message -
From: "Ken Monroe" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 7:00 AM
Subject: Concatenate 2 Queries


Hello!

Is there a way to combine (concatenate) 2 different queries *without* using
the QueryNew, QueryAddRow, QuerySetCell stuff?  Something like
QueryCat(Query1, Query2). ??

Thx
~~
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: Emailing Errors Automatically

[Chris Norloff]

-- Original Message --
From: "Marc J. Mataya" <[EMAIL PROTECTED]>
>When my app has a user error, error.cfm is called using CFERROR.  Since you
>cannot execute any functions in this page such as CFMAIL, I am simply
>redirecting the error.cfm using JavaScript to another page that will
>successfully CFMAIL me.  

If you're using CF 4.5, then use Type=Exception, because it can use all the CF tags. 
It makes things a lot easier.

Chris Norloff

~~
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: 2 javascript questions

[Guy M. Saenger]

These should not be passed as strings (in single quotes) if you
are wanting to pass objects.  If you always want the first field on
the page you could do ...

document.forms[0].elements[0].focus();

otherwise, you need to pass the actual form and field objects.

--
Guy M. Saenger
[EMAIL PROTECTED]
214.448.8887

- Original Message -
From: "Timothy Lynn" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, July 31, 2001 2:18 PM
Subject: 2 javascript questions


> 'lo there,
>
> I'm working on the checkout portion of a shopping cart app. First part
> of my question is about setting the focus to the first element of the
> form. I have some code which does this:
>
> function toForm() {
>  document.form1.Firstname.focus();
> }
>
> It's called at body onLoad and this works fine. However, I'd like to
> make this code re-useable and place it in my site-wide javascript file.
> So I tried in my include file:
>
> function toForm(theForm, theField) {
>  document.theForm.theField.focus();
> }
>
> and then called it by:
>
> onLoad="toForm('form1','Firstname')
>
> However, I was getting errors stating that theForm and theField were
> null objects. Anybody see what I'm doing wrong here?
>
> Second question. I would also like to include the functionality to click
> on a checkbox to have your billing info carry over to your shipping
> information. Again, I can get this working in a static format, but I'd
> like to make it more reusable.
>
> function InitSaveVariables(form) {
> ShipFirst = form.ShipFirst.value;
> etc.
> }
> function ShipToBillPerson(form) {
> if (form.copy.checked) {
> InitSaveVariables(form);
> form.ShipFirst.value = form.BillFirst.value;
> etc.
> }
> else {
> form.ShipFirst.value = ShipFirst;
> etc.
> }
> }
>
> Ideally, I'd like to be able to pass in the form and then have the
> function cycle through the fields in the form collection without having
> to explicitly name each field.
>
> I've put off really getting into javascript for too long, so I'm trying
> to use it more to get a better grasp. TIA for your help!
>
> -Tim
>
~~
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

CF Server stopped responding

[W Luke]

On my local test machine (Win2k, IIS, CF 4.5), none of the pages can be
viewed.  In IE it connects to the server, but just "Waits for a reply"
forever - is this an IIS problem, or a CF problem?  I've tried restarting
CFAS, and the machine itself, but no joy.

Any help appreciated.

Will


~~
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

Catching Errors

[W Luke]

I need a quick solution to catching errors on a site (leaving tomorrow for
holiday).  Errors are few and fare between - occasionally there is a query
error but that's about it.

I'm not sure which type of error to catch (monitor, validation, request) or
how to do it - is it a case of putting cferror in application.cfm?

Many thanks

Will


~~
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: Question: Creating a primary key field

[Stuart Miller]

>From what I've heard, Access does not support transactions. I'm not sure how
that affects ...

-Original Message-
From: Susan Allen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 5:11 PM
To: CF-Talk
Subject: RE: Question: Creating a primary key field


Does Access not support  at all, or just the commit?  I have
been trying to implement  with Access ...

Susan Hamilton Allen
Information Technology Manager
MEVATEC Corporation
White Sands Missile Range, NM

>>> Stuart Miller 8/1/2001 8:28:17 AM >>>
scratch the , Access does not support it



INSERT INTO Contact( the fields... )
VALUES ( the values... )



SELECT  MAX(ID) AS TheID
FROMContactInfo



INSERT INTO ContactInfo ( ContactID, the fields... )
VALUES (#qry_getnewid.TheID#, the values..)




The cftransaction tag will ensure that no other records will be inserted
into these tables while processing the queries between the start and end of
the transaction.

-s

Stuart Miller   
Rocom New Media
t: 01937 487492
e: [EMAIL PROTECTED]
w: http://www.rocom.co.uk   



-Original Message-
From: Shannon Rhodes [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 01, 2001 2:41 PM
To: CF-Talk
Subject: Question: Creating a primary key field


Is it possible to query which was the last ID number created (autonumber
field in Access) for the purpose of adding 1 to explicitly state the new ID
number for a newly created record?

The reason why I ask is that I'm having trouble inserting my new info into
two separate tables because I need the newly created ID number for table A
to be inserted into table B.  If I can't "guess" what the number will be,
I'm stuck trying to take the user through a second page where I insert into
table A then turn around and query the new record to insert the new field
into table B.  That leaves me with the problem of what to do if the user
abandons the application on the second page, leaving no new record created
in table B.

This may sound like screwy application design (and maybe it is, I'm still
pretty new at this), but the problem is that table A contains contact
information, while table B contains all other information (class
registration, payment methods, etc), and they have a one-to-one relationship
because I may need to change which person the info is associated with (it's
possible that a person will register and pay for a class, but a co-worker
will attend in their place).  I can't make the classID a primary key in
table B either (the person could decide to switch classes) so I just have an
autonumber as a primary key.  Argh!  All suggestions welcomed.

TIA,
Shannon
[EMAIL PROTECTED] 



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
~~
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 Question - Complex

[Guy M. Saenger]

What Stuart says below is correct.  However, you need to separate the
database name from the table name with 2 dots in TSQL.  Therefore,
it becomes ...

INSERT INTO TableOnDB1 (fields...)
SELECT fields...
FROM DB2..dbo.TableOnDB1

--
Guy M. Saenger
[EMAIL PROTECTED]
214.448.8887

- Original Message -
From: "Stuart Miller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 9:19 AM
Subject: RE: SQL Question - Complex


> You want to do a cross database join with an INSERT SELECT query:
>
> INSERT INTO TableOnDB1 (fields...)
> SELECT fileds...
> FROM DB2.dbo.TableOnDB1
>
> The "DB2" in the FROM clause needs to be the name of the database (not the
> datasource name).
>
> -s
>
> Stuart Miller
> Rocom New Media
> t: 01937 487492
> e: [EMAIL PROTECTED]
> w: http://www.rocom.co.uk
>
>
>
> -Original Message-
> From: Tangorre, Mike [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 01, 2001 3:01 PM
> To: CF-Talk
> Subject: SQL Question - Complex
>
>
> Does anyone know if it is possible to pull from two different databases in
a
> stored procedure?
> What I have is DB1 and DB2, I need to take values from DB1 and insert them
> into DB2...this is
> just the cut and dry of what I am doing... I am actually doing a lot more
> but this is the foundation.
>
> Any ideas?
> T-SQL?
>
> mike
>
~~
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: Shopping Cart Software?

[admin]

Yep CFWebstore is the best. I run it for www.ontvstore.com and managed to
covert from a perl based app to cfwebstore in less that a week. easy to
customize. Robust and well written.


Richard
Y2K Internet Technologies
- Original Message -
From: "Howie Hamlin" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 8:54 AM
Subject: Re: Shopping Cart Software?


> Have a look at www.cfwebstore.com.  Very good product and support.  Comes
with source (unlike others which charge you additional for
> source).
>
> HTH,
>
> Howie Hamlin - inFusion Project Manager
> On-Line Data Solutions, Inc.
> www.CoolFusion.com
> 631-737-4668 x101
> inFusion Mail Server (iMS) - The Intelligent Mail Server
> Join the DevCon community at www.coolfusion.com/devcon
>
> - Original Message -
> From: "Joshua Miller" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 01, 2001 11:42 AM
> Subject: Shopping Cart Software?
>
>
> > Looking for a robust, full featured Shopping Cart system to integrate
into
> > ColdFusion. I've heard a little about AbleCommerce, is this the best
option?
> > It's a little on the pricey side at $3000 and $495 per additional store.
> >
> > Anyone know of a good CF Cart application that won't bust the wallet?
> >
> > Joshua Miller
> > Web Development::Programming
> > Eagle Technologies Group, Inc.
> > www.eagletgi.com
> > [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: 2 javascript questions

[Martin Laine]

Answer to first question

You need to evaluate the javascript code:

function toForm(theForm, theField) {
 eval("document." + theForm + "." + theField + ".focus()");
}

-Original Message-
From: Timothy Lynn [mailto:[EMAIL PROTECTED]]
Sent: 31 July 2001 20:19
To: CF-Talk
Subject: 2 javascript questions


'lo there,

I'm working on the checkout portion of a shopping cart app. First part
of my question is about setting the focus to the first element of the
form. I have some code which does this:

function toForm() {
 document.form1.Firstname.focus();
}

It's called at body onLoad and this works fine. However, I'd like to
make this code re-useable and place it in my site-wide javascript file.
So I tried in my include file:

function toForm(theForm, theField) {
 document.theForm.theField.focus();
}

and then called it by:

onLoad="toForm('form1','Firstname')

However, I was getting errors stating that theForm and theField were
null objects. Anybody see what I'm doing wrong here?

Second question. I would also like to include the functionality to click
on a checkbox to have your billing info carry over to your shipping
information. Again, I can get this working in a static format, but I'd
like to make it more reusable.

function InitSaveVariables(form) {
ShipFirst = form.ShipFirst.value;
etc.
}
function ShipToBillPerson(form) {
if (form.copy.checked) {
InitSaveVariables(form);
form.ShipFirst.value = form.BillFirst.value;
etc.
}
else {
form.ShipFirst.value = ShipFirst;
etc.
}
}

Ideally, I'd like to be able to pass in the form and then have the
function cycle through the fields in the form collection without having
to explicitly name each field.

I've put off really getting into javascript for too long, so I'm trying
to use it more to get a better grasp. TIA for your help!

-Tim
~~
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: Mail Client

[Tracy Bost]

I would be scared of the cfpop tag for a webmail program.
See if you can find a cfx tag or write your own using imap... That will  be
a lot more flexible for you and will also give your users more functionality
such as adding folders, etc
- Original Message -
From: "James Maltby" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 10:55 AM
Subject: RE: Mail Client


> go buy Ben Forta's CF Book - there's a whole chapter about rolling your
own
> pop3 cfmail app.
>
> J
>
> -Original Message-
> From:  [mailto:[EMAIL PROTECTED]]
> Sent: 01 August 2001 12:59
> To: CF-Talk
> Subject: Mail Client
>
>
> Hi Everyone,
>
> I need some help from you.
>
> I have a yahoo mail account and i want to build a mail client using
> Coldfusion to access the mails and send mails using that account.
> Basically I am planning to build a web based mail client using cfm
> (something like the hotmail or yahoo site).
>
> I dont know where to start. Can anyone guide me on that ???
>
> Thanx in advance,
> SANTHA
>
~~
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

ActivePdf

[Janine Jakim]

has anyone used the active pdf?  How do you set the master query/related
query in CF???  I've been going through all the examples that they have and
I haven't come across how they do a db to form in  cf.  All their examples
that have to do with db are in asp.  Any help would be greatly appreciated.
Thanks,
janine

~~
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: Question: Creating a primary key field

[Susan Allen]

Does Access not support  at all, or just the commit?  I have been 
trying to implement  with Access ...

Susan Hamilton Allen
Information Technology Manager
MEVATEC Corporation
White Sands Missile Range, NM

>>> Stuart Miller 8/1/2001 8:28:17 AM >>>
scratch the , Access does not support it



INSERT INTO Contact( the fields... )
VALUES ( the values... )



SELECT  MAX(ID) AS TheID
FROMContactInfo



INSERT INTO ContactInfo ( ContactID, the fields... )
VALUES (#qry_getnewid.TheID#, the values..)




The cftransaction tag will ensure that no other records will be inserted
into these tables while processing the queries between the start and end of
the transaction.

-s

Stuart Miller   
Rocom New Media
t: 01937 487492
e: [EMAIL PROTECTED]
w: http://www.rocom.co.uk   



-Original Message-
From: Shannon Rhodes [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 01, 2001 2:41 PM
To: CF-Talk
Subject: Question: Creating a primary key field


Is it possible to query which was the last ID number created (autonumber
field in Access) for the purpose of adding 1 to explicitly state the new ID
number for a newly created record?

The reason why I ask is that I'm having trouble inserting my new info into
two separate tables because I need the newly created ID number for table A
to be inserted into table B.  If I can't "guess" what the number will be,
I'm stuck trying to take the user through a second page where I insert into
table A then turn around and query the new record to insert the new field
into table B.  That leaves me with the problem of what to do if the user
abandons the application on the second page, leaving no new record created
in table B.

This may sound like screwy application design (and maybe it is, I'm still
pretty new at this), but the problem is that table A contains contact
information, while table B contains all other information (class
registration, payment methods, etc), and they have a one-to-one relationship
because I may need to change which person the info is associated with (it's
possible that a person will register and pay for a class, but a co-worker
will attend in their place).  I can't make the classID a primary key in
table B either (the person could decide to switch classes) so I just have an
autonumber as a primary key.  Argh!  All suggestions welcomed.

TIA,
Shannon
[EMAIL PROTECTED] 



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
~~
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: Shopping Cart Software?

[Stephenie Hamilton]

http://cfwebstore.com
~~
Stephenie Hamilton
Allaire Certified ColdFusion Professional



- Original Message -
From: Joshua Miller <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 11:42 AM
Subject: Shopping Cart Software?


> Looking for a robust, full featured Shopping Cart system to integrate into
> ColdFusion. I've heard a little about AbleCommerce, is this the best
option?
> It's a little on the pricey side at $3000 and $495 per additional store.
>
> Anyone know of a good CF Cart application that won't bust the wallet?
>
> Joshua Miller
> Web Development::Programming
> Eagle Technologies Group, Inc.
> www.eagletgi.com
> [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: Mail Client

[James Maltby]

go buy Ben Forta's CF Book - there's a whole chapter about rolling your own
pop3 cfmail app.

J

-Original Message-
From:  [mailto:[EMAIL PROTECTED]]
Sent: 01 August 2001 12:59
To: CF-Talk
Subject: Mail Client


Hi Everyone,

I need some help from you.

I have a yahoo mail account and i want to build a mail client using
Coldfusion to access the mails and send mails using that account.
Basically I am planning to build a web based mail client using cfm
(something like the hotmail or yahoo site). 

I dont know where to start. Can anyone guide me on that ???

Thanx in advance,
SANTHA
~~
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: Shopping Cart Software?

[Howie Hamlin]

Have a look at www.cfwebstore.com.  Very good product and support.  Comes with source 
(unlike others which charge you additional for
source).

HTH,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - The Intelligent Mail Server
Join the DevCon community at www.coolfusion.com/devcon

- Original Message -
From: "Joshua Miller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 11:42 AM
Subject: Shopping Cart Software?


> Looking for a robust, full featured Shopping Cart system to integrate into
> ColdFusion. I've heard a little about AbleCommerce, is this the best option?
> It's a little on the pricey side at $3000 and $495 per additional store.
>
> Anyone know of a good CF Cart application that won't bust the wallet?
>
> Joshua Miller
> Web Development::Programming
> Eagle Technologies Group, Inc.
> www.eagletgi.com
> [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: Shopping Cart Software?

[Tangorre, Mike]

I know one you can lease...
will you be integrating it into an existing site or will you be buidling a
new site alltogether?

Mike


Michael T. Tangorre

Web Applications Developer
Office Phone: 703-558-4746
Cellular Phone: 607-426-9277
AIM: CrazyFlash4
Personal Email: [EMAIL PROTECTED]
Work Email: [EMAIL PROTECTED]
School Email: [EMAIL PROTECTED]

This Email contains MillenniuM Information
Systems, LLC Privileged Information which
is Customer or Business Sensitive.



-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 11:43 AM
To: CF-Talk
Subject: Shopping Cart Software?


Looking for a robust, full featured Shopping Cart system to integrate into
ColdFusion. I've heard a little about AbleCommerce, is this the best option?
It's a little on the pricey side at $3000 and $495 per additional store.

Anyone know of a good CF Cart application that won't bust the wallet?

Joshua Miller
Web Development::Programming
Eagle Technologies Group, Inc.
www.eagletgi.com
[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: weird OLEDB error

[Andrew Tyrone]

I have yet to see any performance gain for ACCESS or SQL SERVER using OLE DB over 
ODBC.  I remember reading an article on setting up OLE DB (in the CF Journal) a ways 
back. The author said he couldn't post his numbers because "my MBA prevents me from 
reporting those statistics because I didn't adhere to any form of scientific method . 
. . I did find that OLE DB was a little faster than ODBC to the same SQL Server 
database . . ."

I was asking myself after reading this article just what the hell good an article was 
without proof of concept.  When I tried this myself, OLE DB wasn't any faster and was 
either slower for doing small to medium-sized queries, and caught up somewhat when 
doing large queries.

If anyone has any benchmarks that THEY'VE done and can share, I'd be interested to see 
them.

Thanks,

Andy

-Original Message-
From: Don Vawter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 8:36 PM
To: CF-Talk
Subject: Re: weird OLEDB error


I have had similiar problems with this and CF5. I eventually gave up and
went back to ODBC. Whatever performance gain (if any) isn't worth the
aggravation.

- Original Message -
From: "Marlon Moyer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, July 26, 2001 4:27 PM
Subject: RE: weird OLEDB error


> Are you using CF5, because I started having this problem when I upgraded.
> It's definitely keeping me from going to CF5 on my production machine.
> Sometimes I also get a message saying that the login failed for user
'(name
> of database I'm trying to log into)'
>
> Marlon
>
>
> -Original Message-
> From: S R [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 26, 2001 5:15 PM
> To: CF-Talk
> Subject: weird OLEDB error
>
>
> Hi Everyone,
>
> I have a CF page pulling some info from an OLEDB SQL Server datasource and
> every so often, when I call the page I'll get an error that says "Login
> failed for OLEDB source 'login name for my database'
>
> If I sit there and refresh my browser for awhile the error will go away
and
> the page will come up just fine, its as if it loses connectivity for
awhile
> then, appears. I can't afford this to happen in a production environment.
> Does anyone have any ideas why this may be happening? Is it a better idea
to
>
> enter the datasource as an ODBC rather than an OLEDB in CF Admin?
>
> thanks for your help
>
> Sal
>
~~
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

Shopping Cart Software?

[Joshua Miller]

Looking for a robust, full featured Shopping Cart system to integrate into
ColdFusion. I've heard a little about AbleCommerce, is this the best option?
It's a little on the pricey side at $3000 and $495 per additional store.

Anyone know of a good CF Cart application that won't bust the wallet?

Joshua Miller
Web Development::Programming
Eagle Technologies Group, Inc.
www.eagletgi.com
[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: My header/footer inclusion scheme hinders Verity searches!

[Andrew Tyrone]

One way I've tricked Verity into reading a title tag in an app where the headers, 
footers, and other parts of the page are dynamic, is to comment out the title.  So 
just like you did, but:





Body contents go here.




Now you have a valid HTML page being sent back to the browser, but Verity will still 
pick out the title between comments.  I only know that this works in all 4.x versions 
of ColdFusion; I haven't tested it with 5.  I hope it does or I'm in trouble!

Also, I use includes and set the page params before each instead of using custom tags 
for this, although the performance is negligible.  Of course you'd have to test each 
method under load to be sure.

If anyone has any better ways to accomplish this, I'd love to hear about them.


-Andy

-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 27, 2001 1:38 PM
To: CF-Talk
Subject: My header/footer inclusion scheme hinders Verity searches!


I like to use custom tags for header/footer inclusion, because it is
easy and elegant for our non-CFers to use:
-


Body contents go here.


-

However, if you want to use Verity to search the site, you lose the
page titles, since Verity extracts titles from the
Title HTML code.

There is a workaround, which almost defeats the easiness and elegance
of the custom tag:
-

TitleToAppearAtTopOfBrowser <--HERE'S THE WORKAROUND
Body contents go here.


-

Is there a better way? Is there a way to hack Verity to understand
that my "metaTitle" attribute is an alternate source of the document
title? Is Verity not the way to go? Any ideas whatsoever? :)

Thanks,
Jamie
~~
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: Mail Client

[BT]

I would check out LoadMail.com

-Original Message-
From:  [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 7:59 AM
To: CF-Talk
Subject: Mail Client


Hi Everyone,

I need some help from you.

I have a yahoo mail account and i want to build a mail client using
Coldfusion to access the mails and send mails using that account.
Basically I am planning to build a web based mail client using cfm
(something like the hotmail or yahoo site).

I dont know where to start. Can anyone guide me on that ???

Thanx in advance,
SANTHA
~~
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: Concatenate 2 Queries

[Dave Watts]

> The problem I'm having if I use a UNION is that the queries 
> use 2 different WHERE clauses.  What  I need to do is:
> 
> SELECT Fields
> FROM Table
> WHERE Cond1
> UNION
> SELECT Fields
> FROM Table
> Where Cond2
> 
> My understanding is I can only use the WHERE clause after the 
> last SELECT block...

Your understanding is in error. You can use completely different WHERE
clauses. You can only use one ORDER BY clause for the entire UNION, and you
must have the same number of columns in each SELECT, and those columns have
to have the same data types (or at least those data types have to be
implicitly castable).

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: Concatenate 2 Queries

[Benjamin S. Rogers]

I don't know about the Query a Query feature in ColdFusion 5, but every
RDBMS that I'm familiar with will let you specify two separate WHERE
clauses. There wouldn't be much point in a UNION statement if not. Perhaps
you are thinking about the SELECT clause which must have the same number of
fields with the same names and of the same datatypes?

Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057

-Original Message-
From: Ken Monroe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 10:47 AM
To: CF-Talk
Subject: Re: Concatenate 2 Queries


The problem I'm having if I use a UNION is that the queries use 2 different
WHERE clauses.  What  I need to do is:

SELECT Fields
FROM Table
WHERE Cond1
UNION
SELECT Fields
FROM Table
Where Cond2

My understanding is I can only use the WHERE clause after the last SELECT
block...

- Original Message -
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 10:38 AM
Subject: RE: Concatenate 2 Queries


> > Is there a way to combine (concatenate) 2 different queries
> > *without* using
> > the QueryNew, QueryAddRow, QuerySetCell stuff?  Something like
> > QueryCat(Query1, Query2). ??
>
> I'm not sure if Query a Query does this, but how about using UNION?
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
>
>
>
~~
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: Concatenate 2 Queries

[Larry Juncker]

If you have an item in both tables that is the same, which I guess you do,
you could try this:

Lets use Lot_Id

SELECT Fields
FROM Table
WHERE Cond1
AND Lot_ID IN
(SELECT Fields
FROM Table
Where Cond2)

Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
[EMAIL PROTECTED]

-Original Message-
From: Ken Monroe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 9:47 AM
To: CF-Talk
Subject: Re: Concatenate 2 Queries


The problem I'm having if I use a UNION is that the queries use 2 different
WHERE clauses.  What  I need to do is:

SELECT Fields
FROM Table
WHERE Cond1
UNION
SELECT Fields
FROM Table
Where Cond2

My understanding is I can only use the WHERE clause after the last SELECT
block...

- Original Message -
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 10:38 AM
Subject: RE: Concatenate 2 Queries


> > Is there a way to combine (concatenate) 2 different queries
> > *without* using
> > the QueryNew, QueryAddRow, QuerySetCell stuff?  Something like
> > QueryCat(Query1, Query2). ??
>
> I'm not sure if Query a Query does this, but how about using UNION?
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
>
>
>
~~
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: Concatenate 2 Queries

[Ken Monroe]

Looks like this is working great.

Thx!

- Original Message -
From: "Tim Painter" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 10:24 AM
Subject: Re: Concatenate 2 Queries


> If you are using CF 5, you can use UNION with the new Query of a query to
do
> that.
>
> 
> Select foo from Query1
> UNION
> Select foo from Query2
> 
>
>
> - Original Message -
> From: "Ken Monroe" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 01, 2001 10:00 AM
> Subject: Concatenate 2 Queries
>
>
> Hello!
>
> Is there a way to combine (concatenate) 2 different queries *without*
using
> the QueryNew, QueryAddRow, QuerySetCell stuff?  Something like
> QueryCat(Query1, Query2). ??
>
> Thx
>
~~
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

Union Syntax

[Neil Clark]

SELECT select_list [INTO clause] 
[FROM clause] 
[WHERE clause] 
[GROUP BY clause] 
[HAVING clause] 
 
[UNION [ALL] 
 
SELECT select_list 
[FROM clause] 
[WHERE clause] 
[GROUP BY clause] 
[HAVING clause]...] 
[ORDER BY clause] 
[COMPUTE clause]


~~
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

Mail Client

Hi Everyone,

I need some help from you.

I have a yahoo mail account and i want to build a mail client using Coldfusion to 
access the mails and send mails using that account.
Basically I am planning to build a web based mail client using cfm (something like the 
hotmail or yahoo site). 

I dont know where to start. Can anyone guide me on that ???

Thanx in advance,
SANTHA 


~~
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

Is This A Reliable Method To PAss Form Variable Values?

[Mike Flanigan]

First a note of thanks to all of you-I've been a lurker on this list for a
few months as I get up to speed in CF and have learned a TREMENDOUS amount
by reading your posts and replies. Many thanks!

Now, on to the question:

I have a roster of ID 's and status_codes (1 ID -> 1 status_code)  that I am
selecting out of a database and presenting to a user.  The user may change
the status_code for an id and submit the form to update the status_code
field in the database.

This roster has the potential of becoming lengthy (perhaps 200-300 ID's
 x 15k users).  In order to minimize DB access and time I would
like to submit back to the DB only the ID's and status_codes that have
changed - I'd further like to do this without another trip back to the DB to
obtain the original status_code.

I have a solution that appears to work but I just kind of stumbled across it
and want to verify that I can rely on it.

Code Snippet:


   #RosterQuery.Fname# #RosterQuery.MI# #RosterQuery.Lname#
   #DateFormat(RosterQuery.STATUS_DATE,"mm-dd-yy")#

  CHECKED>Include
  CHECKED>Exclude

  
...

When I cfloop through the form collection on the action page

ID = #ID# - Value = #form[ID]#

 I get output that looks like this:
ID=24251295 - Value=0,PREV1 
ID=25498093 - Value=0,PREV0 
ID=25570830 - Value=0,PREV0 
ID=25624983 - Value=1,PREV0 
ID=25686844 - Value=0,PREV0 
ID=26154139 - Value=0,PREV0 
ID=26196423 - Value=1,PREV0 
ID=26661137 - Value=0,PREV1 
...

Finally, my question:  when you have form variables named the same (in this
case ID-a radio button and ID-a hidden variable) will the values associated
with each instance of the like-named form variable always be collapsed into
a "1 ID to many values" data structure as shown in the output?  I'm hoping
so-I can work with this and determine what changes have occured.







Mike Flanigan 
UPSHOT Marketing
Director of E-Solutions
Office  804.422.9673
Cell804.357.1259
http://www.upshot.net/



~~
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: Concatenate 2 Queries

[Ken Monroe]

The problem I'm having if I use a UNION is that the queries use 2 different
WHERE clauses.  What  I need to do is:

SELECT Fields
FROM Table
WHERE Cond1
UNION
SELECT Fields
FROM Table
Where Cond2

My understanding is I can only use the WHERE clause after the last SELECT
block...

- Original Message -
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 10:38 AM
Subject: RE: Concatenate 2 Queries


> > Is there a way to combine (concatenate) 2 different queries
> > *without* using
> > the QueryNew, QueryAddRow, QuerySetCell stuff?  Something like
> > QueryCat(Query1, Query2). ??
>
> I'm not sure if Query a Query does this, but how about using UNION?
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
>
>
>
~~
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: Concatenate 2 Queries

[C. Hatton Humphrey]

Also, depending on the database you're using you might look into doing a
UNION select through the SQL itself.


> -Original Message-
> From: Tim Painter [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 01, 2001 10:24 AM
> To: CF-Talk
> Subject: Re: Concatenate 2 Queries
>
>
> If you are using CF 5, you can use UNION with the new Query of a
> query to do
> that.
>
> 
> Select foo from Query1
> UNION
> Select foo from Query2
> 
>
>
> - Original Message -
> From: "Ken Monroe" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 01, 2001 10:00 AM
> Subject: Concatenate 2 Queries
>
>
> Hello!
>
> Is there a way to combine (concatenate) 2 different queries
> *without* using
> the QueryNew, QueryAddRow, QuerySetCell stuff?  Something like
> QueryCat(Query1, Query2). ??
>
> Thx
>
~~
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: Question: Creating a primary key field

[Yager, Brian T Contractor/NCCIM]

So you still would have to worry about another insertion beore your second query
runs.


-Original Message-
From: Stuart Miller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 9:28 AM
To: CF-Talk
Subject: RE: Question: Creating a primary key field


scratch the , Access does not support it



INSERT INTO Contact( the fields... )
VALUES ( the values... )



SELECT  MAX(ID) AS TheID
FROMContactInfo



INSERT INTO ContactInfo ( ContactID, the fields... )
VALUES (#qry_getnewid.TheID#, the values..)




The cftransaction tag will ensure that no other records will be inserted
into these tables while processing the queries between the start and end of
the transaction.

-s

Stuart Miller   
Rocom New Media
t: 01937 487492
e: [EMAIL PROTECTED]
w: http://www.rocom.co.uk   



-Original Message-
From: Shannon Rhodes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 2:41 PM
To: CF-Talk
Subject: Question: Creating a primary key field


Is it possible to query which was the last ID number created (autonumber
field in Access) for the purpose of adding 1 to explicitly state the new ID
number for a newly created record?

The reason why I ask is that I'm having trouble inserting my new info into
two separate tables because I need the newly created ID number for table A
to be inserted into table B.  If I can't "guess" what the number will be,
I'm stuck trying to take the user through a second page where I insert into
table A then turn around and query the new record to insert the new field
into table B.  That leaves me with the problem of what to do if the user
abandons the application on the second page, leaving no new record created
in table B.

This may sound like screwy application design (and maybe it is, I'm still
pretty new at this), but the problem is that table A contains contact
information, while table B contains all other information (class
registration, payment methods, etc), and they have a one-to-one relationship
because I may need to change which person the info is associated with (it's
possible that a person will register and pay for a class, but a co-worker
will attend in their place).  I can't make the classID a primary key in
table B either (the person could decide to switch classes) so I just have an
autonumber as a primary key.  Argh!  All suggestions welcomed.

TIA,
Shannon
[EMAIL PROTECTED]



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
~~
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