Re: which is the best way to do auto retrieval of Address...

2002-02-27 Thread Jon Hall
http://www.ashleyit.com/rs/main.htm jon - Original Message - From: "han peng" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 27, 2002 1:13 AM Subject: which is the best way to do auto retrieval of Address... > hi... i need to do a address input fields..

Re: local variable dump?

2002-02-27 Thread Stephen Moretti
> Ah, if wishes could come true... > Unfortunately, I don't believe you can loop through the variables or client > scopes. > Client variables you can. Use GetClientVariablesList() if CFDump doesn't work. Server variables are the other scope that you cannot CFDUMP. Regards Stephen

RE: OT JS again

2002-02-27 Thread Steve Oliver
There's a tag called cf_state on the dev exchange that does all of the work for you, you just declare the name of the field. _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: [EMAIL PROTECT

RE: local variable dump?

2002-02-27 Thread Pascal Peters
The local (variables.) scope is not a structure, so you cannot retreive them automatically. You can see them using the debugger in CFStudio. -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: woensdag 27 februari 2002 18:06 To: CF-Talk Subject: QQ: local variable dump

RE: local variable dump?

2002-02-27 Thread David Schmidt
Ah, if wishes could come true... Unfortunately, I don't believe you can loop through the variables or client scopes. __ Why Share? Dedicated Win 2000 Server ยท PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activatio

RE: which is the best way to do auto retrieval of Address...

2002-02-27 Thread Steve Oliver
Yes you could do that, in the onchange paramater of the select box have it popup a new window. Do the query in that new window, then user the following javascript. opener.formname.streetname = 'qry.StreetName'; opener.formname.city = 'qry.City'; If the form isn't named, and you only have 1 fo

RE: 'Edit with CF Studio' with right-click in Windows Explorer

2002-02-27 Thread Dave Watts
> After upgrading to Studio 5.0 I lost the 'Edit with CF > Studio' option when I right-click on a cfm or html file > in Windows Explorer. How can I get this back or is this > a new feature of Studio 5.0? Thanks! By default, you should have this option. In any case, though, it's easy to add it

Re: Locked

2002-02-27 Thread Bryan Stevenson
This can also mean that the database is corrupted. Try opening the DB and compacting and repairing it. Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromed

QQ: local variable dump?

2002-02-27 Thread Tyler Silcox
Is it possible to dump/loop through local variables? As I've said many times on this list, cfdump is a godsend for debugging, but I have not found a way to loop through all my local/varaible scoped variables yet... Tyler Silcox email | [EMAIL PROTECTED] _

Re: Locked

2002-02-27 Thread Howie Hamlin
It could also happen if someone opens the database in exclusive mode. HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server >>> Find out how iMS Stacks up to t

Locked

2002-02-27 Thread kelly
Been getting this error on a certain site. Normally it is due to have the table in design mode. But this isn't the case this time. Can anyone shed some light as to why else this happens? Thanks! ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Could not update

RE: Problem w/ CFFILE...

2002-02-27 Thread Elizabeth Walter
Kelly, Try adding this atribute to your form tag: enctype="multipart/form-data" -Elizabeth -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 11:40 AM To: CF-Talk Subject: Problem w/ CFFILE... I haven't run across this error before.

RE: Template running more than once?

