Re: .NET co-Exist with CF Server

2002-02-25 Thread Jon Hall
I've installed the SDK and VS.net on my personal machines, which run Win2k server/ CF5/ SQL 2000 and had no problems. I can't think of a reason why dotNet would conflict with CF in any way. VS.net does change some IIS settings, but VS wont be on a production server anyway so that shouldn't be

RE: .NET co-Exist with CF Server

2002-02-25 Thread Paul Wille
Jason, The only thing I can say is regarding MDAC 2.7. Take a link below: http://www.8wire.com/articles/?AID=2318 MDAC 2.7 has a pretty serious bug in its ADO libraries that apparently tends to chunk up many of your CPU cycles. As a co-manager of a development production environment, we are

Expression results? Experts ?

2002-02-25 Thread Ian Vaughan
Hi I am getting the following error when trying to add a record to my database via coldfusion, anyone on the list have any ideas ? Error Occurred While Processing Request Error Diagnostic Information Expression result cannot be converted to a string Expressions used inside

RE: Expression results? Experts ?

2002-02-25 Thread Kevan . Windle
You might want ot check the value you have in url. It could be that CF thinks it's the structure that holds url variables. Try changing the name fo the variable or using the scope specifier as in variables.url. -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 25

Trim Problem

2002-02-25 Thread Jason Davis
I'm using #Trim(value)# or #LTrim(RTrim(value))# And in both, some characters from the side are being corrupted. This are Hebrew letters. Using CF 5.0, any known bugs? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM /

Re: Trim Problem

2002-02-25 Thread Zac Spitzer
Jason Davis wrote: I'm using #Trim(value)# or #LTrim(RTrim(value))# And in both, some characters from the side are being corrupted. This are Hebrew letters. Using CF 5.0, any known bugs? yep theres a hotfix for this bug __ Why

javascript question

2002-02-25 Thread John McCosker
Greetings, I'm confused over this, its strange. I have two dynamic select boxes populated server side by coldfusion. Both are initially populated the same, i.e. times of each record published in descending order. Also I build an array of these times The first select box acts as a filter, so

Re: Trim Problem

2002-02-25 Thread Stephen Moretti
I'm using #Trim(value)# or #LTrim(RTrim(value))# And in both, some characters from the side are being corrupted. This are Hebrew letters. Using CF 5.0, any known bugs? yep theres a hotfix for this bug http://www.macromedia.com/v1/Handlers/index.cfm?ID=22434Method=Full ;o)

Data Merge to word from coldfusion

2002-02-25 Thread Carlo
Hi I curently have data that I output to a word file. My requirement is to loop through a query and output each result in the wordfile. How would one go about doing that? My current code is included below, and all I have in the RTF word file is placeholders between % signs that coldfusion

help:opening a excel file on web but read only to user

2002-02-25 Thread han peng
hihi... making help calls to all gurus/ expert out there... to open a EXCEL file in web... window.location='test.xls' how i can let a user to open a excel file to view the content but disable them from editing..? currently.. I'm using fusebox.. and including all files in the index.cfm..

session without cookies - why/how does this work?

2002-02-25 Thread Bimal Shah
Hello I have an Application.cfm page with the following: cfapplication name=sessiontest sessionmanagement=Yes setclientcookies=No And two cf pages: page1.cfm cfset session.name = tom.smith page2.cfm cfoutput#session.name#/cfoutput In the browser, I type in http://mywebserver/page1.cfm and

Re: Experts Only! - Summarizing Results

2002-02-25 Thread Jochem van Dieten
Jason Davis wrote: I'm running a full text search on my Product table using MSSearch service. Query looks something like this: SELECT Product_title,Product_description FROM Products WHERE CONTAINS (*,'#Query_filtered#') Where Query_filtered is something similiar to

Re: session without cookies - why/how does this work?

2002-02-25 Thread Jochem van Dieten
Bimal Shah wrote: Why/how does this work when I have set setclientcookies to No and I am not passing CFID,CFTOKEN (since I am typing in the URLS directly - no url or form variables being sent)? Setting setclientcookies to No only means they are not set again. If they have been set before,

RE: session without cookies - why/how does this work?

2002-02-25 Thread Mark Smyth
Hi Probably you've set setclientcookies to yes previously, and they are still being used. setclientcookies does not tell CF not to use cookies if they exist, simply not to set them. Put this code into your application cfm to kill the cookies when you close the browser and then try the same

RE: joining arrays

2002-02-25 Thread Raymond Camden
ArrayConcat at cflib.org will do this: http://www.cflib.org/udf.cfm?ID=265 === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a

Re: Simple Message Board

2002-02-25 Thread Tony Schreiber
The base version is non-fused. I'm sending you the current release now. There was a non-fused version of SMB running around...can whoever told me about that let me know the whereabouts? I cannot locate my copy. Thanks. Regards, Eric J. Hoffman Director of Internet Development

Fw: CFHTTP...

2002-02-25 Thread Neil H.
I never received a response to this message. Does anyone know about CFHTTP behavior on a machine with multiple IPs? Thank you, Neil - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 3:16 PM Subject: CFHTTP... I want

Re: help:opening a excel file on web but read only to user

2002-02-25 Thread Richard Meredith-Hardy
I think you will have to make the excel file itself read only rather than any setting you can make in the way it is served up. han peng wrote: hihi... making help calls to all gurus/ expert out there... to open a EXCEL file in web... window.location='test.xls' how i can let a user

Pulling Files from Database

2002-02-25 Thread Watson, Nicholas
I'm building a ColdFusion front end for a application that was written in another language. All of the content, and the HTML for formatting that content (mostly bolds, italics, line breaks) is stored in a SQL 2000 database in an image field as an HTML file. Any ideas on how I can pull this

RE: session without cookies - why/how does this work?

