Re: Couple of somewhat OT learning questions

2002-12-29 Thread cf-talk
Just a quick side note on this... PHP's own website (www.php.net) indicates that although the API modules (for IIS, I don't know about Apache) provide significant performance improvement they are not to be considered stable at this time. So if you need REAL stability in a production environment yo

RE: Loop question from a beginner

2002-12-29 Thread Matthew Walker
You could simply loop and say something like However, repeating the selected item could be a feature. You could have the currently selected item at the top of the box, followed by then all the available options including the one you've currently selected. For example, think of the wa

Server Set-up Apache & Access?

2002-12-29 Thread Russ
Rookie question here, but I'm hoping it's got an easy enough answer. I've just set up my server--I'm running RedHat Linux 7.2 and have CFMX all set-up. I'm almost there. Now, I need to know if there's any way (an easy/free way is what I'm REALLY asking for here) to install MS Access drivers on t

RE: Couple of somewhat OT learning questions

2002-12-29 Thread Jim Davis
> HAPPY NEW YEAR EVERYONE > > OK - new year, new beginnings - > > I am doing all I can to advance my own skills and improve my > services... > > Couple questions (Don't know if anyone can help with the 2nd > question and > beyond, but hey - everyone on this list is a brilliant web > gur

RE: ODBC Date Question

2002-12-29 Thread Peter Bagnato
Hi Julia, I went to your search screen and tried returning some data using the following dates: 5/6/1999 AND 12/6/2002 It couldn't find anything, so it was a bit hard to reproduce your problem. However, this query will not return anything except the year you ask for: SELECT count(t.File) as

Loop question from a beginner

2002-12-29 Thread Mitko Gerensky-Greene
Hello, Here is a dumb beginners question. I am working on a small site which has a database of songs. For each song there are fields like type, language, tempo, etc. In the admin page I need to allow editting of the type of song or its language or its tempo. The data that was given to me was init

Re: CFMX doesn't seem to like Oracle8 CLOB data

2002-12-29 Thread Sean A Corfield
On Sunday, Dec 29, 2002, at 10:04 US/Pacific, Stacy Young wrote: > Sean do you happen to know off hand if the OCI drivers in 8i support > the > query timeout option? I noticed the JDBC version with CFMX does not. Sorry, I don't know (we only use the 9i drivers and I don't think we use the query

Re: Couple of somewhat OT learning questions

2002-12-29 Thread Sean A Corfield
On Sunday, Dec 29, 2002, at 12:29 US/Pacific, Rafael Alan Bleiweiss wrote: > 3. If I teach myself PHP can I co-mingle PHP and CF on the same page? Not easily although it might be possible. I think you'd need Apache 2.0.x so that you could 'stack' mod_jrun (connecting to CFMX) and mod_php and a

RE: top clause in a SP

2002-12-29 Thread Samuel Neff
Try this: declare @top varchar; set @top = 2; exec('select top ' + @top + ' * from books;'); HTH, Sam > -Original Message- > From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]] > Sent: Sunday, December 29, 2002 3:34 PM > To: CF-Talk > Subject: top clause in a SP > > > Happy new

RE: Couple of somewhat OT learning questions

2002-12-29 Thread Eric Hoffman
1. Watch closely your performance monitor. Observe if the processor is pushing the limits; if not, RAM will certainly give you the best performance gains as you can get a lot of improvement out of caching, etc etc etc. If you are doubling up SQL and the like on that server, don't. Keep that gu

RE: Couple of somewhat OT learning questions

2002-12-29 Thread Mike Brunt
I can give you an opinion on your first question. My experience shows that more RAM is more beneficial and when added to the fact that adding more RAM is far less disruptive and less costly than adding an extra processor, that is the route I would. One other important point, if you don't already

Re: Couple of somewhat OT learning questions

2002-12-29 Thread Bruce Sorge
2. Several prospective clients want someone skilled in PHP and MySQL... would there be conflicts running PHP on my server alongside CF? No, there are no conflicts. I currently have PHP4, CFMX and .NET running on the same server with no issues. 3. If I teach myself PHP can I co-mingle PHP an

Re: Couple of somewhat OT learning questions

2002-12-29 Thread Christian Cantrell
In response to your first question, it all depends on which resource (CPU or RAM) you are running out of under load. Off the top of my head, I would say that you should consider an additional CPU since 512MB of RAM is a reasonable amount while a 500MHz processor is quite old. That said, h

Re: Couple of somewhat OT learning questions

