Re: Inserting date/time stamp

2003-03-10 Thread Michael T. Tangorre
just make a function that reset the form (to its default values) when the
submit button is clicked..

input type=button name=submit value=submit
onClick=runTheFunction()

function runThefunction(){
document.formname.reset();
document.formname.submit();
}

- Original Message -
From: FlashGuy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 10, 2003 6:46 PM
Subject: RE: Inserting date/time stamp


 Right, but the idea I was trying to achieve was to keep the look the
same (with the input field) so it matches the rest of the form.



  From: FlashGuy [EMAIL PROTECTED]
  How can I stop people of editing the input line where I'm dumping the
date? I don't want them to be able to change it.
  
  input type=text name=theTime value=cfoutput
#DateFormat(todayDate, ,  dd, )#/cfoutput size=30
 
  I'd display it as plain text (not in a form field), and do a hidden form
field to send the value through the form.
 
  cfoutput #DateFormat(todayDate, ,  dd, )#/cfoutput
  input type=hidden name=theTime value=cfoutput
#DateFormat(todayDate, ,  dd, )#/cfoutput
 
 
  
  Scott Brady
  http://www.scottbrady.net/
 
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Inserting date/time stamp

2003-03-10 Thread Tony Weeg
cfoutput
input type=text name=theTime value=#DateFormat(todayDate, ,
 dd, )# size=30 onBlur=this.value='#DateFormat(todayDate,
,  dd, )#';
/cfoutput

or 

input type=text name=theTime value=#DateFormat(todayDate, ,
 dd, )# size=30 READONLY

thats two methods that i use.

tony


-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 10, 2003 8:44 PM
To: CF-Talk
Subject: Re: Inserting date/time stamp


just make a function that reset the form (to its default values) when
the
submit button is clicked..

input type=button name=submit value=submit
onClick=runTheFunction()

function runThefunction(){
document.formname.reset();
document.formname.submit();
}

- Original Message -
From: FlashGuy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 10, 2003 6:46 PM
Subject: RE: Inserting date/time stamp


 Right, but the idea I was trying to achieve was to keep the look the
same (with the input field) so it matches the rest of the form.



  From: FlashGuy [EMAIL PROTECTED]
  How can I stop people of editing the input line where I'm dumping
the
date? I don't want them to be able to change it.
  
  input type=text name=theTime value=cfoutput
#DateFormat(todayDate, ,  dd, )#/cfoutput size=30
 
  I'd display it as plain text (not in a form field), and do a hidden
form
field to send the value through the form.
 
  cfoutput #DateFormat(todayDate, ,  dd, )#/cfoutput
  input type=hidden name=theTime value=cfoutput
#DateFormat(todayDate, ,  dd, )#/cfoutput
 
 
  
  Scott Brady
  http://www.scottbrady.net/
 
 
 
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



How to get field names in MSAccess

2003-03-10 Thread Terry
I know this is simple, but can't remember.

How do use a query to get list of column or field names.  Using CF5.0


Thanks

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: How to get field names in MSAccess

2003-03-10 Thread Joe Eugene
cfquery name=qName .
select * from someTable
/cfquery

cfoutput
#qName.columnList#
/cfoutput