2002-02-27 Thread Chad Gray
I have never been able to get IE for Windows to submit two pages on a double click, but Netscape for Linux, and Irix will allow a double submit. I can replicate the double submit consistently on Linux, and Irix. My action page was not suppose to run if it had already run (based on looking at

Problem w/ CFFILE...

2002-02-27 Thread Kelly Matthews
I haven't run across this error before. On my form I have this: Logo: Which allows for me to upload a file. I basically click Browse and find the image. The action page has: Well I am getting an error on that that says: Message Error in CFFILE tag Type UNKNO

Re: Form field values on post

2002-02-27 Thread Alex
javascript is slow on NT? Are you sure about this? On Wed, 27 Feb 2002, Hays, Duncan wrote: > I'm trying to post a form and then, on the page I'm posting to, loop thro ugh > all the form fields and get the values. I've been shown form.formfields a nd > that great for the names but how to I get

RE: CFREPORT :: (CRPE32.DLL) could not be located

2002-02-27 Thread Paul Ihrig
do i need a full version on the server to run cfreport? http://store.crystaldecisions.net/dr/v2/ec_MAIN.Entry16?SP=10024&PN=29&xid=1 5248&V1=30010453&V2=30010453&V3=1&V5=11028983&V4=10&S1=&S2=&S3=&S4=&S5=&DSP= 0&CUR=840&PGRP=0&CACHE_ID=36273 what version!?? thank you -paul _

Re: Form field values on post

2002-02-27 Thread Stephen Moretti
> I'm trying to post a form and then, on the page I'm posting to, loop through > all the form fields and get the values. I've been shown form.formfields and > that great for the names but how to I get the values out. I can't come up > with the syntax. > form.yourformvariable or if you're looping

RE: Form field values on post

2002-02-27 Thread David Schmidt
Whoops! on the action page... #fieldname# = #myvalue# -Original Message- From: Hays, Duncan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 8:18 AM To: CF-Talk Subject: Form field values on post I'm trying to post a form and then, on the pa

RE: Form field values on post

2002-02-27 Thread Hays, Duncan
Thank you Thank you Thank you -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 11:28 AM To: CF-Talk Subject: RE: Form field values on post on the action page... #fieldname# = #evaluate("#thisvariablename#") --

RE: Form field values on post

2002-02-27 Thread David Schmidt
on the action page... #fieldname# = #evaluate("#thisvariablename#") -Original Message- From: Hays, Duncan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 8:18 AM To: CF-Talk Subject: Form field values on post I'm trying to post a form and then, on th

Form field values on post

2002-02-27 Thread Hays, Duncan
I'm trying to post a form and then, on the page I'm posting to, loop through all the form fields and get the values. I've been shown form.formfields and that great for the names but how to I get the values out. I can't come up with the syntax. *I'll use JavaScript prior to the submit if I have t

OT JS again

2002-02-27 Thread savan . thongvanh
sorry for all the js stuff today. have a function to write a select box of states. is it faster, in general, to write text to a page with a function or return a string and write the string? Thanksabunch, Savan __ Get Your Own D

RE: Access -> MS SQL script?

2002-02-27 Thread Declan Maher
use the upsizing wizard in Access after you grt username and pass from the person in charge of sql server. -Original Message- From: Louis Klepner [mailto:[EMAIL PROTECTED]] Sent: 27 February 2002 15:44 To: CF-Talk Subject: RE: Access -> MS SQL script? Thanks for the advice, and I wish i

RE: Template running more than once?

2002-02-27 Thread Shawn Grover
It is an action page for a form, but the submit button is NOT being double-clicked. I guess I can add this code to see if the browser somehow thinks a double click is being done, but I don't think that is the issue. Thanks though. Shawn Grover -Original Message- From: Chad Gray [mailto:

RE: Access -> MS SQL script?

2002-02-27 Thread Louis Klepner
Thanks for the advice, and I wish it were that easy for me... but I'm i n a shared hosting environment and don't have access to the SQL Server Mana ger. Could I do this on my development machine, then somehow export a script which would replicate the database on the actual server? Or am I stuck

RE: Access -> MS SQL script?

2002-02-27 Thread David Schmidt
Just make sure that your data is imported properly, particularly where autonumbers must become identity fields. It can also cause duplicating d ata every once in a while. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 7:06 AM To:

Re: Access -> MS SQL script?

2002-02-27 Thread Stephen Moretti
> Hello Fellow CF'ers, > > I was wondering if anyone knew of a script that would analyze a Access > Database and replicate the structure in SQL? Something which loops through > the tables, checks data types, and creates a MS SQL version of the database- > You can just open up SQL Server Enterpris

RE: CFREPORT :: (CRPE32.DLL) could not be located

2002-02-27 Thread Hays, Duncan
I don't think CF4.5 has anything other than the tag. We got a demo of Crystal Reports 8.0 which let you install the web reporting functionality on the web server. Then we ended up buying Crystal Enterprise 8.0 and CR 8.5. Enterprise 8.0 is a whole app to administer your reports which we don't e

Access -> MS SQL script?

2002-02-27 Thread Louis Klepner
Hello Fellow CF'ers, I was wondering if anyone knew of a script that would analyze a Access Database and replicate the structure in SQL? Something which loops through the tables, checks data types, and creates a MS SQL version of the database- Thanks, Lou Klepner

RE: CFREPORT :: (CRPE32.DLL) could not be located

2002-02-27 Thread Paul Ihrig
i thought there was a scaled down version on cf server 4.5 ent we have reports around here some where but i thought 5 would have it built in! ok... can i install it from 4.5? -paul -Original Message- From: James Maltby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 9:4

RE: CFREPORT :: (CRPE32.DLL) could not be located

2002-02-27 Thread Hays, Duncan
I'm pretty sure you need Crystal installed to produce the report. I know that it WASN'T included with 4.5 and isn't in 5. If it's running non-locally you might be able to set the full path to the Crystal server or you could call it directly "http://./myreport.rpt";. If called directly it w

CFREPORT :: (CRPE32.DLL) could not be located

2002-02-27 Thread Paul Ihrig
ok? where do i get this dll? i thought cfreport was standard in 5? first time messing with it. do i actually need crystal on my local machine to test some one else's report? thanks -paul Error occurred while processing CFREPORT The Crystal Reports Engine (CRPE32.DLL) could not be located on

OT: Non-Wrapping strings in IE5

2002-02-27 Thread Carlisle, Eric
This is pretty odd. I noticed that strings of certain characters just won't warp in IE5. "! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! !" <-- Put this in a fixed width table. It won't wrap when it's supposed t

Re: CFPOP and html stripping

2002-02-27 Thread Tyler Silcox
You can grab the HTML part of the multi-part message from your attachments directory that you specify with the AttachmentsPath attribute of cfpop. CF saves your HTML part of the message with a unique filename, without a file extension. So you'll have to parse out the real attachments first, and

Re: too much cookie?

2002-02-27 Thread savan . thongvanh
depends on how much else you're sending back and forth but more than li kely not. (speaking AS a dialup user :) ) [EMAIL PROTECTED] on 02/26/2002 05:52:48 PM Please respond to [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> cc: Subject: too much cookie? I'm wondering if using a coo

Re: CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode error

2002-02-27 Thread Dave Carabetta
>We received the following error from CF 5.0 this morning: > > >Error Occurred While Processing Request >Error Diagnostic Information >An error has occurred while processing the expression: > > >webroot=CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLC

'Edit with CF Studio' with right-click in Windows Explorer

2002-02-27 Thread Earl, George
After upgrading to Studio 5.0 I lost the 'Edit with CF Studio' option when I right-click on a cfm or html file in Windows Explorer. How can I get this back or is this a new feature of Studio 5.0? Thanks! George __ Why Share? De

CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode error

2002-02-27 Thread Earl, George
We received the following error from CF 5.0 this morning: Error Occurred While Processing Request Error Diagnostic Information An error has occurred while processing the expression: webroot=CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode12233

Query angst!

2002-02-27 Thread Crispin Ryan
Help! I've got three tables - resources (resource_id, description, total_available) resources allocated: (allocation_id, resource_id, event_id) and events with event_id and event_date My output for each event has to show: All resource names, and the total number of each resource booked on that d

Re: ORDER BY in a query of queryies (built with QueryNew)

2002-02-27 Thread Zac Spitzer
> > > > > > > > #cartquery.owner#)> > #cartquery.qty#)> > "#cartquery.desc#"> > #cartquery.price#)> > > > > > select SUM(qty) AS quantity, owner, descriptio

Re: CF Mail and SMTP Auth

2002-02-27 Thread Jochem van Dieten
Jim McAtee wrote: > Can CF Server be configured to use SMTP authorization to relay mail through > a remote server that requires SMTP Auth? No. But after a glance through RFC 2554 it looks feasible to make sure that the MTA accepts authentication of the "From: AUTH=password" type and just append

RE: Bulk restoring databases

2002-02-27 Thread Ian Tait
You could script it... >From tsql help: This example restores a full database and transaction log and moves the restored database into the C:\Program Files\Microsoft SQL Server\MSSQL\Data directory. RESTORE DATABASE MyNwind FROM MyNwind_1 WITH NORECOVERY, MOVE 'MyNwind' TO 'c:\Pro

<    1   2