RE: Creating Datasources Using CF

2001-01-02 Thread Johan Coens
Check the CF Developer Gallery for creating datasources. Regards, Johan Coens -Original Message- From: Tan Siew Ling [mailto:[EMAIL PROTECTED]] Sent: dinsdag 2 januari 2001 5:01 To: CF-Talk Subject: Creating Datasources Using CF Hi All Can i write CF codes to create datasources

Re: Creating Datasources Using CF

2001-01-02 Thread Ken M. Mevand
i think datasources are just Windows registry entries. so maybe u can try using CFREGISTRY to add. -ken -Original Message- From: Tan Siew Ling [mailto:[EMAIL PROTECTED]] Sent: dinsdag 2 januari 2001 5:01 To: CF-Talk Subject: Creating Datasources Using CF Hi All Can i write CF

RE: Creating Datasources Using CF

2001-01-02 Thread Allan Pichler
This code has worked fine for me on a windows box! CFSET newdatasource = "Whatever" CFSET description = "" CFSET database = "whateverDB" CFSET server = "(local)" CFSET Trusted_Connection = "" CFSET UseProcForPrepare = "Yes" CFSET OEMTOANSI = "Yes" CFSET driver =

RE: Re[2]: Generating unique values

2001-01-02 Thread JustinMacCarthy
But it doesn't create values which are not easy to guess. Two consecutive UUID will have similar values + 1 Justin -Original Message- From: listmb [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 31, 2000 10:01 PM To: CF-Talk Subject: Re[2]: Generating unique values Thanks Nick,

RE: Creating Datasources Using CF

2001-01-02 Thread Stephen Moretti
Folks, You might want to bear in mind that it is not good to leave CFregistry active on a production server.. Regards Stephen -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 02 January 2001 10:46 To: CF-Talk Subject: RE: Creating Datasources

Re[4]: Generating unique values

2001-01-02 Thread listmb
Thanks this sounds like they are using a guid call to generate this. Is there some other algorihth i could use or ways I could do this? Thanks, WayGee Hello JustinMacCarthy, Tuesday, January 02, 2001, 6:15:41 AM, you wrote: J But it doesn't create values which are not easy to guess. J Two

RE: Re[4]: Generating unique values

2001-01-02 Thread JustinMacCarthy
Depends what you want to do but something like : cfset keylength = 10 ! length of key - cfset key ="" !--- the key "" to start cfloop from=1 to=keylength index=idx !--- you might want to change this, to use a different set of charactors if being used in a url for

Animated tutorial on assertions

2001-01-02 Thread Hal Helms
Happy New Year/New Millennium, everyone! I've put together an animated tutorial on making assertions in CF. Assertions help ensure that what we expect is what we get -- or at least we know if we don't! There's a link at www.halhelms.com as well as a custom tag for making assertions. Thanks to

RE: Creating Datasources Using CF

2001-01-02 Thread Stolpner, Richard J
Here is a CFHTTP method for creating the FastTrack to ColdFusion class Datasource. This might give you some ideas. CFHTTP URL="http://#CGI.SERVER_NAME#/cfide/administrator/datasources/editdsinfo.cfm " METHOD="POST" RESOLVEURL="YES" CFHTTPPARAM NAME="OriginalDSN" TYPE="FormField" VALUE=""

Sessions/cookies

2001-01-02 Thread Michael Ross
Sorry to ask a question about this but I am having problems. I set up my application.cfm for sessions. I am able to use them almost all the time. Then out of the blue I will get this error message. Error

Admin E-mail (newbie level question)

2001-01-02 Thread Scott Wolf
My brain has completely locked up on me (must had a bit too much to drink on Sunday), but I can't remember how to change the admin e-mail for a specific application. The CF-Administrator says it's possible, but I can't find it in the docs. If someone could help me, I'd really appreciate it.

RE: Admin E-mail (newbie level question)

2001-01-02 Thread JustinMacCarthy
CFERROR TYPE="Request" or "Validation" or "Monitor" or "Exception" TEMPLATE="template_path" MAILTO="email_address" EXCEPTION="exception_type" Justin -Original Message- From: Scott Wolf [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 2:46 PM To: CF-Talk

preparing for CF certification...

2001-01-02 Thread Jamie Keane
Hi folks. I'm thinking about going for my Allaire CF Certification in the moderately near future. What are some of the things I can do to help prepare? Just looking for suggestions. :) Thanks and hope you all had a happy and safe New Year's! Jamie -- Jamie Keane Programmer SolutionMasters,

Image Thumbnail

2001-01-02 Thread Chad Gray
Does anyone know of a good CF application or any other kind of tool to make a thumbnail image? I tried CF_AutoResize, and it worked very well. The only problem i had was some of my users will be uploading CMYK files, PDF's, all kinds of different image files. Thanks ~ Paid

RE: preparing for CF certification...

2001-01-02 Thread Nick Betts
Try looking at www.brainbench.com. They have a free certification exam on there which is good prep. Nick Betts -Original Message- From: Jamie Keane [mailto:[EMAIL PROTECTED]] Sent: 02 January 2001 15:18 To: CF-Talk Subject: preparing for CF certification... Hi folks. I'm thinking

Re: cfstoredproc problem

2001-01-02 Thread Sima . Lee
Hi, You might already solved the problem. Since I do not see any post here I reply it anyway. First, if you use SQL server , you have to set up the return code you self in the stored procedure. Because the default return code is 0. The stored procedure should look something like: CREATE

RE: preparing for CF certification...

2001-01-02 Thread JustinMacCarthy
Just make sure who know the blink tag :-) ~Cynical Justin Hi folks. I'm thinking about going for my Allaire CF Certification in the moderately near future. What are some of the things I can do to help prepare? Thanks and hope you all had a happy and safe New Year's! Jamie ~

Re: Sessions/cookies

2001-01-02 Thread Greg Wolfinger
SQL = "UPDATE tblsessions SET LOGIN = 'rumm01', LOGGEDIN = 'YES' WHERE IDNUMBER= na" Use single quotes around the na, so it should look like this UPDATE tblsessions SET LOGIN = 'rumm01', LOGGEDIN = 'YES' WHERE IDNUMBER='na' --Greg - Original Message - From: "Michael Ross" [EMAIL

Re: Image Thumbnail

2001-01-02 Thread Greg Wolfinger
Paint Shop Pro from Jasc Software (www.jasc.com) has a good batch operation that can do this. This however isn't done on the server on the fly. --Greg - Original Message - From: "Chad Gray" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 02, 2001 10:15 AM

Re: preparing for CF certification...

2001-01-02 Thread Kevin Schmidt
structures and error handling as well as some basic stuff not CF related (SQL, WebServer stuff etc) - Original Message - From: "Jamie Keane" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 02, 2001 9:18 AM Subject: preparing for CF certification... Hi folks.

Re: preparing for CF certification...

2001-01-02 Thread Ryan
At 10:51 1/2/01 -0600, you wrote: structures and error handling as well as some basic stuff not CF related (SQL, WebServer stuff etc) I hope its SQL and web server stuff in general, not MSSQL and IIS? I use linux/apache/MySQL, and am just starting to learn MSSQL. I hope to take the test in the

Re: Generating unique values

2001-01-02 Thread C Frederic Valone
I just checked this out by generating a loop of 50 uuid's and found that none of the values are incremented by 1 they differ in various ways although the last portion of the id is the same in all cases. Here is the list that was generated 00075D9C-F809-1A51-B7D6809AFF5FEEB7

Re: preparing for CF certification...

2001-01-02 Thread Jamie Keane
I've done that and scored a Master's Certification from it. Thanks though. :) -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Nick Betts [EMAIL

FW: Animated tutorial on assertions

2001-01-02 Thread Angél Stewart
Hey! That assert is good stuff. I must admit though, that I was blown away by that little Viewlet applet :) I think that's a great tool! :) Thanks to you for showing this animated tutorial utility to me heh heh -Gel -Original Message- From: Hal Helms [mailto:[EMAIL PROTECTED]] I've

RE: Windows 2000 Error Codes

2001-01-02 Thread Aaron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sarcasm aside, there's too many to have in one list. First stop, try Microsoft Knowledge Base Search: http://search.support.microsoft.com/kb/c.asp You can usually find any and all errors there. Aaron Johnson, MCSE, MCP+I Allaire Certified

RE: preparing for CF certification...

2001-01-02 Thread William J Wheatley
no its all generic i use Linux/Apache Sybase =) so its all basic stuff should be a breeze Bill Wheatley Director of Development AEPS INC Allaire ColdFusion Consulting Partner Allaire Certified ColdFusion Developer http://www.aeps.com ICQ: 417645 http://www.aeps2000.com 954-472-6684 X303

Re: preparing for CF certification...

2001-01-02 Thread Kevin Schmidt
I don't think anything is IIS specific. - Original Message - From: "Ryan" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 02, 2001 9:52 AM Subject: Re: preparing for CF certification... At 10:51 1/2/01 -0600, you wrote: structures and error handling as well as

RE: Animated tutorial on assertions

2001-01-02 Thread Hal Helms
Did I mention that I get 90% of anything you make with that, now? ;=) That is a great tool. It takes just a little getting used to cursor placement, but wow! Hal Helms == See www.ColdFusionTraining.com for info on "Best Practices with ColdFusion Fusebox" training, Jan 22-25 == -Original

OT: Alternative To SQL Server Enterprise Manager

2001-01-02 Thread Joe Sheble aka Wizaerd
I'm wondering if any CF'ers here has found an affordable alternative to SQL Server's Enterprise Manager? I had found SQL Navigator from http://www.quest.com/sql_navigator_ss/index.asp, but have found it lacking in a lot of areas, as well as buggy as h*ll... Enterprise Manager gives a lot of

RE: Generating unique values

2001-01-02 Thread Neil Clark
Erm, isnt this to do with the fact that the id's are taken from a combination of your NIC ID and your system clock? The fact that the template would have been processed in such a fraction of a second could be the answer. Just a thought. N ! --- Neil Clark

Can only send 2046 characters through CFMAIL?

2001-01-02 Thread Ryan
I am calling a custom tag that calls CFMAIL, no matter what content I put between the CFMAIL/CFMAIL tags, I only get 2046 characters of it when it arrives via email. If I just setup a simple CF template with just a single call to CFMAIL, all the characters come though. So I don't think its my

RE: Generating unique values

2001-01-02 Thread JustinMacCarthy
While this is true in your case , it depends on the machine being used etc. GUIDs are created using a complicated algorithm which take several factors into consideration. Sometimes this results in consecutive UUID (Guids) being 1 apart, other times it doesn't. It depends on the resource etc.

FirstDayOfMonth problems

2001-01-02 Thread Gina.M.Shillitani
I am trying to create an option in my CF calendar that allows repeating events that relocate themselves to the first business day of the month. For example, if the 1st falls on a Saturday, relocate that event to the 3rd, or Monday, the first business day. I have a problem with FirstDayOfMonth,

Re: Alternative To SQL Server Enterprise Manager

2001-01-02 Thread Chris Michl
You can filter out system tables in Enterprise Manager by right clicking on the server name and then selecting "Edit SQL Server Registration Properties". Uncheck "Show system databases and system objects." Chris - Original Message - From: "Joe Sheble aka Wizaerd" [EMAIL PROTECTED] To:

Re: Can only send 2046 characters through CFMAIL?

2001-01-02 Thread Ryan
At 11:33 1/2/01 -0500, you wrote: There is no difference between calling cfmail from a custom tag. And, since you've already done a test and it is not your mail server then I think there is more than likely a bug in your custom tag. If you post the code then it would be easier to diagnoe. OK,

Re: Alternative To SQL Server Enterprise Manager

2001-01-02 Thread Joe Sheble aka Wizaerd
that is exactly what the doctor ordered... thanx... It remains as an SDI application, but I've lived with it this long, guess I can take it a bit longer... At 10:41 AM 1/2/01 -0600, you wrote: You can filter out system tables in Enterprise Manager by right clicking on the server name and then

RE: preparing for CF certification...

2001-01-02 Thread Philip Arnold - ASP
structures and error handling as well as some basic stuff not CF related (SQL, WebServer stuff etc) I hope its SQL and web server stuff in general, not MSSQL and IIS? I use linux/apache/MySQL, and am just starting to learn MSSQL. I hope to take the test in the next year or so. Please tell

RE: Alternative To SQL Server Enterprise Manager

2001-01-02 Thread Daniel Lancelot
Hi, Its not perfect, and sometimes it falls over (slightly more often than enterprise manager), but access2000 offers a slightly more convienient interface that enterprise manager - to connect to a SQL db through access, create a new project to an existing datasource, and Robert is your Parental

setting structures into arrays

2001-01-02 Thread Greg Wolfinger
Hey Guys: I am having problems creating an array of structures and serializing it into a wddx package for client storage in a db. My code looks like this: cfscript history=ArrayNew(1); order=StuctNew(); StructInsert(order, "id", "0001"); StructInsert(order, "date",

RE: setting structures into arrays

2001-01-02 Thread Hal Helms
The problem is that setting the array variable as you have just puts a pointer to "order". When that changes, so will your reference. Instead, use "history[1] = Duplicate( order )". Hal Helms == See www.ColdFusionTraining.com for info on "Best Practices with ColdFusion Fusebox" training, Jan

RE: setting structures into arrays

2001-01-02 Thread JustinMacCarthy
Here is some code I use loop over a recordset (rs) and creates an array of structure with is stored as WDDX cfset MyArray = ArrayNew(1) cfloop query=rs cfscript tmp = StructNew(); tmp.ID = #id#; tmp.StatusCode = #statusid#; // add current thing to

Re: Can only send 2046 characters through CFMAIL?

2001-01-02 Thread Howie Hamlin
I just tried your code on a WIN2K server (sorry but I don't have a Linux box) and it works fine. The only thing that I can think of is that you're not terminating the message body with CRLF pairs and the body is one long line. If that's the case then you need to break up the lines with CRLF

RE: FirstDayOfMonth problems

2001-01-02 Thread Jeremy Allen
Your code is doing what you tell it to Gina :) ! cfset FirstBusinessDay = DateAdd("d",2,thedate) first business day = #DateFormat(firstbusinessday,", dd, ")# *NOTE* (BThis should return Monday, 04/02/2001 but returns Tuesday, 04/03/2001/B) Okay what is

RE: setting structures into arrays

2001-01-02 Thread Rick Lamb
I seem to remember last time I did something like this that ArrayAppend worked. Either way I know I found another way around this without using the duplicate function sense I was not using cfs 4.5. Let me know if you are in a similar situation and I will look up the code I used. Rick

RE: setting structures into arrays

2001-01-02 Thread Aaron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 It doesn't look like you're handling the name of the structure programatically so you could do this: !--- create a new array --- cfset history = arraynew(1) cfscript // populate the first structure order =

RE: Can only send 2046 characters through CFMAIL?

2001-01-02 Thread Philip Arnold - ASP
I just tried your code on a WIN2K server (sorry but I don't have a Linux box) and it works fine. The only thing that I can think of is that you're not terminating the message body with CRLF pairs and the body is one long line. If that's the case then you need to break up the lines with CRLF

Re: setting structures into arrays

2001-01-02 Thread Greg Wolfinger
Rick/Hal: The duplicate function worked like a charm since I am running 4.5. However, it would be nice to have a work around in case I run into this situation with a 4.0 live server. --Greg - Original Message - From: "Rick Lamb" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent:

wrap results in a table

2001-01-02 Thread Eric Fickes
Hello all, I was wondering if anybody knows of any way to wrap results list in a table? For the windows users, when you drop to a command prompt and use dir /w, it wraps the columns like I'd like to do. I'm sure there's a way to do a long drawn out script that compares the query.CurrentRow and

Re: Sessions/cookies

2001-01-02 Thread Jamie Keane
CF usually doesn't care about case (except for string comparison functions that aren't of the "NoCase" variety), but if you wanted to fake case-insensitivity just in case, use lcase() on the strings. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270

Re: FirstDayOfMonth problems

2001-01-02 Thread Jim McAtee
Gina, You're making just one mistake in your code. That's in using the function FirstDayOfMonth(). This function returns the ordinal day in the year, a number from 1 to 365 (or 366). When you then use the function DayOfWeek() on this number the results don't really have any meaning, since

RE: Alternative To SQL Server Enterprise Manager

2001-01-02 Thread Dylan Bromby
DB Artisan and ERStudio are pretty slick. -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 8:18 AM To: CF-Talk Subject: OT: Alternative To SQL Server Enterprise Manager I'm wondering if any CF'ers here has found an affordable

RE: Alternative To SQL Server Enterprise Manager

2001-01-02 Thread Lee Fuller
Actually, I'd like to find something that my clients can use, to login to their SQL database and make changes. Also, that will work with the security of the SQL server to keep unwanted eyes out of other DB's. (Kinda like what MySQL will do.) Lee -Original Message- From:

Re: Animated tutorial on assertions

2001-01-02 Thread dave fauth
Looks great. I was wondering what was in the "Copy of Neo" directory. dave At 09:19 AM 1/2/2001 -0500, you wrote: Happy New Year/New Millennium, everyone! I've put together an animated tutorial on making assertions in CF. Assertions help ensure that what we expect is what we get -- or at

RE: Alternative To SQL Server Enterprise Manager

2001-01-02 Thread Clint Tredway
One more thing, this is CF based. It will run on the web server so you cna get to it anywhere. -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 12:10 PM To: CF-Talk Subject: RE: Alternative To SQL Server Enterprise Manager Actually, I'd

RE: Alternative To SQL Server Enterprise Manager

2001-01-02 Thread Clint Tredway
I have a tool that does just that. It allows you to view data and update each row. You just plug in the DSN that is setup with CF admin and go. If anyone is interested let me know and I will send you a link to down load it. -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]]

RE: Creating Datasources Using CF

2001-01-02 Thread lsellers
Check the CF Developer Gallery for creating datasources. Hi All Can i write CF codes to create datasources instead of using cold fusion admin? Specifically, aeons ago I wrote cf_autoaddmdb. I believe there are others now. Requires CFREGISTRY. --min ~ Paid Sponsorship

RE: Can only send 2046 characters through CFMAIL?

2001-01-02 Thread lsellers
It *sounds* to me like like somewhere along the line there's a "char line[2048]" or "char line[2048+1]". That is, someone is assuming lines won't be more than about 2048 characters long (remember the crlf and the null). Which isn't a bad assumpttoin, considering I believe the official RFC's

Re: Alternative To SQL Server Enterprise Manager

2001-01-02 Thread C Frederic Valone
Id like to take a look at it Clint Clint Tredway wrote: One more thing, this is CF based. It will run on the web server so you cna get to it anywhere. -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 12:10 PM To: CF-Talk Subject: RE:

dynamic form controls

2001-01-02 Thread Cornillon, Matthieu
Happy new year, everyone. I have a form with a couple of drop down controls. I'll call them dd_country and dd_city. I would like the contents of dd_city to be based on the contents of dd_country. If the user selects France, the dd_city should hold Paris, Marseilles, Nice. If the user selects

RE: dynamic form controls

2001-01-02 Thread Aaron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi Matthieu, Check out Nate Weiss's tag to do exactly this: http://www.nateweiss.com/taggallery/TwoSelectsRelated/CF_TwoSelectsRel ated.html Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. phn617.350.0339

Re: dynamic form controls

2001-01-02 Thread Greg Wolfinger
You can preload all of the cities and all of the countries using JavaScript to get instant changes. This may take a while longer for the page to display on the users end. Or you could write a javascript that automatically submits the form to itself after changing the drop down list value that

Request VS Application scope

2001-01-02 Thread Bryan Love
Here's an interesting question: We all know that setting global variables in the request scope is faster and more thread-safe than using the Application scope, but does that remain true as we scale? Environment: 50 request variables are set in application.cfm (so they are set every time a page

RE: Alternative To SQL Server Enterprise Manager

2001-01-02 Thread Clint Tredway
If anyone has a problem getting this app running, shoot me an email and I will assist you. Here are the basics: There is a sql script in the sql scripts folder. create a database or run this script on an existing db and then in the application.cfm change the variable 'dsn' to the dsn you are

Re: Request VS Application scope

2001-01-02 Thread Greg Wolfinger
To my understanding using automatic read locking degrades the performance of a server greatly. Also, any performance degrade with using the Request scope won't make too much of a noticable difference. This is only my understanding, but I'm not positive. So as far as I am concerned the use of

