Re: Recordcount/Query Strangeness..

2001-07-31 Thread David Cummins
Maybe it would be a good idea if your count variable (citysearch) had a different name to your query variable (citysearch)... ;) I usually name queries q_something etc to avoid this sort of problem. David Cummins Lee Fuller wrote: > > Ok.. Now I think I'm going nutz. This is completely crazy.

RE: Recordcount/Query Strangeness..

2001-07-31 Thread Lee Fuller
Oh my gosh! You're SO right Kevin. It was right in front of my face, and I didn't even see it. Thanks! > -Original Message- > From: Kevin Langevin [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 31, 2001 10:02 PM > To: CF-Talk > Subject: RE: Recordcount/Query Strangeness.. > >

RE: Recordcount/Query Strangeness..

2001-07-31 Thread Kevin Langevin
Ummm...there's no loop in this code. On line 6 you're setting the variable citysearch equal to something, and therefore you're blowing away the resultset, because it's also called citysearch. I'm pretty sure that you can't have a VARIABLES scope variable and a query resultset that use the same n

Recordcount/Query Strangeness..

2001-07-31 Thread Lee Fuller
Ok.. Now I think I'm going nutz. This is completely crazy. When running this code... 1: 2: 3: NOT! 4: 5: 6: 7:#citysearch.recordcount# 8: 9: I get an error nearl line 7 column 15 "Error resolving parameter CITYSEARCH.RECORDCOUNT". However, I *CAN* do a CFOU

RE: Emailing Errors Automatically

2001-07-31 Thread Peter Tilbrook
Try using the JSStringFormat function (JavaScript String Format): eg: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marc J. Mataya Sent: Wednesday, 1 August 2001 3:18 PM To: CF-Talk Subject: Emailing Errors Automatically CFUG, When my app has a

Re: Resizing images

2001-07-31 Thread Kay Smoljak
On Tue, 31 Jul 2001 02:16:23 -0700 (PDT), Hamid Hossain <[EMAIL PROTECTED]> wrote: >I want to be able to resize gif, jpg or bmp pictures >with coldfusion. cfx_pwimageproc does this, and a lot more (http:www.developer.perthweb.com.au). It outputs jpegs, but not gifs, because of the ridiculous lic

Emailing Errors Automatically

2001-07-31 Thread Marc J. Mataya
CFUG, When my app has a user error, error.cfm is called using CFERROR. Since you cannot execute any functions in this page such as CFMAIL, I am simply redirecting the error.cfm using JavaScript to another page that will successfully CFMAIL me. See the code below. The problem is that the diagno

RE: Got the fellow, but....

2001-07-31 Thread Peter Tilbrook
http://grc.com/dos/grcdos.htm#conclusion At the bottom of the page he states that "BlackICE Defender had ABSOLUTELY NO EFFECT WHATSOEVER". Interesting article to be sure! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paris Lundis Sent: Wednesday, 1 Au

RE: Got the fellow, but....

2001-07-31 Thread Paris Lundis
wheres the comparison? Didn't see it there :) -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: "Peter Tilbrook" <[EMAIL PROTECTED]> Date: Wed, 01 Aug 2001 10:47:07 +1000 Subject: RE: Got the fello

RE: Got the fellow, but....

2001-07-31 Thread Peter Tilbrook
Absolutely. Even if you are not running a server you should try Zone Alarm. Check out http://www.grc.com for a frank comparison between BlackIce Defender and Zone Alarm. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Michael Lugassy Sent: Tuesday, 31 J

RE: Passing a form file to CFMAIL

2001-07-31 Thread Peter Tilbrook
You should use CFFILE to do your file duties then use the CFMAILPARAM in your CFMAIL to handle the attachent. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Wildminds Sent: Wednesday, 1 August 2001 2:45 AM To: CF-Talk Subject: Passing a form file to CFMA

RE: Print PDF to Network Printer

2001-07-31 Thread Peter Tilbrook
ActivePDF is a good product (I used it on a project for creating Wills online). It was pretty pricey but does a good job. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Aylor Sent: Wednesday, 1 August 2001 7:50 AM To: CF-Talk Subject: Re: Print PD

RE: html and cold fusion in string -larger question

2001-07-31 Thread Jared Clinton
This technique allows HTML pages to have dynamically updated sections without refreshing the entire page, it may be of some assistance. http://www.vboston.com/DepressedPress/Content/ColdFusion/Essays/GIFAsPipe/In dex.cfm Jared Clinton -Original Message- From: Gilbert Midonnet [mailto:[

Re: mySQL

2001-07-31 Thread Matt Robertson
I'm using the Windows version and its a great replacement for MS Access. Solid as a rock and minimal memory usage (for me at least), it has evidenced none of the instability/memory leakage I got using Access in the past. But its missing many of the features you'd expect from a true enterprise

RE: mySQL

2001-07-31 Thread Costas Piliotis
First off, it's not fully ANSI-92 Compliant last I checked... Here's your answers: a. will it support 4-5 and even 10 gig of data? Sure. It indexes the data. Should be fine. b. will it allow full-text indexing/searching? Yes!: http://www.mysql.com/doc/F/u/Fulltext_Search.html c. does it allo

RE: Print PDF to Network Printer

2001-07-31 Thread Richard Colman
TNX for the suggestion. Looks like the PDFPrint product might do it. -Original Message- From: Steve Aylor [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 2:50 PM To: CF-Talk Subject: Re: Print PDF to Network Printer wasnt aware that you could . 1. Run the full version of A

Re: mySQL

2001-07-31 Thread Michael Lugassy
The big and most important question before I even begin installing: a. will it support 4-5 and even 10 gig of data? b. will it allow full-text indexing/searching? c. does it allow replication between remote servers? d. anyone know something about hebrew support? Michael. - Or

Re: Print PDF to Network Printer

2001-07-31 Thread Steve Aylor
wasnt aware that you could . 1. Run the full version of Adobe Acrobat on a server - legally. 2. Control the Acrobat print functions via CF or other language server side - legally. but ... maybe the peeps at www.activepdf.com have a tool you can use/buy. Stephen M. Aylor Aylor Insuranc

Re: mySQL

2001-07-31 Thread Tracy Bost
We're using MySQL on a linux box with coldfusion for some things. As far as select statements go, its extremely fast even with a large amount of data. MS-SQL is going to give you alot more functionality though. - Original Message - From: "Michael Lugassy" <[EMAIL PROTECTED]> To: "CF-T

Re: can't connect to mail server

2001-07-31 Thread S R
I did not get a banner I got a cannot connect error, so somehow there is not a connection between my web server and our mail server,   Thanks   Sal >From: Len Conrad <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Re: can't connect to mail server >D

Print PDF to Network Printer

2001-07-31 Thread Richard Colman
Trying to: * query database * create adobe FDF file * feed FDF file to pre-constructed PDF form * print resulting form (with field data inserted) to network printer (NOT browser). I have seem to have most of the components, but not the one that will print the resulting form. There used to be a t

Re: Exception Handling in SQL?

2001-07-31 Thread eric . laney
This is an ideal place for BEGIN TRAN / COMMIT TRAN / ROLLBACK TRAN. I've done this in the past with SQL Server 7.0 and it works great. DECLARE @ErrNum int SET @ErrNum = 0 -- delete the line item BEGIN TRAN delete Invoice_Line_Item Where Invoice_Line_Item_ID = @Line_Item_ID set @ErrNum = @Err

Re: [mySQL]

2001-07-31 Thread Alex
its free, fast, has hype. NO triggers, stored procs, sub queries, row level locking. Pretty much any enterprise utilities that a DB has MySQL doesn't. Nusphere makes a custom MySQL with some enterprise features at a price. Also postgresql is free. If you already have SQLServer stick with it; it's

CFX_crwtopdf tag syntax

2001-07-31 Thread Richard Colman
Anyone happen to have the "doc" or syntax available for this old, no longer available, and very cool tag. Don't actually need the tag, just the syntax. TNX. Richard Colman ~~ Structure your ColdFusion code with Fusebox. Get the official book at

Re: 2 JavaScript questions

2001-07-31 Thread eric . laney
function toForm(theForm, theField) { document.theForm.theField.focus(); } and then called it by: onLoad="toForm('form1','Firstname') The problem is that what you're passing into the function is a string, not a form object. The way JS works, it's going to expect a form object. Instead, try th

RE: html and cold fusion in string -larger question

2001-07-31 Thread Gilbert Midonnet
> Perhaps if you explained your larger problem the insight of this list may > suggest a better solution. Problem: displaying constantly changing prices in a table without refreshing the whole page (because of the flash/flicker) Backend: I'm pulling the prices from an xml page. Attempt: refres

Re: can't connect to mail server

2001-07-31 Thread Len Conrad
>Are there any ideas as to why Cold Fusion cannot connect to a mail server? >You can rule out the mail server being down or change of address because I >just tested it using a non-cold fusion program from the CF machine? > and I received an email. When >I go to the CF Admin and 'verify' the ma

mySQL

2001-07-31 Thread Michael Lugassy
I was wondering if someone is using mySQL with coldfusion? and in general, can someone tell me how good mySQL is compared to msSQL, does it support full-text? and reasonable (3-5 gb) amount of data? Michael. ~~ Structure your ColdFusion code with

encrypting url parameters

2001-07-31 Thread Douglas Jordon
Are there any simple methods of encrypting a url variable? I need to pass a record id number around and would like to turn it into text. TIA, Doug Jordon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusiona

RE: can't connect to mail server

2001-07-31 Thread John Fix 3rd
Anything in the mail server log? Is it possible that some anti-spam options are turned on that are preventing CF from connecting? John www.cornells.com > -Original Message- > From: S R [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 31, 2001 4:39 PM > To: CF-Talk > Subject: can't con

RE: selecting top n records - RESOLVED

2001-07-31 Thread Pete Freitag
Mark, Your going to need to ORDER that recordset by COUNT(ID_PRODUCT), because it will select the TOP 3 of the recordset, not necessarily the Largest values, the ordering it uses is based on the indexes it has setup, you should never assume ordering, unless you use ORDER BY. The fact that

RE: What is the purpose of the \cfusion\mail\undevilr directory?

2001-07-31 Thread Cameron Childress
Yeah, I didn't type "URL may wrap" like I normally do. All you have to do is unwrap the URL from the next line and it will work. -Cameron Cameron Childress elliptIQ Inc. p.770.460.1035.232 f.770.460.0963 -- http://www.neighborware.com America's Leading Community Network Sof

RE: can't connect to mail server

2001-07-31 Thread Pete Freitag
There is a big difference between receiving mail and sending mail. They use different protocols to send mail you use SMTP (port 25), and to receive you use POP3 (port 110) or IMAP. So your SMTP server could be down, and your POP3 server is still running. A lot of times the SMTP server is on a d

Re: Resizing images

2001-07-31 Thread Keith Meade
cfx_kmSuite includes that functionality, along with a whole lot of other stuff. Check out the cfx_kmGraphic module at: http://www.hoptechno.com/kmtools/ cfx_kmSuite is marketed by a third party, but I'm the author. If the product isn't exactly what you need, let me know and I'll fix it. (smi

RE: can't connect to mail server

2001-07-31 Thread S R
I've tried both >From: "Dylan Bromby" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: can't connect to mail server >Date: Tue, 31 Jul 2001 13:46:52 -0700 > >are you connecting by its IP or FQDN? > >-Original Message- >From: S R [mailto:[EMA

Re: [Sort by 1st three letters of month?]

2001-07-31 Thread Alex
you could set up an array,structure, or a new DB table with 1,jan .. 12 ,dec "Willy Ray" <[EMAIL PROTECTED]> wrote: Ok, I'm an idiot. I have my users putting in text strings for months. I need Jan. 12 to be ordered ahead of Aug. 9 These are text records. Is there any way to do this? I g

FW: selecting top n records - RESOLVED

2001-07-31 Thread Mark Warrick
Here's the answer to the question for anyone who is curious. SELECT TOP 3 COUNT(ID_PRODUCT) as thecount, ID_PRODUCT FROM ORDER_LINEITEMS GROUP BY ID_PRODUCT = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTE

RE: Data-modeling for anniversaries...

2001-07-31 Thread Jay Sudowski - Handy Networks LLC
Hi David, You might want to check into the DatePart function - (the Access DatePart function, not the CF DataPart function. They both work the same way, but have slightly different syntax). Select name, anidate from ani where AniDate = DatePart("ww", now()) HTH. Jay Sudowski ---

RE: can't connect to mail server

2001-07-31 Thread Dylan Bromby
are you connecting by its IP or FQDN? -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 1:39 PM To: CF-Talk Subject: can't connect to mail server Are there any ideas as to why Cold Fusion cannot connect to a mail server? You can rule out the mail serve

RE: selecting top n records

2001-07-31 Thread Leon Oosterwijk
SELECT * FROm Table LIMIT 10; -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 3:23 PM To: CF-Talk Subject: RE: selecting top n records First thought would be something like: SELECT TOP 10 COUNT(PRODUCTID) AS COUNTER, PRODUC

RE: SQL SERVER 7

2001-07-31 Thread Jay Sudowski - Handy Networks LLC
Hi Jerry - Why not use DTS and schedule the task to run on intervals. I think that would be the easiest way to do things. Jay -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 12:16 PM To: CF-Talk Subject: SQL SERVER 7 Hi, Could an

can't connect to mail server

2001-07-31 Thread S R
Are there any ideas as to why Cold Fusion cannot connect to a mail server? You can rule out the mail server being down or change of address because I just tested it using a non-cold fusion program and I received an email. When I go to the CF Admin and 'verify' the mail server connection I get '

RE: What is the purpose of the \cfusion\mail\undevilr directory?

2001-07-31 Thread Carlisle, Eric
http://devex.allaire.com/developer/gallery/info.cfm?ID=05D90D06-6C6B-11D5-83 That address gave me some odd error. Invalid attribute The value '05D90D06-6C6B-11D5-83' is not valid object ID. This value was passed to the custom tag 'cfa_isEmbeddedObject' via the attribute 'objectID'. I searched

RE: selecting top n records

2001-07-31 Thread Bill King
First thought would be something like: SELECT TOP 10 COUNT(PRODUCTID) AS COUNTER, PRODUCTID FROMORDERDETAIL GROUP BYPRODUCTID ORDER BYCOUNTER DESC There may be something faster, but this works... - BILL - -Original Message- From: Mark Warrick [mailt

Re: selecting top n records

2001-07-31 Thread Don Vawter
assuming that productId is a primary key your query will always have a count of one I think the table should not be Products but ORDERS_LINEITEMS - Original Message - From: "Kevin Mansel" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 31, 2001 2:13 PM Subject:

RE: selecting top n records

2001-07-31 Thread Pete Freitag
SELECT TOP 10 COUNT(ID_PRODUCT) AS Sold, ID_PRODUCT FROM ORDERS_LINEITEMS GROUP BY ID_PRODUCT ORDER BY COUNT(ID_PRODUCT) DESC you can replace the 10 with N Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developers Resources http://www.cfdev.com/ -Original Message- From: Mark W

RE: What is the purpose of the \cfusion\mail\undevilr directory?

2001-07-31 Thread Cameron Childress
There are lots of reasons. Most of which have to do with failure to communicate with the mail server. Causes can include am empty "from" field, network outage between CF and your mail server, misconfigurations of mail servers, etc... As blatant self-promotion, I would like to suggest that you c

Sort by 1st three letters of month?

2001-07-31 Thread Willy Ray
Ok, I'm an idiot. I have my users putting in text strings for months. I need Jan. 12 to be ordered ahead of Aug. 9 These are text records. Is there any way to do this? I guess I could parse out the first three characters of whatever my user entered, run it through a big cfswitch to ass

RE: selecting top n records

2001-07-31 Thread Kevin Mansel
Try this... SELECT COUNT(ProductID) AS TopN, ProductID FROM Products GROUP BY ProductID ORDER BY TopN DESC remember to put something of numerical value in the maxrows attribute. hth kev ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-

CFFTP in 4.0/4.5 - 4.0 worked / 4.5 errors

2001-07-31 Thread Justin Hansen
We finally moved from 4.0 to 4.5.1 SP2 last week and now we are having a problem with cfftp. The page in question reads the orders from the db and creates a .txt file which is then uploaded to a 3rd party. All of this stuff worked before the upgrade and now it doesn't. I also installed the ftp.dl

RE: html and cold fusion in string

2001-07-31 Thread Pete Freitag
Its probably not a good idea having CFML code in variables, because in order to execute it you have to write it to a file (It would be nice if there was an EvaluateCFML() that would eval tags). Perhaps if you explained your larger problem the insight of this list may suggest a better solution. B

Exception Handling in SQL?

2001-07-31 Thread Shawn Grover
We are using SQL Server 7, and need to delete records. However, we need to intercept if a foriegn key constraint error is thrown. SQL Server seems to be throwing an exception as soon as the error is encountered, and not giving our script a chance to handle the error. Is there anyway around this

selecting top n records

2001-07-31 Thread Mark Warrick
I need to select the top selling products from a table of lineitems. Top selling products would be those whose ID_PRODUCT shows up the most in the ORDERS_LINEITEMS table. Any clues from the SQL gurus out there? ---mark = Mark Warrick - Fusioneers.com Per

RE: What is the purpose of the \cfusion\mail\undevilr directory?

2001-07-31 Thread Carlisle, Eric
Yup, tried that earlier and it worked. So the \undelivr directory is just there to catch e-mail that can't be sent due to mail server communication problems? Are there any other contingencies where files will be sent to this directory? Many thanks, Eric Carlisle -Original

RE: Scheduler Woes

2001-07-31 Thread Gordon Burns
At 13:30 31/07/01 -0400 Debbie Dickerson said >It's no coincidence. :-) > >There's an updated version of the ascf.dll file that will take care of your >problem. The original shipped with the security patch caused scheduled tasks >to fail on CF 4.0x. The corrected version is available here: >ht

RE: Data-modeling for anniversaries...

2001-07-31 Thread Braver, Ben
Yes, check the MS Access help system for the DatePart function, and also the Format Property for Date/Time Data Types, Custom Formats. -Ben -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 12:17 PM To: CF-Talk Subject: RE: Data-modeling for an

RE: What is the purpose of the \cfusion\mail\undevilr directory?

2001-07-31 Thread Justin Greene
Messages that Cold Fusion is not able to hand off to the smarthost appear here. Your smtp server may accept abc and 123 as valid email addresses and just try to append you domain to the end of them. Try putting a bad IP address for the SMTP server and watch the directory fill up. -Original

Re: html and cold fusion in string

2001-07-31 Thread Jochem van Dieten
Gilbert Midonnet wrote: > As part of trying to solve a larger problem I would like to put a lot (100+ > lines) of html and cold fusion code ( etc... no SQL) into a string. > > Two questions. > > 1. what's the best way of dealing with this? > > cfsavecontent or if you don't have cf 5 one of

Re: 2 javascript questions

2001-07-31 Thread Don Vawter
on the first question if you always want to set focus to FIRST element of the FIRST form you can use: on the second you can just loop over the elements array and grab what you need - Original Message - From: "Timothy Lynn" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tues

What do I need to do to get CF/Crystal Reports running together?

2001-07-31 Thread Shawn Grover
We need to use crystal reports with our current CF project. My intial testing seems to say that the CFREPORT tag isn't working. But, I'm thinking I probably didn't setup the crystal reports side of things right. (CFREPORT, specified the .rpt file, got dll errors). I did dig, and found the hidd

RE: CFQUERY question

2001-07-31 Thread Costas Piliotis
Like what? What exactly are you looking for? CREATE, ALTER, AND DROP work... -Original Message- From: Pooh Bear [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 2:26 PM To: CF-Talk Subject: CFQUERY question hey can i do Full SQL programming inside cfquery tags? or is it limite

html and cold fusion in string

2001-07-31 Thread Gilbert Midonnet
As part of trying to solve a larger problem I would like to put a lot (100+ lines) of html and cold fusion code ( etc... no SQL) into a string. Two questions. 1. what's the best way of dealing with this? ... 2. Should I be trying this at all? :> TIA -- glm -

2 javascript questions

2001-07-31 Thread Timothy Lynn
'lo there, I'm working on the checkout portion of a shopping cart app. First part of my question is about setting the focus to the first element of the form. I have some code which does this: function toForm() { document.form1.Firstname.focus(); } It's called at body onLoad and this works fine

RE: Data-modeling for anniversaries...

2001-07-31 Thread David Grabbe
Is there a way to do the same thing in Access2000? David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 3:09 PM To: CF-Talk Subject: RE: Data-modeling for anniversaries... I would use a series of database functions to turn

RE: Data-modeling for anniversaries...

2001-07-31 Thread mherbene
I would use a series of database functions to turn the original date into a date in the current year, like this (Oracle-ish code since I don't know what DB you're using but am too lazy to find the exact syntax): to_date (to_char(aniv_date_field, 'm-d') + '-' + currentyear(), 'm-d-' ) now I h

solved: clearing cfmap .tmp files

2001-07-31 Thread Eric J Hoffman
I did find what I neededcf_delete_files. Eric -Original Message- From: Eric J Hoffman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 1:59 PM To: CF-Talk Subject: clearing cfmap .tmp files if we make a change in a site dynamically, how can we easily run some code to n

clearing cfmap .tmp files

2001-07-31 Thread Eric J Hoffman
if we make a change in a site dynamically, how can we easily run some code to nuke all the .tmp files in a directory? Is there a custom tag for such, or do we need to run a cfdirectory list, somehow dump to list, then loop it and cffile delete each? A better way? Thanks in advance!!! Eric J H

sorting verity search results

2001-07-31 Thread FARRAH NG
hi all, i am working on the CF verity search engine. In my CFSearch i have 9 collections and the search results returned is in a kind of random order. Is there a way to display the search result in a sorted order? thanks everybody. --

mail client

2001-07-31 Thread Eric J Hoffman
per a few suggestions, I looked at the CrazyCabs webmail client on my CF diskand it is ok... Is there a more feature laden one that anyone here uses...we are looking for free-cheap since it is for a non-profit??? Thanks!!! Eric J Hoffman Director of Internet Development Small Dog Design

CF Tree

2001-07-31 Thread Tangorre, Mike
Is anyone aware of any sites explaining and demonstrating the use of CF Tree? I am trying to build some functionality into a website to allow users to view there files and folders. Mike ~~ Structure your ColdFusion code with Fusebox. Get the offici

RE: Next/Previous

2001-07-31 Thread Pete Freitag
The direct link for QueryBrowse is: http://www.cfdev.com/products/productdetail.cfm?id=1004&ref=126 -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 2:15 PM To: CF-Talk Subject: Re: Next/Previous Joshua, I like CF_QueryBrowse from the CF D

RE: Data-modeling for anniversaries...

2001-07-31 Thread Paul Sizemore
David, I asked such a question a while back. Answer follows. My query was: select month (compdate) as month, day (compdate) as day, year (compdate) as year, net_sales from sale_head where locnum = #Form.StoreNum# AND compdate >= today - 365 order by month, day

VBScript/CF and Crystal Reports

2001-07-31 Thread Todd Ashworth
In VBScript, you can use something like this to tell Crystal Reports what database file it should pull its table information from. set FirstTable = Session("oRpt").Database.Tables.Item(1) FirstTable.Location = "mydatabase.db" Is there something similar in ColdFusion? Actually, is there ANY way

Re: Next/Previous

2001-07-31 Thread Terri Stocke
Joshua, I like CF_QueryBrowse from the CF Developer's Exchange. It's extremely customizable. It also provides the actual result page numbers at the bottom (1, 2, 3, 4...etc., though I could not get that to work with this tag). The only weird thing I found is that for some reason, I cannot get

Re: CF INTELLIGENT AGENT QUESTION

2001-07-31 Thread Michael Dinowitz
If its webserver password protection then the CFHTTP tag can have the password in it. If it's cookie based then do the following: 1. Call a page that sets the cookie. 2. read the cookie from the CFHTTP header info 3. call the next page while sending the cookie as a CFHTTPPARAM 4. repeat as needed

Next/Previous

2001-07-31 Thread Joshua Tipton
Anyone have code for a good previous and next record display. I can write one but I am feeling lazy. TIA, Joshua Tipton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http:

What is the purpose of the \cfusion\mail\undevilr directory?

2001-07-31 Thread Carlisle, Eric
Firstoff, I'm using CF 4.5.1. I thought that the "undevilr" folder was there to catch mail that was either sent back or timed out contacting the mail server. Am I wrong? I tried this tag, which was formatted badly on purpose. Test When I execute this tag, a spool file does appear in the \spool

RE: All vars?

2001-07-31 Thread Costas Piliotis
Here's the actual code - I use this in my error handling page for development: FORM.#myVar2# #evaluate("form." & "#myvar2#")# -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 10:52 PM To: CF-Talk Subject:

CF INTELLIGENT AGENT QUESTION

2001-07-31 Thread Lewis Steven
Is it possible to use CFHTTP to connect to a web site and establish an on going session? What I am trying to accomplish is to have the agent go into a password protected site, then query the search engine on that site and retrieve individual web pages from the links that are returned. If this is

RE: CFEncrypt and Oracle

2001-07-31 Thread Joshua Tipton
encrypt to base64 -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 12:55 PM To: CF-Talk Subject: CFEncrypt and Oracle I am trying to use encrypt some information going into a database on Oracle 8, and I can't do the insert into because I get

Verity - sorting query results

2001-07-31 Thread Aimee Abbott
Hello everyone, Is there more than one way to sort query results? I have set up a collection for a policy manual. I need to be able to sort my results by date and by policy number. I am already using CUSTOM1 and CUSTOM2. Does anyone know if CF5 will allow more than two CUSTOM's? Thank you

Data-modeling for anniversaries...

2001-07-31 Thread David Grabbe
I've run into a data-modeling stumper. I have a database table which contains wedding anniversaries and the respective couple's name. The date is stored as the wedding date, so calculating the anniversary is easy. The primary usage of this is to display the anniversaries on a monthly calendar.

RE: Scheduler Woes

2001-07-31 Thread Debbie Dickerson
It's no coincidence. :-) There's an updated version of the ascf.dll file that will take care of your problem. The original shipped with the security patch caused scheduled tasks to fail on CF 4.0x. The corrected version is available here: http://www.allaire.com/handlers/index.cfm?id=21579#850 De

RE: SQL SERVER 7

2001-07-31 Thread Glenn Olsen
Since you want to send data back and forth at the db level (sproc), look in SQL Server Books OnLine, 'linked servers, configuring'. You can setup a linked server via Enterprise Manager or the system sproc sp_addlinkedservers. Since these are 2 SQL boxes, that part is relatively straightfoward.

Re: Passing a form file to CFMAIL

2001-07-31 Thread Terri Stocke
Hi, You would have to save the file to the server first (using CFFILE), and then attach it to your email using mimeattach, calling the file with #file.serverfile#. If you just try to "attach" the information via the form variable name, it won't do anything (except I think it will throw an erro

RE: Got the fellow, but....

2001-07-31 Thread Jon Hall
I'm not trying to start a firewall war, but as you say, ZoneAlarm must be set up to allow each program to communicate over the network. This seems entirely to much work to me, plus AFAIK when you install a new program on the box you have to click on a little box to let the program have access

RE: Passing a form file to CFMAIL

2001-07-31 Thread Cameron Childress
I just saw someone on the Atlanta CFUG list come acorss this and it worked fine, but you have to CFFILE type="Upload" the file tot he server first. -Cameron Cameron Childress elliptIQ Inc. p.770.460.1035.232 f.770.460.0963 -- http://www.neighborware.com America's Leading Com

Re: locking error

2001-07-31 Thread eric . laney
It means that whatever value you had for the timeout attribute in your cflock tag was too short. You received the error message because you had throwontimeout="yes". Instead of removing the locks, either increase the timeout value or consider moving from a scope lock to a name lock so you can l

RE: Purchasing a copy of ColdFusion Server in the UK

2001-07-31 Thread Philip Arnold - ASP
> Anyone know where I can purchase a copy of ColdFusion Server in the UK? > > I just tried Unipalm but was told that they don't sell to end users... Aidan, In case you STILL looking to purchase a copy, there has been a slight delay on shipments to the UK - the main problem being if you're a Part

CFEncrypt and Oracle

2001-07-31 Thread Ray Bujarski
I am trying to use encrypt some information going into a database on Oracle 8, and I can't do the insert into because I get errors stating that there are invalid characters. Any tips here? Thanks, Ray ~~ Structure your ColdFusion code with Fusebo

RE: SQL SERVER 7

2001-07-31 Thread Kevin Mansel
The code wouldn't be that complicated considering you have both ODBC sources set up on the box that the cold fusion queries are running from. Just submit to both DataSources through your ODBC setup through cf. Or am i missing a "HUGE" step? ~ Kevin Mansel Senior Web Developer Fo

RE: PDFConnect

2001-07-31 Thread Simon Horwith
it's really not very tough to populate pdf forms on the fly manually, to be honest. check out pdfzone.com... I believe there's a tutorial there. ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion 5 Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 2

How to use CFEXECUTE

2001-07-31 Thread seth ward
Can't seem to get any help from the UK on this one, hopefully you guys can help... I'm trying to automatically convert existing GIF images into BMP format. I have previously done this using the CFX_COMMAND tag from www.intrafoundation.com which allows you to execute command line calls, which exec

Passing a form file to CFMAIL

2001-07-31 Thread Wildminds
I'm just about to run some preliminary tests, but thought I'd run it by the group just in case. It's a fairly simple situation; the visitor fills out the form, and browse/selects their resume to be included (attached). Upon submission, the form data is passed to the CFMail page. Essentially,

RE: SQL SERVER 7

2001-07-31 Thread Philip Arnold - ASP
> Could anyone give me any feedback on the following: > > We have a SQL Server say for example "SQL1" based in Belfast, and > another SQL Server "SQL2" Based in London. > > What i need to do is write a stored procedure from a database in "SQL1" > "Table1" to insert data into "SQL2" "Table2",

RE: cfmail

2001-07-31 Thread Ryan Edgar
You have to use type="html". Ryan Edgar Web Applications Developer Biznet Solutions 133 - 137 Lisburn Road Belfast BT9 7AG www.biznet-solutions.com Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: 31 Jul

PDFConnect

2001-07-31 Thread Richard Colman
Thinking about purchasing PDFConnect tag product. Any comments or feedback from users would be appreciated. Contact me on the list, or off. Thank you. Richard Colman [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the officia

RE: Purchasing a copy of ColdFusion Server in the UK

2001-07-31 Thread Declan Maher
Aidan, If you like you can purchase a copy of coldfusion server from us in Northern Ireland! BizNet Solutions 133-137 Lisburn Road Belfast, BT09 7AG Ireland + 44 (028) 90 223224 + 44 (028) 90 223223 [EMAIL PROTECTED] http://www.biznet-solutions.com -Original Message- From: Darren Adam

RE: cfmail

2001-07-31 Thread Chris Bohill
Make sure that you set the type of the CFMail to "HTML", then you can format the email any way you wish. Cheers, Chris -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: 31 July 2001 16:47 To: CF-Talk Subject: cfmail is there a way to put tags in the tag to make

SQL SERVER 7

2001-07-31 Thread Jerry Staple
Hi, Could anyone give me any feedback on the following: We have a SQL Server say for example "SQL1" based in Belfast, and another SQL Server "SQL2" Based in London. What i need to do is write a stored procedure from a database in "SQL1" "Table1" to insert data into "SQL2" "Table2",i have

  1   2   >