2002-02-25 Thread Lewis Steven
I think that when you set SETCLIENTCOOKIES=NO that tells the appserver not to set CFID and CFTOKEN to persistent cookies, otherwise they are still being passed but just as non-persistent cookies. -Original Message- From: Bimal Shah [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25,

RE: OLEDB Error Code = 18456

2002-02-25 Thread Dave Carabetta
I am using OLEDB data connections SQL 2000 SP2 - CF 5 (no service packs) Win 2K Sp 2. I have just recently started getting a string of odd data connection errors OLEDB Error Code = 18456 Login failed for user 'sa' (userame is not relevant have tried different users - defaulted back to SA to see

Locale functions and IE6

2002-02-25 Thread Tristram Charnley
I can't get the LSCurrencyFormat function to work correctly in IE6 - I want to display GBP but it will only show dollars. The same function works fine in IE5+. Has anyone else encountered problems with this or other locale specific functions in IE6? If so are there any workarounds? For that

Re: Joining Tables from Different Datasources... Possible?

2002-02-25 Thread Jamie Jackson
Thanks for the replies. What I am doing is attempting to join a Verity result set on a SQL server table. The table contains abstracts, display codes, titles etc., of PDF's that Verity has also indexed. Currently, to get a match, I'm using nested loops to determine matches, and I modify the

RE: .NET co-Exist with CF Server

2002-02-25 Thread Jason Miller
Great article I will have to see if this has been fixed yet. Thanks -Original Message- From: Paul Wille [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002 12:29 AM To: CF-Talk Subject: RE: .NET co-Exist with CF Server Jason, The only thing I can say is regarding MDAC 2.7.

including external files

2002-02-25 Thread Smith, Daron [PA]
Is there any way to include external files using cfinclude? I have a content editor on an internal server, and I want to be able to view the finished product as it would appear on the external web server. Rather than constantly synchronizing both servers, I would like to just use cfinclude.

RE: .NET co-Exist with CF Server

2002-02-25 Thread Paul Wille
Jason, I looked around a bit myself. I could not find anything regarding a fix for this. If you run across anything, please post it to this discussion. Thank you, --Paul Paul W. Wille [EMAIL PROTECTED] - Certified Advanced ColdFusion 5 Developer

RE: Newbie Question

2002-02-25 Thread jon
If you've got PHP on the server, you should pick up PHPmyAdmin, an excellent front end to MySQL. Makes DB creation/maintenance a snap... -- jon -Original Message- From: Jeffrey Cohen [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 10:37 PM To: CF-Talk Subject: Re:

RE: Joining Tables from Different Datasources... Possible?

2002-02-25 Thread Kevan . Windle
Just a thought, but if you use MS Indexing instead of Verity, along with other advantages (it's faster and self-maintaining)you can build sql statements combining db tables and file indexes. -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED]] Sent: 25 February 2002 15:19

RE: Joining Tables from Different Datasources... Possible?

2002-02-25 Thread Jim Curran
Try Query of Queries. - j cfsearch collection=myCollection name=SearchQuery criteria=foo cfquery name=newResult dbtype=query Select * from SearchQuery Where blah like '%blah%' /cfquery -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002

RE: .NET co-Exist with CF Server

2002-02-25 Thread Dave Watts
I am wondering if anyone else has installed the new .NET architecture (which will be part of the Whistler server aka Windows server .NET or 2002). I am curious if there have been any issue with this coexisting with a implementation of CF Server 5.0. There is also an MDAC 2.7 out which

RE: session without cookies - why/how does this work?

2002-02-25 Thread Dave Watts
I think that when you set SETCLIENTCOOKIES=NO that tells the appserver not to set CFID and CFTOKEN to persistent cookies, otherwise they are still being passed but just as non-persistent cookies. No, I'm pretty sure that when you use SETCLIENTCOOKIES=NO in CFAPPLICATION, no cookies are

Re: Joining Tables from Different Datasources... Possible?

2002-02-25 Thread Jamie Jackson
if you use MS Indexing instead of Verity You can't index binaries (PDFs) though, can you? Thanks, Jamie On Mon, 25 Feb 2002 15:51:29 -, in cf-talk you wrote: Just a thought, but if you use MS Indexing instead of Verity, along with other advantages (it's faster and self-maintaining)you can

Re: Joining Tables from Different Datasources... Possible?

2002-02-25 Thread Jamie Jackson
I don't see how this ties in the DB table :-/ Thanks, Jamie On Mon, 25 Feb 2002 10:58:59 -0500, in cf-talk you wrote: Try Query of Queries. - j cfsearch collection=myCollection name=SearchQuery criteria=foo cfquery name=newResult dbtype=query Select * from SearchQuery Where blah like

Slightly OT: Search Engine statistics?

2002-02-25 Thread Ian Lurie
Hi all, I'm building a CF-based marketing support application. One feature I'm considering is the ability to provide the customer with search engine position, plus the top 500 keyword searches in their industry (not just for them). For search engine positioning: Has anyone done this with

Form?

2002-02-25 Thread Douglas Brown
Is there a way to check a form to see if any fields were left without having to check each one independently? Success is a journey, not a destination!! Doug Brown __ Get Your Own Dedicated Windows 2000 Server PIII 800

Re: Joining Tables from Different Datasources... Possible?

2002-02-25 Thread Jamie Jackson
Hmm, thanks. I'll check that out. Jamie On Mon, 25 Feb 2002 17:25:07 -, in cf-talk you wrote: I've not done it but according to the MS site there is a filter available from Adobe that allows you to do it. http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/pro dte chn

Re: Form?

2002-02-25 Thread Gyrus
Is there a way to check a form to see if any fields were left without having to check each one independently? Loop through the Form scope as a structure? cfset blankField=FALSE cfloop collection=#Form# item=field cfif field EQ cfset blankField=TRUE /cfif /cfloop (Not tested!)

Re: Form?

2002-02-25 Thread Dave Hannum
Have you used CFFORM? Builds cross browser validating JS on the fly. Gr eat tool! Dave - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 25, 2002 1:03 PM Subject: Form? Is there a way to check a form to see if any fields

Re: Form?

2002-02-25 Thread Pete Ruckelshaus
Something sort of like this? cfif isDefined(form.FIELDNAMES) cfloop collection=#form# item=i cfif #i# IS #i# is blank/cfif /cfloop cfabort cfelse cfloop collection=#url# item=i cfif #i# IS #i# is blank/cfif /cfloop cfabort /cfif Pete - Original Message - From: Douglas Brown

Re: Form?

2002-02-25 Thread Jamie Jackson
Something like this: cfloop index=i list=#form.fieldnames# cfif NOT LEN(#evaluate('form.' i)#) Form.#i# is a NULL string. cfbreak /cfif /cfloop On Mon, 25 Feb 2002 10:03:00 -0800, in cf-talk you wrote: Is there a way to check a form to see if any fields were left without having to

CFPOP and html stripping

2002-02-25 Thread Mark A. Kruger - CFG
Folks, Can anyone verify that CFPOP on 4.5 strips out all html tags in the body of a message? I have a friend who's trying to let an editor email a mass mail message to his CF server - which then forwards it to the appropriate groups. But the email message is supposed to be html, and it appears

RE: Documentation - Application Documentation

2002-02-25 Thread Trey Rouse
My question, or really concern is building application documentation to accompany delivery of a project. Code documentation is very straight forward. Currently, I'm trying to build some samples to use as a model for our ongoing and future development. The IEEE standard is cumbersome to say th e

RE: cfserver 4.5.2 unable to fufill request

2002-02-25 Thread Trey Rouse
This was common behavior on our machines running Orrielly's Website. Abandoning that product and using IIS and Apache stopped the behavior. We also could not stop and start the web server service when this happene d. We did find that sometimes restarting the web service, then the CF servic es

Re: Joining Tables from Different Datasources... Possible?

2002-02-25 Thread Jamie Jackson
Will do. Thanks very much, Jamie On Mon, 25 Feb 2002 13:05:36 -0500, in cf-talk you wrote: Oops, missed that: Try this: cfsearch collection=MyCollection name=SearchQuery criteria=foo cfquery name=MyTable datasource=myDB dbtype=ODBC Select * from MyTable /cfquery cfquery name=newResult

Structure ordering

2002-02-25 Thread Neil Clark
I am sure I have done this before, but I simply can't remember I have a structures which is a basic Key = Value pairs setup which tends to follow the pattern of : objectid1, objectid2, objectid3 etc... however, in some instances I have more than 10 Objects in a structure and they NEED to

RE: Structure ordering

2002-02-25 Thread Raymond Camden
Your saying you want the keys ordered in a struct? Sorry, but it doesn't happen that way. Keys in a struct are not meant to be a particular order. They are just meant to be... there. That is a bad way of saying that you are probably not using structures correctly. If you intention is to have all

Re: Experts Only! - Summarizing Results

2002-02-25 Thread Jason Davis
Jochem, Thanks for the code, there are still problems though: 1. I need the summary to be no more then 2-3 sentences, currently there is no upper limit for the output summary, as your code stopps when he finds all words. 2. I'm receiving a Bad regular expression error on this line: temp =

access query?

2002-02-25 Thread Douglas Brown
I have not messes with access before, and I am getting the following error. ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. Here is my query CFQUERY DATASOURCE=iec NAME=insert_classes INSERT INTO

RE: Structure ordering

2002-02-25 Thread Dave Watts
I have a structures which is a basic Key = Value pairs setup which tends to follow the pattern of : objectid1, objectid2, objectid3 etc... however, in some instances I have more than 10 Objects in a structure and they NEED to be in the correct order within the structure. When it is

MS SQL Server / Managing in Access

2002-02-25 Thread Paul Giesenhagen
I have heard that MS Access 2000 has the ability to act as the Enterprise manager within MS SQL Server .. (or at least something close). I have tried to find information in the help, but can't .. could someone explain how to go about accessing my SQL Server remotely through MS Access I need to

RE: MS SQL Server / Managing in Access

2002-02-25 Thread Dave Watts
I have heard that MS Access 2000 has the ability to act as the Enterprise manager within MS SQL Server .. (or at least something close). I have tried to find information in the help, but can't .. could someone explain how to go about accessing my SQL Server remotely through MS Access

Re: access query?

2002-02-25 Thread Jamie Jackson
Take out the parenthesized data types. Jamie On Mon, 25 Feb 2002 11:03:48 -0800, in cf-talk you wrote: I have not messes with access before, and I am getting the following error. ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in

Re: MS SQL Server / Managing in Access

2002-02-25 Thread Jon Hall
Yeah it's actually pretty cool. You need MDAC 2.6 and sp1 I believe for Access 2000 to connect to a SQL Server. Access 2002 is ready to go out of the box. Just create a new project and type in the name or ip of the sql server, and login. jon - Original Message - From: Paul Giesenhagen

Re: Structure ordering

2002-02-25 Thread Neil Clark
Thanks Ray / Dave, First off - I am not *asking* them to be ordered, I am asking them to be in the order that I place them into the structure, with what you are stating Ray : this is how structures should behave yes? But CF is taking my inserted keys and then changing the order I have placed

Re: Structure ordering

2002-02-25 Thread Neil Clark
Dave, As with the previous mail, a correct order in a structure I would say should be as you insert them, but I think the ability to order a structure should be in CF (as it would save me time! :-) Neil - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL

RE: Structure ordering

2002-02-25 Thread Raymond Camden
First off - I am not *asking* them to be ordered, I am asking them to be in the order that I place them into the structure, with what you are stating Ray : this is how structures should behave yes? No. As Dave said, think of it is a bag. If you want ordering like you seem to be asking

RE: Structure ordering

2002-02-25 Thread Simon Horwith
arrays and stacks do this (stacks are not defined as a data object type in CF), but not structures. Just the nature of the beast. ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion 5 Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036

RE: Structure ordering

2002-02-25 Thread Raymond Camden
Dave, As with the previous mail, a correct order in a structure I would say should be as you insert them, but I think the ability to order a structure should be in CF (as it would save me time! :-) You _can_ sort a structure by sub values. See StructSort.

Re: Form?

2002-02-25 Thread Matthew Walker
You could try this... :-) http://www.matthewwalker.net.nz/inform/ - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 7:03 AM Subject: Form? Is there a way to check a form to see if any fields were left withou t

upsize access to Oracle?

2002-02-25 Thread Carl
What is the easiest way to upsize an MS Access 97 or 2000 (NT) data base to Oracle 8.1.7 (UNIX)? Most of the access tables utilize the Auto Number field feature for primary key designation. Thanks for the help! Carl __ Get

Re: upsize access to Oracle?

2002-02-25 Thread Pete Ruckelshaus
Use the Oracle Migration Workbench that comes with the Oracle client. Pete - Original Message - From: Carl [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 25, 2002 3:20 PM Subject: upsize access to Oracle? What is the easiest way to upsize an MS Access 97 or

Re: Structure ordering

2002-02-25 Thread Neil Clark
Thanks Matthew, but I cant use this I would have done that ages ago otherwise! I think I will experiment with certain examples given. N - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 25, 2002 8:09 PM Subject: Re:

protecting non-cf files

2002-02-25 Thread Jennifer Knoblock
I'd like to protect some streaming media files for a subscription based service that would be powered by CF. The server that ColdFusion runs on isn't powerful enough to run both the streaming server and the CF server, so the streaming software is on another server. How can I protect the media

Re: Structure ordering

2002-02-25 Thread Matthew Walker
Ah! :-( - Original Message - From: Neil Clark [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 9:52 AM Subject: Re: Structure ordering Thanks Matthew, but I cant use this I would have done that ages ago otherwise! I think I will experiment with

Re: upsize access to Oracle?

2002-02-25 Thread Carl
Thanks Pete! - Original Message - From: Pete Ruckelshaus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 25, 2002 3:34 PM Subject: Re: upsize access to Oracle? Use the Oracle Migration Workbench that comes with the Oracle client. Pete - Original Message

RE: access query?

2002-02-25 Thread Phillip Broussard
I would take a look at this '#start_time#''#start_ampm#', It doesn't look like a correct date/time fromat to me but I could be wrong. Phillip -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002 1:04 PM To: CF-Talk Subject: access

RE: Structure ordering

2002-02-25 Thread Dave Watts
First off - I am not *asking* them to be ordered, I am asking them to be in the order that I place them into the structure, with what you are stating Ray : this is how structures should behave yes? I'm not Ray, but the answer is still no. The contents of structures are ordered - in fact,

Re: MS SQL Server / Managing in Access

2002-02-25 Thread Paul Giesenhagen
Well I have been able to connect and load up tables, but how do you run queries? Paul Yeah it's actually pretty cool. You need MDAC 2.6 and sp1 I believe for Access 2000 to connect to a SQL Server. Access 2002 is ready to go out of the box. Just create a new project and type in the name or

IP Address Locator

2002-02-25 Thread Jeff Green
Hi all, I have a client that would like to deny any order placed from Indonesia. Is there an easy way to do this? Is there some way to match an IP address up to a country? Thanks, jeff __ Why Share? Dedicated Win 2000

RE: IP Address Locator

2002-02-25 Thread Dan Phillips
Check out http://www.toolsforselling.com/?iplookup It's a tool that will tell you what ISP an IP belongs to. -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 24, 2002 5:03 PM To: CF-Talk Subject: IP Address Locator Hi all, I have a client that

RE: IP Address Locator

2002-02-25 Thread Darryl Lyons
Can you check their locale? -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Monday, 25 February 2002 8:03 AM To: CF-Talk Subject: IP Address Locator Hi all, I have a client that would like to deny any order placed from Indonesia. Is there an easy way to do this?

Re: IP Address Locator

2002-02-25 Thread Jerry Johnson
Do you really need to deny any order from Indonesia, or do you just need to not ship to there? Is it a problem of the buyer not being there, or the delivery address not being there? (I ask because the deliver issue is MUCH easier to solve). Jerry Johnson [EMAIL PROTECTED] 02/24/02 05:02PM

RE: IP Address Locator

2002-02-25 Thread Jeff Green
This looks good, now I just need it in a custom tag :) jeff -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002 2:04 PM To: CF-Talk Subject: RE: IP Address Locator Check out http://www.toolsforselling.com/?iplookup It's a tool that will

RE: IP Address Locator

2002-02-25 Thread Sicular, Alexander
I would say you cant really do it with any degree of certainty. They can easily go through proxies in other countries. I know for a fact that many people in many countries do this to get around government internet restrictions. I would just check the shipping address. Good luck, Alexander

Fw: Simple Message Board 2.0 Beta

2002-02-25 Thread Luca Unti
the option to configure in the admin wich forums are accessible by registration - (require registration ? yes/no)- This would be a real enhancement ! many thanks for this great application - luca will be available soon! I just wanted to get a feel for any additional features anyone might have

RE: IP Address Locator

2002-02-25 Thread Jeff Green
I need to deny orders placed from Indonesia. This merchant says in his whole history of fullfilling orders, he has received about 400 orders from Indonesia, and not one has been legit. Thats not too good of a record :) Jeff -Original Message- From: Jerry Johnson [mailto:[EMAIL

RE: IP Address Locator

2002-02-25 Thread Trey Rouse
www.arin.net whois by ip -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 24, 2002 4:03 PM To: CF-Talk Subject: IP Address Locator Hi all, I have a client that would like to deny any order placed from Indonesia. Is there an easy way to do this?

Recursion of UDFs

2002-02-25 Thread Paul Wille
Hello everyone, I have a flat table of employees (referenced by employee number) that I need to build a dynamic Org chart for. The necessary table information is as such: empNum fName lName supervisorNum -- 1JohnSmith 2Fred

Re: Recursion of UDFs

2002-02-25 Thread James Sleeman
At 11:33 AM 2/26/2002, you wrote: to populate this struct, but my UDF does not continue looping after the first recursion call. Oh man, I spent most of yesterday debugging a seemingly simple recursive UDF, I was so sure it was all correct, just couldn't work out what was going on. Until I

Re: IP Address Locator

2002-02-25 Thread Jon Hall
Ok, lets step back for a second. How does he know these orders are from Indonesia? The order placer has to type this in or select it from a dropdown right? So why not just check to see if the country is Indonesia, and abort the order if so. cfif form.country EQ 'indonesia' cflocation

Re: Recursion of UDFs

2002-02-25 Thread Alex
Lets see your UDF. maybe there is a bug. On Mon, 25 Feb 2002, Paul Wille wrote: Hello everyone, I have a flat table of employees (referenced by employee number) that I need to build a dynamic Org chart for. The necessary table information is as such: empNum fName lName

Does access support this

2002-02-25 Thread Douglas Brown
I dont want to use acceses identity field, and was wondering id access supports this? DECLARE @max_id int BEGIN SELECT @max_id = max(id) FROM tableName IF @max_id = NULL SELECT @max_id = 1 ELSE SELECT @max_id = @max_id + 1 END Success is a journey, not a destination!! Doug Brown

RE: IP Address Locator

2002-02-25 Thread jon
Why not just check the shipping address? -- jon - jon roig online community services manager epilepsy foundation tel: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Trey Rouse [mailto:[EMAIL PROTECTED]]

Re: Fw: Simple Message Board 2.0 Beta

2002-02-25 Thread Tony Schreiber
Thanks. That's something that's come up before. I have been of the midset since starting SMB that I never wanted to host a non-registration required message board again. ;) But I should definitely add that... the option to configure in the admin wich forums are accessible by registration -

Need to delete to delete a struct key before reassigning it?

2002-02-25 Thread Ryan
My coworker has a couple of times brought up the fact that in some places I reset a variable without deleting it. For example, if when looking at a user's session variable, if I find it to be out of date I reset by CFSET session = StructNew() Or if I just need to reset their basket contents I

Re: access query?

2002-02-25 Thread Bryan Stevenson
Yes I'd check that format. '#start_time#''#start_ampm#' For starters you would want something more like '#start_time# #start_ampm#' (note the 1 set of single quotes). That said it may still not be correct. I'd look into using the CreatODBCDateFormat().it will solve your problems

RE: Recursion of UDFs

2002-02-25 Thread Paul Wille
Actually, due to time, I'm going to have to bag on this idea for now. I'll revisit soon, though. I think the comment mentioned about the local vars is my problem, though. :) Such a simple little thing too! Thank you anyway...I'll post an answer to it when I figure it out. --PWW Paul W. Wille

Re: Experts Only! - Summarizing Results

2002-02-25 Thread Jochem van Dieten
Jason Davis wrote: Jochem, Thanks for the code, there are still problems though: 1. I need the summary to be no more then 2-3 sentences, currently there is no upper limit for the output summary, as your code stopps when he finds all words. The upper limit is controlled by the words

RE: Returning IDs off a query...

2002-02-25 Thread Thanh Nguyen
I played with it a little bit and figured that out already. Thanks anyway. Thanh -Original Message- From: Tyler M. Fitch [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 12:57 PM To: CF-Talk Subject: RE: Returning IDs off a query... Thanh, If you use a trigger that

Template running more than once?

2002-02-25 Thread Shawn Grover
We have a case where it appears our template is running twice - but only intermittently. We did a SQL Profile/Trace and noticed two calls to the stored proc on the page, for one page request (us clicking the form submit button only once). We also added some logging capabilities to the stored proc

text file processing

2002-02-25 Thread Brian Scandale
I need a couple of pointers on text file processing. First I use cffile to get the file into a memory variable Now I need to: - parse the file one line at a time searching for a specific string and when I find it - read 7 more lines and then begin reading the next 15 lines, one line at a

RE: Template running more than once?

2002-02-25 Thread Zac Belado
We have a case where it appears our template is running twice - but only intermittently. I had a similar problem and it was, thankfully, tracked down to an error in a dynamic img tag. Disable images in your browser and see if it still loads the tempalte twice. If it doesn't then try looking in

RE: dynamic input text/background color

2002-02-25 Thread Costas Piliotis
For nutscrape, use .styles instead... -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 24, 2002 4:50 PM To: CF-Talk Subject: RE: dynamic input text/background color Works great Steve... thanks! FYI: Netscape 4.7 chokes with a javascript

text file processing

2002-02-25 Thread Brian Scandale
I figured it out thanks, Brian cffile action=READ file=/var/www/html/af/testfile.txt variable=txt cfset rowcount = 0 cfloop list=#txt# delimiters=#chr(10)# index=i cfset rowcount = rowcount +1 cfif i contains To: [EMAIL PROTECTED] ==br

RE: Need to delete to delete a struct key before reassigning it?

2002-02-25 Thread Dave Watts
My coworker has a couple of times brought up the fact that in some places I reset a variable without deleting it. For example, if when looking at a user's session variable, if I find it to be out of date I reset by CFSET session = StructNew() Or if I just need to reset their basket

Re: text file processing

2002-02-25 Thread David Schmidt
Excellent. It is good to see someone post the answer even when they find it themselves. Helps the next poor fellow. Thanks! David (aka... The next poor fellow. lol) __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM /

Re: protecting non-cf files

2002-02-25 Thread Kay Smoljak
Hi Jen, I asked similar question a while back, although all the files I need to protect are on the same server. Storing the files you want to protect outside the web root and calling them with CFCONTENT seemed to be the best way to go, although it does involve a small processing hit each time.

RE: Need to delete to delete a struct key before reassigning it?

2002-02-25 Thread Robert Miller
Better yet, create another level under the SESSION structure and create your session-level structures and arrays there. It becomes very easy to whack your one session-specific level when you want to delete or re-initialize all of your user's session-specific information. I would use SESSION.TLA

Magazines, Article and Diagrams.

2002-02-25 Thread James
Hi guys, I am setting up a site for a magazine. Each article needs to go on-line, most articles have got diagrams or images contained in them. I am a bit stuck on trying to figure out the best way to structure this. The 2 options I have come up with are: 1. Have a table called IMAGES which

RE: Magazines, Article and Diagrams.

2002-02-25 Thread Matthew Walker
I'd strongly recommend the first. Some other ideas... On this site: http://www.tramper.co.nz/index.cfm/action/story/StoryID/78/TrackID/105/ , I did this, but set the site to automatically insert an image every x characters down the page (in between paragraphs). That's a bit tricky. Easier might

  1   2   >