JDBC drivers for old FoxPro DBF files.

[Arden Weiss]

Need advice on what database drivers work well with CF10 and the old FoxPro for 
DOS DBF files. Back in the CF

Client has app that has been running flawlessy since 2000 or so using CF5 and 
the ODBC drivers that came with the product to process credit card transactions 
via authorize.net -- back in the CF6 days, I failed to find a JDBC driver that 
played nicely with the DBF files -- hope that has changed.

Recently flaws in the SSL3 security (POODLE) caused authnet to drop support for 
SSL3 and hence broke the application -- we now will be using CF10 with Java 1.7 
and TSL1.2 to solve that problem, but we need solid support for DBF file update 
until the whole system gets rewritten/changed.

Any/all advice requested. 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359703
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Easy Credit Card Processing Service?

[Arden Weiss]

One of my clients was using AUTHORIZE.NET for quite a while, but about a year 
ago we swithched to SAGE -- why -- considerable cheaper per transaction and the 
accountant was being driven mad by the non-standard accounting practices being 
used by authorize.net -- she loves the reports she gets from SAGE.

The Cold Fusion code to interface with SAGE and AUTHORIZE.NET is quite similar 
-- it took me less than a day to swithch the code over -- the main issue was 
that SAGE used fewer fields and different field names when communicating with 
the gateway.

In both cases processing send-to-response time is normally less than two 
seconds. We do about 100,000 transactions a year with very, very few problems 
-- the most serious issue is that the DSL internet connection squats every once 
in a while. So we do have and offline mode built into the logic of the card 
present point-of-sale system and in that mode use a telephone line based credit 
card machine to keep ringing sales.

If you are interested, I will be giving a presentation at the December meeting 
of the Maryland Cold Fusion User Group in Rockville MD on this point of sale 
system that merges a heritage FoxPro for DOS point of sale syatem with Cold 
Fusion credit processing interface. 

The user group sponsored by TeraTech has an Adobe Live broadcast of the 
meetings, so you can attend remotely if you wish -- the CF code to do the 
send/recive gateway transaction is as follows:



  https://www.sagepayments.net/cgi-bin/eftBankcard.dll?Retail_Transaction"; 
port="443" method="post">





  

  

  https://www.sagepayments.net/cgi-bin/eftBankcard.dll?Transaction"; 
port="443" method="post">


    
    



  



Hope this helps...

Arden Weiss



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315799
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Is it possible to access network drives with CFDIRECTORY and CFCONTENT

[Arden Weiss]

I seem to not be able to access a mapped network drive with CFDIRECTORY and 
CFCONTENT. 

The CF7 app needs to be able to access/manage a store of PDF files and display 
them in the user's browser.

Everything works great as long as the PDF files are located in a folder on a 
drive directly attached to the box on which CF7 is installed, but fails when I 
try to access the same files located on a mapped network drive.

The simple solution would be to put the files on one of the drives on the CF 
box, but the network guys are fussy about doing that. 

So any insight on how to access and display the PDF files located on a 
networked drive  would be most helpful.




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308841
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: internetmerchant.com

[Arden Weiss]

>is anyone using these guys?
>they have a deal at HMS with them that looks decent.
>
>And does anyone know/have code to interact with their gateway.
>
>tia

Not to confuse you, if your mind is made up, but suggest you
take a look at Sage before you decide -- we moved from authorize.net 
to Sage because of two major factors:
1. Much cheaper 
2. Authorize.net do not use standard accounting procedures/reporting
   which made them unacceptable to the Accountant.

http://www.sagepayments.com/Products/BankCard.aspx 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294051
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Authorize.net card present account

[Arden Weiss]

>Hmm...so, let me get this straight:
>
>- A "card present" account is actually just an account that, if the card is 
>actually present, requires a bit less information (no address,cvv needed) 
>than a non-card present account, because the track information on the card 
>gets sent;
>
>- However if the card is not present, you can spoof it by sending more 
>information, i.e. the address and zip code.

Note: Depending on the "processor" either the "zip and addr" or the CVC number 
on the back of the card is required -- "First Data" wants the "zip and addr", 
"Sage" appears to want the CVC number. 

Regarding tests -- go for it -- guarrenteed to work -- it is in production here.
If you want to contact me offline [EMAIL PROTECTED] -- can send CFHTTP code 
snippets that work for us.

>
>-- Josh
>
>
>
>- Original Message - 
>From: "Arden Weiss" <[EMAIL PROTECTED]>
>To: "CF-Talk" 
>Sent: Friday, February 02, 2007 12:53 PM
>Subject: Re: Authorize.net card present account
>
>
>>

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268561
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Authorize.net card present account

[Arden Weiss]

>
>For various dumb reasons my boss wants to use the card present account to 
>process web transactions.
>
>I tried bouncing a web transaction off the card present account, but not 
>surprisingly got the error "account not authorized for that type of 
>transaction" or some such.

My experience with authorize.net is as follows:

We are running AIM card pressent system and can enter card data manually in 
those cases where the customer has phoned in a purchase and given credit card 
information.

In the case where the card is present and swiped, the contents of the enire 
track 1 is sent to the bank as x_track1 variable (processing entity) via 
authoize.net along with other required information via a CFHTTPS transmission 
-- approvals or denials are sent back.

In the case where the card is NOT present, the card number, expiration info 
numeric part of the address and the zipcode is sent as separate variables via 
the same process -- approvals or denials are received back.

As far as we are concerned the process is transparent at authoize.net -- 
however, at the bank or processor, they do keep track of whether track1 or the 
pieces comprising the contents of track1 and different rules apply plus the 
cost of manual transactions are more than scanned transactions.

If you have questions, I suggest you contact Corey Koeing at [EMAIL PROTECTED] 
-- he is the resident program that is familar with CF and the what they do.

Also, of interest is the fact that authorize.net does not handle Pin Debit 
transacitons -- debit cards are handle just like credit cards transactions and 
settle daily...

Hope this was helpful...

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268533
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Generating Static HTM Pages with CF7

[Arden Weiss]

I have created a CF program that generates a static HTM page -- obtained by 
manually doing a "View Source" and then "Save As" once the CFM page is 
displayed in IE.

Since I need to do 100 or so pages like this, am needing advice on how to do 
the "view source" and "save as" programatically/easily.

Can this be accomplished via CFDOCUMENT ?

Any/all advice welcome.

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264279
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ColdFusion and Microsoft Excel

[Arden Weiss]

The MasRizal product uses the Jakarta stuff...

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261842
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: ColdFusion and Microsoft Excel

[Arden Weiss]

I tried with success in using the CFCONTENT method to generate Excel 2000 
files; however, it blew up when Excel 2003 was on the client's machine.

Instead, I bought the CFX_EXCEL product from MasRizal and it has worked 
flawlessly for just about a year now. See product at following link

http://www.masrizal.com/index.cfm?fuseaction=idea.download_detail&ProductID=cfx_excel

>Question:
>I am a newb to CF and I have been assigned the daunting task of dynamically
>generating an excel file with absolutely no user action entailed.  We
>currently have code that takes HTML and throws it in an excel file, but the
>user is prompted to download/save it.  We dont want that. I have seen many
>different solutions given here, but i am not sure which to follow.  The
>overall task is to create and excel file on the fly and then email it out to
>a user.  Any help is appreciated.

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261808
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Authorize.net processing refunds

[Arden Weiss]

Yes, refunds work without the need for full CC -- key is having the Transaction 
ID that was used to do the original charge against which you want to do a 
credit/refund  full or partial.

Note that if the charge being refunded has not yet gone to settlement, then, 
you must void out the sale and recharge a balance due.


> I'm building my first refund processor for authorize.net, and it acts 
> like it wants the full CC # and the exp date. I do not and will not 
> ever store these anywhere. 
> 
> The docs say you can just send the last 4 digits of the #, the trans 
> ID, and the amount. 
> 
> not having any luck with it yet. I keep getting response code 3 and 
> reason code 6 - Credit card is invalid. 
> 
> Anybody else ever do this?
> 
> Thanks,
Will

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256810
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: OT: can you resolve this domain?

[Arden Weiss]

>Hey all,
>
>We are having some dns issues where some ISP's can resolve our domain and 
>some can't.  Something about nameserver records pointing to multiple 
>servers.  It would be super duper if some folks could try to hit our domain, 
>and then just reply to the list "yes" or "no" and what isp you are on, or if 
>you use a different dns server than your isp's, whose dns server you're 
>using.  For example "yes - comcast" or "no - cox".  So far ones that can't 
>resolve are Speakeasy and Verizon, while it seems others can.  The domain 
>is:
>
>http://www.igigi.com
>
>TIA!
>

No for Verizon from here in the back waters of Chesapeake Bay  :-)

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252167
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: 3 Authorize.Net Questions

[Arden Weiss]

One added point -- on voids and credit transactions the previous transaciton ID 
is sent to the gateway via variable x_ref_trans_id...



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252166
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: 3 Authorize.Net Questions

[Arden Weiss]

>http://www.authorize.net/support/AIM_guide.pdf
>
>Everything you need to know about integration is contained in there.
>

Well, not quite everything -- some added thoughts for your consideration.

There also is a "card-present" pdf file on their site if you are needing to
do a point-of-sale app where you can have the customer swipe his card.

In a card not present situation or where you have to mannually enter the card 
info
in a card-present system, the ZIP and ADDRESS field names expected by the 
gateway are X_ZIP and X_ADDRESS respectively. Example code that works well 
follows:

https://secure.authorize.net/gateway/transact.dll"; >
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  


Also note that doing a refund or credit against a same-day sale (one that has 
not gone to settlement requires a "void" operation and then a "auth_capture" to 
charge the new amount.  With next day refunds/credits (done after settlement) 
you can do a credit without having to do a void. With a void or credit, you 
only need to have the TRAN_ID code returned by the gateway along with the last 
four digits of the credit card number (so no need to do a card reswipe for 
refunds partial or total). 

Finally, both debit and credit cards are handled the same by the gateway.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252163
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Returning javascript variables to CFMX via hidden fields.

[Arden Weiss]

I also want to thank Steve Drucker for the initial example code snippets that 
show how to pass variables back and forth between CF and Javascript -- see 
following link for Chapter 19 of the "The Cold Fusion Web Database Construction 
Kit" that deals with Data Validation Techniques, etc...

http://docs.rinet.ru/Cold/ch19/ch19.htm

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184729
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Returning javascript variables to CFMX via hidden fields.

[Arden Weiss]

Thanks for pointing out the obvious to this Javascript newbie -- your revised 
code did the trick for this simple app -- next step will be to use your other 
advise for my real case of where I am creating the initial mover box contents 
from database tables.

Thanks Again Pascal...

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184727
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Returning javascript variables to CFMX via hidden fields.

[Arden Weiss]

I understand that -- in the code I posted, that is happening -- there are three 
cases in the code posted.  

The first case sends a CF variable mCF_VAR_IN to Javascript and then javascript 
sends it back as a different variable mCF_VAR_OUT -- this works fine in both IE 
and firefox.

The 2nd case a variable "hello" is defined in Javascript and sent back to CF 
for display as a text string "Hello World" -- this works fine in both IE and 
firefox.

The third case is related to a Javascript mover box -- while the variable is 
returned in both IE and Firefox, the actual values of the menu2 variables are 
not being produced inside Javascript when run via IE6 hence, they come back as 
empty string when the variable "result_set1" gets displayed in CF.

The problem is definitely inside the Javascript code, not CF because even when 
I inserted a document.write(mystr3) inside the javascript STUFFVALUE() program, 
it came up empty...

That's about it here in the back waters of Chesapeake Bay...



>The values of JavaScript variables are, by themselves, never returned to the
>server. You have to copy the values into form fields or URL parameters or
>cookies for this to happen.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>phone: 202-797-5496
>fax: 202-797-5444

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184510
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Returning javascript variables to CFMX via hidden fields.

[Arden Weiss]

As follows is the code requested -- am just a newbiew JS programmer, so any 
help/advice is welcome...










JavaScript: Mover Box Pick List


  

  
  
 Menu Item 1
 Menu Item 2
 Menu Item 3
 Menu Item 4
 Menu Item 5
  
  

  

  
  
  Menu Item 6
  
  
  

  
  
 
  
  
  

  

  

  












got to theForm.cfm

mCF_VAR_OUT = #mCF_VAR_OUT#
hello = #hello#
selected_list = #result_set1#



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184507
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Returning javascript variables to CFMX via hidden fields.

[Arden Weiss]

The values of Javascript variables are being returned properly to CFMX when CFM 
template is run via FireFox Browser. 

The values are being returned as empty or null strings when run via Internet 
Explorer 6 sp2 (have not checked with IE 5.5)

Any ideas why and what setting changes need to be made in IE 6 to eliminate 
this problem ?

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184504
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

cfexecute problems

[Arden Weiss]

I am having trouble running a Visual FoxPro Executable via CFEXECUTE to do some DBF 
maniupations on the Server -- the EXE is loaded as a service and then is not released 
upon execution timeout as specified in the CFEXECUTE statement (20 seconds) -- I 
included reference to an "outputfile" but no output is actually generated by the 
program so the file generated is empty.  

JasonOU reported to Macromedia that he fixed the problem by running 
"dcomcnfg". He then went to the "Default Security" tab, clicked on "Edit Default" 
under "Access Permissions", and added the account which the IIS service uses to 
execute anonymously (this is generally IUSR_machinename).

Since I am running XP Home (without IIS), I am using CF's Internal equivalent of IIS 
and am wondering what fix works that may be similar to the one suggested by JasonOU to 
get the EXE released. 

Thanks in advance...

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183230
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: forms and sub-forms best practices feedback desired

[Arden Weiss]

Very nice -- Thanks

Hope to get some more inputs -- this ole brain needs all the help it can get and then some :-))
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

