Re: Another Newbie Problem

2002-12-12 Thread Jochem van Dieten
Dina Hess wrote: Actually, any attempt to apply the word standard to the many flavors of SQL probably *is* questionable. :) Not at all. There have been official SQL standards since 1987. You seem to confuse the lack of conforming implementations with the absence of a standard. But I'm

Re: How to change this query from MS Access to MySQL Query

2002-12-12 Thread Stephen Moretti
Rick, Instead of this: CFQUERY Name=GetProperty Datasource=#DSN# Select * from Properties where PropertyID in (Select PropertyID from Rentals where Rentals.ClientID in (Select ClientID from Clients where Clients.ClientID =

Re: Verity Newbie

2002-12-12 Thread Stephen Moretti
I've never actually had to use Verity... until now. It will be on CF5. I've been reading up on it, and trawling through the archives a great deal as well, but I still have a couple of questions. Firstly, this application will be on a shared host. I downloaded a tag from the DevEx which

ListAppend()

2002-12-12 Thread Oliver Cookson
Hi, I have recently read Ben Forta's new series Reality and it mentioned in there that Macromedia have warned people off using ListAppend() (and some other list functions) and to make list's manually, for example (raw example, you get the drift): CFSET TempList = CFLOOP CFSET TempList =

Re: Verity Newbie

2002-12-12 Thread samcfug
From a provider's viewpoint. On our shared server, each site is permitted two verity collections set up by the server admin. CFregistry is disabled as a security issue as are several common low level Tags. Developers therefore, must conform their code to a standard that will not only protect the

Re: IIS on WinXP Pro

2002-12-12 Thread Steven Wojciechowski
I came across the same problem I just change the directory that IIS points to depending on which site I am working on. I don't have much need to work on more than one site at a time so this works for me. Stevie http//www.swoj.com - Original Message - From: Al Everett [EMAIL PROTECTED]

Re: IIS on WinXP Pro

2002-12-12 Thread Jochem van Dieten
Quoting Steven Wojciechowski [EMAIL PROTECTED]: I came across the same problem I just change the directory that IIS points to depending on which site I am working on. I don't have much need to work on more than one site at a time so this works for me.

ODBC Drivers on Linux

2002-12-12 Thread Antonio Mokarzel
Hi, Imagine this scenario: I have a server running Linux and Cold Fusion MX Pro. My boss wants to buy DB2 but I read at the Cold Fusion MX Feature Comparison Matrix (Macromedia site) that ODBC connectivity is not available at this version. Question: Is there any solution or I will have to

RE: IIS on WinXP Pro

2002-12-12 Thread Everett, Al
That's all great but I'm on a limited budget and this is only a lowly P3-500MHz I've got. -Original Message- From: Chris Kief [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 11:09 PM To: CF-Talk Subject: RE: IIS on WinXP Pro You guys must not get out much...or

RE: IIS on WinXP Pro

2002-12-12 Thread Everett, Al
Well I'm not seeing it. -Original Message- From: samcfug [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 11:23 PM To: CF-Talk Subject: Re: IIS on WinXP Pro AFAIK WinXP Pro will support multiple web sites = Douglas White

FW: CFFILE Pemissions Setting

2002-12-12 Thread Jillian Carroll
I posted this to the Linux group yesterday, but I didn't get any responses... Can anybody please help me out? -- Jillian -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED]] Sent: December 11, 2002 1:45 PM To: CF-Linux Subject: CFFILE Pemissions Setting I have a CF file

RE: IIS on WinXP Pro