Joe Eugene
Certified Advanced ColdFusion Developer


 -Original Message-
 From: Terry [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 10, 2003 9:32 PM
 To: CF-Talk
 Subject: How to get field names in MSAccess


 I know this is simple, but can't remember.

 How do use a query to get list of column or field names.  Using CF5.0


 Thanks

 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: How to get field names in MSAccess

2003-03-10 Thread S . Isaac Dealey
If you don't want to select any data, and just want the column names, use

cfquery name=qName .
select * from someTable
where myprimarykey is null
/cfquery

or where myprimarykey = #somevalueiknowwontexistinthetable#

 cfquery name=qName .
 select * from someTable
 /cfquery

 cfoutput
 #qName.columnList#
 /cfoutput


 Joe Eugene
 Certified Advanced ColdFusion Developer


 -Original Message-
 From: Terry [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 10, 2003 9:32 PM
 To: CF-Talk
 Subject: How to get field names in MSAccess


 I know this is simple, but can't remember.

 How do use a query to get list of column or field names.
 Using CF5.0


 Thanks


 ~~
 ~~~|
 Archives:
 http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
 Subscription: http://www.houseoffusion.com/cf_lists/index.
 cfm?method=subscribeforumid=4
 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
 Get the mailserver that powers this list at
 http://www.coolfusion.com

   Unsubscribe: http://www.houseoffusion.com/cf_lists/uns
   ubscribe.cfm?user=633.558.4



s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

tapestry api is opensource http://www.turnkey.to/tapi

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Where did my CFMX files go?

2003-03-10 Thread Critz
oi CF-Talk,!!

  I have installed/uninstalled/removed dirs/rebooted/installed...etc a number of times.


  my file extensions point to: C:\CFusionMX\runtime\lib\wsconfig\1\jrun.dll

  but  under  wsconfig,  I  have no 1 directory.. I thought perhaps my copy of cfmx 
was uh I dunno
  old... so i d/l a new one... same deal.

  any ideas any suggestions?

  Critz


---
[This E-mail scanned for viruses by Declude Virus]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



OT: MXDU 2003 photos/speaker slides online

2003-03-10 Thread Tilbrook, Peter
Check out http://mxdu.com

==
Peter Tilbrook
Internet Applications Developer
Australian Building Codes Board
GPO Box 9839
CANBERRA ACT 2601
AUSTRALIA

  WWW: http://www.abcb.gov.au/
   E-Mail: [EMAIL PROTECTED]
Telephone: +61 (02) 6213 6731
   Mobile: 0439 401 823
Facsimile: +61 (02) 6213 7287 


**
The information contained in this e-mail, and any attachments to it, is
intended for the use of addressee and is confidential.  If you are not 
the intended recipient, you must not use, disclose, read, forward, copy or
retain any of the information.  If you have received this e-mail in 
error, please delete it and notify the sender by return e-mail or telephone.  
The Commonwealth does not warrant that any attachments are free from 
viruses or any other defects.  You assume all liability for any loss, damage, or 
other consequences which may arise from opening or using the attachments.

**
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Macromedia DONT help me now. so where do i turn now?

2003-03-10 Thread Michael Kear
AMAZING

Regular readers to this list will be aware that I have been wrestling
with installing CFMX since last Friday to no avail.   I decided to see
if Macromedia would back me up as a reseller and developer, and I called
their support line.

I got connected to their Manilla office and Pauline's response was that
I couldn't even talk to a support person unless I paid US$500.

IN other words, I have downloaded the CFMX, it doesn't install
correctly, for whatever reason, I can't make it work, no one else can
either apparently, and Macromedia aren't going to try unless I cough up
nearly 2/3 of the cost of a server.  That's to evalutate it!!!

I guess I'm just not meant to be in the MX world. 


Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: How to get field names in MSAccess

2003-03-10 Thread Joe Eugene
 If you don't want to select any data, and just want the column names, use
 or where myprimarykey = #somevalueiknowwontexistinthetable#

What happens.. if you dont have a primary key? out of luck?

select * from TableName where 1=0;

Joe Eugene


 -Original Message-
 From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 10, 2003 10:25 PM
 To: CF-Talk
 Subject: RE: How to get field names in MSAccess


 If you don't want to select any data, and just want the column names, use

 cfquery name=qName .
   select * from someTable
   where myprimarykey is null
 /cfquery

 or where myprimarykey = #somevalueiknowwontexistinthetable#

  cfquery name=qName .
  select * from someTable
  /cfquery

  cfoutput
  #qName.columnList#
  /cfoutput


  Joe Eugene
  Certified Advanced ColdFusion Developer


  -Original Message-
  From: Terry [mailto:[EMAIL PROTECTED]
  Sent: Monday, March 10, 2003 9:32 PM
  To: CF-Talk
  Subject: How to get field names in MSAccess
 
 
  I know this is simple, but can't remember.
 
  How do use a query to get list of column or field names.
  Using CF5.0
 
 
  Thanks
 
 
  ~~
  ~~~|
  Archives:
  http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
  Subscription: http://www.houseoffusion.com/cf_lists/index.
  cfm?method=subscribeforumid=4
  FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
  Get the mailserver that powers this list at
  http://www.coolfusion.com

  Unsubscribe:
 http://www.houseoffusion.com/cf_lists/uns
  ubscribe.cfm?user=633.558.4



 s. isaac dealey954-776-0046

 new epoch  http://www.turnkey.to

 lead architect, tapestry cms   http://products.turnkey.to

 tapestry api is opensource http://www.turnkey.to/tapi

 certified advanced coldfusion 5 developer
 http://www.macromedia.com/v1/handlers/index.cfm?ID=21816

 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Where did my CFMX files go?

2003-03-10 Thread Michael Kear
O does this sound familiar to me

I'm sorry Critz, I can only offer sympathy, because I have been
wrestling with this same problem since last Friday.

I'll save you some heartburn.  Don't call Macromedia unless you have
US$500 lying around the place with nothing to do.


Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.





-Original Message-
From: Critz [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 11 March 2003 2:45 PM
To: CF-Talk
Subject: Where did my CFMX files go?

oi CF-Talk,!!

  I have installed/uninstalled/removed dirs/rebooted/installed...etc a
number of times.


  my file extensions point to:
C:\CFusionMX\runtime\lib\wsconfig\1\jrun.dll

  but  under  wsconfig,  I  have no 1 directory.. I thought perhaps my
copy of cfmx was uh I dunno
  old... so i d/l a new one... same deal.

  any ideas any suggestions?

  Critz




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Where did my CFMX files go?

2003-03-10 Thread jonhall
Did it stop working all of the sudden, or were there suspicious
circumstances...

My 1 dir contains:
jrun.dll
jrun.ini
jrunserver.store
README.txt
and a bunch of jrun log files.

Try reinstalling updater 2, I've found it useful for fixing an install
I've broken by deleting stuff I shouldn't have.

-- 
mailto:[EMAIL PROTECTED]
Monday, March 10, 2003, 10:44:32 PM, you wrote:

C oi CF-Talk,!!

C   I have installed/uninstalled/removed dirs/rebooted/installed...etc a number of 
times.


C   my file extensions point to: C:\CFusionMX\runtime\lib\wsconfig\1\jrun.dll

C   but  under  wsconfig,  I  have no 1 directory.. I thought perhaps my copy of 
cfmx was uh I dunno
C   old... so i d/l a new one... same deal.

C   any ideas any suggestions?

C   Critz


C ---
C [This E-mail scanned for viruses by Declude Virus]

C 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Macromedia DONT help me now. so where do i turn now?

2003-03-10 Thread jonhall
Michael, have you tried installing on another computer entirely?

-- 
mailto:[EMAIL PROTECTED]
Monday, March 10, 2003, 11:11:05 PM, you wrote:

MK AMAZING

MK Regular readers to this list will be aware that I have been wrestling
MK with installing CFMX since last Friday to no avail.   I decided to see
MK if Macromedia would back me up as a reseller and developer, and I called
MK their support line.

MK I got connected to their Manilla office and Pauline's response was that
MK I couldn't even talk to a support person unless I paid US$500.

MK IN other words, I have downloaded the CFMX, it doesn't install
MK correctly, for whatever reason, I can't make it work, no one else can
MK either apparently, and Macromedia aren't going to try unless I cough up
MK nearly 2/3 of the cost of a server.  That's to evalutate it!!!

MK I guess I'm just not meant to be in the MX world. 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Macromedia DONT help me now. so where do i turn now?

2003-03-10 Thread Michael Kear
Thanks for your suggestion.

What would be the point of it?  I'm sorry but I don't see the reason.
Can you elaborate a little for me? 

I have two computers in my company. Only two.  It's a one-person
company.  The other computer is really small and old.   It would be
really stretched to run the server at all, let alone do anything with
it.  (Plus my servers which are production servers and I'm not going to
go tinkering about with those unless I know what I'm doing)  I need it
on this box.



Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 11 March 2003 3:24 PM
To: CF-Talk
Subject: Re: Macromedia DONT help me now. so where do i turn now?

Michael, have you tried installing on another computer entirely?

-- 
mailto:[EMAIL PROTECTED]
Monday, March 10, 2003, 11:11:05 PM, you wrote:

MK AMAZING

MK Regular readers to this list will be aware that I have been
wrestling
MK with installing CFMX since last Friday to no avail.   I decided to
see
MK if Macromedia would back me up as a reseller and developer, and I
called
MK their support line.

MK I got connected to their Manilla office and Pauline's response was
that
MK I couldn't even talk to a support person unless I paid US$500.

MK IN other words, I have downloaded the CFMX, it doesn't install
MK correctly, for whatever reason, I can't make it work, no one else
can
MK either apparently, and Macromedia aren't going to try unless I cough
up
MK nearly 2/3 of the cost of a server.  That's to evalutate it!!!

MK I guess I'm just not meant to be in the MX world. 



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Macromedia DONT help me now. so where do i turn now?

2003-03-10 Thread Joe Eugene
 I got connected to their Manilla office and Pauline's response was that
 I couldn't even talk to a support person unless I paid US$500.

To all List Members who recommended calling MM Support to report BUGS.

Can you guys please contribute $500 to Mike, so we can this resolved :).

Yea right...

Joe Eugene


 -Original Message-
 From: Michael Kear [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 10, 2003 11:11 PM
 To: CF-Talk
 Subject: Macromedia DONT help me now. so where do i turn now?


 AMAZING

 Regular readers to this list will be aware that I have been wrestling
 with installing CFMX since last Friday to no avail.   I decided to see
 if Macromedia would back me up as a reseller and developer, and I called
 their support line.

 I got connected to their Manilla office and Pauline's response was that
 I couldn't even talk to a support person unless I paid US$500.

 IN other words, I have downloaded the CFMX, it doesn't install
 correctly, for whatever reason, I can't make it work, no one else can
 either apparently, and Macromedia aren't going to try unless I cough up
 nearly 2/3 of the cost of a server.  That's to evalutate it!!!

 I guess I'm just not meant to be in the MX world.


 Cheers,
 Michael Kear
 Windsor, NSW, Australia
 AFP Webworks.





 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Macromedia DONT help me now. so where do i turn now?

2003-03-10 Thread Joe Eugene
 I got connected to their Manilla office and Pauline's response was that
 I couldn't even talk to a support person unless I paid US$500.

Sorry Michael, but this is no suprise.

I downloaded IBM Websphere v5.0 evaluation version, which comes with 60 day
support,
had some simple issues with software JVM, send IBM support an email at like
2am,
got a reply with solution 9am. Excellent support.

Joe Eugene


 -Original Message-
 From: Michael Kear [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 10, 2003 11:11 PM
 To: CF-Talk
 Subject: Macromedia DONT help me now. so where do i turn now?


 AMAZING

 Regular readers to this list will be aware that I have been wrestling
 with installing CFMX since last Friday to no avail.   I decided to see
 if Macromedia would back me up as a reseller and developer, and I called
 their support line.

 I got connected to their Manilla office and Pauline's response was that
 I couldn't even talk to a support person unless I paid US$500.

 IN other words, I have downloaded the CFMX, it doesn't install
 correctly, for whatever reason, I can't make it work, no one else can
 either apparently, and Macromedia aren't going to try unless I cough up
 nearly 2/3 of the cost of a server.  That's to evalutate it!!!

 I guess I'm just not meant to be in the MX world.


 Cheers,
 Michael Kear
 Windsor, NSW, Australia
 AFP Webworks.





 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Macromedia DONT help me now. so where do i turn now?

2003-03-10 Thread jonhall
I'm just thinking along the lines that there may be something wrong
with the computer, maybe a corrupted nic driver, or a somehow broken
IIS install...I've seen both of those cause many strange problems. The
Metabase can get corrupted, but IIS will still function to a point,
and corrupted nic drivers can cause all sorts of odd things to happen.

I've installed MX on 3 machines, some old, some new, and had problems,
but nothing like what you are seeing, and haven't seen people
mentioning this kind of problem, so the problem would seem to be with
your setup somewhere.Trying to install on another system would at
least give concrete proof that the problem is with the computer if it
succeeds. At which point I'd say it's time for a Windows reinstall, or
at least download a copy of Metaedit to make sure your IIS metabase
isn't corrupt, and reinstall the nic drivers.

Forgive me if I'm off base, I've followed the threads but there have
been quite a few and I may have missed some relevant point.

-- 
mailto:[EMAIL PROTECTED]
Monday, March 10, 2003, 11:30:08 PM, you wrote:

MK Thanks for your suggestion.

MK What would be the point of it?  I'm sorry but I don't see the reason.
MK Can you elaborate a little for me? 

MK I have two computers in my company. Only two.  It's a one-person
MK company.  The other computer is really small and old.   It would be
MK really stretched to run the server at all, let alone do anything with
MK it.  (Plus my servers which are production servers and I'm not going to
MK go tinkering about with those unless I know what I'm doing)  I need it
MK on this box.



MK Cheers,
MK Michael Kear
MK Windsor, NSW, Australia
MK AFP Webworks.




MK -Original Message-
MK From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
MK Sent: Tuesday, 11 March 2003 3:24 PM
MK To: CF-Talk
MK Subject: Re: Macromedia DONT help me now. so where do i turn now?

MK Michael, have you tried installing on another computer entirely?

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Javascript Signed Scripting Re: window.close question?

2003-03-10 Thread Joshua Miller
Actually, you CAN do this without needing to change security settings.

Just change the window opener's reference to TOP and then you can close
it.

script
window.open('popup.html','popWin','width=300,height=300');
window.opener=top;
window.close();
/script

This doesn't work on IE5 or Netscape 4.7x but it works on all other
IE/NS variations.

I saw this link earlier today while looking for some ActionScript
reference.

http://aspalliance.com/peterbrunone/impossible.asp

HTH

Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
 

*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of 
Garrison Enterprises Inc.
 
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]

*


-Original Message-
From: Jann VanOver [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 10, 2003 7:18 PM
To: CF-Talk
Subject: Javascript Signed Scripting Re: window.close question?


Mozilla has a write up on signed javascripting:
http://www.mozilla.org/projects/security/components/signed-scripts.html

There's an old (Netscape 4.0) article here:
http://polaris.umuc.edu/~mgaylor/SignedScripts.html

And some Netscape/Gekko notes at
http://devedge.netscape.com/central/security/ AND
http://devedge.netscape.com/viewsource/2002/bypassing-security-restricti
ons/

On 3/9/03 1:48 PM, James Blaha [EMAIL PROTECTED] wrote:

 Jeff, Jann  Critz,
 
 Thank you all very much for your input and time. I¹m working on an 
 intranet application so I¹m not worried about security for the user¹s 
 browser. Jann do you know how this would be done in a secure, signed, 
 scripting environment? If you do can you please email me an example if

 you have one handy otherwise I found a work around for my issue so I 
 can put an end to this thread.
 
 Thanks again!
 
 Regards,
 James Blaha
 
 
 Jann VanOver wrote:
 On 3/7/03 10:30 AM, James Blaha [EMAIL PROTECTED] 
 mailto:[EMAIL PROTECTED]
 wrote:
 
   
 Hello All:
 
 JavaScript Question
 
 I need to have JavaScript code work for Netscape 4.7 to open a child 
 window and close the parent and bypass the confirm message. [snip]
 
 
 You should not be able to do this unless you are in a secure, signed, 
 scripting environment.  Period.
 
 What you are asking invades the user's privacy.  When you close the 
 parent, you lose all their page history information -- this is why the

 confirmation message appears.  The confirmation message will always 
 appear if you programmatically try to close a window that the user 
 opened.
 
 I am a bit shocked that the code you give doesn't launch a 
 confirmation message in IE and Netscape 6-7.  You must have your user 
 privacy settings lower in those browsers.
 
 
 
 
   
 Can someone
 please send me an example?
 
 This code works in IE and Netscape 6-7 but not Netscape 4.7
 
 !--- SCRIPT LANGUAGE = JavaScript
 
 {
 
 newwin=window.open(Login.cfm,_blank,... ) firstwindow = 
 window.self; firstwindow.opener = window.self;
 
 firstwindow.close();
 newwin.focus()
 
 }
 /SCRIPT ---
 
 
 
 
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: How to get field names in MSAccess

2003-03-10 Thread Jason Miller
just do a WHERE 0 = 0

I just tested it out and it works
cfquery name=qName datasource=#dsndata#
select * from ModuleFeatures
where 0 = 0
/cfquery
cfoutput
#qName.columnList#
/cfoutput

outputs all the columns in that table
jay miller


Joe Eugene wrote:


If you don't want to select any data, and just want the column names,
use

or where myprimarykey = #somevalueiknowwontexistinthetable#





What happens.. if you dont have a primary key? out of luck?



select * from TableName where 1=0;



Joe Eugene





  

-Original Message-

From: S. Isaac Dealey [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
]

Sent: Monday, March 10, 2003 10:25 PM

To: CF-Talk

Subject: RE: How to get field names in MSAccess





If you don't want to select any data, and just want the column names,
use



cfquery name=qName .

select * from someTable

where myprimarykey is null

/cfquery



or where myprimarykey = #somevalueiknowwontexistinthetable#





cfquery name=qName .

select * from someTable

/cfquery

  

cfoutput

#qName.columnList#

/cfoutput

  





Joe Eugene

Certified Advanced ColdFusion Developer

  





-Original Message-

From: Terry [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ]

Sent: Monday, March 10, 2003 9:32 PM

To: CF-Talk

Subject: How to get field names in MSAccess





I know this is simple, but can't remember.



How do use a query to get list of column or field names.

Using CF5.0





Thanks







~~

~~~|

Archives:

http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 

Subscription:  http://www.houseoffusion.com/cf_lists/index
http://www.houseoffusion.com/cf_lists/index .

cfm?method=subscribeforumid=4

FAQ:  http://www.thenetprofits.co.uk/coldfusion/faq
http://www.thenetprofits.co.uk/coldfusion/faq 

Get the mailserver that powers this list at

http://www.coolfusion.com http://www.coolfusion.com 

  

Unsubscribe:

  

http://www.houseoffusion.com/cf_lists/uns
http://www.houseoffusion.com/cf_lists/uns 



ubscribe.cfm?user=633.558.4

  





s. isaac dealey954-776-0046



new epoch   http://www.turnkey.to
http://www.turnkey.to 



lead architect, tapestry cmshttp://products.turnkey.to
http://products.turnkey.to 



tapestry api is opensource  http://www.turnkey.to/tapi
http://www.turnkey.to/tapi 



certified advanced coldfusion 5 developer

http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 








~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Macromedia DONT help me now. so where do i turn now?

2003-03-10 Thread Christian Cantrell
For installation support via email, use the following form:

http://www.macromedia.com/support/email/isupport/

It's free.

Christian

On Monday, March 10, 2003, at 11:11 PM, Michael Kear wrote:

 AMAZING

 Regular readers to this list will be aware that I have been wrestling
 with installing CFMX since last Friday to no avail.   I decided to see
 if Macromedia would back me up as a reseller and developer, and I  
 called
 their support line.

 I got connected to their Manilla office and Pauline's response was that
 I couldn't even talk to a support person unless I paid US$500.

 IN other words, I have downloaded the CFMX, it doesn't install
 correctly, for whatever reason, I can't make it work, no one else can
 either apparently, and Macromedia aren't going to try unless I cough up
 nearly 2/3 of the cost of a server.  That's to evalutate it!!!

 I guess I'm just not meant to be in the MX world.


 Cheers,
 Michael Kear
 Windsor, NSW, Australia
 AFP Webworks.





 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: How to get field names in MSAccess

2003-03-10 Thread Joe Eugene
 just do a WHERE 0 = 0

This will work for the purpose of getting the schema/columns, but it
brings back the entire Table Data.. because 0=0 leads to TRUE

The query has to lead to False like i suggested below.
 select * from TableName where 1=0;

Which leads to false and brings back NO DATA, Just schema(columns).

This is not the best way to get Table metaData. You should also
be able to get column data types and size limits.
This is only possible with using a Java Alernative(Better) or using
System Table Information.

Joe Eugene


 -Original Message-
 From: Jason Miller [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, March 11, 2003 12:11 AM
 To: CF-Talk
 Subject: Re: How to get field names in MSAccess


 just do a WHERE 0 = 0

 I just tested it out and it works
 cfquery name=qName datasource=#dsndata#
 select * from ModuleFeatures
 where 0 = 0
 /cfquery
 cfoutput
 #qName.columnList#
 /cfoutput

 outputs all the columns in that table
 jay miller


 Joe Eugene wrote:


 If you don't want to select any data, and just want the column names,
 use

 or where myprimarykey = #somevalueiknowwontexistinthetable#





 What happens.. if you dont have a primary key? out of luck?



 select * from TableName where 1=0;



 Joe Eugene







 -Original Message-

 From: S. Isaac Dealey [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 ]

 Sent: Monday, March 10, 2003 10:25 PM

 To: CF-Talk

 Subject: RE: How to get field names in MSAccess





 If you don't want to select any data, and just want the column names,
 use



 cfquery name=qName .

   select * from someTable

   where myprimarykey is null

 /cfquery



 or where myprimarykey = #somevalueiknowwontexistinthetable#





 cfquery name=qName .

 select * from someTable

 /cfquery



 cfoutput

 #qName.columnList#

 /cfoutput







 Joe Eugene

 Certified Advanced ColdFusion Developer







 -Original Message-

 From: Terry [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ]

 Sent: Monday, March 10, 2003 9:32 PM

 To: CF-Talk

 Subject: How to get field names in MSAccess





 I know this is simple, but can't remember.



 How do use a query to get list of column or field names.

 Using CF5.0





 Thanks







 ~~

 ~~~|

 Archives:

 http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
 http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4

 Subscription:  http://www.houseoffusion.com/cf_lists/index
 http://www.houseoffusion.com/cf_lists/index .

 cfm?method=subscribeforumid=4

 FAQ:  http://www.thenetprofits.co.uk/coldfusion/faq
 http://www.thenetprofits.co.uk/coldfusion/faq

 Get the mailserver that powers this list at

 http://www.coolfusion.com http://www.coolfusion.com



   Unsubscribe:



 http://www.houseoffusion.com/cf_lists/uns
 http://www.houseoffusion.com/cf_lists/uns



   ubscribe.cfm?user=633.558.4







 s. isaac dealey954-776-0046



 new epoch   http://www.turnkey.to
 http://www.turnkey.to



 lead architect, tapestry cmshttp://products.turnkey.to
 http://products.turnkey.to



 tapestry api is opensource  http://www.turnkey.to/tapi
 http://www.turnkey.to/tapi



 certified advanced coldfusion 5 developer

 http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
 http://www.macromedia.com/v1/handlers/index.cfm?ID=21816








 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Verity file indexing

2003-03-10 Thread Kay Smoljak
OK, found the problem.

The .cfm files had an xml prolog - ?xml version=1.0 encoding=iso-8859-1?. If I 
change the filename to .html they are indexed fine, prolog and all. If I remove the 
prolog, the .cfm files get indexed.

This seems like a bug... I couldn't find mention of it anywhere on MM's site though. 
Seeing as Dreamweaver inserts the prolog by default I'd imagine this is a problem that 
more people will start to see. Is it changed in MX I wonder?

Kay.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Verity file indexing

2003-03-10 Thread Joe Eugene
 The .cfm files had an xml prolog - ?xml version=1.0
 encoding=iso-8859-1?.

Yes, that prolog is Part of what makes an xml document valid.
I dont think DWMX puts that in any file, unless you tell it
to create an xml file.

Joe Eugene


 -Original Message-
 From: Kay Smoljak [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, March 11, 2003 12:05 AM
 To: CF-Talk
 Subject: Verity file indexing


 OK, found the problem.

 The .cfm files had an xml prolog - ?xml version=1.0
 encoding=iso-8859-1?. If I change the filename to .html they
 are indexed fine, prolog and all. If I remove the prolog, the
 .cfm files get indexed.

 This seems like a bug... I couldn't find mention of it anywhere
 on MM's site though. Seeing as Dreamweaver inserts the prolog by
 default I'd imagine this is a problem that more people will start
 to see. Is it changed in MX I wonder?

 Kay.
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Macromedia DONT help me now. so where do i turn now?

2003-03-10 Thread Tilbrook, Peter
Mike, what's your phone number. I'll call you tommorrow (Wednesday) morning
and try and assist.

Cheeers!

==
Peter Tilbrook
Internet Applications Developer
Australian Building Codes Board
GPO Box 9839
CANBERRA ACT 2601
AUSTRALIA

  WWW: http://www.abcb.gov.au/
   E-Mail: [EMAIL PROTECTED]
Telephone: +61 (02) 6213 6731
   Mobile: 0439 401 823
Facsimile: +61 (02) 6213 7287 

-Original Message-
From: Michael Kear [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 11 March 2003 3:30 PM
To: CF-Talk
Subject: RE: Macromedia DONT help me now. so where do i turn now?


Thanks for your suggestion.

What would be the point of it?  I'm sorry but I don't see the reason.
Can you elaborate a little for me? 

I have two computers in my company. Only two.  It's a one-person
company.  The other computer is really small and old.   It would be
really stretched to run the server at all, let alone do anything with
it.  (Plus my servers which are production servers and I'm not going to
go tinkering about with those unless I know what I'm doing)  I need it
on this box.



Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 11 March 2003 3:24 PM
To: CF-Talk
Subject: Re: Macromedia DONT help me now. so where do i turn now?

Michael, have you tried installing on another computer entirely?

-- 
mailto:[EMAIL PROTECTED]
Monday, March 10, 2003, 11:11:05 PM, you wrote:

MK AMAZING

MK Regular readers to this list will be aware that I have been
wrestling
MK with installing CFMX since last Friday to no avail.   I decided to
see
MK if Macromedia would back me up as a reseller and developer, and I
called
MK their support line.

MK I got connected to their Manilla office and Pauline's response was
that
MK I couldn't even talk to a support person unless I paid US$500.

MK IN other words, I have downloaded the CFMX, it doesn't install
MK correctly, for whatever reason, I can't make it work, no one else
can
MK either apparently, and Macromedia aren't going to try unless I cough
up
MK nearly 2/3 of the cost of a server.  That's to evalutate it!!!

MK I guess I'm just not meant to be in the MX world. 




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: How to get field names in MSAccess

2003-03-10 Thread Shlomy Gantz
Found this old piece of code  hope it helps


CFSET Table = MyTable
CFSET Datasource= myDsn
CFSET dbusername= admin
CFSET dbpassword= 

CFSET columnlist=
CFOBJECT type=COM name=MyConnection class=ADODB.Connection
action=CREATE
CFSET TEMP = MyConnection.Open(DSN=#Datasource#,#dbusername#,
#dbpassword#, -1)
CFSET ColumnNames = MyConnection.OpenSchema(4)
CFSET RSfields = columnnames.Fields
CFSET Tablename = RSfields.Item(TABLE_NAME)
CFSET Columnname = RSfields.Item(COLUMN_NAME)
CFLOOP condition=NOT ColumnNames.EOF
CFSET Column = Columnname.Value
CFSET Table2 = Tablename.Value
CFIF not listcontains(columnlist,Column) AND Table2 is #Table#
CFSET columnlist = listappend(columnlist,Column)
/CFIF
CFSET temp = ColumnNames.MoveNext()
/CFLOOP
CFSET CALLER.getColumns = QueryNew(column_name,type_name,length)
CFSET temp = QueryAddRow(CALLER.getColumns , listlen(columnlist) )
CFSET x=1
CFLOOP list=#columnlist# index=column
CFSET temp = QuerySetCell(CALLER.getColumns, column_name, column , 
x)
CFSET temp = QuerySetCell(CALLER.getColumns, type_name, text , x)
CFSET temp = QuerySetCell(CALLER.getColumns, length, 10 , x)
CFSET x=x+1
/CFLOOP
CFSET temp = MyConnection.Close()

It's bad code, inefficient, not documented... but it worked  I think I
used it to mimic sp_columns in SQL. I think you have to create a regular DSN
for this to work.

Shlomy Gantz
Certified Macromedia Instructor
President, Bluebrick Inc.



-Original Message-
From: Terry [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2003 6:32 PM
To: CF-Talk
Subject: How to get field names in MSAccess


I know this is simple, but can't remember.

How do use a query to get list of column or field names.  Using CF5.0


Thanks


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: How to get field names in MSAccess

2003-03-10 Thread Jason Miller
Yes you are right - I may have misunderstood.. .I thought what was
requested was merely getting column names.. nothing more.. so that was
the quick and dirty of it. Depending on what was needed - I thought it
may have helped.. 
I use that quick code if I just need to quickly sniff out the db -
didn't know the involvment of what was needed.

but yes - everything you say below is true - no argument there..

Joe Eugene wrote:


just do a WHERE 0 = 0





This will work for the purpose of getting the schema/columns, but it

brings back the entire Table Data.. because 0=0 leads to TRUE



The query has to lead to False like i suggested below.

  

select * from TableName where 1=0;





Which leads to false and brings back NO DATA, Just schema(columns).



This is not the best way to get Table metaData. You should also

be able to get column data types and size limits.

This is only possible with using a Java Alernative(Better) or using

System Table Information.



Joe Eugene





  

-Original Message-

From: Jason Miller [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
]

Sent: Tuesday, March 11, 2003 12:11 AM

To: CF-Talk

Subject: Re: How to get field names in MSAccess





just do a WHERE 0 = 0



I just tested it out and it works

cfquery name=qName datasource=#dsndata#

select * from ModuleFeatures

where 0 = 0

/cfquery

cfoutput

#qName.columnList#

/cfoutput



outputs all the columns in that table

jay miller





Joe Eugene wrote:





If you don't want to select any data, and just want the column names,

use



or where myprimarykey = #somevalueiknowwontexistinthetable#











What happens.. if you dont have a primary key? out of luck?







select * from TableName where 1=0;







Joe Eugene















-Original Message-



From: S. Isaac Dealey [  mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]

]



Sent: Monday, March 10, 2003 10:25 PM



To: CF-Talk



Subject: RE: How to get field names in MSAccess











If you don't want to select any data, and just want the column names,

use







cfquery name=qName .



select * from someTable



where myprimarykey is null



/cfquery







or where myprimarykey = #somevalueiknowwontexistinthetable#











cfquery name=qName .



select * from someTable



/cfquery







cfoutput



#qName.columnList#



/cfoutput















Joe Eugene



Certified Advanced ColdFusion Developer















-Original Message-



From: Terry [  mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ]



Sent: Monday, March 10, 2003 9:32 PM



To: CF-Talk



Subject: How to get field names in MSAccess











I know this is simple, but can't remember.







How do use a query to get list of column or field names.



Using CF5.0











Thanks















~~



~~~|



Archives:



http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 

 http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4



Subscription:   http://www.houseoffusion.com/cf_lists/index
http://www.houseoffusion.com/cf_lists/index 

 http://www.houseoffusion.com/cf_lists/index
http://www.houseoffusion.com/cf_lists/index .



cfm?method=subscribeforumid=4



FAQ:   http://www.thenetprofits.co.uk/coldfusion/faq
http://www.thenetprofits.co.uk/coldfusion/faq 

 http://www.thenetprofits.co.uk/coldfusion/faq
http://www.thenetprofits.co.uk/coldfusion/faq



Get the mailserver that powers this list at



http://www.coolfusion.com http://www.coolfusion.com
http://www.coolfusion.com http://www.coolfusion.com







Unsubscribe:







http://www.houseoffusion.com/cf_lists/uns
http://www.houseoffusion.com/cf_lists/uns 

 http://www.houseoffusion.com/cf_lists/uns
http://www.houseoffusion.com/cf_lists/uns







ubscribe.cfm?user=633.558.4















s. isaac dealey954-776-0046







new epochhttp://www.turnkey.to
http://www.turnkey.to 

 http://www.turnkey.to http://www.turnkey.to







lead architect, tapestry cms http://products.turnkey.to
http://products.turnkey.to 

 http://products.turnkey.to http://products.turnkey.to







tapestry api is opensource   http://www.turnkey.to/tapi
http://www.turnkey.to/tapi 

 http://www.turnkey.to/tapi http://www.turnkey.to/tapi







certified advanced coldfusion 5 developer



http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 

 http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816























RE: Macromedia DONT help me now. so where do i turn now?

2003-03-10 Thread Michael Kear
This is a very generous offer from Peter. He's a good man.  I've sent
him my phone number off-line. 

SO many people have shown a willingness to help with this, I promise I
wont get it fixed and not post the solution here.  I'm sure there are
plenty of people who want to know how it turns out.


Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.





-Original Message-
From: Tilbrook, Peter [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 11 March 2003 5:15 PM
To: CF-Talk
Subject: RE: Macromedia DONT help me now. so where do i turn now?

Mike, what's your phone number. I'll call you tommorrow (Wednesday)
morning
and try and assist.

Cheeers!

==
Peter Tilbrook
Internet Applications Developer
Australian Building Codes Board
GPO Box 9839
CANBERRA ACT 2601
AUSTRALIA

  WWW: http://www.abcb.gov.au/
   E-Mail: [EMAIL PROTECTED]
Telephone: +61 (02) 6213 6731
   Mobile: 0439 401 823
Facsimile: +61 (02) 6213 7287 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



<    1   2   3