forms and sub-forms best practices feedback desired

[Arden Weiss]

In many cases I have a master form/page with a dozen or so fields. 

On the master form/page I also have one or more buttons that call sub-forms/pages for purposes of maintaining multiple records associated with the master form/record (in a one to many relationship).

The question I have is "What is the best practice to use to maintain state in the master form/page while working with the sub-form/pages -- so any changes that have been made in the fields on the master form/page re-appear when the master form/page reloads?

Right now I am using client scoped variables to do the trick to avoid using cflock with session scoped variables.

Is this the best practice or is another approach mo-betta???
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Toggling Insert key off and on

[Arden Weiss]

Thanks for pointing me in the right direction. 

At minimum I can do a trim of the field contents on screen display and then use the kind of script you suggest to omit trailing spaces.

Alternatively, I could just increase the max length of the field to double the number of allowable characters and handle the trailing spaces on submit.

Stay tuned...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Toggling Insert key off and on

[Arden Weiss]

Guess the follow-up question is how to clear spaces behind cursor when entering data into a field -- a script to remove trailing spaces as the user types.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Toggling Insert key off and on

[Arden Weiss]

Bummer :-)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Toggling Insert key off and on

[Arden Weiss]

Is there a way to determine the setting of the Insert key and toggle it to either off or on -- on entry to a form -- I assume it is done with _javascript_ -- need the script.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Active Directory / LDAP login

[Arden Weiss]

Take a look at this link:
http://www.macromedia.com/devnet/mx/coldfusion/articles/ntdomain.html 

and also at this link:
http://www.macromedia.com/devnet/mx/coldfusion/articles/ntdomain_1.html

and this link:
http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=7&threadid=800572&forumid=1#2874619

Hope this helps...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: populating neighbourhood dropdown based on municipality chosen

[Arden Weiss]

WoW -- the goodies at http://www.mattkruse.com/_javascript_/  are really fantastic -- thanks for sharing Mark...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: populating neighbourhood dropdown based on municipality chosen

[Arden Weiss]

Isn't this a case of where Nate Weiss's  can be used. It is available at the following URL

http://projects.nateweiss.com/nwdc/workcode.htm
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: User Authentication

[Arden Weiss]

My two cents...

Maybe I am off-base, but I only use session variables for login management purposes -- instead I mostly use client variables to gain inter-template communication -- the advantage of this is that no locking is required.  

Guess there are some disadvantages, but I haven't found them yet and would like to be enlightened, etc.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: OT How to prevent someone changing my home page

[Arden Weiss]

I too use AdAware 6.0 (along with the memory resident Ad-Watch) in addition to Symantec virus protection software. Further I also have a firewall in place as provided by my Belkin wireless router.  The entire set of product types are required to provide a good defense to the various intruders our there. Even with this in place, I still get spam email from folks that use different source addresses which rules are hard to create to block.

An excellent tool to determine how "stealth" you are in at http://www.pcflank.com/ -- see set of available test in upper left hand menu entitled: "Test your System"

Happy trails...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: CSS 'focus' in IE

[Arden Weiss]

What I use for focus into field one...


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: CFMX and non-HTML Paginated Report Generation

[Arden Weiss]

Hoping I can get some more feedback on what you experts use and like to do non-HTML paginated reports.

Appreciate very much the responses received so far that tells me to avoid trying to use Crystal Reports with CFMX. 

Also, found post at Macromedia forum that quoted the Crystal tech support saying that they do not support CFMX -- bully for them :-)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

CFMX and non-HTML Paginated Report Generation

[Arden Weiss]

Does Crystal Reports play nice with Cold Fusion these days??

If so, exactly what components/versions of Crystal are required to be able to generate reports in PDF file format?

Also, what report generation products do you use and like -- instead of Crystal Reports -- to generate paginated reports via CFMX ??

Thanks for any and all advice...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Force Refresh

[Arden Weiss]

What works for me is to add at time string down to the nearest second to insure uniqueness -- easier than using a random number...

    
    
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Specify default folders when uploading files.

[Arden Weiss]

I am using the standard HTML INPUT tag with TYPE="FILE" and do not seem to be able to make CF go to a pre-specified local folder to get the file to be uploaded.  It goes to the last one visited by other windows components. My current code that doesn't work is as follows:



  
Value="#mFILE_NAME#">


Any advice on how to do this would be very helpful.

Thanks in advance.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: How to post a null date variable to a table

[Arden Weiss]

>Why not use the cfqueryparam tag -- which you should be using anyway  :-)

Good Question -- used it and got success -- both blank and populated date fields now post without error  -- Wh Ho !!

But had trouble getting the exact syntax you suggested to work for me -- so ended up with the following construct -- probably can shorten it when I am awake in the am -- but your advice got me on the right track -- a gold star for your -- thanks 


  

  



   UPDATE MYTABLE
 SET AGT_TO_DTC = 
  VALUE = "#AGT_TO_DTC#" null="#mTEST#" /> 
 WHERE ID_NUMBER = '#mFINDIT#'

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: How to post a null date variable to a table

[Arden Weiss]

Yes the existing code works, but what if the variable #appl_date# becomes blank on the user's input form/field -- then a 1/1/1900 date gets posted to the APPL_DATE field in MYTABLE table.

 APPL_DATE = #APPL_DATE# ,

The alternative is to use a CASE statement in the UPDATE query, but I can't seem to get that syntax right either...

Brain Cramp time I guess...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

How to post a null date variable to a table

[Arden Weiss]

How to post a null date to SQL Server 2000 via a variable instead of just using the word "Null" or do I have to use an embedded CASE statement.


  UPDATE mytable
  SET
  APPL_DATE = #APPL_DATE# , <-- This has a valid date and works fine
  APRV_DATE = Null  <-- This posts a Null Date to "mytable"   
  WHERE L_NUMBER = '#mFINDIT#'


Hope the question is clear...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Importing Access to MSSQL

[Arden Weiss]

Several ways to do this.

Use the upsizing wizard -- but I'm told that there are problems using that approach for data -- okay to get the table structures in place I think. Alternatively, create the new tables manually in MSSQL.

Once the tables are in place, use CF to query the Access Table and then use CF to Insert recrods into MSSQL table.

Another way is to use a Windows app in client-server mode with ODBC drivers to do the Query and Post process -- I use Visual FoxPro and ODBC drivers for this purpose a lot irrespective of what the "from" and "to" databases are (Excel, Text, Access, MySQL, MSSQL, Oracle, etc). 

Both of these processes allow for a lot of data checking and cleanup to be done in the migration process because of FoxPro's extensive string and date manipulation functions.  Processing Datetime fields can be a bugger to deal with especially going from other than Access to MSSQL. 

To give you some performance numbers, I deleted and then created a new MSSQL table located at a hosting service from a local 10,000 record FoxPro DBF file -- the process took about 20 minutes over a 56k modem.

Just another two cents -- hope it helps...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: desktop application

[Arden Weiss]

If you want to stick with a flavor of CFML, there is a budding product out of Toronto called CORAL that permits building CFML-based apps on a local machine just like you would build a VB or whatever app locally and use whatever backend database you want. For more details go to:
http://www.pcaonline.com/coral/index.cfm
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Help! can't get Oracle connection

[Arden Weiss]

If I recall what I was told correctly, you had to be running the Enterprise version of CFMX to support Oracle with direct drivers -- hence the reason going with the ORA92 ODBC drivers for version 9.2 of Oracle -- I am running CFMX Standard/Professional or what it is now called and it works great with the ORA92 ODBC driver...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Help! can't get Oracle connection

[Arden Weiss]

Which version of Oracle are you running -- what I did for Oracle 9.2 is download the ORA92 ODBC driver from Oracle (the one with CFMX is for Oracle 8  I believe) and installed it.

Next I went to the Control Panel/Administrative Tools/Data Sources (ODBC).
In this screen click on the System DSN tab and pres the  button. Then scroll down to the entry that should say "Oracle in OraHome92" -- the fill out the fields on "Oracle ODBC Driver Configuration" screen and press the "Test Connection" button -- if you got the entries right, then the connection should test out okay. 

With the test connection working, you can then go to CFMX Admin and the DNS will appear in the list ready to use.

As least that is what I recall happened to me a couple of months ago when I installed in on my laptop...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Flex is out

[Arden Weiss]

And if Microsoft buys MM for Flask etal, guess what -- Cold Fusion is
dead -- just like they knifed FoxPro in the back...

-Original Message-
From: Dwayne Cole [mailto:[EMAIL PROTECTED]
Sent: Monday, March 29, 2004 11:16 PM
To: CF-Talk
Subject: Re: Flex is out

I predict that Macromedia is going to sell off ColdFusion within the
next 2 years.  Their product portfolio is too diversified and their
customer segments have very little in common - Flash, ColdFusion,
Director, Fireworks, Breeze, and now Flex - very different developer
communities.

Macromedia is all over the place and their strongest commitment is
still to their original flagship product lines.  ColdFusion was only
valuable to MM because it provided the "dynamic" support that Flash
was missing and it was much better than ultra-dev.   Now that .NET and
PHP is gaining strength, Macromedia is having a difficult time staying
loyal.

Don't get me wrong, with out a doubt, Macromedia has done a very good
job with ColdFusion MX (I still think they made a serious mistake by
abandoning ColdFusion Studio) but I do not believe that they are
willing and better yet capable of providing the necessary support to
ensure that "ColdFusion Development" stay ahead of the pack (.NET,
PHP, ASP).  From an operational perspective, I don't think it's
sustainable effort.

I respect Macromedia's apparent strategy but I believe that selling
off ColdFusion to a very close and "up and coming" partner will do
both Macromedia and ColdFusion a great deal of good.  If they don't
sell off ColdFusion they should and probably will sell off something
else because they are struggling trying to hold it all (ColdFusion,
Breeze, Authorware, SoundEdit, Director, Contribute, Flex, Dreamweaver
etc.) together.   If they have smart people on their board of
directors, they are probably having this discussion as we speak, if
not we should all be concerned.

We should be greatful to MM for it's investment and support of the
Community, but don't do to ColdFusion what Eisner did to Disney and
what TimeWarner did to AOL.

Dwayne Cole, MS in MIS, MBA
Certified Advanced ColdFusion Developer
850-591-0212

"It can truly be said that nothing happens until there is vision. But
it is equally true that a vision with no underlying sense of purpose,
no calling, is just a good idea - all "sound and fury, signifying
nothing."  The Fifth Discipline - Peter Senge

-- Original Message --
From: Dick Applebaum <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date:  Mon, 29 Mar 2004 19:47:49 -0800

>After reflection:
>
>I was very upset, as are  most of about a missed opportunity.
>
>But the market will decide
>
>yes, the market will decide
>
>Dick
>
>On Mar 29, 2004, at 7:15 PM, Dick Applebaum wrote:
>
>> Danielle
>>
>>  I agree with most (if not all) of what you say.
>>
>>  RIAs... yes
>>
>>  Flex (half a job well done) --- yeah, in theory!
>>
>>  But a separate, very expensive, server to do half a job --- why,
>> little
>>  potential gain (IMO) and big potential loss (also IMO)
>>
>>  if MACR sells 1.000 or even 10.000 Flex license they will be
>> distracted
>>  and lose the war (IMO)
>>
>>  Dick
>>
>>  On Mar 29, 2004, at 6:01 PM, Danielle Romain wrote:
>>
>>  > If Macromedia sees the Internet's future in RIAs (a point to
which I
>>  > agree, BTW), how does a $12000 product enable that future?
>>  >
>>  >  Flex succeeds because it bring the positives of Flash of a
content
>>  > delivery standpoint while freeing developers of the Flash IDE,
which
>>  > some find very intimidating.
>>  >
>>  >  In the next generation of Internet applications, it is going to
be
>>  > tough to discern between a web app and a traditional desktop
>>  > application.  This is the same motivation, I think, behind
>> Microsoft's
>>  > XAML, due out with Longhorn.  Given the delays in Longhorn, its
deep
>>  > Flash development base and legions of ColdFusion developers, MM
has
>>  > roughly 1 year to grab market and mindshare.  While I'm sure the
>>  > niche, enterprise market is lucrative, I  think there is enough
>>  > enthusiasm among the poorer folk to have driven some impressive
>> sales
>>  > volume in this product.
>>  >
>>  >  It just seems like is overlooking a opportunity to build a
>> tremendous
>>  > technology advantage, catching Microsoft on its backfoot.
>>  >
>>
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Flex is out