Re: Request VS Application scope

2001-01-02 Thread Peter Theobald
But as a recent thread discussed, proper coding requires that you should always lock every access to an Application variable, in which case automatic read locking on Application scope variables does not degrade performance any more than manual read locking of every read of an Application scope

scheduling app. revisited

2001-01-02 Thread Todd Ashworth
A while back there were a few discussions on a scheduling app. Some people had expressed interest in looking at one that I am developing. The app is in an early alpha and more or less works, (as long as you don't try to break it ;), well enough to give you an idea of what it will do when 100%

Re: Request VS Application scope

2001-01-02 Thread Greg Wolfinger
So it appears your choice is to properly lock access to shared variables and take the slight performance hit using either automatic locking or manual locking, or do not properly lock access to shared variables and have an unstable server If I understand your response correctly (which I may

RE: Request VS Application scope

2001-01-02 Thread Jeremy Allen
One of the points to using application variables is the fact that they are persistent. The entire scope is a shared memory scope which means that your variables persist which means you dont have to continually set them every time. Request scope does not persist beyond one template call.. So the

Re: Request VS Application scope

2001-01-02 Thread Greg Wolfinger
In the real world ColdFusion doesnt handle its persistent variables so well. There is the factor of locking and many things that should not be visible to the developer (in a language like CF... which are). The reason why locking is visible to the developer is because it is much more

Help with a SQL statement

2001-01-02 Thread Andres
I need some help with a sql statement: I have two tables: 1 --- * teaserusers log_userstatus --- -- userid (varchar)logid (varchar) nickname (text) userid (varchar) firstname (text)fieldchanged (varchar) email (text)

Re: Help with a SQL statement

2001-01-02 Thread Greg Wolfinger
Can we see your current SQL statement? --Greg - Original Message - From: "Andres" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 02, 2001 4:42 PM Subject: Help with a SQL statement I need some help with a sql statement: I have two tables: 1

Access. um, access on a Linux box

2001-01-02 Thread Jamie Keane
Hi everyone, I have been asked to determine if there is a way for a client to run a CF/Linux/Apache box and maintain all DBs on a separate NT machine. Is there a good ODBC bridge that will fix this (preferably free/OSS)? I'm looking at a few potential possibilities, but I wanted to see if any

RE: Help with a SQL statement

2001-01-02 Thread Andres
SELECT teaserusers.userid, teaserusers.nickname, teaserusers.firstname, teaserusers.lastnames, teaserusers.email, teaserusers.registereddate, log_userstatus.* FROM

Re: Access. um, access on a Linux box Redux

2001-01-02 Thread Jamie Keane
Oops. I forgot to add: The two datasources we'd be connecting to are an Access DB and an Oracle DB. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message-

Re: Access. um, access on a Linux box

2001-01-02 Thread Ryan
At 17:05 1/2/01 -0500, you wrote: Hi everyone, I have been asked to determine if there is a way for a client to run a CF/Linux/Apache box and maintain all DBs on a separate NT machine. Is there a good ODBC bridge that will fix this (preferably free/OSS)? I'm looking at a few potential

Re: Access. um, access on a Linux box

2001-01-02 Thread Jamie Keane
The thing is these are existing datasources, and the admin who's going to be in charge of maintaining the servers has minimal NT experience. He wants to migrate over to Linux where the client was once using NT/Apache. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100

Re: Access. um, access on a Linux box Redux

2001-01-02 Thread Ryan
At 17:10 1/2/01 -0500, you wrote: Oops. I forgot to add: The two datasources we'd be connecting to are an Access DB and an Oracle DB. you should have no problem connecting to an Oracle database (running on any platform) from Linux. MS Access is harder. I know it can be done with perl, you can

A cure for CFDecrypt (don't get excited - it's humorous)

2001-01-02 Thread Howie Hamlin
http://mindprod.com/unmain.html ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe:

RE: Request VS Application scope

2001-01-02 Thread Benjamin S. Rogers
The reason why locking is visible to the developer is because it is much more efficient if the person writing the code, who knows how the application should work, decides where to lock and more importantly what type of lock to use. If the ColdFusion server had to decide whether to use a

RE: Adding items to Shopping cart

2001-01-02 Thread BORKMAN Lee
Well, yeah. The most basic approach is like this: 1) on your form, make a text box for each product, and name the text field quantity_XXX, where XXX is the product ID; 2) on your form-handler, loop through all of the form fields. If fieldName is of the form "quantity_XXX", and the value of

RE: A cure for CFDecrypt (don't get excited - it's humorous)

2001-01-02 Thread lsellers
http://mindprod.com/unmain.html Eeh. That's how I write me codelfish anyway. :) --min ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

ODBC Date/time with Javascript

2001-01-02 Thread Scott, Andrew
Can anyone point me to some resources or even tell me what functions are available to JS with regards to ODBC datetime values Is it possible to convert using JS to a normal date/time string. What I am looking at doing is using JS to compare that a cookie has expired, by doing a compare on

Differences between OLE and ODBC

2001-01-02 Thread Andres
Hello All, In my search to find out the time difference between OLE and ODBC, i created this little script. I have two simple queries: cfquery name="FindUsers" datasource="facilitadortestsite_ole" dbtype="OLEDB" debug SELECT * FROM TeaserUsers /cfquery cfquery name="FindUsers_odbc"

RE: Request VS Application scope

2001-01-02 Thread Peter Theobald
html font size=3Here Here!!br Finally someone seems to understand/agree with my frustration on this point.br br The way Cold Fusion handles locking is just DUMB. It is ASKING for application instability, which in the long run will ruin the reputation of Cold Fusion as a web development

RE: Request VS Application scope

2001-01-02 Thread Peter Theobald
Here Here!! Finally someone seems to understand/agree with my frustration on this point. The way Cold Fusion handles locking is just DUMB. It is ASKING for application instability, which in the long run will ruin the reputation of Cold Fusion as a web development environment. It is especially

Sorry

2001-01-02 Thread Phil Labonte
Test ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe:

RE: dynamic form controls

2001-01-02 Thread Mike Kear
I endorse Aaron's view. I spent most part of a day trying to figure out the javascript for doing this ( I really must spend time learning javascript!) and after I had finally got it to work, I read a post here on CF-talk about this CF_TwoSelectsRelated tag. The second page I did, using the tag,

OT: Update to Null

2001-01-02 Thread David Shadovitz
Is it possible to UPDATE the value of a numeric field to NULL? Here's the scenario, which must be common: The records of the Employees database table are displayed in an HTML table, with an Edit and Delete button in each row. The user clicks Edit to display a particular record in an editable

RE: Update to Null

2001-01-02 Thread Rick Lamb
UPDATE Employees SET Age = NULL WHERE Id = 2 This has always worked fine for me using MS SQL 7.0 and MS Access. Rick -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 9:31 PM To: CF-Talk Subject: OT: Update to Null Is it

Re: Update to Null

2001-01-02 Thread David Shadovitz
Hmm. I'm using Oracle. I thought I tried this just before I escaped from my office today. I'll try it again in the morning. Thanks. -David On Tue, 02 Jan 2001 22:27:17 -0600 [EMAIL PROTECTED] (Rick Lamb) writes: UPDATE Employees SET Age = NULL WHERE Id = 2 This has always

ot: where are my checkboxes?

2001-01-02 Thread Jon Hall
Sorry this is OT, but I cant figure this one out, and since I seem to have misplaced God's email address, my next best resource of omniscience would be cf-talk ;-) I have a collapsible JavaScript menu that is generated from a query. It works wonderfully in IE, but in Netscape my checkboxes are

Re: Alternative To SQL Server Enterprise Manager

2001-01-02 Thread moonerent
DataBaseBlocks is cool. http://www.commerceblocks.com Rick - Original Message - From: "Lee Fuller" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 02, 2001 10:10 AM Subject: RE: Alternative To SQL Server Enterprise Manager Actually, I'd like to find something

Is this a job for Verity?

2001-01-02 Thread Kay Smoljak
Hi all, I have an application hosted on CFAS 4.0.1/MS SQL Server 7 which requires a search feature for news articles. The article text for each item is stored in an external html file. The title, category, date and filename for each article is stored in the db. I am kinda stumped as to how I can