2002-12-29 Thread Jesse Houwing
> > >1. Does 2 CPUs on a Windows 2k server running CF 5 enterprise make more >sense than adding RAM? I have a Compaq 1600r server, with 512 megs of >RAM, and one 500 mhz CPU... > CF would benefit greatly if you add a new CPU, make sure the new CPU has exactly the same SSpec as the one already

Re: excel as a vehicle to collect and write back data to a CF-App

2002-12-29 Thread Richard Meredith-Hardy
I've done this using a vba script in excel to wrap the columns you select into a wddx packet (using wddx_com.dll) and then sending it to the server using asptear.dll works rather well. [EMAIL PROTECTED] wrote: > > I have a customer, > who runs an application, > where he can show, who > is a a

Couple of somewhat OT learning questions

2002-12-29 Thread Rafael Alan Bleiweiss
HAPPY NEW YEAR EVERYONE OK - new year, new beginnings - I am doing all I can to advance my own skills and improve my services... Couple questions (Don't know if anyone can help with the 2nd question and beyond, but hey - everyone on this list is a brilliant web guru so why not ask right?)

top clause in a SP

2002-12-29 Thread Richard Meredith-Hardy
Happy new year (nearly) I would like to be able to pass the TOP n value into a SP, but can't get it to work. you would think the following would work, but whatever data type I cast @xx as, it doesn't like it: DECLARE @xx int SET @xx = 150 SELECT TOP @xx field1 Etc anyone any ideas? (this

ODBC Date Question

2002-12-29 Thread Julia Green
This I am sure is a beginning question...so one of you experts can help me... I have a client Gilway lighting, whose form, gilwaydb.cfm submits an ODBC date to an Access table whose dates I converted all to Date/Time(shot over to SQL Server) in the format mm/dd/, the table is called tblfile4d

Re: Dynamically created form input names

2002-12-29 Thread Ryan Mitchell
Brilliant!! Thank you so much, this worked perfectly! Ryan On 29/12/02 17:47, "Scott Brady" <[EMAIL PROTECTED]> wrote: >> Basically what I want is #form[#FORM.domain##FORM.registerindex#]# > > This should work: > > #Evaluate("FORM." & FORM.domain & FORM.registerindex)# > > or, with your notati

RE: CFMX doesn't seem to like Oracle8 CLOB data

2002-12-29 Thread Stacy Young
Sean do you happen to know off hand if the OCI drivers in 8i support the query timeout option? I noticed the JDBC version with CFMX does not. Stace -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 1:17 AM To: CF-Talk Subject: Re: CFMX do

Re: Dynamically created form input names

2002-12-29 Thread Scott Brady
> Basically what I want is #form[#FORM.domain##FORM.registerindex#]# This should work: #Evaluate("FORM." & FORM.domain & FORM.registerindex)# or, with your notation: #Evaluate("FORM[" & FORM.domain & FORM.registerindex & "]")# Scott --- Scott Brady http

Re: Dynamically created form input names

2002-12-29 Thread Ryan Mitchell
That¹s a good start! Thanks! And I could just leave as is, but out of curiosity... I have 2 variables being passed FORM.domain and FORM.register. Register is a list, through which im looping basically to make a combination of FORM.domain and FORM.register. How can I put these together to get the

Re: Dynamically created form input names

2002-12-29 Thread Bud
On 12/29/02, Ryan Mitchell penned: >Hmm this might be confusing, but ill try my best > >I've got a set of form text inputs, the names of which are dynamically >created according to how many of them there are > >Eg (abbreviated code) > > > > >How do I get the action page to know the name of the

Dynamically created form input names

2002-12-29 Thread Ryan Mitchell
Hmm this might be confusing, but ill try my best I've got a set of form text inputs, the names of which are dynamically created according to how many of them there are Eg (abbreviated code) How do I get the action page to know the name of the form field? If I do #FORM.#variablename##index

Re[2]: excel as a vehicle to collect and write back data to a CF-App

2002-12-29 Thread cf-talk
Hi Dave, thank you very much. That helped a lot. I somehow thought it before I started this question that the whole process is much of a pain. :-( Uwe Sunday, December 29, 2002, 1:14:02 PM, you wrote: DB> I have done more or less the same thing with my customers. It's a lot less DB> taxing on the

RE: excel as a vehicle to collect and write back data to a CF-App

2002-12-29 Thread Dave Babbitt
I have done more or less the same thing with my customers. It's a lot less taxing on the server to create the spreadsheet from HTML/CSV and have it run on the client than it is to manipulate it via an MS Office object on the server, but you end up doing both. I create the look I want for my Excel s