[Arden Weiss]

Maybe just another go nowhere Spectra product chasing tumble weeds...

-Original Message-
From: Rob [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 30, 2004 12:30 AM
To: CF-Talk
Subject: Re: Flex is out

On Mon, 2004-03-29 at 21:11, Geoff Bowers wrote:
> So Flex is expensive.. its a product we all want to use today but
> probably won't be able to till tomorrow.  We all fall somewhere
within
> the developer spectrum but none of us are everywhere at once.
>
> If Flex is successful in the enterprise space as Contribute has been
in
> the consumer space Macromedia would be on a winner, no?
I guess, back to the beta max analogy (which is apples to windows) -
they still use beta maxes in TV studios.

I think I get where they are coming from though, for example:

IBM WebSphere Application Server Advanced Edition 4.0 (20P5323) for
PC,
Unix - $12,108

Microsoft Content Management Server Enterprise Edition (V04-00018) for
PC - $12,031

Microsoft Content Management Server Enterprise Edition For PC -
$34,841

and while its true that M$ has like 80 billion dollars in the bank, it
seems like if that is the market they want - then they are in the
right
price range.

If they don't want the poor playing with their stuff, then so be it.

--
Rob <[EMAIL PROTECTED]>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Monitor if newsletter is opened

[Arden Weiss]

All of my CF5 code ran without problems in CFMX 6.1 (didn't buy into
6.0) -- in fact, I still have CF5 installed on one machine and I test
some code I write under both 5 and 6.1 to make sure it runs in both
environments.

The only anoyance in 6.1 vs 5 is that when a CFQUERY fails on a called
action page, I get a blank page displayed without any debugging
information. There may be a setting to get around this, but I have not
bothered to go looking for it.

-Original Message-
From: cfhelp [mailto:[EMAIL PROTECTED]
Sent: Monday, March 29, 2004 9:35 AM
To: CF-Talk
Subject: RE: Monitor if newsletter is opened

That's actually quite brilliant and simple.

I would setup a website that is just for this so there are no other
visits
logged. Use ODBC Logging and then run an SELECT DISTINCT IP against
it.

But if the recipient is using preview it will be in accurate.

Rick

-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
Sent: Monday, March 29, 2004 6:22 AM
To: CF-Talk
Subject: RE: Monitor if newsletter is opened

Send an HTML message and have at least one of the images pull from
your
webserver, then check your web logs.

That's the first thing that comes to my mind ;)

Hatton

> Anyone have a code sample that will allow us to track what % of our
> newsletter is actually opened by the recipiant?
>
> Any help you can offer would be appreciated.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.642 / Virus Database: 410 - Release Date: 3/24/2004
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Driving a local scanner with CFMX

[Arden Weiss]

Man -- Activescan looks like the perfect solution except for one minor
problem -- apparently it doesn't work anymore -- with Windows/CFMX --
who to blame, Macromedia or Microsoft, or Activescan -- anybody got
more insite on what is really going on there.

You can buy what they now call an Open Source license for about a
thousand bucks (no support, no return).  They say it may or may not
work in your environment.

Bummer...

 -Original Message-
From: Steve Nelson [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 27, 2004 6:12 PM
To: CF-Talk
Subject: RE: Driving a local scanner with CFMX

Looks like it's discontinued, but look at this:

http://www.cfdev.com/activescan/

Steve Nelson

  _____

From: Arden Weiss [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 27, 2004 12:04 AM
To: CF-Talk
Subject: Driving a local scanner with CFMX

Seeking advice on how to seamlessly drive a twain scanner attache to
User's
local PC from within a CFMX application.

Thanks in advance...

P.S. Thought I already posted this, but it did not show up in
CF-Talk...

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Driving a local scanner with CFMX

[Arden Weiss]

My apoligies for the "?hit" last night -- that's what happens when us
grandpas (age 70 and older) try to do all-nighters.  We'll wait to see
how functional you young-ans are by the time you are on social
security...

Again, sorry for the false postings -- and, as for as the spam SQL
postings, my email address got captured somewhere along the line late
last year and is still being used by someone to send emails that look
like they come from me but really don't. I have since changed
addresses; so, any emails from [EMAIL PROTECTED] should be trashed.

Again, my sincere apoligies -- but, still looking for advice on
driving a local scanner...

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 27, 2004 11:59 AM
To: CF-Talk
Subject: Re: Driving a local scanner with CFMX

Tony Weeg wrote:

> what the heck is this shit?

Something that Michael will undoubtedly sort out without any need
for us to worry about it.

Jochem

--
I don't get it
immigrants don't work
and steal our jobs
 - Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Driving a local scanner with CFMX

[Arden Weiss]

Yup -- still up -- just finished updating a set of pages that do a SQL
"UPDATE" for a variable number of checkboxes -- kinda complex, but it
is now done -- had to do the update only if they changed -- if the
didn't change I didn't update the field "last updated"

-Original Message-
From: Paige Chandler [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 27, 2004 1:35 AM
To: CF-Talk
Subject: Re: Driving a local scanner with CFMX

Hi Guy,

What are you doing up still?

It looks like I just finished a major project a few minutes ago:
printing multi-page, multi-paragraph instant letters.

I hope to wrapup the Survey project tomorrow.

I believe I'm going to bed now.

You might be interested to know that, after 2 appointments with the
gen. practitioner I went to the cardiologist last week (3/15) and he,
of course, scheduled a stress test for last Monday 3/22.  I passed the
test, of course, BUT after the test and after the photo session, while
waiting for them to remove the needles, etc. I had trouble taking a
deep breath - again.  Just like at your party.  So they checked all
the test results before they would release me.  Nothing showed up on
the test.  So I had another appointment with him today. They don't
know what it is but it concerns them - more than me. Anyway he gave me
a prescription for Nexum (something for stomach acid) and if it
happens again it will be serious. He wants to do a cauterization -not
good. Means a day in the hospital.  I'll see him again in about a
month.  So counting the next one, starting with that little event at
your party has resulted in no less then 6 doctor's appointments,
including the stress test.  And it may not be over yet.  Anyway I'm
feeling fine, no pain so I was back on the trail doing 2 miles
yesterday.  The doc said he knew it wouldn't do any good to ask me to
curtail my walking so he wouldn't bother.  Keep hiking.

Have a great weekend.

Regards,

Paige

  - Original Message -
  From: Arden Weiss
  To: CF-Talk
  Sent: Saturday, March 27, 2004 12:04 AM
  Subject: Driving a local scanner with CFMX

  Seeking advice on how to seamlessly drive a twain scanner attache to
User's local PC from within a CFMX application.

  Thanks in advance...

  P.S. Thought I already posted this, but it did not show up in
CF-Talk...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Driving a local scanner with CFMX

[Arden Weiss]

Seeking advice on how to seamlessly drive a twain scanner attache to User's local PC from within a CFMX application.

Thanks in advance...

P.S. Thought I already posted this, but it did not show up in CF-Talk...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Dead ?

[Arden Weiss]

Still getting 3 to 5 emails of many postings -- but my delete key still
works...

- Original Message -
From: "Michael Dinowitz" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, July 12, 2001 5:44 PM
Subject: Re: Dead ?


> If it is then we've got a lot of mediums here. :)
>
>
> > Is the list dead again ?
> >
> > Uwe
> >
> >
> > SD Solutions
> > Fon: +49 8122 903791
> > Fax: +49 8122 903792
> > Mail: [EMAIL PROTECTED]
> > Web: www.sdsolutions.de
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Apache webserver and CF

[Arden Weiss]

I suggest you download a paper entitled "ColdFusion and Apache install tips
and tricks" that was presented at the Annapolis Cold Fusion User Group
meeting by Mark Mathis on setting up Apache for use with Cold Fusion.
www.ancfug.com/meetings/

Following his tips, I have Apache and CF 4.5 working fine on my ME laptop...


- Original Message -
From: "Michael S. Kimmett" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 10:11 AM
Subject: Apache webserver and CF


> I am having troubles with a ColdFusion application that I have moved from
my company's test webserver to my personal machine.
>
> My machine is running Win 98, Apache 1.17, CFServer 4.5sp2.  The test
server that was running the application without any problems was running
WinNT, IIS, CFServer 4.5sp2.  I have made all the mappings in my Apache
...conf file that were made for IIS.  I have made all the CFServer mappings
on my machine that were on the test machine.
>
> So at this point none of the mapped paths are working.  In an attempt to
test the application using the non-mapping address ( Non Mapped Address:
http://localhost/client/inprogress/index.cfm  Mapped Address:
http://localhost/ABC ) when I hit the index.cfm page I am getting broken
images ( I have an template that I am including on the index page that is
setting variables that are called in the app which reference the mapped URL
address) as well as this weird ODBC error:
> Error Occurred While Processing Request
>   Error Diagnostic Information
>   ODBC Error Code = S0002 (Base table not found)
>
>   [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'CGLOBAL'.
>
>
>
>   Date/Time: 06/15/01 09:08:07
>   Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
>   Remote Address: 127.0.0.1
>
>
>
> What is weird about this error is that their is no DB connection made on
this template (index.cfm).  Does anyone have an idea as to why I am having
all this trouble with this app?  Has anyone else had a similar experience?
I am looking for some advice on what to do.  Thanks in advance.
>
>
>
> --Michael
>
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Weird Session Timeouts

[Arden Weiss]

You stated my point much more clearly -- Thanks...

- Original Message -
From: "Dylan Bromby" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 10:08 AM
Subject: Re: Weird Session Timeouts


> As a follow-up, don't forget if you use the sessiontimeout in the
> application.cfm, I don't think that value can exceed what's set in the
> admin.
>
> On 6/15/01 6:39 AM, "Dylan Bromby" <[EMAIL PROTECTED]> wrote:
>
> > It's other way around. If *no* application.cfm is found, the defaults in
the
> > CF Admin will be used.  Otherwise, any application.cfm file found by the
app
> > will override the admin. If the admin took precedence, there would be no
use
> > to setting sessions in any application.cfm file.
> >
> > On 6/15/01 6:10 AM, "Arden Weiss" <[EMAIL PROTECTED]> wrote:
> >
> >> Think the value specified in CF Admin controls/over-rides the value in
the
> >> applicatiion.cfm
> >>
> >> - Original Message -
> >> From: "Norman Elton" <[EMAIL PROTECTED]>
> >> To: "CF-Talk" <[EMAIL PROTECTED]>
> >> Sent: Friday, June 15, 2001 9:01 AM
> >> Subject: Weird Session Timeouts
> >>
> >>
> >>> This one's got me stumped. In my application.cfm, I've got...
> >>>
> >>> CFAPPLICATION NAME="PansophyPrd" CLIENTMANAGEMENT="Yes"
> >>> SESSIONMANAGEMENT="Yes" SETCLIENTCOOKIES="Yes"
> >>> SESSIONTIMEOUT="#CreateTimeSpan(0,8,0,0)#"
> >>> APPLICATIONTIMEOUT="#CreateTimeSpan(0,8,0,0)#"
> >>>
> >>> Seems right to me. Technically there shouldn't be quotes are the
> >>> createtimespans, but it doesn't seem to make any difference.
> >>>
> >>> In CF Administrator, the maximum session timeout is 10 hours, the
default
> >> is
> >>> 20 minutes. The catch is, sessions seem to time out within an hour.
> >> Perhaps
> >>> it's somehow using the 20 minute default (I was away from my desk the
> >> entire
> >>> hour). This has happened before on other servers, and it certainly
> >>> troubling.
> >>>
> >>> Any advice?
> >>>
> >>> Thanks
> >>>
> >>> Norman Elton
> >>>
> >>>
> >>>
> >>
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Weird Session Timeouts

[Arden Weiss]

Think the value specified in CF Admin controls/over-rides the value in the
applicatiion.cfm

- Original Message -
From: "Norman Elton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 9:01 AM
Subject: Weird Session Timeouts


> This one's got me stumped. In my application.cfm, I've got...
>
> CFAPPLICATION NAME="PansophyPrd" CLIENTMANAGEMENT="Yes"
> SESSIONMANAGEMENT="Yes" SETCLIENTCOOKIES="Yes"
> SESSIONTIMEOUT="#CreateTimeSpan(0,8,0,0)#"
> APPLICATIONTIMEOUT="#CreateTimeSpan(0,8,0,0)#"
>
> Seems right to me. Technically there shouldn't be quotes are the
> createtimespans, but it doesn't seem to make any difference.
>
> In CF Administrator, the maximum session timeout is 10 hours, the default
is
> 20 minutes. The catch is, sessions seem to time out within an hour.
Perhaps
> it's somehow using the 20 minute default (I was away from my desk the
entire
> hour). This has happened before on other servers, and it certainly
> troubling.
>
> Any advice?
>
> Thanks
>
> Norman Elton
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: How can I wrap other processing into cfml

[Arden Weiss]

Check out CFEXECUTE...


- Original Message -
From: "Jane Zou" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, June 12, 2001 6:35 PM
Subject: How can I wrap other processing into cfml


> Just wondering how to create a simple wrapper to invoke other
> processing into cfml, such as: a batch(.bat), a winzip, an xxx.exe.
>
> The programs of xxx.bat, xxx.exe, etc are written in other
> languages, these programs are not open sourced.
>
> I know in VB, you can use API: OpenProcess, GetExitCodeProcess, etc
> to wrap these programs around, so the programs will run but the user will
> not know what is going on behind.
>
> Any idea?  I am trying to integrate many processing into one with
> out too much of developing efforts.
>
> Thanks in advance!
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: MACROMEDIA COLDFUSION SERVER 5 NOW AVAILABLE

[Arden Weiss]

Thank you Macromedia (Phil and others) for monitoring this site and being
proactive in getting reliable/timely info out to the troops here on the
firing lines.

Keep up the good work...

- Original Message -
From: "Phil Costa" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, June 12, 2001 9:43 AM
Subject: RE: MACROMEDIA COLDFUSION SERVER 5 NOW AVAILABLE


> Now that boxes and CDs have been manufactured, your subscription
fulfillment
> should arrive in the next 2-3 weeks . If you are a subscription holder,
you
> should have received an email from Macromedia with a temporary serial
number
> and a link to a downloadable version.
>
> If you have not received this email, please contact Customer Service and
> they will look into it for you. Using this electronic form is the easiest
> and fastest way to get Customer Service:
> http://www.allaire.com/services/customerservice/index.cfm
>
> Phil Costa
> Sr. Product Marketing Manager / Macromedia
> [EMAIL PROTECTED]
>
>
> > -Original Message-
> > From: Bruce, Rodney [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, June 11, 2001 4:23 PM
> > To: CF-Talk
> > Subject: RE: MACROMEDIA COLDFUSION SERVER 5 NOW AVAILABLE
> >
> >
> > So when do those of us with subscriptions get the upgrade sent to us?
> >
> > -Original Message-
> > From: Jeff Whatcott [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, June 11, 2001 11:58 AM
> > To: CF-Talk
> > Subject: MACROMEDIA COLDFUSION SERVER 5 NOW AVAILABLE
> >
> >
> > Both boxed and electronic versions of ColdFusion Server 5 are
> > available
> > immediately for purchase directly from Macromedia or from
> > distributors and
> > resellers worldwide.  Check out today's release (attached)
> > for details,
> > including a sampling of customers who are already live on
> > ColdFusion Server
> > 5.
> >
> > Regards,
> >
> > Jeff Whatcott
> > Director, Product Marketing / Macromedia
> > [EMAIL PROTECTED]
> >
> >
> > MACROMEDIA COLDFUSION SERVER 5 NOW AVAILABLE
> > Customers Benefit from Increased Developer Productivity and
> > Enhanced Server
> > Performance
> >
> > San Francisco, California -June 11, 2001-Macromedia, Inc.
> > (NASDAQ: MACR)
> > today announced the availability of Macromedia ColdFusion
> > Server 5, the
> > latest version of the industry-leading Web application
> > server. ColdFusion
> > Server 5 is available immediately for purchase directly from
> > Macromedia or
> > from distributors and resellers worldwide (see below for
> > details). A free
> > 30-day evaluation version is also available for download via
> > http://www.macromedia.com/software/coldfusion/resources/.
> >
> > "ColdFusion Server 5 provides the most approachable and cost-effective
> > solution for creating interactive user experiences on the
> > Web," said Adam
> > Berrey, vice president, ColdFusion business, Macromedia. "By
> > focusing on the
> > key developer requirements - increased productivity,
> > simplified management,
> > and enhanced performance - ColdFusion 5 enables customers and
> > partners to
> > build and deliver the next generation of Web applications."
> >
> > Macromedia ColdFusion 5 empowers Web developers with a highly
> > productive
> > solution for Web development, deployment and management.
> > Customers such as
> > Johns Hopkins University, Hasbro, Inc., the Smithsonian
> > Museum of Natural
> > History, Binney & Smith - creators of Crayola, RemoteSite.com, Eastern
> > Carolina University, CHUM.FM and Flare Networks have already
> > successfully
> > deployed production sites with ColdFusion Server 5.
> >
> > "Macromedia ColdFusion 5 is right on target in meeting the
> > needs of the Web
> > developer community," said Vernon Elliot, senior technical
> > analyst, Hasbro,
> > Inc. "It's intuitive and powerful language has allowed us to develop
> > applications far more quickly than we could have using any other
> > alternatives. With its charting engine, user-defined
> > functions, core engine
> > tuning and numerous other enhancements, this new version has
> > clearly taken
> > our developer productivity up a notch."
> >
> > ColdFusion 5 also enjoys widespread support among the
> > thousands of leading
> > Web development consultancies and service providers in the Macromedia
> > Alliance (see http://www.macromedia.com/go/cfpartnerlist for partner
> > endorsements). Macromedia Alliance members provide
> > professional services,
> > training, packaged applications, and complimentary technology
> > that support
> > the ColdFusion application server.
> >
> > "With the release of ColdFusion 5, we are now able to deliver
> > more to our
> > clients," said Brett T. Smith, president, World Wide Internet
> > Publishing
> > Ltd., a Macromedia Alliance Partner. "Macromedia has shown great
> > responsiveness to the needs of developers with this release. With new
> > features such as the dynamic charting engine and user-defined
> > functions we
> > can take our applications to another level."
> >
> > ColdFusion 5 offe

RE: OT: NETSCAPE IS GOING AWAY! A Web Developer's Dream Come True !

[Arden Weiss]

Well Ah -- my two cents...

I'm really surprised that Netscape (that is it new owners) haven't 
abandoned Netscape sooner to devote efforts and technologies acquired into 
more profitable endeavors.  What would you do if you were in their shoes? 
 Recall, Marriott abandonded a whole chain of Roy Roger hamburger joints to 
put their money in more profitable endeavors (even though Roy was my hero). 
 <:-))

What we developers think is of no importance to the "wigs" with the gold if 
the products they own/control can't be instrumental in turning a profit for 
them -- call it product extinction if you will.

If the current owners end of committing it to the open community, then, 
either we developers will get behind it and keep it going (with either 
money or sweat) for the purposes we need it for or it will die and M$ 
monopolistic plan will succeed.

>From a wider perspective, unless the "open source" plan becomes a 
successful competitor with vendor-owned products and "open source" products 
are recognized as valid players by the major buyers of techonology (big 
corporations and the federal/state/local governments) products with the 
open source tag will only be used by the "techies" that have the smarts to 
maintain it themselves -- not the dumbed down corportate IT support folks.

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Jon Hall [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, June 08, 2001 10:25 PM
To: CF-Talk
Subject:Re: OT: NETSCAPE IS GOING AWAY! A Web Developer's Dream Come True 
!

This is just too much. Netscape 4.x is old and dying thank god, but NS6 is
different and it is not going away.

Netscape was arguably superior until around the 4.0's (96-97?) when MS
started throwing tons of money into IE. Netscape as a company started to
stagnate as many of their top developers flew the coop, and incompetent
management took over, then AOL took over totally killing innovation. Then
someone decided to pour tons of money updating the 4.5 code when Mozilla 
was
first starting out, which delayed the transition to the Mozilla codebase.

While Netscape was busy stagnating, Microsoft has been busy building a pile
of non-standard garbage, that only runs on Windows and the Mac. There is
nothing at all exceptional about IE, except that MS has continued to invest
in it, and it lets lazy html developers eek by without knowing why their
code sucks. What many people dont realize is that all of this IE specific
code floating around is be a major pita when Microsoft decides that it's
time for the world to change and they release a whole new browser.

Microsoft has actively ignored most standards, and tried to corrupt the 
ones
that exist. NS6/Mozilla supports many more of the standards that the web
needs to develop for the future. IE's support of CSS1/DOM1 is laughable and
buggy with many features not implemented, while Mozilla is supporting up to
DOM2 and CSS2. Mozilla has even incorporated an irc chat client, which 
means
easy chat room building for us.

It is now IE's turn to stagnate, since v4 there has not been much 
innovation
at all. I am currently running IE6 Beta and there is nothing new that 
really
matters.

Mozilla also has the advantage of being open source. So guess what every
single internet appliance manufacturer is going to integrate? Most people
agree that appliances will be the majority of web clients in the future.Red
Hat and the rest of the Linux vendors should be moving over to Mozilla
within the next couple of months too.

I haven't written any more NS4.x code in a long time, and only make a
passing effort at compatibility these days. However the more I develop with
the standards in mind, the more I realize how bad IE is. I actually spend
more time working around IE bugs, and compatibility issues now, wishing
people would just go download Mozilla ;-)

.and Opera sucks, but it is superior IE as far as standards support 
goes.
I'll give it that.

jon
- Original Message -
From: "Stevens, Jason" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, June 08, 2001 8:19 PM
Subject: RE: OT: NETSCAPE IS GOING AWAY! A Web Developer's Dream Come True 
!


> While I'm no fan of monopolies, I have been nothing but happy with
> Microsoft's browser. Netscape was a substandard product that limited web
> development and it's getting what it deserves if you ask me. It did a
great
> job of being picky about the code it worked with, which kept me in check
> MANY of times, but restrained us in many other areas. So here's a pat on
the
> back to those Netscape guys, go help Opera out, they're workin on a
heckuva
> browser there.
>
> Jason
>
> -Original Message-
> From: Steve Bernard [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 08, 2001 3:15 PM
> To: CF-Talk
> Subject: RE: OT: NETSCAPE IS GOING AWAY! A Web Developer's Dream Come
> True!
>

~~
Struc

RE: CF Certification before 14th July

[Arden Weiss]

Grandfathered means that your 4.5 certification will be accepted as the same having 
gotten registered for 5.0
-- you get in free so to speak...

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Hamid Hossain [SMTP:[EMAIL PROTECTED]]
Sent:   Saturday, June 09, 2001 3:41 AM
To: CF-Talk
Subject:CF Certification before 14th July

Hi all

I want to understand if I got certified before the
14th July. What will happen. As I read in this
mail-list before few days, I will be grandfathered for
CF 5.0

What is Grand-Fathered means ?!! does it mean that I
will be CF 5.0 Certified directly or I should book
another exam for free or What ?

Thanks All
Hamid Hossain
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Hack Advice - Break a CF Query

[Arden Weiss]

Sneeky -- but good to know -- did you also try other puncuation type characters???

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Ryan Sabir [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, June 06, 2001 9:03 PM
To: CF-Talk
Subject:RE: Hack Advice - Break a CF Query

Haha worked it out..

I initially was a bit stumped as to what you wanted and then I worked it
out.. and then was intrigued trying to break ODBC by submitting something...
try this...

submit a [ (open square bracket) to the query, that should break it.. not
sure why though

seeya!

-Original Message-
From: Allen Hudson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 7 June 2001 6:35 AM
To: CF-Talk
Subject: Hack Advice - Break a CF Query


My application is hosted with inhouse government hosting.  Therefore I don't
have access to the CF server or easy access to my sites pages.  The only
thing I have control over on a less than 4 week notice is uploading a new
database. (Flintstone-ville)

However, there seems to always be a lock on the database (access 97) such
that I cannot upload when I want. I have created a dbunlock.cfm page to
upload (runs a query that throws an error that will unlock the db) with our
scheduled site upgrade in about 4 weeks.

In the meantime, it occurs to me I could run an html page offsite
(workstation) and submit it to the live page with some code that would throw
an error.  Does anyone know of some code that would do that?

Query on live site page:


SELECT BASEINFO, BASE, VCODE
FROM ROTARY
WHERE BASEINFO = '#FORM.INFO#'


TYIA

Allen Hudson
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

FW: ColdFusion 5 Availability

[Arden Weiss]

Email received from MM on subject -- also note eval article at InfoWorld:

http://iwsun4.infoworld.com/articles/tc/xml/01/06/04/010604tcmacro.xml

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, June 04, 2001 5:34 PM
To: CF-Talk
Subject:ColdFusion 5 Availability

There have been some questions on the list about ColdFusion 5 availability.
This email is intended to answer some of the frequently asked questions:

Which versions of ColdFusion 5 are available?
The following editions of ColdFusion 5 have been released to manufacturing
and are available for purchase (see below for details):
** ColdFusion Server 5, Enterprise Edition for Windows
** ColdFusion Server 5, Professional Edition for Windows
** ColdFusion Server 5, Professional Edition for Linux
** ColdFusion Server 5, Enterprise Edition for HP-UX

Can I buy ColdFusion 5?
Yes. All of the above editions can be ordered from Macromedia sales at
1-888-939-2545 or through resellers that offer ColdFusion. The electronic
version of ColdFusion Server 5 for Windows is available for purchase through
the Macromedia Online Store (http://www.macromedia.com/store). Boxed
versions of ColdFusion 5 will be made available from the Online Store when
the boxes start shipping (in the next 2 weeks).

How can I evaluate ColdFusion 5?
You can download a free 30-day evaluation version of ColdFusion 5 for
Windows, Linux or HP-UX at
http://www.macromedia.com/software/coldfusion/trial/contents.html. You
should also check out the many resources, including data sheets and a
performance brief, at
http://www.macromedia.com/software/coldfusion/resources/evaluation/.

Thanks for your support.

Phil Costa 
Sr. Product Marketing Manager
Macromedia
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

FW: 4.5 certification to 5.0

[Arden Weiss]

FYI -- The "word" from our favorite vendor about certification...

Glad they finally are taking the proactive initiative to clear up confusion -- but DUH 
-- why not post it to the list directly...
 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Niamh O'Byrne [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, June 04, 2001 6:49 PM
To: '[EMAIL PROTECTED]'
Subject:4.5 certification to 5.0

Dear Sir,
I am the new certification manager working for Steve Curtin at Macromedia.
I was forwarded a question that you had in regards to certification:
A letter will be going out to all certified 4.5 developers this week and
notices are going up on our web site to inform people that the 4.5 exam will
be retired on July 14th.  In its place will be the ColdFusion 5.0 exam.
No one who is 4.5 certified will be required to take the 5.0 certification.
They will be grand-fathered into the program.

People will receive a new certificate in 4 to 6 weeks and a new logo will be
downloadable from our web site.

For further information or if you have any questions for me, feel free to
drop me an e-mail or give me a call.

Best regards,

Niamh Fiona O'Byrne
Developer Certification Manager
Macromedia
275 Grove Street,
Newton, MA 02466

Telephone: (617) 219-2991
Fax: (617) 219-2204



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Apache and trailing back slash

[Arden Weiss]

Yep -- I got the same thing -- To make things work on both Apache and IIS, 
I ended up adding a check for it within an  statement and 
stripping it off if there was a "/\" at the end -- see following code -- go 
figure...




  
  


 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   sebastian palmigiani [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, June 01, 2001 1:27 PM
To: CF-Talk
Subject:Apache and trailing back slash


I do not understand why you get trailing back slash  when using
GetDirectoryFromPath with Apache web server

#GetDirectoryFromPath(CGI.CF_TEMPLATE_Path)#

In other words I get

c:/program files/apache group/apache/htdocs/members/om/archive/adu/\

Why is there a trailing back slash? How do I get rid of it?

Sebastian
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: can anyone help?

[Arden Weiss]

See Apache installation instructions paper "ColdFusion and Apache install 
tips and tricks" by Mark Mathis on Annapolis Cold Fusion Users Group web 
site (2/22/01 meeting) if you decide to go that route. It will help... 
www.ancfug.com/meetings

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Tony Schreiber [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, May 31, 2001 9:59 AM
To: CF-Talk
Subject:Re: can anyone help?

I know this isn't the answer to your question, but ditch PWS and run
Apache for Win32. Works great. ;p I think I'm running 1.3.20 on my
development machine. Easy install, SMALL footprint...

> I have win2K professional with personal web server for development.
>
> PWS is hanging after any requests, whether with an htm or cfm file 
request.
> When choosing any options in PWS I get the following message:
>
> Server is busy
> This action cannot be completed because the other program is busy. Choose
> 'Switch to' to activate the busy program and correct the problem.
>
> There are no other programs running. I have uninstalled and reinstalled 
PWS
> and same problem.
>
> Can anyone help?
>
> Sebastian
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Unstable MySQL on Windows 2000

[Arden Weiss]

Have you found it to be stable on NT4 ???

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, May 30, 2001 11:34 AM
To: CF-Talk
Subject:Unstable MySQL on Windows 2000

Has anyone successfully gotten MySQL, ColdFusion and W2K to work together?

I am getting flaky at best connections to MySQL using the MyODBC driver. I
works for a little bit then I get nothing but datasource errors. Like:
ODBC Error Code = ()


Unknown connection error for the data source, 'INSPIR.'


Data Source = "INSPIR"


The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (1:1) to (1:66) in the template file
C:\INETPUB\WWWROOT\INSPIR\COMPANY\QRY\QRY_LIST.CFM.


Date/Time: 05/30/01 09:30:31
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
Remote Address: 127.0.0.1
HTTP Referer: http://127.0.0.1/inspir/company/snpr/index.cfm



Regards,

Rob Rusher

Spectra Architect, Certified ColdFusion Instructor + Developer, Certified
Java Programmer

(303) 885-7044 Cell
(970) 472-1775  Fax
[EMAIL PROTECTED]

[EMAIL PROTECTED]
http://www.flarenetworks.com


plan, build and integrate interactive applications and e-business services
to enhance knowledge sharing, e-commerce and business communications
initiatives
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF5 review in eWEEK

[Arden Weiss]

Regarding:

>> Is it allaire's responsibility to make sure *you're* up to speed?

In a nutshell -- Yes -- not from a technical knowledge point of view of 
knowing how to use their product, but defintely from a product availability 
and the business reasons why, I as a customer/developer/client should buy 
their upgrade -- unless, of course, Macromedia is not interested in 
increasing the number of upgrades they sell.  They haven't said anything 
directly to me or my clients as registered users about upgrading and the 
business reasons why? My client's as a registered user don't even know it 
exists and won't unless I tell them).

What is Macromedia's viewpoint on the "business reasons" (not techie 
reasons) that a firm should upgrade to 5.0 -- can anyone point to a source 
on their web site that addresses this issue (here I go hunting instead of 
them providing).

Note: As a comparision, I got an annoucement from Adobe about their new 
Actobat 5.0 product which I promptly went out and bought, because they also 
gave me a few business reasons why to upgrade. Maybe that is one reason why 
Adobe's stock is rising and Macromedia's isn't...

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Dylan Bromby [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, May 30, 2001 9:49 AM
To: CF-Talk
Subject:RE: CF5 review in eWEEK

as far as being *proactive*, you could have signed up for the CF5.0 beta
test and learned all about it for months before its release. is it 
allaire's
responsibility to make sure *you're* up to speed? i can't imagine what my
business would be like if i waited for others to educate me about
technology.


-Original Message-
From: Arden Weiss [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 6:26 AM
To: CF-Talk
Subject: RE: CF5 review in eWEEK


Sorry you missed my point -- I and my clients buy products from a vendor
(Allaire/Macromedia) and they choose not to keep the paying customer
informed in a proactive manner -- instead they wait for the
customer/client/developer to go to their events/websites to get information
-- is that how you as a developer behave with your customers?

Same with the thread about certification CF4.5 vs 5.0 (recent ongoing
thread) -- regarding the real truth about whether CF4.5 certifcation
transfers to 5.0 and other related issues -- some think so, some do not --
which is it -- guess who could/should set the record straight in a
proactive manner...



 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Raymond Camden [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, May 30, 2001 8:27 AM
To: CF-Talk
Subject:RE: CF5 review in eWEEK

> Sad that this kind of insight is not available direcly from
> Allaire/Macromedia.

Eh? There is nothing in this article that is not available on either the
web
site, or in the streaming video announcements from last years DevConf (err,
which is ALSO on the web site).

===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

"My ally is the Force, and a powerful ally it is." - Yoda
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF5 review in eWEEK

[Arden Weiss]

Sorry you missed my point -- I and my clients buy products from a vendor 
(Allaire/Macromedia) and they choose not to keep the paying customer 
informed in a proactive manner -- instead they wait for the 
customer/client/developer to go to their events/websites to get information 
-- is that how you as a developer behave with your customers?

Same with the thread about certification CF4.5 vs 5.0 (recent ongoing 
thread) -- regarding the real truth about whether CF4.5 certifcation 
transfers to 5.0 and other related issues -- some think so, some do not -- 
which is it -- guess who could/should set the record straight in a 
proactive manner...



 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Raymond Camden [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, May 30, 2001 8:27 AM
To: CF-Talk
Subject:RE: CF5 review in eWEEK

> Sad that this kind of insight is not available direcly from
> Allaire/Macromedia.

Eh? There is nothing in this article that is not available on either the 
web
site, or in the streaming video announcements from last years DevConf (err,
which is ALSO on the web site).

===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

"My ally is the Force, and a powerful ally it is." - Yoda
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF5 review in eWEEK

[Arden Weiss]

Very interesting overview of CF5 and beyond at following link...

http://www.zdnet.com/eweek/stories/general/0,11011,2764421,00.html

Sad that this kind of insight is not available direcly from 
Allaire/Macromedia.

Here we developers are -- acting essentially as outside sales folks for 
Macromedia -- and we have to depend on insight such as this from 3rd party 
sources -- oh well.

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF with Advantage Database Server ? Anyone?

[Arden Weiss]

Whoops -- 900kb of course...

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Tony Schreiber [SMTP:[EMAIL PROTECTED]]
Sent:   Saturday, May 26, 2001 5:24 PM
To: CF-Talk
Subject:RE: CF with Advantage Database Server ? Anyone?

> it to you -- it's about 900mb so I didn't want to send it out via my 56k 

900mb? What the heck is in that paper?

Tony Schreiber, Senior Partner  Man and Machine, Limited
mailto:[EMAIL PROTECTED]   http://www.technocraft.com

http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion
http://www.is300.net ___The Enthusiast's Home of the Lexus IS300
http://www.digitacamera.com __DigitA Camera Scripts and Tips
http://www.linklabexchange.com _Miata Link ECU Data Exchange
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF with Advantage Database Server ? Anyone?

[Arden Weiss]

Coming from a Clipper and FoxPro background, I bought and installed 
Advantage Database Server but never got around to getting it setup with 
Cold Fusion (client decided to go with SQL Server).

But, talking with the folks at Extended Systems (vendor for Advantage 
Database Server), they assured me that it will work via their ODBC driver. 
However, since the ODBC driver is not in the CF Admin ODBC picklist, you 
will probably have to configure it like I did with MySQL and its ODBC 
driver.

I gave a paper at the Annapolis Cold Fusion User Group meeting May 24th on 
what I did to get MySQL Database Server configured with CF. Follow that 
analogy and I think you will be able to get Advantage Database Server 
configured. The Extended Systems Folks said they would help, but I never 
got around to asking them for assistance. Their 800 number is 800-235-7576.

If you would like the paper, it will be up on the Annapolis User Group Site 
soon http://www.ancfug.com/meetings/ or just email me back and I will send 
it to you -- it's about 900mb so I didn't want to send it out via my 56k 
line until I am sure you are interested.

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Pablo Varando [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, May 25, 2001 10:40 PM
To: CF-Talk
Subject:CF with Advantage Database Server ? Anyone?

I am faced with a customer that is needing a coldfusion powered site, but 
his company uses a database I've never heard of called "Advantage Database 
Server".  It does have OLEDB and ODBC capabilities, but am unsure as if 
ColdFusion could handle this project.

I thought I'd ask everyone here and see if anyone has had experience with 
this database and if it could be done.

There is more information on this database at:
http://www.advantagedatabase.com
ODBC/OLE Support at:
http://www.advantagedatabase.com/ADS/Product+Detail/_FAQs+and+Data+Sheet  
s..htm#ProductFAQs

Please reply if you can help.

Thanks!

Pablo Varando
CFM-Resources.Com
http://www.cfm-resources.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFGRID with list box?

[Arden Weiss]

Ya but -- Correct me if I'm wrong -- I've been told that the new CFGRID 
involves a five mb download the first time it is used -- which makes it's 
usefullnees nil for most applications -- those that still want to be 
functional on a 56k line.

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Paul Hastings [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, May 25, 2001 1:58 AM
To: CF-Talk
Subject:Re: CFGRID with list box?

* Team Allaire *
> CFGRID only provides input boxes, i.e. you can't insert a list (a.k.a.
> drop-down) box... correct?

the all new & improved (and i do mean improved) cfgrid will make
its debut in cf5 if you can wait.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: winzip and cfexecute

[Arden Weiss]

Have you tried just using the 16bit DOS version of PKZIP <:-))

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, May 24, 2001 11:33 AM
To: CF-Talk
Subject:RE: winzip and cfexecute

I must be missing something. Do I have to do any setup on winzip. If I call
it from cfexecute it, I can see winzip from task manager but it just hangs
and then cf times out, and if I use it from the command line it just opens
winzip and does nothing?

-Original Message-
From: dave fauth [mailto:[EMAIL PROTECTED]]
Sent: 23 May 2001 17:42
To: CF-Talk
Subject: RE: winzip and cfexecute




At 03:57 PM 5/23/2001 +0100, you wrote:
>So you can call 6.3 from the command line? How do you do that?
>
>-Original Message-
>From: David Fauth [mailto:[EMAIL PROTECTED]]
>Sent: 22 May 2001 15:51
>To: CF-Talk
>Subject: Re: winzip and cfexecute
>
>
>I had to use winzip 6.3 to make it work.  Newer versions of Winzip and the
>batch file would spawn a process but never complete.
>
>dave
>
>
>
>
>-- Original Message --
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>Date: Tue, 22 May 2001 14:48:19 +0100
>
>>Anyone successfully used the add-on command line utility for winzip from
>>cfexecute? It starts ok but whatever I do it seems to terminate half way
>>through and just leave the temp zip file and an open cmd process.
>>Using CF 4.51 and Win NT.
>>
>>
>>**
*
>***
>>
>>The opinions expressed in this E-mail are those  of  the individual  and
>>not  necessarily  the  company.  This E-mail and  any files transmitted 
>>with it are confidential and solely for the use of the intended recipients
>>
>>**
*
>***
>>
>>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ImageMagick COM Object or CFX tag

[Arden Weiss]

Where can imagemagick be found -- tried http://www.imagemagick.com/ -- no go.

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Malcolm Taylor [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, May 24, 2001 9:52 AM
To: CF-Talk
Subject:RE: ImageMagick COM Object or CFX tag

We've implemented a number of applications which call ImageMagick
processes through CFEXECUTE and they seem to work very reliably.  If you
need some sample code, let me know.

-Original Message-
From: Jay Brushett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 6:17 AM
To: CF-Talk
Subject: ImageMagick COM Object or CFX tag



Hi all,

I was wondering if anyone knows of or could give me advice on how to
create
either a COM object (best case, may be used for ASP too) or a CFX tag
which
implements the Imagick Magick graphics library.

Thanks,

Jay
< > < > < > < > < Strategy ~ Creativity ~ Technology > < > < > < > < > <
>

Jay Brushett
[EMAIL PROTECTED]

Developer

< ZeddComm Inc. >
2nd Floor, The Tower | 100 Signal Hill Road
St. John's, Newfoundland | Canada A1A 1B3
Main: 709.570.5669 | Fax: 709.739.9003
Web: www.zeddcomm.com
< > < > < > < St. John's ~ Toronto ~ Newport Beach ~ Ottawa > < > < > <
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Subject: SLightly OT - a time formula

[Arden Weiss]

Dividing by 60 as an integer gives you the "hours"
Using the "mod" command with a base of 60 gives you the remaining minutes.

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Jeffrey Davis [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, May 22, 2001 11:15 PM
To: CF-Talk
Subject:Subject: SLightly OT - a time formula 


Will,

Probably could write this as one line of code, but basically (and this is
off top of head, using someone elses machine, web browser but no CF or
Studio to help check, so this is pseudo-code)



 #HoursResult#hrs. #MinutesResult#minutes

Jeff Davis
Fig Leaf Software
"We've Got You Covered!"

  Hi all, 

  This is slightly OT, but refers to a cf project so I guess it is relevant
in 
  a way. Does anyone know a formula for calculating time. I have numbers of 
  minutes, and need to calculate the time in hours and minutes from these. 

  For example, I have the figure of 400 minutes. I need to calculate how
many 
  hours and minutes this is. Dividing by 60 won't do the job, it gives an 
  answer of 6.. What I need is a formula that will give me the
correct 
  answer: 6hrs 40minutes. 

  Anyone know a nice formula for calculating this? 

  TIA 

  Will 

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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

FW: Beta version of Cold Fusion for Linux

[Arden Weiss]

Whoops a bit of a brain cramp -- I was referring to version 5 for Linux.

The Allaire site only shows 4.5 stuff...

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Arden Weiss [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, May 21, 2001 3:28 PM
To: '[EMAIL PROTECTED]'
Subject:Beta version of Cold Fusion for Linux

Last night I listened to the WebMonkey Radio interview of the MySQL 
developers at:
http://hotwired.lycos.com/webmonkey/radio/monty_widenius.html

If I heard them correctly, they said the Linux version of Cold Fusion has 
ODBC access to MySQL Server built in -- guess that means included in the 
ODBC pick list in the Administrator...

Can anyone verify this?

Also, do we know when it is expected to be released?



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Beta version of Cold Fusion for Linux

[Arden Weiss]

Last night I listened to the WebMonkey Radio interview of the MySQL 
developers at:
http://hotwired.lycos.com/webmonkey/radio/monty_widenius.html

If I heard them correctly, they said the Linux version of Cold Fusion has 
ODBC access to MySQL Server built in -- guess that means included in the 
ODBC pick list in the Administrator...

Can anyone verify this?

Also, do we know when it is expected to be released?

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Zac [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, May 21, 2001 2:28 PM
To: CF-Talk
Subject:Re: Bizarre Error: Server/Studio Duplicating Carriage Returns

Willy Ray wrote:

> I'm running the eval of Cold Fusion Server 4.5 Enterprise on Redhat 7.1. 
 When
> I save a template through RDS, for every carriage return I enter as I 
code, I
> get two carriage returns on the saved document.  Example:

> Big problem.  I've got a template with only about 20 lines of actual code 
on
> it, but it's up to about 14000 lines, due to this problem.  I have studio 
on
> two different machines, and it doesn't seem to matter which I use.  Also, 
this
> is not happening from the same two workstations if I write to an NT 
machine
> through RDS, or through windows networking.
>
> Any ideas?

Check the Editor's file settings and see if its using PC line breaks.
Perhaps the Linux machine is interpreting the CRLF setting on the PC as two
carriage returns?




--

Among modern occupations, only cult leaders and TV weathermen
rival the technological visionary's ability to retain credibility
despite all evidence to the contrary.


Nathan Myhrvold



email: [EMAIL PROTECTED]
web: http://www.pixelgeek.com/
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: the big export...ColdFusion.NET?

[Arden Weiss]

Supposedly the Java killer  <:-))

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   John McKown [SMTP:[EMAIL PROTECTED]]
Sent:   Sunday, May 20, 2001 8:12 PM
To: CF-Talk
Subject:RE: the big export...ColdFusion.NET?

Pronounced "C Sharp", I think it is the successor to C++.

John McKown, Owner
Delaware.Net, Inc.
30 Old Rudnick Lane, Suite 200
Dover, DE 19901
phone: 302-736-5515
toll free: 888-432-7965
fax: 302-736-5945
e-mail: [EMAIL PROTECTED] 
icq: 1812513



-Original Message-
From: Paul Mone [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 18, 2001 7:01 PM
To: CF-Talk
Subject: RE: the big export...ColdFusion.NET?


What is C#?

-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 18, 2001 7:36 AM
To: CF-Talk
Subject: Re: the big export...ColdFusion.NET?


Michael, before you go and learn VB, realize that vb is morphing into
vb.net. Although the syntax is similar, the changes/improvements are quite
drastic. You may want to skip picking up a book on the old VB and
concentrate on learning the new stuff. Microsofts site is a great place to
start though.


The whole dotNet thing is very interesting... Microsofts try at interpreted
code, like java.
Which leads me to think back to Macromedia's repeatedly saying dotNet in the
press release that they were commited to dotNet.
It isn't too far of a stretch to say that Neo may be ported to dotNet, and
specifically C#, which is basically java anyway. The more I think about it,
the more I think it's a no brainer for Macromedia to do a C# port. It will
probably run much faster on Windows. The only risk would be confusing the
users as to which is better.

That's my random Friday thought. Anyone have any comments?


jon
- Original Message -
From: "Michael Lugassy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 18, 2001 10:57 AM
Subject: Re: the big export


> thanks for the tip, paul!
> I keep seeing this "learn VB" tips and I was wondering -
> are there any good and quick resources on learning VB on the net?
something
> you know about??
>
> Michael.
>
> - Original Message -
> From: "Paul Mone" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, May 18, 2001 12:49 AM
> Subject: RE: the big export
>
>
> >
> > This is definately something I would consider "off-line" processing. In
> > most cases, CF is not suitable for these types of tasks, espcially if
it's
> a
> > task that you'll have to repeat on scheduled basis.  If this is a
one-time
> > event (are you sure? :) ) then you can way the time for development vs.
> time
> > of processing.
> >
> > one time operation?
> >
> > Developing it in CF is probably the quickest solution.  Won't be the
> > quickest app in the world.
> >
> > recurring task?
> >
> > Do it in C, or even better, VB.  It would be quicker to develop this in
VB
> > than C, and the performance increase that C would give you is probably
> > negligible.  Writing an offline recurring task like this in CF would be
a
> > mis-use of your CFServer's resources.
> >
> >
> > ---
> > Paul Mone
> > Ninthlink Consulting Group
> > [EMAIL PROTECTED]
> > 619.222.7082
> >
> >
> > -Original Message-
> > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 17, 2001 9:49 AM
> > To: CF-Talk
> > Subject: the big export
> >
> >
> > I need the fastest way to export 100s of 1000s of text
> > files into a database. I need each file in a a new row like this:
> > file1name, file1content
> > file2name, file2content
> >
> > CF is too slow for this, what can I use?
> >
> > Thanks,
> >
> > -=Michael.
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: OT: Re: Weather Icons: I need some

[Arden Weiss]

Try this site -- whole bunch of good ones -- found it by asking Jeeves

http://209.47.223.2/help/icons/index.htm

Meanwhile... Play nice guys  <:-)) or go to your room...

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Zac [SMTP:[EMAIL PROTECTED]]
Sent:   Sunday, May 20, 2001 6:38 PM
To: CF-Talk
Subject:Re: OT: Re: Weather Icons: I need some

Laszlo Nadai wrote:

>>> This doesn't appear to be even remotely CF related at all.
> Unless, of course, someone is doing CF development, and needs weather icons...
> :-)

If people need icons then I think the best thing to do is do a google search
for weather icon instead of posting a message to the list.

Especially since the question has nothing whatsoever to do with CF or CF
development.

There is already enough traffic on the list that I think its better to
occasionally make comments like this to ensure that the static stays off
list instead of clogging the it with queries that could be answered in about
a 10 seconds with, as I mentioned, a google search.





--

   I've just always been afraid that if we get too strict with this
   'eye for an eye' business, it won't be very long before we're
   all pretty much blind.

   Will Durst


   email: [EMAIL PROTECTED]
   WWW: http://www.director-online.com/
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Developers Exchange (Allaire)

[Arden Weiss]

Well just be happy...

No telling how bad it would be if it were not be managed by industry professionals 
<:-))

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Saturday, May 19, 2001 6:09 AM
To: CF-Talk
Subject:Developers Exchange (Allaire)

DevEx is showing a lot of errors at the moment. Does Allaire/MM know yet?

Cheers!

--
Peter Tilbrook
Chief Web Developer
Lunar Power Internet Technologies
Unit 1, 26-28 Winchcombe Court
Mitchell, ACT, 2911
AUSTRALIA

Phone: +61-2-6242-
Fax: +61-2-6242-6655
Web: http://www.lunarpower.com.au
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: PLEASE DO NOT OPEN AND DELETE THE EMAIL THAT SAYS....THIS IS A REALLY COOL HOME PAGE...IT IS A VIRUS...

[Arden Weiss]

And then -- how to get rid of the virus -- the latest version of Norton AntiVirus 
didn't complain -- so much for Norton Huh?

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, May 17, 2001 10:47 AM
To: CF-Talk
Subject:PLEASE DO NOT OPEN AND DELETE THE EMAIL THAT SAYSTHIS IS A REALLY 
COOL HOME PAGE...IT IS A VIRUS...

PLEASE DO NOT OPEN AND DELETE THE EMAIL THAT SAYSTHIS IS A REALLY COOL
HOME PAGE...IT IS A VIRUS...


Forte Interactive, Inc.
301 Clematis St. Suite 3000
West Palm Beach, FL 33401

E. [EMAIL PROTECTED]
P. 561.833.4040
F. 561.833.4141
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Using MySQL with CF and Apache.

[Arden Weiss]

I and a couple other members of the Annapolis CF User Group WWW.ANCFUG.COM 
are investigating getting MySQL database server to work with Cold Fusion 
4.5 and Apache Web Server on Win9x/ME/NT boxes.

Like to collaborate with any others interested in same.

We have CF, Apache and MySQL installed and working in a rudimentary manner 
and want/need to do more.

Please reply off-line if you are interested.

Thanks...

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

FW: Advanced CF5 Bootcamp format

[Arden Weiss]

The second option sounds great.

The only problem is that Adam can talk faster than I can hear/absorb and at that 
price, absorbsion is King.

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Matt Eschenbaum [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, April 19, 2001 1:03 PM
To: CF-Talk
Subject:RE: Advanced CF5 Bootcamp format



I'm trying to make a decision about the Advanced Bootcamp for ColdFusion 5,
Database, and Javascript, and I could really use some advice.

I'm wondering if the format is right for people.   Currently, I have it
scheduled like this:

-- 68 hours over six days, 12 hours per day M-F, 8 hours on Saturday
-- All three meals catered
-- $4,500 normally, $3,950 early registration

But it's been suggested that a better format would be this:

-- 60 hours over five days, 12 hours per day M-F
-- Breakfast and lunch catered, dinner is on your own
-- $3,500 normally, $2,950 early registration

I really want to provide a truly advanced training course, and need to have
plenty of time to thoroughly cover everything.  The 12-hour-per-day format
worked really well on the recent Database Development course we did in
March, but I don't know if people are really wanting to go an extra two days
like that.

I would really appreciate any input you can give me.  If you would, please
look at the detailed itinerary at:

http://www.coldfusiontraining.com/index.cfm?fa=home.getinfo&InfoType=itinera
ry&TitleCode=advboot&EventID=4

and let me know what you think people might like better.  I get the feeling
that I'm being a _wee_ bit too enthusiastic about the amount of training
people want. :)

Thanks in advance.

Respectfully,

Adam Phillip Churvis
Productivity Enhancement, Inc.

http://www.ColdFusionTraining.com
http://www.ColdFusionSeminars.com
http://www.CommerceBlocks.com

E-mail:  [EMAIL PROTECTED]
Phone:   770-446-8866
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Advanced CF5 Bootcamp format

[Arden Weiss]

The second option sounds great.

The only problem is that Adam can talk faster than I can hear/absorb and at that 
price, absorbsion is King.

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Matt Eschenbaum [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, April 19, 2001 1:03 PM
To: CF-Talk
Subject:RE: Advanced CF5 Bootcamp format



I'm trying to make a decision about the Advanced Bootcamp for ColdFusion 5,
Database, and Javascript, and I could really use some advice.

I'm wondering if the format is right for people.   Currently, I have it
scheduled like this:

-- 68 hours over six days, 12 hours per day M-F, 8 hours on Saturday
-- All three meals catered
-- $4,500 normally, $3,950 early registration

But it's been suggested that a better format would be this:

-- 60 hours over five days, 12 hours per day M-F
-- Breakfast and lunch catered, dinner is on your own
-- $3,500 normally, $2,950 early registration

I really want to provide a truly advanced training course, and need to have
plenty of time to thoroughly cover everything.  The 12-hour-per-day format
worked really well on the recent Database Development course we did in
March, but I don't know if people are really wanting to go an extra two days
like that.

I would really appreciate any input you can give me.  If you would, please
look at the detailed itinerary at:

http://www.coldfusiontraining.com/index.cfm?fa=home.getinfo&InfoType=itinera
ry&TitleCode=advboot&EventID=4

and let me know what you think people might like better.  I get the feeling
that I'm being a _wee_ bit too enthusiastic about the amount of training
people want. :)

Thanks in advance.

Respectfully,

Adam Phillip Churvis
Productivity Enhancement, Inc.

http://www.ColdFusionTraining.com
http://www.ColdFusionSeminars.com
http://www.CommerceBlocks.com

E-mail:  [EMAIL PROTECTED]
Phone:   770-446-8866
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ASP for Cold Fusion Disciples

[Arden Weiss]

If you (as I do) tend to learn better by example, downloaded CodeCharge 
from http://www.codecharge.com/download/?templ=examples&example_id=4

CodeCharge is a code generator that can be used to generate Cold Fusion, 
ASP, JSP, PHP and Pearl code for an identical spec'd app. Their existing 
tutorial sucks, but they are now in the process of updating it.

Inspect the code that is generated for each flavor and learn therefrom.

Alternatively, download one or more of the ZIP files that they have for 
eight or so already canned apps and inspect the code for each and learn 
therefrom.

Send them money if you want to keep it.

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Troy Hiltbrand [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, April 19, 2001 12:38 PM
To: CF-Talk
Subject:ASP for Cold Fusion Disciples

I am a Cold Fusion disciple and am currently working with ASP and JSP. 
 Does
anyone know of any web sites that teach ASP and JSP from the perspective of
someone that has been writing web apps in Cold Fusion?  It just seems that 
I
have been taking things like client variables and IsDefined for granted.
Thanks for your help.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Creating Page Breaks to make page printable?

[Arden Weiss]

I use max table width of 670 with similar success.

The advantage of this in addition to printing is that 670 pixel width 
displays well on any size screen.

On 640x480 the user has to scroll the screen right to see everything. On 
800x640 the total available screen width is used effectively. On higher 
resolution screens the used area is still restricted to the 670 pixel 
center portion of the screen.

When printing, the 670 pixels will fit on a portrait page well (680 is to 
big).  650 pixel table widths will also work fine, but you can get 20 more 
pixels with the 670 setting.

Vertical paginated control of printed pages is a completely different 
issue. There I am using PDF files -- created and displayed in the browser 
via an application button -- not the browsers print button. Alternatively 
one can use CFEXECUTE to run Access or FoxPro report writer on the server 
and print to a PDF file which is then displayed in the browser and printed 
accordingly (the latter requires the CF administrator  permission to run 
CFEXECUTE, which is unlikely on hosted shared servers).

Don't you just love the fact that these hot-shot tool developers provide us 
poor little application developers with these half-baked tools.

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Michael Lugassy [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, April 17, 2001 11:55 AM
To: CF-Talk
Subject:Re: Creating Page Breaks to make page printable?

If you mean a printable version for every page (just
like we did on:
http://www.imvamp.com/support/documentation/player/monitor/index.html
(click on: printable version)

you should use a table code that will break the line
at about 650 pixels width

just specify

table width=650
and on every td specify td width=650
this will break lines automaticlly at the end of the words with no need to
use  or special wrapping techniques.

just keep the table below 650pixels!
and make a clean page. people like it!

Thanks,

Michael Lugassy
Interactive Music Ltd.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Note passing system?

[Arden Weiss]

To a hammer, every problem seems like a nail -- Right?

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Joe Sheble aka Wizaerd [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, April 17, 2001 9:43 AM
To: CF-Talk
Subject:Re: Note passing system?

As strange as this may sound in light of normal developmental thought 
processes... I like to re-invent the wheel... each time I do, I get a 
better, more efficient, and sometimes a much better looking wheel...  of 
course I don't do this all the time, and I may use a function or two that 
somebody else wrote, but I've always written my own applications.  It's why 
I'm a developer... I love developing...

At 02:37 AM 4/17/01 -0400, you wrote:
>:o)
>
>Hi Peter. I certainly understand where you're coming from. After 3 years of
>doing some solid CF work, I'm very capable of building most of the stuff
>that I need. I'm just an advocate of code reuse. If there's something out
>there that helps me reduce my coding time, I'd like to take advantage of it.
>I really hate reinventing the wheel.
>
>Thanks for the feedback...
>
>Rey...
>Certified Allaire Instructor
>Member of Team Allaire
>
>"A browser's beauty, at its heart, is its usefulness as a *TOOL*."
>
>
>- Original Message -
>From: "Peter Tilbrook" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Tuesday, April 17, 2001 1:59 AM
>Subject: RE: Note passing system?
>
>
> > As a side note - if you have an idea for your application - do it! Do not
> > expect someone else to have already written the code for you. CF makes
> > coding easy. If you are worried about the code have trusted people try and
> > break it. Spend at least 3 weeks with beta testers on trusted code. You
> > would be amazed at how the feedback either picks up problems or points
>out,
> > even unobtrusively, better ways to accomplish a task.
> >
> > -Original Message-
> > From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, 17 April 2001 15:33
> > To: CF-Talk
> > Subject: RE: Note passing system?
> >
> >
> > I implemented the same thing for the new Friends Plus site. The beauty of
> > the system is that nobpdys email address is released.
> >
> > We could be draconian and introduce full auditing but it has not been
> > necessary yet. The user remain anonymous and their email address is never
> > released unless they give it out.
> >
> > -Original Message-
> > From: Rey Bango [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, 17 April 2001 14:57
> > To: CF-Talk
> > Subject: Re: Note passing system?
> >
> >
> > Not really, Paul. Its more like an internal messaging system. One where I
> > can write a message to another user or perhaps a group of users and have
> > them correspnd back. Again, its not a true email system but one that would
> > allow me to be able to communicate within the scope of my own application.
> >
> > Rey...
> > Certified Allaire Instructor
> > Member of Team Allaire
> >
> > "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
> >
> >
> >
> > - Original Message -
> > From: "Paul Begovich" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Monday, April 16, 2001 7:35 PM
> > Subject: Re: Note passing system?
> >
> >
> > > Sounds like you want a project management tool.
> > >
> > > We have an internal system here we use to parse out work.  Basically the
> > > client/project manager submits an item to a form and it appears on the
> > > necessary persons desktop based on who they select.  They see the item,
>do
> > > the work, mark their time, and reply via the form.  It's a great project
> > > management tool and it keeps track of correspondence.
> > >
> > > Building a system like your describing isn't too difficult, it's just
>time
> > > consuming.  We have looked into outside utilities to do this, but we've
> > > found them lacking.  As a development shop we have found that when we
>need
> > > some additional functionality we build it on.  The current system we
>have
> > > now has grown out of several developers efforts in the past two years to
> > > incompass project managment, billing, contacts, work requests, logging,
> > and
> > > a host of other things.
> > >
> > > A third party too may save you time in the short run, but in the long
>run,
> > > it'll probably lacks the additional functionality you want.  I recommend
> > > buiding your own system, keeping in mind you want to be able to add
> > > additionally functionality in the future.
> > >
> > > - Paul
> > >
> > >
> > > - Original Message -
> > > From: "Rey Bango" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Monday, April 16, 2001 1:07 PM
> > > Subject: Note passing system?
> > >
> > >
> > > > Anyone know of a good CF-based note/messaging system? I'm not talking
> > > about
> > > > an email server but more of a db driven messaging software that will
> > allow
> > > > me to post a mes

RE: cfdirectory

[Arden Weiss]

The following code eliminates the periods in the directory listing plus, in 
this case, a file named "B77.TXT"
Hence this kind of logic can be changed to eliminate whatever files you 
don't want (like all TXT files if you use the RIGHT(NAME,3) NEQ "TXT"... 
etc...


  






  
#UCase(Name)# 
  
#NumberFormat(SIZE,"999,999,999")# 
  
#DateFormat(DateLastModified)# 
#TimeFormat(DateLastModified)#

  


 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Raymond B. [SMTP:[EMAIL PROTECTED]]
Sent:   Saturday, April 14, 2001 8:21 PM
To: CF-Talk
Subject:RE: cfdirectory

f you're displaying it alpha order (standard), then . and .. are always at
the top. CFDIRECTORY returns a query object, so just skip the first two
records using the startrow="" property.

-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: April 14, 2001 14:57
To: CF-Talk
Subject: cfdirectory


How can I keep the . and the .. from showing when I display the contents of
a directory?

Joshua Tipton
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: User Name and Password Routine

[Arden Weiss]

Go to Chapter 17 of Sybex's Mastering Cold Fusion book to see the details explained; 
then, copy the code from the accompanying CD. 

Works great out of the box/book, including session management...

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Sean Percival [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, April 13, 2001 1:39 PM
To: CF-Talk
Subject:User Name and Password Routine

All,

Hey all, im glad I found this list, it seems to be a valuable resource.

I'm currently creating a user name and password routine that interfaces with
a access database. Does anyone have any experience with this or can anyone
point me in a good direction to get started?

Thanks,
Sean

Sean Percival
Owner
Paragon Matrix - Web and Graphic Design
877.498.6072 - phone
[EMAIL PROTECTED] - email
[EMAIL PROTECTED] - wireless email
www.paragonmatrix.com - web
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: MIME TYPE?

[Arden Weiss]

Go to http://www.infomentum.com and look for AppletFile.  Works great -- 
both up and down -- with progress bars to keep the user distracted from 
poking keys and clicking buttons during the process...

^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Brian Thornton [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, April 10, 2001 12:01 AM
To: CF-Talk
Subject:MIME TYPE?

Anyone know how to download a file instead on displaying it on the browser? 
To generate to pop up dialog for saving it to a disk...

-Brian
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Stupid Question? - Commenting Code That Does Not Show in Browser

[Arden Weiss]

I find it very helpful to put the following 
at the top of every CFM page -- for my sanity
-- if it helps others that's fine too.



 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Steven A. del Sol [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, April 03, 2001 2:52 PM
To: CF-Talk
Subject:Re: Stupid Question? - Commenting Code That Does Not Show in Browser

If you are using CF just put in three dashes instead of two...




At 12:34 PM 4/3/2001 -0600, you wrote:
>I want to place comments in the code for the other developers.  However I do
>not want the comments to show up in the browser with "view source." Am I
>totally overlooking something?
>
>Thanks,
>Jeff
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: [Oracle Auto-Increment]

[Arden Weiss]

What about SQL Server -- how to auto-increment??

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Alex [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, April 02, 2001 9:45 AM
To: CF-Talk
Subject:Re: [Oracle Auto-Increment]

create a sequence then in your INSERT sql type sequencenqme.next_val.
not sure on specific syntax

Jamie Symonds <[EMAIL PROTECTED]> wrote:
Hi - I am inserting results of a form into an Oracle 8
database - in the past, while using Access, I would set the
first field of the table ("id") to "auto-number" for my
primary key.  Oracle does not have an auto-increment feature
- how do I go about this?  Thanks.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: [Re: An ignorance question to the masters]

[Arden Weiss]

Surely you jest -- and yes it still is April Fool's day...

See http://www.globalscape.com for the cutest FTP trick available...

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   zac [SMTP:[EMAIL PROTECTED]]
Sent:   Sunday, April 01, 2001 5:38 PM
To: CF-Talk
Subject:Re: [Re: An ignorance question to the masters]

Arden Weiss wrote:

> Personnally, I use CuteFTP for FTP processes (except when I use 
> WS_FTP is also another excellent alternative -- both free for initial
> download and $30 or so to keep.

I was under the impression (perhaps mistaken) that Cuteftp was a piece of
spy ware that reported all your uploads?

I remember seeing some hacks  around to remove this.

Is that not the case anymore?



-- 

How to become a writer

 1.Get angry. 
 2.Think you're better than most people.
3.Try to explain this to others.
4.Feel alienated by their reactions.
5.Get angrier. 

Heather Havrilesky aka Polly Esther
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: [Re: An ignorance question to the masters]

[Arden Weiss]

Personnally, I use CuteFTP for FTP processes (except when I use  
WS_FTP is also another excellent alternative -- both free for initial 
download and $30 or so to keep.

Note, that if you set up locally at 127.0.0.1 then just use DOS or Window 
file copy commands to do whatever you want with the files in the 
C:\inetpub\wwwroot\. folders.

Then, I also have a staging site at a CF hosting service (for 
pre-production testing). I use CuteFTP to manage my area on that site. 
 Similarly, I use CuteFTP to manage files on the production site wherever 
that is.

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Julia Phu [SMTP:[EMAIL PROTECTED]]
Sent:   Sunday, April 01, 2001 4:35 PM
To: CF-Talk
Subject:Re: [Re: An ignorance question to the masters]

Thank you, Brian.

Julia


"Brian Thornton" <[EMAIL PROTECTED]> wrote:
I would either create a network share or a ftp directory to somewhere in
your root. Use the files in Studio and upload / copy them to the network...
- Original Message -
From: "Julia Phu" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, March 31, 2001 10:06 PM
Subject: An ignorance question to the masters


> Hi,
>
> I'm new to ColdFusion and yet have a stupid question.
>
> I have a development server which has IIS, Oracle8i, and CF Application
Server
> installed. The CF Studio is installed on my laptop. My ignorance is how 
to
do
> my work from my laptop and connect to the development server. Is this the
> right setup?
>
> Thanks in advance.
>
> Julia
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Password Protection

[Arden Weiss]

Can send you what I've done if you like -- basically the same thing.
Structure of USERS table I used is as follows:

Items 8 and 12 thru 18 are Y/N fields that provide/deny access to various buttons
on various templates throughout the app. Just a bunch of  statements 
throughout the program -- the values of the items in this table are stored 
in client variables so they are avaiable throughout the app.

I used the login/password and session management login contained in Chapter 17
of Sybex's Mastering Cold Fusion directly and then added fields as I needed them.

User Level is a 0/1 thing with 0 meaning no access (so don't have to remove a 
user from the table to deny access).

Structure for table:USERS.DBF
Field  Field Name  TypeWidthDec   Index   Collate Nulls
1  F_NAME  Character  15Yes
2  L_NAME  Character  15Yes
3  USER_NAME   Character  25Yes
4  USER_ID Character  10Asc   MachineNo
5  PASSWORDCharacter  10Yes
6  LAST_CHNG   Character  16Yes
7  USER_LEVEL  Character   1Yes
8  REPT_MENU   Character   1Yes
9  EMAIL   Character  70Yes
   10  PHONE   Character  30Yes
   11  FAX Character  30Yes
   12  CAN_APRVCharacter   1Yes
   13  CAN_RECALL  Character   1Yes
   14  CAN_FTP Character   1Yes
   15  CAN_EXPORT  Character   1Yes
   16  CAN_ADMIN   Character   1Yes
   17  ONLY_SHIP   Character   1Yes
   18  CAN_AP_SHP  Character   1Yes
** Total **  234

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Heidi Belal [SMTP:[EMAIL PROTECTED]]
Sent:   Sunday, April 01, 2001 10:52 AM
To: CF-Talk
Subject:Password Protection

Hi all!
I have a question that i'd like suggested solutions to
if possible!
I want to allow certain people to access certain
pages. 
I already have a log in page which is password
protected, but everybody who logs in has full access
to all the pages.  I want to eliminate that full
access.
So, how about if i categorize the people into various
levels of access, and assign each a number.  Then have
that number in the database in the password/username
table.  Then when a person tries to access the page,
before displaying it checks which number/level the
person is in and if the person is allowed access.
What do you think?
Thanks!



=
Heidi Belal
ICQ# 32127109
http://m3.easyspace.com/hmbelal

A bus stops at a bus station.
A train stops at a train station.  On my desk
I have a work station...
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: question

[Arden Weiss]

Well -- your not the only fool up hacking away...

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Evan Lavidor [SMTP:[EMAIL PROTECTED]]
Sent:   Sunday, April 01, 2001 12:36 AM
To: CF-Talk
Subject: question

I have a table of data that was populated by an app not built by me (so I'm
starting off at a disadvantage in terms of not knowing everything about it -
I'm getting more info to help clear that up).

In two of the columns in the table (SQL Server 7), the data has been stored
as WDDX packets.

So, I'm doing the following to get at them and have a look at the data in a
more usable and understandable form:

| 
|   SELECT T.Col1, T.Col2
|   FROM OldDataTable T
| 
|
| 
| 
|
| 
|   #col1query.recordcount#
|   #col1query.columnlist#
|   
|   #col2query.recordcount#
|   #col2query.columnlist#
| 

All pretty straightforward, right?

Both of the  tags execute fine and I see the recordcount and
columnlist from col1query.  However, when it gets to the col2query outputs,
I get the following:

| Error Diagnostic Information
| An error occurred while evaluating the expression:
| #col2query.recordcount#
|
| Error near line 26, column 2.
| --
--
| Error resolving parameter COL2QUERY.RECORDCOUNT
|
| The object RECORDCOUNT is not present in the scope named COL2QUERY. It is
likely that you
| have misspelled the name of the object you are trying to access.


Now, if it was an invalid packet (which it doesn't look like when I just
output it to the screen), it would fail the  call, right?  Since it
passes it, why can't I access it like a query?

Col1query works just fine.  Gives me a recordcount, a columnlist, I can loop
over records, etc. etc. etc.


Thanks in advance for any insight anyone can offer.

Let's not even discuss the fact that I'm working on this at 12:35 on April
Fools Day ;-)


Evan
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

How to tell if a QUERY UPDATE fails.

[Arden Weiss]

I know how to tell if a QUERY SELECT fails -- recordcount() is zero.

How do you tell if a QUERY UPDATE or QUERY INSERT fails??

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Bud [SMTP:[EMAIL PROTECTED]]
Sent:   Saturday, March 31, 2001 10:09 AM
To: CF-Talk
Subject:RE: SELECT * Queries

On 3/31/01, Arden Weiss penned:
>Simple question from my older twin -- what do you do to get these 
>timings -- haven't done it before (obviously).

The template execution time and query times are shown when debugging is active.
-- 

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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SELECT * Queries

[Arden Weiss]

Simple question from my older twin -- what do you do to get these timings -- haven't 
done it before (obviously).

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Jonathan Lim [SMTP:[EMAIL PROTECTED]]
Sent:   Saturday, March 31, 2001 9:38 AM
To: CF-Talk
Subject:RE: SELECT * Queries

Hi Bud,

My DBA told me that the * will mean more data has to be transferred from the
DB server to your CF server. That's what slows it down. The DB time spent
getting the data for * or for a specific field is negligable. We're working
with DB2.

HTH
Jon

> -Original Message-
> From: Bud [mailto:[EMAIL PROTECTED]]
> Sent: 31 March 2001 13:37
> To: CF-Talk
> Subject: SELECT * Queries
> 
> 
> Hi all. I've always been told, and read here that using * in SELECT 
> queries is slower than specifying the field names. I just happen to 
> be working on a site now where I have a page with 3 big SELECT 
> queries. One of them with over 100 fields. If I use * in lieu of the 
> field names, the page execution time is reduced from +- 250 
> milliseconds to +- 185 milliseconds, with the actual query times 
> being cut by about 1/3.
> 
> Anyone else experience this? The 2 largest queries have no joins, but 
> even the one with a join goes from 50 ms to 35 ms if I use:
> SELECT L.*,B.*
> 
> Have I been reading this wrong? I've sure wasted alot of time 
> entering field names into Select queries , not to mention slowing 
> down my apps.
> 
> Thanks,
> -- 
> 
> Bud Schneehagen - Tropical Web Creations
> 
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: disabling RDS

[Arden Weiss]

Have a "best" book reference/tutorial on RDS usage ? ? ?

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Simon Horwith [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, March 30, 2001 11:07 AM
To: CF-Talk
Subject:RE: disabling RDS

I believe not running the RDS service is the best way to prevent people from
using it.

~Simon

Simon Horwith
Macromedia Certified Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com



-Original Message-
From: William J Wheatley [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 10:53 AM
To: CF-Talk
Subject: disabling RDS


so whats the best way to disable RDS if you dont want the boxes to have RDS
ACCESS? if you uncheck RDS password in CFADMIn it will just let you get in
without 1 right?


Bill Wheatley
Director of Development
AEPS INC
Allaire ColdFusion Consulting Partner
Allaire Certified ColdFusion Developer
http://www.aeps.com
ICQ: 417645
http://www.aeps2000.com
954-472-6684 X303

IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by
the named addressee.  It is confidential and may contain legally privileged
information.  No confidentiality or privilege is waived or lost by any
mistaken transmission to you.  If you receive this e-mail in error, please
immediately delete it from your system and notify the sender.  You must not
disclose, copy or use any part of this e-mail if you are not the intended
recipient.  The RTA is not responsible for any unauthorized alterations to
this e-mail or attachment to it
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Import data to ACCESS

[Arden Weiss]

what about just using ODBC to insert records to an empty Access Database after you 
have done a select against Orrible 7.

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   James Maltby [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, March 30, 2001 5:45 AM
To: CF-Talk
Subject:Import data to ACCESS

Here's a dudy for y'all - 

SCENARIO: current client's website - running on NT4, CF 4.01, Access 97
backend - have come back to us with the following request:

They have an Orrible 7 database internally from which they want to export
tab delimited (or csv) data (deleted, amended and new records) on a regular
basis (usually about 200 - 500 records each time) - and they want us to
write an application that will "execute" this file on their server.

ISSUES: the server does not have Access on it, just the databases required -
they will not allow a remote ODBC connection to the Oracle database - the
server is v. old (about 2 years old - 1/2 gig RAM - x86 Pentium II
300/400(?) Proc.)

SOLUTION: we suggest upgrading the backend to MS SQL - using SPs to import
the data - run by CF pages in the admin management system we have written.

PROBLEM: they want us to suggest using the current techs. - i.e. using
ACCESS databases without having access on the server any suggestions...

TIA

James
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Unbelievable! Patricia Lee wrote:

[Arden Weiss]

Now let me think -- Most of you bought a $20,000 car to drive to work in 
and you're complaining about spending $1,000 for a product(s) so you can 
pay for your car -- get real  <:--))

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, March 29, 2001 5:49 PM
To: CF-Talk
Subject:Unbelievable! Patricia Lee wrote:

UltraDev 4 at US$600 for page layout (must be rich) and CF Studio at US$495 for code 
(the latter I can understand).

By the way - according to Allaire's "purchase" page it is now called "Macromedia 
ColdFusion" - erk.



not really.

I use Ultradev to edit my page layout, not to code.  I feel safe (with about
a 10% reservation factor) using Ultradev with code that has been riddled
with CF code.  I've only seen a small percentage of F***ups since Ultradev
4.

When I decide in the middle of things that my table needs 5 more colmns, 3
additional rowspans and a few more nested form elemetns, I just might try it
in UD first.  However, it can't beat CFStudio for pure raw coding in this
girls opinion.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF Adhoc Query Frontend...

[Arden Weiss]

I need to implement a semi-generalized CF-based adhoc query frontend for existing CF 
app.

Don't want to re-invent the wheel if possible.

Something completely canned to buy (CFX or othewise) or some existing 
CF code in a book or on the web somewhere that I can use as a starting point.

Any references/links regarding what's available would be a big help?

Thanks in advance...

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Registry size.

[Arden Weiss]

Time to move your client variables to ODBC source, etc... to avoid CrAsHiTiSe.

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Neil H. [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, March 27, 2001 7:47 PM
To: CF-Talk
Subject:Registry size.

I noticed my registry is getting huge (128 megs) and that I increased it to
160 megs for space sakes but are the entries in there that I can remove from
CF not collecting garbage?

Thanks,

Neil
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists