Re: Dynamic query woes

2002-05-28 Thread Mike Townend
try something like... Dim StartDate, EndDate StartDate = DateSerial(Request(s_year),Request(s_month),Request(s_day)) EndDate = DateSerial(Request(e_year),Request(e_month),Request(e_day)) qSearch = SELECT TypeOfEvent,EventText,ModifiedDateTime,ModifiedBy,ActionPerformed _ FROM tbl_auditlog _

http://address

2002-05-28 Thread John McCosker
Greetings, we have a dynamic site running off one directory structure, for multible customers, lets say, http//www.domain.com/allCustomersSeeThisDirName/.. some customers have now specified they would like http//www.domain.com/dirNameSpecificToThem/, is there a clean way to MASK this, while

RE: QuerySim custom tag and Fusebox 3

2002-05-28 Thread heirophant mm
Well, that's simple enough. Thanks, Alistair. I would never have seen that. And thanks everyone for their input. Date: Mon, 27 May 2002 11:24:49 +0100 From: Alistair Davidson [EMAIL PROTECTED] Subject: RE: QuerySim custom tag and Fusebox 3 Message-ID: [EMAIL PROTECTED] Hi guys The problem is

RE: http://address

2002-05-28 Thread John Beynon
If you have access to the server itself, you could create virtual directories with whatever dirNameSpecificToThem they want all pointing at the physical location of allCustomersSeeThisDirName, HTH, John. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 28 May

K2 Verity

2002-05-28 Thread Frank Mamone
Is it possible to index database content with K2 much like we do with the CF Verity? The documentation doesn't really go there. If yes, is there any advantages to using K2 for DB content? Thanks, Frank Mamone __ Your ad

RE: http://address

2002-05-28 Thread Carlisle, Eric
You can also set up a redirect at... http//www.domain.com/dirNameSpecificToThem/ so that the customer is pointed to... http//www.domain.com/allCustomersSeeThisDirName/.. -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 8:24 AM To: CF-Talk

RE: http://address

2002-05-28 Thread Carlisle, Eric
Once again, my fat fingers hit ctrl-enter in outlook... sending too early. If you use this method, they wont always see the dirNameSpecificToThem in the URL after the redirect... But it's enough for them to put in on a business card. I would handle similar cases by personalizing the page

RE: http://address

2002-05-28 Thread Carlisle, Eric
d'oh! *typo below* What I meant to say was... There would also be a generic view if end users entered the http//www.domain.com/allCustomersSeeThisDirName/ way. Eric -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 9:00 AM To: CF-Talk

RE: http://address

2002-05-28 Thread John McCosker
Thanks Eric, thanks John, we are currently experimenting with all of these options, respectfully, j -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 2:00 PM To: CF-Talk Subject: RE: http://address Once again, my fat fingers hit ctrl-enter

executing dts package...part 2

2002-05-28 Thread Steven Dworman
Well I have been able to fire off any dts package I want through my CF app. However, when it has to open the excel file to import data into a temp table the process fails. Reason being that it can't find the file. I have mapped the location where SQL server reads the excel file properly on the

RE: executing dts package...part 2

2002-05-28 Thread Carlisle, Eric
Any chance you can use a UNC path instead of drive mapping? -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 9:42 AM To: CF-Talk Subject: executing dts package...part 2 Well I have been able to fire off any dts package I want through my CF

Re: executing dts package...part 2

2002-05-28 Thread Kevin McCabe
Is the CF Services Logged in as a User that has rights to the share? I.E. In Windows NT/2K YOu can have the user login as a Local User who has access to the Drive Mapping - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 28,

RE: K2 Verity

2002-05-28 Thread Dave Watts
Is it possible to index database content with K2 much like we do with the CF Verity? The documentation doesn't really go there. If yes, is there any advantages to using K2 for DB content? You don't index content at all with K2, generally - you index with the VDK and search with K2. The

Re: K2 Verity

2002-05-28 Thread Jeff Garza
I haven't found a mechanism to index database content with K2 yet and while you can index documents with K2 I don't recommend it (unless using the spider to index a website...) . Use your standard tools to index your DB content (CFINDEX ) and then search it using K2. You'll get all the benefits

RE: executing dts package...part 2

2002-05-28 Thread Steven Dworman
no unc path allowed. that's why i had to map the drive. the issue is that sql server thinks the mapping is on the local machine, not on the server. i need to figure out a way around this, or to trick sql server. -Original Message- From: Kevin McCabe [mailto:[EMAIL PROTECTED]] Sent:

Re: K2 Verity

2002-05-28 Thread Frank Mamone
I must be misunderstanding this from Fig Leaf's presentation: Ó Determination of which mode to use: ColdFusion looks in the registry for the collection specified in the CFSEARCH tag. If it is found then a VDK search is used Collection names are written to the registry by calls to the

RE: executing dts package...part 2

2002-05-28 Thread Steven Dworman
nevermind...got it -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 10:37 AM To: CF-Talk Subject: RE: executing dts package...part 2 no unc path allowed. that's why i had to map the drive. the issue is that sql server thinks the mapping

Only Win32 CFHTTP broken (Linux/Solaris OK)?

2002-05-28 Thread Tony Schreiber
After wrestling with the Ebay API for a few days and getting some help from list-member Shawn, I discovered that while I couldn't make a call to eBay with CFHTTP (which requires two custom HTTP headers and my errors occured only when passing the required headers) on my Win2k machine, I could do

PaymenTech

2002-05-28 Thread Duane Boudreau
Is anyone here using PaymenTech for credit card authorization and merchant bank? If so, do they have a CF interface? Thx, Duane __ Your ad could be here. Monies from ads go to support these lists and provide more resources

RE: K2 Verity

2002-05-28 Thread Dave Watts
I must be misunderstanding this from Fig Leaf's presentation: Determination of which mode to use: ColdFusion looks in the registry for the collection specified in the CFSEARCH tag. If it is found then a VDK search is used Collection names are written to the registry by calls to the

CFML on WebLogic, WebSphere, etc.

2002-05-28 Thread Vince Bonfanti
New Atlanta is seeking participants for the private beta testing program for BlueDragon for J2EE servers. This edition of BlueDragon will allow you to: - Deploy CFML pages as part of a standard J2EE web application (.war) without installing any additional software on the J2EE server. -

RE: K2 Verity

2002-05-28 Thread Sean McCarthy
Add the collection to your k2server.ini (e:\CFusion\Verity\_nti40\bin) file. Example: [Coll-0] collPath=e:\cfusion\verity\collections\myCollection\file collAlias=myCollectionK2 topicSet= knowledgeBase= onLine=2 when you code your cfsearch use the name defined as the collAlias above check your

verity strategies: double post!!

2002-05-28 Thread Will Swain
Hi guys, Just a general query really. I am trying to build a search function to allow users to search a large site. The site uses dynamic content from a number of different db tables, and also static content on HTML pages. I have indexed all the HTML pages, and can run searches on these

Re: PaymenTech

2002-05-28 Thread Howie Hamlin
They don't have a CFX but they do have a Java implementation if you want it. We built our own CFX for Paymentech because we're Jave-illiterate g. It took about a week of development and testing to write the CFX (which then had to be certified with their gateway). We used some open-source

RE: verity strategies: double post!!

2002-05-28 Thread Robert Everland
I use the spider. I put the website with all the dynamic content on my server and do this C:\CFusion\Verity\_nti40\bin\vspider -common c:\cfusion\verity\common -collection C:\Inetpub\wwwroot\Newweb\verity -start http://localhost -indinclude * -cgiok -followdup Then I move the verity collection

Re: K2 Verity

2002-05-28 Thread Frank Mamone
I see. It checks the if the ColAlias exists in the registry. Thank you all! - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 10:49 AM Subject: RE: K2 Verity I must be misunderstanding this from Fig Leaf's presentation:

RE: Only Win32 CFHTTP broken (Linux/Solaris OK)?

2002-05-28 Thread Dave Watts
After wrestling with the Ebay API for a few days and getting some help from list-member Shawn, I discovered that while I couldn't make a call to eBay with CFHTTP (which requires two custom HTTP headers and my errors occured only when passing the required headers) on my Win2k machine, I

Verity Spider on MX

2002-05-28 Thread Frank Mamone
Has the field mapping problem with Verity Spider in CF 5.0 still exist in CFMX? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics.

RE: Verity Spider on MX

2002-05-28 Thread Dave Watts
Has the field mapping problem with Verity Spider in CF 5.0 still exist in CFMX? According to the MX documentation, no, that's been fixed. I haven't tested it myself, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444

populate a table