2002-12-12 Thread Everett, Al
I have Pro. From what I've seen, XP Home doesn't run IIS/PWS at all. -Original Message- From: samcfug [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 11:23 PM To: CF-Talk Subject: Re: IIS on WinXP Pro WinXP home will not support multiple web sites, but the Pro

RE: IIS on WinXP Pro

2002-12-12 Thread Everett, Al
I'm not doing any hosting, though. I just want to set the sites up to make it easier for development. -Original Message- From: samcfug [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 11:52 PM To: CF-Talk Subject: Re: IIS on WinXP Pro I must be having a senior

RE: IIS on WinXP Pro

2002-12-12 Thread Everett, Al
This looks like what I'll end up doing. Thanks all for the suggestions and information. -Original Message- From: Steven Wojciechowski [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 7:04 AM To: CF-Talk Subject: Re: IIS on WinXP Pro I came across the same problem I

RE: CFFILE Pemissions Setting

2002-12-12 Thread webguy
is UL = Upload? What user are you running CF under? I presume its running under apache? Anyway you chould use cfexecute .. to run chown on the file after you upload it. WG -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED]] Sent: 12 December 2002 13:13 To: CF-Talk

RE: IIS on WinXP Pro

2002-12-12 Thread Everett, Al
If I'm using CF5, what version of Apache should I be going after? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 12:23 AM To: CF-Talk Subject: RE: IIS on WinXP Pro However, Apache may run on XP, especially if you use Cygwin

Prev 1 2 3 ... Next

2002-12-12 Thread paul smith
Google results offer links like the subject. Given RecordCount from a query, is there a tag to create links like the subject? Or a script? best, paul ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4

Re: IIS on WinXP Pro

2002-12-12 Thread James Smith
Slightly off topic, but what do people use Cygwin for? It is all good fun as a toy but what practical applications does it have? -- James Smith [EMAIL PROTECTED] - Original Message - From: Everett, Al [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 1:22

Wuick question: if odd/if even

2002-12-12 Thread Janine Jakim
I Know this is easyIwant a different background depending on the year chosen by the user- basically if it ends as an odd number make background blue if year ends with even number make background green. Is there a better way than saying cif (Right(#Year#, 1) EQ 1) or (Right(#Year#, 1) EQ 3) or

RE: Wuick question: if odd/if even

2002-12-12 Thread Craig Dudley
cfif year mod 2 eq 1ODDcfelseEVEN/cfif -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: 12 December 2002 13:32 To: CF-Talk Subject: Wuick question: if odd/if even I Know this is easyIwant a different background depending on the year chosen by the user-

RE: Wuick question: if odd/if even

2002-12-12 Thread Pascal Peters
cfif Year MOD 2 -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: donderdag 12 december 2002 14:32 To: CF-Talk Subject: Wuick question: if odd/if even I Know this is easyIwant a different background depending on the year chosen by the user- basically if it ends

RE: Prev 1 2 3 ... Next

2002-12-12 Thread webguy
Not sure if there is a tag but it is easy to do. here is the logic (top of my head - not tested) NumberOfPages = Round(NumberOfResults / ResultsPerPage); for(i=1;i lte NumberOfPages;i=i+1) { startrow = i * ResultsPerPage; writeOutput(showresults.cfm?startrow= startrow); } WG

RE: Wuick question: if odd/if even

2002-12-12 Thread webguy
yeap, here u go if (year mod 2) year even else year odd you can use IIF like this too, but the above is easier to read... WG -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: 12 December 2002 13:32 To: CF-Talk Subject: Wuick question: if

Re: IIS on WinXP Pro

2002-12-12 Thread Jochem van Dieten
Quoting James Smith [EMAIL PROTECTED]: Slightly off topic, but what do people use Cygwin for? It is all good fun as a toy but what practical applications does it have? I have used it for: - OpenSSH - PostgreSQL - lynx And various small command line tools like tail, bzip2 etc. Don't know how

RE: Wuick question: if odd/if even

2002-12-12 Thread Janine Jakim
Thanks- I knew it was super easy -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 8:38 AM To: CF-Talk Subject: RE: Wuick question: if odd/if even cfif year mod 2 eq 1ODDcfelseEVEN/cfif -Original Message- From: Janine Jakim

OT-Another quick question- float datatype

2002-12-12 Thread Janine Jakim
I'm pulling from a DB4 db and dumping into a SQL db Most of their numbers from the DB2 are formatted as float. i remember being told to stay away from float as a datatype.Should I make the datatype in the sql an integer instead? Thanks for any insight. j

Re: IIS on WinXP Pro

2002-12-12 Thread James Smith
Slightly off topic, but what do people use Cygwin for? It is all good fun as a toy but what practical applications does it have? I have used it for: - OpenSSH - PostgreSQL - lynx All of those are available for Win32 anyway though, aren't they? (I know you have to compile OpenSSH yourself

Cygwin (was Re: IIS on WinXP Pro)

2002-12-12 Thread webguy
The cygwin tools are great for eveny thing !! You need the knowledge of sed , grep, find, file etc etc cvs client, ssh client etc.. for example print all www requests for ip xxx.xxx.xxx.xxx in the web log to a file.. grep 'xxx.xxx.xxx.xxx' /c/WEBLOG.log results.txt There are loads

Re: OT-Another quick question- float datatype

2002-12-12 Thread Jochem van Dieten
Quoting Janine Jakim [EMAIL PROTECTED]: I'm pulling from a DB4 db and dumping into a SQL db Most of their numbers from the DB2 are formatted as float. i remember being told to stay away from float as a datatype.Should I make the datatype in the sql an integer instead? What does the data

RE: MM Rich Text Editor - WAS: RE: Macromedia Contribute

2002-12-12 Thread Rick Faircloth
The biggest question I would have in using it is how to use it with multiple text fields to edit on a single page. e.g., if a client has an announcements page and has, say, Title, Teaser, and Text fields, and all are separate fields in a database, would I have to set up 3 instances of AE on that

Re: IIS on WinXP Pro

2002-12-12 Thread Bruce Sorge
XP does not allow hosting of multiple sites. I have several sites on my XP machine, and all I do is create a virtual directory for each site. So, I would be able to access the sites like: http://localhost/sitea http://localhost/siteb etc... All you need to do is make sure each site is set up

CFMX/SQL Server query problems

2002-12-12 Thread Bosky, Dave
I can view my datasources in DWMX and see my tablenames/datafields as well but when I attempt a basic query to that datasource I always get the following error. Any idea of what might be the cause and how to correct it. I know it must be simple but I'm running CFMX,MSSQL2000 locally.

Re: IIS on WinXP Pro

2002-12-12 Thread Jochem van Dieten
Quoting James Smith [EMAIL PROTECTED]: Slightly off topic, but what do people use Cygwin for? It is all good fun as a toy but what practical applications does it have? I have used it for: - OpenSSH - PostgreSQL - lynx All of those are available for Win32 anyway though, aren't they?

RE: OT-Another quick question- float datatype

2002-12-12 Thread Janine Jakim
The data is generally an id of some sort- teacherid/etc. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 8:57 AM To: CF-Talk Subject: Re: OT-Another quick question- float datatype Quoting Janine Jakim [EMAIL PROTECTED]: I'm

RE: IIS on WinXP Pro

2002-12-12 Thread Everett, Al
Won't really work for me. I'd have to monkey quite a bit with the way the code (e.g., subdirectories) is set up so that it works the same on the dev server as well as the (hosted) production server. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Thursday,

RE: How to change this query from MS Access to MySQL Query

2002-12-12 Thread Rick Faircloth
Hi, Stephen. Thanks a lot for the help. As usual, I was overcomplicating the logic. What you've proposed makes perfect sense. I was able to greatly simplify a page-full of subqueries based on your examples. Now mySQL is happy, therefore, I am too! :o) (I'll just be glad when mySQL 4.1 comes

RE: CFMX/SQL Server query problems

2002-12-12 Thread Alford, Sean
Dave, Have you tried the query without the dbo in your from clause??? Sean -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 9:00 AM To: CF-Talk Subject: CFMX/SQL Server query problems I can view my datasources in DWMX and see my

RE: Cygwin (was Re: IIS on WinXP Pro)

2002-12-12 Thread webguy
Actually a great example is using VNC over ssh to admin windows servers http://www.uk.research.att.com/vnc/sshvnc.html Having said that terminal services have got much better... WG -Original Message- From: webguy [mailto:[EMAIL PROTECTED]] Sent: 12 December 2002 13:56 To: CF-Talk

Re: IIS on WinXP Pro

2002-12-12 Thread Bruce Sorge
This can all be accomplished dynamically with CF. I run into the same situation. My laptop, which is my development machine, only has a C drive. My test web server at home as the sites running on the F drive, and my production server also uses the F drive. So, I just set everything up in the

RE: OT-Another quick question- float datatype

2002-12-12 Thread Jochem van Dieten
Quoting Janine Jakim [EMAIL PROTECTED]: The data is generally an id of some sort- teacherid/etc. An integer (or at least an exact numeric) should be fine. Frankly, I am a bit surprised that they used an approximate numeric for an ID, which typically is something you use as PK/FK. Jochem

RE: CFMX/SQL Server query problems

2002-12-12 Thread Bosky, Dave
Yeah. I tried it both ways. -Original Message- From: Alford, Sean [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 9:14 AM To: CF-Talk Subject: RE: CFMX/SQL Server query problems Dave, Have you tried the query without the dbo in your from clause??? Sean

GUID in MX

2002-12-12 Thread Shahzad.Butt
Hi Coldfusion MX Server is giving following error 'ByteArray objects cannot be converted to strings' If I select a Uniqueidentifier field from SQL Server 2000. My DSN is configured as adding an ODBC from system DSN and then ODBC Socket from CFMX Server. Is it bug which has been

RE: ListAppend()

2002-12-12 Thread Raymond Camden
Arrays are faster than lists - but I wouldn't warn against using ListAppend - and I am not aware of any official MACR recommendation against it. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL

RE: OT-Another quick question- float datatype

2002-12-12 Thread Janine Jakim
In the DB4 it is a double number field- when imported into SQL it changes to float. just like all the text fields become nvarchar and need changed to varchar. Thanks, j -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 9:16 AM To:

RE: CFMX/SQL Server query problems

2002-12-12 Thread brook
Try running the query through the Query Analyzer. Does it work from there? There error is reporting that the table does not exist, it could be a small typo or a mixed up datasource name assignment At 09:15 AM 12/12/2002 -0500, you wrote: Yeah. I tried it both ways. -Original

CFPOP and undeliverable mail

2002-12-12 Thread Luis Lebron
I am writing some code for a newsletter. I would like to be able to remove any Undeliverable email address from our recipients list. I'm using the following code: cfpop server = server username = user password = pwd action = GETHEADERONLY NAME = msg ul cfoutput query = msg cfif #subject#

SQLException occurred in JDBCPool

2002-12-12 Thread Joshua Miller
Anyone know what may have caused these errors? I've got a few scheduled tasks that run at 2:00am, 2:15am and 2:30am and they all threw this same exception: SQLException occurred in JDBCPool When I went to the server today and ran the tasks they ran fine - no errors. Anyone? Thanks in

Re: CFPOP and undeliverable mail

2002-12-12 Thread Jochem van Dieten
Quoting Luis Lebron [EMAIL PROTECTED]: From: System Administrator - To: Luis Lebron Subject: Undeliverable: Test message -Date Thu, 12 Dec 2002 07:44:24 -0600 Body: Your message To: '[EMAIL PROTECTED]' Subject: Test message Sent: Thu, 12 Dec 2002 07:44:12 -0600 did not reach the following

Custom 404 pages - catching invalid links

2002-12-12 Thread Carlisle, Eric
I'm creating a custom 404 page. I'd like to be able to catch the invalid links that the users are typing in. Such as... The page you were trying to get, http://www.mysite.com/foo http://www.mysite.com/foo , was not found. Etc I can't find any CGI vars with that info. Any ideas?

Re: SQLException occurred in JDBCPool

2002-12-12 Thread Jochem van Dieten
Quoting Joshua Miller [EMAIL PROTECTED]: Anyone know what may have caused these errors? I've got a few scheduled tasks that run at 2:00am, 2:15am and 2:30am and they all threw this same exception: SQLException occurred in JDBCPool When I went to the server today and ran the tasks they ran

Updater2...

2002-12-12 Thread brook
FYI, After installing the Updater and rebooting, I get an error that IIS hung on startup, and I can not get the mmc to open or IIS to start. Brook ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4

CFC's in the application Scope

2002-12-12 Thread brook
If I stored a component instance in the application scope: cfobject component = lfcomponents.lfinsert_record name = application.ComponentInstance.lfInsertData Would I need to lock each usage of it, when used like this cfinvoke component=#application.ComponentInstance.lfInsertData# Brook

Re: CFPOP and undeliverable mail

2002-12-12 Thread brook
Check out www.cflib.org for a UDF that will find the email address is a string. Also look at www.coolfusion.com and the inexpensive IMS-SE product which has built in undeliverable support and may improvements on the cfmail/pop combo Brook At 08:21 AM 12/12/2002 -0600, you wrote: I am

The Future of ListAppend()

2002-12-12 Thread Oliver Cookson
Hi, I'm not suer this made it to the list so i will post it again. The list seems to be playing up? Oh well see below thanks. :) -- I have recently read Ben Forta's new series Reality and it mentioned in there that Macromedia have warned people off using ListAppend() (and some other list

Re: Cygwin (was Re: IIS on WinXP Pro)

2002-12-12 Thread James Smith
So you would run Cygwin on the remote server running an ssh server and VNC for windows Then run Cygwin on your local machine starting ssh with a command like ssh -L 5901:localhost:5900 remotecomp Then connect the windows vnc viewer on your local machine to localhost:1 yes? -- James Smith

Re: CFC's in the application Scope

2002-12-12 Thread Jochem van Dieten
Quoting [EMAIL PROTECTED]: If I stored a component instance in the application scope: cfobject component = lfcomponents.lfinsert_record name = application.ComponentInstance.lfInsertData Would I need to lock each usage of it, when used like this cfinvoke

RE: IIS on WinXP Pro

2002-12-12 Thread Dave Watts
If I'm using CF5, what version of Apache should I be going after? The module provided with CF 5 only supports Apache 1.3.x, so you could just download the latest version of that. Or, if you're using it for development, you can go ahead and use this third-party module with Apache 2:

RE: ListAppend()

2002-12-12 Thread Dave Carabetta
Arrays are faster than lists - but I wouldn't warn against using ListAppend - and I am not aware of any official MACR recommendation -- Hey Ray. This is cut and pasted directly from the MX ListAppend() help page: ColdFusion inserts a delimiter character before value. To

RE: CFC's in the application Scope

2002-12-12 Thread Raymond Camden
It would be even better though to let the CFC worry about the locks - ie, put the lock in the method. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW :

Quotes in a query string

2002-12-12 Thread Ryan Farrell
I'm building a string to put in a cfquery. The string requires single quotes around a date, but when the cfquery executes, the single quotes have been replaced by double quotes. What gives? It may be hard to read, but those are single quotes before and after the date form field. Thanks!

RE: Cygwin (was Re: IIS on WinXP Pro)

2002-12-12 Thread webguy
Yeap, that was the old way I used to do it with NT. Window 2000 introduced new features ( look here http://online.securityfocus.com/infocus/1629 ).. Having said that you can run anything over the ssh client / server e.g. cvs,ftp etc. Very useful if you want to admin linux from windows for

RE: Quotes in a query string

2002-12-12 Thread Ryan Farrell
Bah, nevermind, forgot about the preserveSingleQuotes function. Thanks, anyways. Ryan -Original Message- From: Ryan Farrell Sent: Thursday, December 12, 2002 8:43 AM To: CFTalk (E-mail) Subject: Quotes in a query string I'm building a string to put in a cfquery.

RE: Quotes in a query string

2002-12-12 Thread Everett, Al
You'll want to review the PreserveSingleQuotes() function. -Original Message- From: Ryan Farrell [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 9:43 AM To: CF-Talk Subject: Quotes in a query string I'm building a string to put in a cfquery. The string requires

RE: IIS on WinXP Pro

2002-12-12 Thread Shawn Regan
What I have done is this: I have one drive with all the development projects. I map that drive as the default website, that way eveything under it becomes part of the default website. This is good enough for development! Shawn Regan pacifictechnologysolutions 15530-B Rockfield Blvd. Suite 4

RE: SQLException occurred in JDBCPool

2002-12-12 Thread Joshua Miller
I don't have access to the Database Logs - our host is providing the database server until we can get our own. There's nothing in the Exception.log related to the issue There's nothing in the Application.log === Scheduler Logs: ===

RE: Quotes in a query string

2002-12-12 Thread Raymond Camden
Use preserveSingleQuotes.. select foo from goo where #preserveSingleQuotes(mysql)# === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW :

Not want Evaluate in my loop

2002-12-12 Thread E. Keith Dodd
I thought I'd done something like this before, but can't locate similar code. Creating a news marquee that can be made up of from 1-5 text fields contained in a larger query. Possibilities are: qNews.Banner1, qNews.Banner2 ... qNews.Banner5 Am able to put them together with: CFSet MarqMess =

Re: FW: CFFILE Pemissions Setting

2002-12-12 Thread Chris Norloff
The uploaded file will be owned by the user account ColdFusion is operating under. Chris Norloff -- Original Message -- from: Jillian Carroll [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Thu, 12 Dec 2002 07:12:59 -0600 I posted this to the Linux

RE: Not want Evaluate in my loop

2002-12-12 Thread Raymond Camden
Here ya go... cfloop from=1 to=5 index=b cfif len(trim(qNews[banner#b#][currentRow])) etc Basically, you just use bracket notation - but I believe you must also specify the correct row number. In this case, I just used currentRow. You can try w/o it as well.

RE: Updater2...

2002-12-12 Thread Stacy Young
I would remove all connectors and re-install them... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 9:37 AM To: CF-Talk Subject: Updater2... FYI, After installing the Updater and rebooting, I get an error that IIS hung on

RE: ListAppend()

2002-12-12 Thread Dave Carabetta
Arrays are faster than lists - but I wouldn't warn against using ListAppend - and I am not aware of any official MACR recommendation against it. G...Sorry about my last post. I was using MyWay.com's e-mail, and it, well, sucks. What I was trying to say was that, according to the MX docs

RE: Prev 1 2 3 ... Next

2002-12-12 Thread Ryan Kime
Here's the basics given a recordcount. A difference from WG's response is the use of Ceiling() instead of Round(). Why? Because if you get 73 results with a perpage setting of 10 (73/10=7.3). With Round, it will round to the nearest integer giving you 7 pages. So you will have only 70 of your 73

Re: Cygwin (was Re: IIS on WinXP Pro)

2002-12-12 Thread James Smith
ok, hadn't thought of that one, like it. Is there any way to get the vnc ports to only respond to one IP address as setting this to 127.0.0.1 would help with the lockdown. -- James Smith [EMAIL PROTECTED] - Original Message - From: webguy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED]

RE: Prev 1 2 3 ... Next

2002-12-12 Thread webguy
good point... WG Here's the basics given a recordcount. A difference from WG's response is the use of Ceiling() instead of Round(). Why? Because if you get 73 results ~| Archives:

RE: ListAppend()

2002-12-12 Thread Raymond Camden
This looks a doc bug to me. The code below shouldn't be any faster than listAppend. If you really want it fast, I'd convert your list to an array, but again, I don't think it most cases it will really be worth it. (But thats just my personal opinion. ;)

RE: SQLException occurred in JDBCPool

2002-12-12 Thread John Ceci
Joshua, Complete shot in the dark, but could it be a privileges issue? If you can run it, but the scheduler can not, is the scheduler running as a different user? Just something to look at... HTH, John -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Thursday,

RE: MM Rich Text Editor - WAS: RE: Macromedia Contribute

2002-12-12 Thread John Lucas
I wouldn't set up a separate instance for title...use a text field. For a teaser and a text field, then you'd need a separate instance unless you just wanted a short 2-line teaser with no htmlthen use a textarea. It isn't a big issue with using more than one instance. Besides, you'd have to

Re: Custom 404 pages - catching invalid links

2002-12-12 Thread Bob Haroche
I'm creating a custom 404 page. I'd like to be able to catch the invalid links that the users are typing in. Such as... The page you were trying to get, http://www.mysite.com/foo http://www.mysite.com/foo , was not found. Etc Here's what I use for that: pThe page you requested,

Please help before my deadline please!!!

2002-12-12 Thread Ian Vaughan
Can anybody help me sort out this problem please before my deadline Saturday please I am trying to populate two related select boxes from my database table, however the actual dropdowns are not being populated. There are no error messages from Coldfusion or from the Javascript so it seems

Is ColdFusion the best answer

2002-12-12 Thread Chad
I will be creating a site much like match.com that will require a few hundred users logging in accessing the CF server, SQL DB and processing multiple requests simultaneously and I was wondering if CF Server 5.0 could handle it or would it be best to go down another road and develop in another

Re: Not want Evaluate in my loop

2002-12-12 Thread E. Keith Dodd
Thanks, Ray, for input 1. I may have misinterpreted what you meant by currentRow, but including it anywhere produced an error: unknown variable. Leaving off helped (as below in 3) 2. Doing the len(trim as this: cfif len(trim(qHomeNews[banner#b#])) produced an error: Paramenter 1 of function

RE: CFPOP and undeliverable mail

2002-12-12 Thread Luis Lebron
I did find an UDF that would verify a string is an email address but none that would find an email address in a string. Luis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 8:39 AM To: CF-Talk Subject: Re: CFPOP and undeliverable

RE: Not want Evaluate in my loop

2002-12-12 Thread Raymond Camden
1. I may have misinterpreted what you meant by currentRow, but including it anywhere produced an error: unknown variable. Leaving off helped (as below in 3) Ack, sorry, yea, currentRow would only be there if you were looping over the query. Soryry about that. I think the other issues below

RE: Please help before my deadline please!!!

2002-12-12 Thread Joshua Miller
Look at CF_TWOSELECTSRELATED in the Tag Gallery - it will make your life much, much easier. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254

RE: Is ColdFusion the best answer

2002-12-12 Thread webguy
Yes, if you design it well. Make sure your DB is designed properly. You should be able use CF to cache alot of the profiles/ content .. WG -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: 12 December 2002 16:10 To: CF-Talk Subject: Is ColdFusion the best answer I

Re: Is ColdFusion the best answer

2002-12-12 Thread Clint Tredway
Where I work, we have an intranet that is enterprise wide with hundreds of users using it everyday all day long using CF5 and SQL 2000. CF and SQL handle this just fine. HTH Clint - Original Message - From: Chad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 12,

RE: Custom 404 pages - catching invalid links

2002-12-12 Thread Carlisle, Eric
That's what I needed. Many thanks :-) -Original Message- From: Bob Haroche [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 10:58 AM To: CF-Talk Subject: Re: Custom 404 pages - catching invalid links I'm creating a custom 404 page. I'd like to be able to catch the invalid

Re: Is ColdFusion the best answer

2002-12-12 Thread Bruce Sorge
The real question is not can CF handle it, it is more like, will my hardware handle it? ColdFuison 5.0 is being used by some very high trafficked sites. If you are talking about having several hundred users logged in, you will want to make sure that you have a beefy stand-alone SQL server and a

RE: Please help before my deadline please!!!

2002-12-12 Thread webguy
There have about 15 mails in response to this, many giving the complete code, examples, and tags. There really isn't much more we can do, besides writing your code for u. This link has all the code you need, you just need to feed it your data

Re: Not want Evaluate in my loop

2002-12-12 Thread E. Keith Dodd
OK now: Set the CurrentRow to 1 and your suggested code worked fine. Thanks! Keith - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 11:14 AM Subject: RE: Not want Evaluate in my loop 1. I may have

RE: Is ColdFusion the best answer

2002-12-12 Thread Jim Davis
-Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 11:10 AM To: CF-Talk Subject: Is ColdFusion the best answer I will be creating a site much like match.com that will require a few hundred users logging in accessing the CF server, SQL

XML and Javascript

2002-12-12 Thread John McCosker
Hey, Would anyone know off any good online resources giving good help with creating XML documents in memory with javascript so they can then be passed via a form to CF. I know javascript can parse XML, so I'm sure it I'll have not problems creating XML docs, or will it? I want to be to append

RE: Custom 404 pages - catching invalid links

2002-12-12 Thread Joshua Miller
One thing I'd recommend is doing something to trap missing images - missing images toss 404 errors too, just not visible to the user. So you can test for file extensions in the code, and if it's GIF or JPG or PNG or whatever, you can use CFCONTENT to replace the image with a clear gif. I do a

RE: Cygwin (was Re: IIS on WinXP Pro)

2002-12-12 Thread Rob Rohan
makes you wish you had all those tools natively eh? (ahem... linux... cough cough) Rob -Original Message- From: webguy [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 5:56 AM To: CF-Talk Subject: Cygwin (was Re: IIS on WinXP Pro) The cygwin tools are great for eveny thing

Re: Is ColdFusion the best answer

2002-12-12 Thread Paris Lundis
CF will handle any load you can come up with... just be sure of the following: 1. run a real database... MySQL is a great one and has awesome cost... 2. Have enough machines to process your requests... 3. Don't try running many servers on one machine... divide FTP, EMAIL, DNS and SQL stuff from

RE: Prev 1 2 3 ... Next

2002-12-12 Thread paul smith
Thanks! I think I need to use Int instead of Round. If I have 73 results, I only want to display links to 1 2 3 4 5 6 7, not to 1 2 3 4 5 6 7 8 In addition, to get the Google format, I need to include Previous/Next. Finally, I need to display the current page with no link. The following is

RE: Cygwin (was Re: IIS on WinXP Pro)

2002-12-12 Thread webguy
Those tools aren't native to linux. The only native element is the kernel :-) All the rest, well they are generally GNU apps.. ask RMS... WG -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: 12 December 2002 16:44 To: CF-Talk Subject: RE: Cygwin (was Re: IIS on

RE: XML and Javascript

2002-12-12 Thread webguy
Be warned IE on the Mac (os9 .* anyway) cannot use javascript. In addition there have been security issues with Mozilla and MicroSoft in this area. anyway, after the warning :-) check out... http://lxr.mozilla.org/mozilla1.0/source/extensions/xmlextras/docs/Soap_Scri pts_in_Mozilla.html

Re: DW - lower case

2002-12-12 Thread Austin Govella
I ma using DW MX. I have to move a whole site from an IIS web server to an Apache web server. Many of the files and links are with Capitalized file names. As a result there are many broken links... Is there any fast way of converting everything in the site to lower case. It's generally best

Re: Please help before my deadline please!!!

2002-12-12 Thread Austin Govella
CFQUERY name=query1 datasource=intranetv8 SELECT * from category_menu where parent_level= catno ORDER BY cat_desc /CFQUERY If that's your actual SQL, don't you need # signs around catno? WHERE parent_level = #catno# -- Austin Govella Grafofini

  1   2   3   >