2002-05-28 Thread Robert Orlini
Hello, If a user selects a vendor from a drop-down list, I want to populate a form and main table called purchases with the info from the vendor data that I have in stored in another table called vendor. Here is some of the code that checks the option field in the drop-down menu. I get a

RE: populate a table

2002-05-28 Thread Margaret Fisk
You need to remove from selectedvendor from your query since you are performing an insert not a select. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 8:47 AM To: CF-Talk Subject: populate a table Hello, If a user selects a vendor from a

RE: populate a table

2002-05-28 Thread John Beynon
SQL Insert statements can't have a FROM clause in them...that could be an issue! -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 16:47 To: CF-Talk Subject: populate a table Hello, If a user selects a vendor from a drop-down list, I want

RE: populate a table

2002-05-28 Thread Philip Arnold - ASP
If a user selects a vendor from a drop-down list, I want to populate a form and main table called purchases with the info from the vendor data that I have in stored in another table called vendor. Here is some of the code that checks the option field in the drop-down menu. I get a syntax

CFFILE Upload Parameter

2002-05-28 Thread samuel . l . george
What would be the 'accept' (mime_type/file_type) parameter for CFFILE Upload? application/msexcel does not work. TIA, Sam __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and

RE: populate a table

2002-05-28 Thread Philip Arnold - ASP
SQL Insert statements can't have a FROM clause in them...that could be an issue! They can if you do INSERT INTO table (fields) SELECT fields FROM otherTable WHERE field=value Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680

RE: populate a table

2002-05-28 Thread Ronald West
Actually John, an insert statement can have a FROM clause. I believe that Robert might have been confused on the syntax, but if he wanted to say pass an Id for a chosen Vendor he could have performed the following: CFIF selectvendor is not New Vendor cfquery name=addvendor datasource=purchases

RE: populate a table

2002-05-28 Thread John Beynon
Yeah, I was just going by his original question which looked like a single INSERT statement to me, not with a nested SELECT. Useful recap though -Original Message- From: Ronald West [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 17:08 To: CF-Talk Subject: RE: populate a table

CFEXECUTE

2002-05-28 Thread phumes1
Hi, Is there a way to display the output from the cfexecute while the program is running to another window? My program can take over a minute to run and I want the operator to see whats happening in the log file. Is there a way to incorporate a Working.. completion bar? Similar to installing

Download an Image

2002-05-28 Thread Troy Simpson
I want to grab an image which is located on a backend server and send it to the client browser. In this case, I can not simple send an img src= alt= border=0 tag in an html page (for reasons I can't get into and you probably do not want to hear about it anyway). In this case, I'm using cfhttp

RE: CFEXECUTE

2002-05-28 Thread Philip Arnold - ASP
Is there a way to display the output from the cfexecute while the program is running to another window? My program can take over a minute to run and I want the operator to see whats happening in the log file. Is there a way to incorporate a Working.. completion bar? Similar to installing

RE: CFEXECUTE

2002-05-28 Thread phumes1
At 05:27 PM 5/28/2002 +0100, you wrote: Is there a way to display the output from the cfexecute while the program is running to another window? My program can take over a minute to run and I want the operator to see whats happening in the log file. Is there a way to incorporate a

CFMAIL Outloook SentItems Folder

2002-05-28 Thread Rollo, Jeff
Our web server is IIS 4, and our mail server is exchange 5.5 with MS Outlook and this only concerns an intranet environment. We have an appl. where mail can be sent by employees using CFMAIL. I was wondering if anyone knew of a way that mail sent using the CFMAIL tag could show in

Re: CFMAIL Outloook SentItems Folder

2002-05-28 Thread todd
Unless you're using a 3rd party cfx/mail tag (to hook into the exchange server) to do that for you the basic CFMAIL tag can't do this. ~Todd On Tue, 28 May 2002, Rollo, Jeff wrote: Our web server is IIS 4, and our mail server is exchange 5.5 with MS Outlook and this only concerns an

RE: CFEXECUTE

2002-05-28 Thread Ben Arledge
If only IE is required, you could use an IFRAME. This way you could have CFFLUSH on its own page and still keep your site design intact. Cheers, Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: May 28, 2002 10:41 AM To: CF-Talk Subject: RE: CFEXECUTE

RE: CFMAIL Outloook SentItems Folder

2002-05-28 Thread Dave Watts
Our web server is IIS 4, and our mail server is exchange 5.5 with MS Outlook and this only concerns an intranet environment. We have an appl. where mail can be sent by employees using CFMAIL. I was wondering if anyone knew of a way that mail sent using the CFMAIL tag could show

RE: CFEXECUTE

2002-05-28 Thread Dave Watts
Is there a way to display the output from the cfexecute while the program is running to another window? My program can take over a minute to run and I want the operator to see whats happening in the log file. Is there a way to incorporate a Working.. completion bar? Similar to

RE: Download an Image

2002-05-28 Thread Dave Watts
I want to grab an image which is located on a backend server and send it to the client browser. In this case, I can not simple send an img src= alt= border=0 tag in an html page (for reasons I can't get into and you probably do not want to hear about it anyway). In this case, I'm

Easiest way to get horoscopes on my site?

2002-05-28 Thread Jon Block
My users want horoscopes. Are the any prepackaged horoscope grabbers that anybody is aware of? Thanks, Jon __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community.

RE: CFEXECUTE

2002-05-28 Thread Andre Turrettini
It all really depends what youre doing with this 1 minute page. if youre doing something in your db that you can query, then you can do so in a repeating manner and display the results each repeat. However, if its just a long query, then you cant do much other than check the indexes and try to

Re: Download an Image

2002-05-28 Thread Troy Simpson
Philip, Sorry, that was by design. ;-) I altered the host name and URL because the actual systems are not accessible by the public. Next time I'll use a more truly fictitious host name and URL. Sorry about that. Troy Philip Arnold - ASP wrote: Not Found The requested URL

RE: CFEXECUTE

2002-05-28 Thread Dave Watts
There's a drawback with CFFLUSH tho. You can't wrap any custom tags around it and ... the footer of the page will not show up until the whole page has been flushed. Well, that's hardly a drawback with CFFLUSH. If the footer is at the bottom of the page, why would anyone expect it to appear

RE: Download an Image

2002-05-28 Thread Philip Arnold - ASP
Sorry, that was by design. ;-) I altered the host name and URL because the actual systems are not accessible by the public. Next time I'll use a more truly fictitious host name and URL. Sorry about that. That's OK, if you had used www.mydomain.com then I wouldn't have tried, but it looked

RE: CFEXECUTE

2002-05-28 Thread Philip Arnold - ASP
Well, that's hardly a drawback with CFFLUSH. If the footer is at the bottom of the page, why would anyone expect it to appear until the entire page has been sent to the browser? You can, however, work around this with judicious use of JavaScript, if that's an acceptable alternative. We have

RE: CFEXECUTE

2002-05-28 Thread todd
Javascript that has to work on Mac / PCs and about 200 (+1, Netscape 7pr1 was released) browsers. That's a nightmare in on itself, but yes, you're right. I'm not bashing you Dave - yes, there are workarounds, but it's not worth it. Now that I think about it, having a hidden frame would work

Scheduled Tasks

2002-05-28 Thread Brad Roberts
When I schedule a task to run weekly or monthly, it reverts back to daily. Is there a fix for this? I couldn't find one on MM's site. -Brad __ This list and all House of Fusion resources hosted by CFHosting.com. The place for

Re: Download an Image

2002-05-28 Thread Troy Simpson
All, I also wanted to add that when I telnet to port 80 on the system here is what I get back: Begin - telnet host.ncsu.edu 80 Trying 1.1.1.1... Connected to host.ncsu.edu. Escape character is '^]'. HEAD

CFPOP question

2002-05-28 Thread Aimee Abbott
Hello all, I have a forecast email that comes out a couple of times a day. I need to extract the numbers and discussion from it and post the information into a database. I am using CFPOP to get the email from the server, I need to know how do get just the information I want from it. So in the

generate multiple PDFs automatically

2002-05-28 Thread Dimo Michailov
Hello all: Here's the situation I am facing: We have a huge recordset - maybe around 5000-6000 records that we would like to use to create PDF reports on the fly and print. I am using FDFs to create a single PDF report from this dataset, but this would be extremely slow and painful to have a

RE: Download an Image

2002-05-28 Thread Philip Arnold - ASP
Do you only have HTTP access to the other server, or does it have a Share to the images? If you can share to it, then CFCONTENT the file via a UNC across the network Otherwise, you'll have to do what Dave said - store the file locally, then CFCONTENT that Philip Arnold Technical Director

Populating the body of an outlook message

2002-05-28 Thread douglas . kronenberger
Is it possible to pass a string to the body of an outlook e-mail message launched though the mailto: or some other message. Doug Kronenberger OI National Training and Education Office Department of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED]

OT: Adding Properties to Form elements?

2002-05-28 Thread Shawn Grover
I once came across an article that explained how to use your own properties within a form field for form validation. Something like this: input name=MyText type=text MyProperty= I know the HTML parsers would ignore the MyProperty in the above tag, and this article I saw detailed how to

RE: help! CFLOCATION and mystery output of HTTP header

2002-05-28 Thread Marlon Moyer
Thanks for this tip Dave, I didn't even know tools like this were around. Sometimes it really pays to lurk :) Marlon At 05:54 PM 5/27/2002 -0400, you wrote: Is it worth tracking down some info on HTTP headers and how CFLOCATION might be getting this wrong? This is a perfect example of

RE: Populating the body of an outlook message

2002-05-28 Thread Will Swain
try looking at http://developer.netscape.com/viewsource/husted_mailto/mailto.html seems to cover what you need. will -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 18:45 To: CF-Talk Subject: Populating the body of an outlook message Is it

RE: Populating the body of an outlook message

2002-05-28 Thread LANCASTER, STEVEN M. (JSC-OL) (BAR)
Is CFMAIL not an option. If it is you can do whatever you want through CFMAIL.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 12:45 PM To: CF-Talk Subject: Populating the body of an outlook message Is it possible to pass a string to

OT: Adding Properties to Form elements?

2002-05-28 Thread Shawn Grover
I once came across an article that explained how to use your own properties within a form field for form validation. Something like this: input name=MyText type=text MyProperty= I know the HTML parsers would ignore the MyProperty in the above tag, and this article I saw detailed how to

Re: Scheduled Tasks

2002-05-28 Thread Jim McAtee
- Original Message - From: Brad Roberts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 11:18 AM Subject: Scheduled Tasks When I schedule a task to run weekly or monthly, it reverts back to daily. Is there a fix for this? I couldn't find one on MM's site.

Re: Download an Image

2002-05-28 Thread Troy Simpson
I believe I have run into another snag. When I use cfhttp url=http://www.mydomain.com/design/slides/0202/10780.jpg; method=GET resolveurl=false/cfhttp to get the image, it appears that #cfhttp.FileContent# does not contain the binary of the image file. Instead, it is a text string. In the

Re: Dynamic query woes

2002-05-28 Thread Dina Hess
dave, i would re-write that section of ASP code to correct both the sql string and the startdate, enddate format as follows: % Dim StartDate, EndDate StartDate = Request(s_month) / Request(s_day) / Request(s_year) EndDate = Request(e_month) / Request(e_day) / Request(e_year)

RE: Populating the body of an outlook message

2002-05-28 Thread Costas Piliotis
Yup. Url parameters for the mailto tag. mailto:[EMAIL PROTECTED]?subject=123body=456 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 10:45 AM To: CF-Talk Subject: Populating the body of an outlook message Is it possible to pass a

Re: generate multiple PDFs automatically

2002-05-28 Thread Randell B Adkins
Could use a LOOP to generate them however that is alot to handle. Another note is that I am not sure there is a way to FORCE the print. You can force the print dialog box but not the actual print that I am aware of. Randy Adkins [EMAIL PROTECTED] 05/28/02 13:37 PM Hello all: Here's the

Open XLS outside IE...

2002-05-28 Thread Dave Carabetta
Is it possible to open an XLS file with the standalone Excel program, rather than the embedded Excel when using IE? If that is not completely clear, this is the scenario: Currently, when an XLS file is viewed, IE spawns an Excel instance within the browser (if not technically correct, I think

RE: CFEXECUTE

2002-05-28 Thread Dave Watts
Let me give an example here so people know I'm not talking out my butt. I went through extensive research to figure this all out and then scrapped [CFFLUSH] because it didn't work the way everyone thinks it does. While I'm not accusing you of talking out your butt, since you're not Jim

RE: Easiest way to get horoscopes on my site?

2002-05-28 Thread Erika L Walker-Arnold
http://www.google.co.uk/search?hl=enie=UTF8oe=UTF8q=horoscope+feedsb tnG=Google+Searchmeta= Erika | -Original Message- | From: Jon Block [mailto:[EMAIL PROTECTED]] | Sent: 28 May 2002 18:00 | To: CF-Talk | Subject: Easiest

FW: Repost: CFFTP 500 Invalid PORT Command.

2002-05-28 Thread Thanh Nguyen
My setting are very basic. The Web server is IIS on Win2k The FTP server is the built-in FTP Server of IIS. I keep all the default settings. (didn't change anything). I was able to connect to the server but when trying to list all files/directories, I got that error. any advice? thanks

Re: CFMAIL Outloook SentItems Folder

2002-05-28 Thread Lewis Sellers
On Tue, 28 May 2002 12:44:25 -0400, in cf-talk you wrote: Our web server is IIS 4, and our mail server is exchange 5.5 with MS Outlook and this only concerns an intranet environment. We have an appl. where mail can be sent by employees using CFMAIL. I was wondering if anyone knew of a

Re: CFMAIL Outloook SentItems Folder

2002-05-28 Thread Lewis Sellers
On Tue, 28 May 2002 12:44:25 -0400, in cf-talk you wrote: Our web server is IIS 4, and our mail server is exchange 5.5 with MS Outlook and this only concerns an intranet environment. We have an appl. where mail can be sent by employees using CFMAIL. I was wondering if anyone knew of a

Query question

2002-05-28 Thread Trace
Is there a way to refer to 2 fields in one query with the same name? I have a field called title in table tbl_Pages and a field called Name in table tbl_Categories cfquery name=getHyperlinks datasource=#ds# SELECTtbl_Pages.title AS hyperlink_title, tbl_Categories.Name AS hyperlink_title

ORDER BY question

2002-05-28 Thread Paul Ihrig
ok. ASC DESC don't work on this one. i want to be able to ORDER BY in a specific order such as ORDER BY tblJobTitle.TitleID='25,26,28,4' is that possible? if not how else could i do it... !--- tblJobTitle.TitleID Partner=25 Principal=26 Senior Associate=28 Associate=4 --- Thanks -paul

Killing a cached query

2002-05-28 Thread Burcham, Steve
What is the best way to 'kill' a cached query on a logout sequence? Thank you. Steve Burcham Webmaster - Field Support Team RDO Equipment Co. Phone (701) 239-8755 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] __ Signup for

RE: ORDER BY question

2002-05-28 Thread Paul Ihrig
ok. ASC DESC don't work on this one. i want to be able to ORDER BY in a specific order such as ORDER BY tblJobTitle.TitleID='25,26,28,4' is that possible? if not how else could i do it... !--- tblJobTitle.TitleID Partner=25 Principal=26 Senior Associate=28 Associate=4 --- Thanks -paul

Query question

2002-05-28 Thread Trace
Is there a way to refer to 2 fields in one query with the same name? I have a field called title in table tbl_Pages and a field called Name in table tbl_Categories cfquery name=getHyperlinks datasource=#ds# SELECTtbl_Pages.title AS hyperlink_title,

RE: Download an Image

2002-05-28 Thread Dave Watts
I believe I have run into another snag. When I use cfhttp url=http://www.mydomain.com/design/slides/0202/10780.jpg; method=GET resolveurl=false/cfhttp to get the image, it appears that #cfhttp.FileContent# does not contain the binary of the image file. Instead, it is a text string.

Re: ORDER BY question

2002-05-28 Thread Randell B Adkins
Create a new field called Sequence or something. Based on the data and the two elements you displayed there is no way without Hard-Coding it. Randy Adkins [EMAIL PROTECTED] 05/28/02 15:39 PM ok. ASC DESC don't work on this one. i want to be able to ORDER BY in a specific order such as

RE: Populating the body of an outlook message

2002-05-28 Thread Matthew R. Small
Yes, try this: a href=mailto:[EMAIL PROTECTED]?subject=Hey therebody=Hello, long time no seeClick here/a You can pass the subject and body of a message through URL parameters. - Matt Small -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28,

OT: Adding Properties to Form elements?

2002-05-28 Thread Shawn Grover
I once came across an article that explained how to use your own properties within a form field for form validation. Something like this: input name=MyText type=text MyProperty= I know the HTML parsers would ignore the MyProperty in the above tag, and this article I saw detailed how to

Appologies

2002-05-28 Thread Shawn Grover
My appologies for my recent barage of the same question (OT: Adding Properties to Form elements?). The list sent me messages saying (1) it was too big, and (2) I had a signature block that appeared I was going on vacation. I didn't think the message made it through. Shawn Grover

RE: generate multiple PDFs automatically

2002-05-28 Thread Matthew R. Small
It sounds like you need activepdf at http://www.activepdf.com. If you just need printed reports, use COM and Word. It's a lot cheaper. http://www.cfcomet.com - Matt Small -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 2:05 PM To:

RE: Query question

2002-05-28 Thread Cantrell, Adam
You need to use a union join. Adam. -Original Message- From: Trace [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 2:36 PM To: CF-Talk Subject: Query question Is there a way to refer to 2 fields in one query with the same name? I have a field called title in table

Re: Query question

2002-05-28 Thread Jerry Johnson
What are you trying to get? 1. a query with all the titles from pages added to all the names from categories? 2. a single field that concatenates the title and the name together? 3. something I'm not seeing? Jerry Johnson [EMAIL PROTECTED] 05/28/02 02:53PM Is there a way to refer to 2

RE: Query question

2002-05-28 Thread Dave Watts
Is there a way to refer to 2 fields in one query with the same name? I have a field called title in table tbl_Pages and a field called Name in table tbl_Categories cfquery name=getHyperlinks datasource=#ds# SELECTtbl_Pages.title AS hyperlink_title,

RE: Apologies

2002-05-28 Thread Dave Watts
My apologies for my recent barage of the same question (OT: Adding Properties to Form elements?). The list sent me messages saying (1) it was too big, and (2) I had a signature block that appeared I was going on vacation. I didn't think the message made it through. I just got the same

RE: Query question

2002-05-28 Thread Cornillon, Matthieu
Trace, What exactly is your intent? It seems that you want to create a list of all the hyperlink_title values, whether they appear in tbl_Pages or tbl_Categories. Is that right? In other words, if you have tbl_Pages: tbl_Pages_pk hyperlink_title 1 A 2 B 3

spawning new windows

2002-05-28 Thread Cornillon, Matthieu
Hi, everyone. I have a challenge for you. I want to spawn a new (2nd) browser window, but I don't want it to use JavaScript. And I want to do it from any page on a site, so I want to put a test in Application.cfm that initiates the process. More specifically: User loads page on site.

Dynamically Processing Form Values

2002-05-28 Thread Jason Miller
Hello all. New to the list - Hope someone can help me. Of course time is somewhat urgent on this. I have a lengthy form page. It is created through 5 cfqueries for eachmain subject. The entire page is a form. I have javascript arrays that populate a summary area on the fly when someone enteres

RE: Adding Properties to Form elements?

2002-05-28 Thread SPANGLER ALAN L. (dal1als)
Try MyText.MyProperty.value -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 2:47 PM To: CF-Talk Subject: OT: Adding Properties to Form elements? I once came across an article that explained how to use your own properties within a form

Re: generate multiple PDFs automatically

2002-05-28 Thread Jason Miller
check cfcomet.com - I just saw a tidbit in there on creating pdf's on the fly.. I think there are less than a dozem posts in the PDF section - so it should be easy to find. I am 100% I saw it there. Jay Miller Randell B Adkins wrote: Could use a LOOP to generate them however that is alot to

Re: Query question

2002-05-28 Thread Trace
It was for concatenating the 2 fields into one. But Dave answered my question. Thank you, Trace - Original Message - From: Jerry Johnson To: CF-Talk Sent: Tuesday, May 28, 2002 1:04 PM Subject: Re: Query question What are you trying to get? 1. a query with all the titles from pages

RE: Apologies

2002-05-28 Thread LANCASTER, STEVEN M. (JSC-OL) (BAR)
I am having the same problem.. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 3:03 PM To: CF-Talk Subject: RE: Apologies My apologies for my recent barage of the same question (OT: Adding Properties to Form elements?). The list sent me

Re: spawning new windows

2002-05-28 Thread Jason Miller
just use target=_blank in a cflocation or a meta rfresh tag. If you don't use java however - it may be a bit difficult instructing the size or parameters of the window.. but if that doesn't matter - the above should work. hoep this helps jay miller Cornillon, Matthieu wrote: Hi, everyone.

RE: spawning new windows

2002-05-28 Thread Dave Watts
Hi, everyone. I have a challenge for you. I want to spawn a new (2nd) browser window, but I don't want it to use JavaScript. This can't be done. If you want to programmatically open a new window, that'll require JavaScript (or something even more complex, like ActiveX) - you can't do it

  1   2   >