Re: clearing all sessions in an application

Do you have some sample code? On Thu, 3 Apr 2003 08:54:50 -0500, Tyler Silcox wrote: There is not an application wide session-clearer, so I always set a UUID, from CreateUUID(), in the application scope and in the user's session variables. Then if the application UUID is different from the

RE: clearing all sessions in an application

Cool...where would you place this code? In all application.cfm files? On Thu, 3 Apr 2003 15:40:35 +0100, Mike Townend wrote: CFLOCK TIMEOUT=5 THROWONTIMEOUT=No TYPE=READONLY SCOPE=SESSION CFSCRIPT Temp = StructNew(); Temp.CFID = Session.CFID;

re: cfquery UPDATE

Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database

Re: cfquery UPDATE

-vancouverisland.com - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:16 AM Subject: re: cfquery UPDATE Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds

Re: cfquery UPDATE

Nevermind...I found the problem. I had a input tag with a hidden field along with a text field. On Thu, 03 Apr 2003 12:56:05 -0500, FlashGuy wrote: WTF Here is my code: cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username

Re: cfquery UPDATE

Man I'm dense today. Figured it out. Used input type=password Doh. On Thu, 03 Apr 2003 13:13:20 -0500, FlashGuy wrote: I have it working now. Thanks Another question. I'm displaying the password in my template as by using input type=text name=Password value

Re: cfquery UPDATE

ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:56 AM Subject: Re: cfquery UPDATE WTF Here is my code: cfquery name=UpdateUser datasource

Submitting form. Passing variables to template

HI, Below is my code. I've removed some code just to make it easier to read. I have three templates. I'm listing the users from a database which gets a radio button inserted at the beginning of each field when displayed. When a user clicks on one of the radio buttons beside a users name I

Re: FOLLOWUP - Submitting form. Passing variables to template

=Selected value=#UserID# onFocus=this.blur();input type=hidden value=#UserID# name=Selected#GetUsers.Username#/td This is the result I get on my submit-action.cfm page: #FORM.Selected# = 8,8,4,7,5,6,3,1,2 On Thu, 27 Mar 2003 07:57:53 -0500, FlashGuy wrote: HI, Below is my code. I've removed some

Checking values of input passed to template

Hi again, I have four input tags that based on which one I click on passes the appropriate varaible. For example input type=image name=new src=cfoutput#Request.App.image_root#/cfoutputnew.gif onFocus=this.blur(); br input type=image name=delete

RE: FOLLOWUP - Submitting form. Passing variables to template

button tags. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: FlashGuy [mailto:[EMAIL PROTECTED] : Sent: Thursday, March 27, 2003 8:05 AM : To: CF-Talk : Subject: Re: FOLLOWUP - Submitting form. Passing variables to template

Re: Checking values of input passed to template

I've never used cfdump. Whats the syntax to dump the variables from the form? cfdump var=query Outputs: query On Thu, 27 Mar 2003 9:55:38 -0500, [EMAIL PROTECTED] wrote: When you use the image type in HTML is passes the .x and .y coords of where on the image you clicked. If you cfdump the

RE: Checking values of input passed to template

OK...now I get: FIELDNAMES NEW.X,NEW.Y NEW.X 11 NEW.Y 11 FORM.fieldnames: NEW.X,NEW.Y How can I check just for new? On Thu, 27 Mar 2003 16:11:19 +0100, Hugo Ahlenius wrote: Try: cfdump var=#Form# and check the manual...

DB and input

Hi, Why is this happening? I'm reading in fields from my database and dumpping them to input tags so that I can edit the lines if required and by clicking on a submit button saves the revised data fields back to my DB. If I put the cursor in a field to edit and hit the backspace to delete the

RE: DB and input

- : From: FlashGuy [mailto:[EMAIL PROTECTED] : Sent: Thursday, March 27, 2003 12:43 PM : To: CF-Talk : Subject: DB and input : : : Hi, : : Why is this happening? I'm reading in fields from my database and : dumpping them to input tags so that I can edit the lines if : required and by clicking

RE: iframes

for some other purpose? --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.671.8708 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent

Encrypting password

HI, I'm displaying all the fields from my database which also contains the users password in plain text. Is there a way to encrypt it when I display it to the screen? As *** or just a bunch of gobbly gook? #GetUsers.Password# --- Colonel

Submitting form from img

Hi, I have a form that I want to submit using an image rather than a input type=submit button. How can I do this? form action=action.cfm method=post img src=file.gif /form --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces

Re: iframes

Hi, I'm trying to create a larger input area for the user to key in information. This is what I have using an iframe but I can't seem to be able to input any information with the box? Is there another way of doing this? table cellpadding=0 cellspacing=0 border=0 tr

RE: iframes

Hmm...if I type in a large paragprah and I want to delete all of it whats the easiest way? I can't hilight it with the curser. The only way is to backspace all the text. I bit of a pain... On Tue, 25 Mar 2003 14:47:24 -0500, FlashGuy wrote: OK...thanks On Tue, 25 Mar 2003 11:37:16

RE: Getting XP Login Name?

Use cfset auth = #CGI.AUTH_USER# cfoutput #user# /cfoutput On Wed, 19 Mar 2003 13:33:30 -, Robertson-Ravo, Neil (RX) wrote: I woudl assume that if you can get to the registry you can get that info... -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent:

Stripping from variable

Hi, I have a variable called file which is being passed to my template via JS. The output always gets duplicated. file = test2test2 -OR- file = cubacuba How can I ouput just one occurrence? Is there some sort of match function? file = cuba

Using createUUID()

Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF?

RE: Using createUUID()

. -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 6:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10

RE: Using createUUID()

Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:05 AM To: CF-Talk Subject: RE: Using createUUID() If there is no change of duplication I like this ID#. In the code below. Would the UUID number be different for the hidden field when I eventually

Check if file on server is *read-only*

HI, Is there a way with CF to check if a file is read-only? I'm listing files on the server with cfdirectory. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba

Re: Check if file on server is *read-only*

Thanks On Mon, 17 Mar 2003 08:51:45 -0700, [EMAIL PROTECTED] wrote: On Windows systems, files that are read only will have an R in the attributes column when using cfdirectory. For *nix systems, you should be able to check the mode column. - Original Message - From: FlashGuy

OT: Saving webpage as a PDF document and retain links

Hi, This is off topic but has anyone had experience saving a webpage (with links etc.) to a PDF file and also retain the links that when clicked on in Acrobat opens those links? Can this be done? --- Colonel Nathan R. Jessop Commanding Officer

RE: Creating a auto-generated account number

It might require a format like TSC-number On Thu, 13 Mar 2003 18:04:52 -0500, John Quarto-vonTivadar wrote: If it doesn't need a specific format why not just use createUUID() ? -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 5:51 PM

Creating a auto-generated account number

Hi, I'm using CF and MySQL in a windows platform. I have a form that when opened I would like a unique account number generated for each form opened. Has anyone done this before? Whats the best way to go about it? --- Colonel Nathan R. Jessop

Using layers...div tags

Hi, I would like to duplicate one part from this website but I'm not sure how to go about it. http://www.mapleleafs.com/home.ml I want to create something similar to the SCORE, LEAFS TV and LEAFS INSIDER by clicking the tabs the content changes. Anyone have any code or would know how to do

input tag

Hi again, I have a form with two input tags. The Login button executes the file assigned to the form tag. How can I have the Logout button run a template file rather then the form? form action=index.cfm method=post input type=submit value=Login style=background:6C993F class=loginbutton

Re: Creating custom tag?

Hi, I have a box that I created that appears multiple times in my template. The only thing that gets modified is the text and the width in pixels based on ths ize on my input box. Is it possible to create a custom tag where I can enter in only the text and width measurements? For examle:

Re: Creating custom tag?

OK...so I don't have to do anything fancy. Just cut my code below into two files. Like so: CFMODULE TEMPLATE=../CustomTags/dialog_start.cfm TEXT=Whatever you want to say BXHEIGHT=100 BEWIDTH=200 input... input... input... CFMODULE TEMPLATE=../CustomTags/dialog_end.cfm ?? On Tue, 11 Mar 2003

Re: Creating custom tag?

Correct. It works great. Thanks On Tue, 11 Mar 2003 07:47:01 -0500, Randell B Adkins wrote: Yes just considering that the dialog_start would be the beginning part of your tabel then your inputs are within that table elements itself. Then you will need to close your tables thus I am

Re: Creating custom tag?

Opps...not quite. Would I put these in my application.cfm along with my APPLICATION. stuff? referenced in the ATTRIBUTE Scope: ATTRIBUTE.TEXT ATTRIBUTE.BXHEIGHT ATTRIBUTE.BXWIDTH On Tue, 11 Mar 2003 07:48:47 -0500, FlashGuy wrote: Correct. It works great. Thanks On Tue

Re: Creating custom tag?

=this.blur(); input type=hidden name=theTime value=#DateFormat(todayDate, , dd, )# /cfoutput CFMODULE TEMPLATE=dialog_end.cfm On Tue, 11 Mar 2003 07:52:50 -0500, FlashGuy wrote: Opps...not quite. Would I put these in my application.cfm along with my APPLICATION. stuff

RE: Creating custom tag?

Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent

input radio buttons

HI, I have the following radio buttons: input type=radio name=Yesnbsp;Yesbr input type=radio name=Nonbsp;No Currently I can click on both the yes and no and they both get selected. I don't want that to happen. The user should only be able to select one. How can I do

Inserting date/time stamp

Hi, I have a form that I want to insert the date and time when the form is opened. This will also be saved to a database when saved. Whats the best way of also creating a automatic reference no which increments when a new form is opened? Any ideas...

RE: Inserting date/time stamp

: www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:14 PM To: CF-Talk Subject: Inserting date/time stamp Hi, I have

RE: Inserting date/time stamp

, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: FlashGuy [mailto:[EMAIL

RE: Inserting date/time stamp

? -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: FlashGuy [mailto:[EMAIL PROTECTED] : Sent: Monday, March 10, 2003 2:14 PM : To: CF-Talk : Subject: Inserting date/time stamp : : : Hi, : : I have a form that I want to insert

RE: Inserting date/time stamp

wrote: dateformat() and timeformat() should take care of display issues nicely for you. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: FlashGuy [mailto:[EMAIL PROTECTED] : Sent: Monday, March 10, 2003 2:27 PM : To: CF-Talk

RE: Inserting date/time stamp

Right, but the idea I was trying to achieve was to keep the look the same (with the input field) so it matches the rest of the form. From: FlashGuy [EMAIL PROTECTED] How can I stop people of editing the input line where I'm dumping the date? I don't want them to be able to change

CF and MySQL

Hi, I've installed MySQL. I can't seem to verify the databases within the CF Adminstrator. I created the data source within the System DSN. I then go into the CF Admin and try to verify the database but it fails. I've also installed MyODBC for MySQL Why? I cant see the database with

input button using a graphic

Hi, How can I have a image file for my submit button rather than what being specified in the VALUE attribute? input type=submit name=SubmitCheck value=[D] --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay,

Deleting entries from database via checkbox

HI, I'm displaying entries from my database in my template. I have input checkboxes displayed on every line. I would like to be able to check on a box or multiple boxes and when a click on my Delete button on my template those entries are deleted from my database. Here is the code that

Re: Force authentication screen

Hi, I have a login template and database authentication that works great. My question is. How can I force the user to always authenticate after the browser has been closed or they click on the logout button on my template? How can I also stop them from dragging a shortcut to the desktop to

RE: Force authentication screen

uses for session management never get written to disk, thus memory resident only, and thus gone when the browser closes. HTH, Mike -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 7:06 AM To: CF-Talk Subject: Re: Force

RE: Force authentication screen

=CFTOKEN value=#localCFTOKEN# /cfif The makes sure that the cookies that CF uses for session management never get written to disk, thus memory resident only, and thus gone when the browser closes. HTH, Mike -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent

Logging out of application

HI, I have a logout button in my application. When clicked I want to sent the user back to the login screen. This works just fine. The problem I'm having is if I click on the back button in IE I'm able to go back to that page. I don't want this to happen. How can I clear all session varaibles

Re: Logging out of application

not sure if this will work but try CFHEADER cfheader name=location value = someurl.html cfheader statusCode = 302 statusText = Document Moved. Let us know Thanks Paul Giesenhagen QuillDesign - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent

RE: Logging out of application

THis would go into the top of my logoff.cfm file? I tried it and I can still click the IE back button and go back the the previous template. On Thu, 27 Feb 2003 12:17:26 -0600, Andy Ousterhout wrote: CFHEADER NAME=Expires VALUE=Now() CFHEADER NAME=Pragma VALUE=no-cache CFHEADER

RE: Logging out of application

On Thu, 27 Feb 2003 13:32:12 -0500, Dave Watts wrote: THis would go into the top of my logoff.cfm file? I tried it and I can still click the IE back button and go back the the previous template. This would need to go into each page that is currently being cached by the browser, that

Whats wrong with this code?

Hi, Whats wrong with the below code? I get a SQL syntax error. cfquery name=qInsertData DATASOURCE=databaser INSERT INTO results ( FileName, Command, CreatedOn, LastAcc, LastMod, Size, Directory, Username, New, Copy, Delete, Move, Rename, Description

RE: Whats wrong with this code?

Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 2:43 PM To: CF-Talk Subject: Whats wrong with this code? Hi, Whats wrong with the below code? I get a SQL

RE: Whats wrong with this code?

-Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 2:55 PM To: CF-Talk Subject: RE: Whats wrong with this code? No. They are all VARCHAR(50) to VARCHAR(255) On Thu, 27 Feb 2003 14:52:50 -0500, Bryan F. Hogan wrote: Are all you

Creating a login screen

Hi, I want to create a login screen that allows the user to create his own password at initial login. So if the password field is empty in the database a Create password input would appear. Once they type in the password and click the Login button then another login template would open with

Inserting into MySQL database

Hi, I have nine variables that I want inserted into my database. cfquery name=qInsertData DATASOURCE=results Insert into myresults (strFileName, strCommand, strCreatedOn, strLastAcc, strLastMod, strSize, strDirectory, strDateCommand, strUsername) VALUES ('#Filename#', cfqueryparam

Checking variables

Hi, I have two variables. I need to check if the contents of the first variable exists in the second and if it does to something and if not do something else. How can I do this with a cfif statement? Example: var1 = mywork var2= C:\temp,C:\windows,c:\program files,c:\tmp DO THIS Or it could

Updating database

Hi, I have this code that updated my MySQL database successfully. I'm testing this out on another PC with just Access. WHen I try to update the database I get the following error? Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or

RE: Updating database

) VALUES('#ListGetAt(Line,1,|)#','#ListGetAt(Line,2,|)#') /cfquery -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: dinsdag 21 januari 2003 13:49 To: CF-Talk Subject: Updating database Hi, I have this code that updated my MySQL database successfully

Re: Updating database

Why do I need an INSERT command? I just want to update my table field. This worked fine in MySQL. On Tue, 21 Jan 2003 14:24:04 +0100, Jochem van Dieten wrote: FlashGuy wrote: Access: -- cfquery name=Update DATASOURCE=prefs dbtype=ODBC UPDATE tblProfiles (strSelect

Re: Updating database

I never received any errors when the code was run? On Tue, 21 Jan 2003 08:38:04 -0500, Todd wrote: I'll be surprised if it worked in MySQL. It's not even a valid SQL Statement. The statement you want is: UPDATE tablename SET (field) = (value) WHERE primaryKey = something RTM:

Re: Updating database

No. I guess I should. On Tue, 21 Jan 2003 08:50:39 -0500, Todd wrote: Then, MySQL is definitely broken. Did you report this to the MySQL dev team as a bug? At 08:48 AM 1/21/2003 -0500, you wrote: I never received any errors when the code was run? On Tue, 21 Jan 2003 08:38:04 -0500,

WTF! Data Sources

Hi, I had MySQl installed. Converted all my Access databases over no problem. All my databases were working fine. Without going into too much detail on why...I uninstalled MySQL. Removed the data sources (ODBC) from the Control Panel and CF Administrator. I rebooted the PC and tried to enter

Re: WTF! Data Sources

That worked. Thanks On Tue, 14 Jan 2003 17:57:59 -, Stephen Moretti wrote: I had MySQl installed. Converted all my Access databases over no problem. All my databases were working fine. Without going into too much detail on why...I uninstalled MySQL. Removed the data sources (ODBC)

Incrementing a variable

Hi, For some reason I can't get my variable to increment when my page is reloaded. I have the following in my application.cfm file cfset child = 0 In my index.cfm file I have the following. cfset child=child + 1 Everytime I refresh the page manually or by using an a href within mu file to

RE: Incrementing a variable

index.cfm sets child = child + 1 = 1 Webguy -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 17 December 2002 12:12 To: CF-Talk Subject: Incrementing a variable Hi, For some reason I can't get my variable to increment when my page is reloaded

RE: Incrementing a variable

=Application.child DEFAULT=0 /CFLOCK And in the index file CFLOCK TIMEOUT=5 THROWONTIMEOUT=No TYPE=EXCLUSIVE SCOPE=APPLICATION CFSET Application.child = Application.Child + 1 /CFLOCK HTH -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17

Re: Incrementing a variable

to zero What are you trying to do? Taz - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 12:12 PM Subject: Incrementing a variable Hi, For some reason I can't get my variable to increment when my page

Re: Incrementing a variable

: cif not isdefined(application.child) cfset application.child = 0 /cfif and cfset application.child = application.child + 1 - Original Message - From: FlashGuy [EMAIL PROTECTED] I have the following in my application.cfm file cfset child = 0 In my index.cfm file I have

RE: Incrementing a variable

index.cfm sets child = child + 1 = 1 3rd view of index.cfm appliation.cfm sets child = 0 index.cfm sets child = child + 1 = 1 Webguy -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 17 December 2002 12:12 To: CF-Talk Subject

Checking

I need to check if part of one string matches part of another. For example, I have to variables. dir = D:\documents\test strShowMe = documents\test,documents\test2,mywork\test,misc\test Using cfif how could I check to see if any text from the dir variable, either documents or test return a

RE: Incrementing a variable

= session.Child + 1 /CFLOCK WG -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 17 December 2002 13:02 To: CF-Talk Subject: RE: Incrementing a variable No...no error. code works just fine. Its not not behaving like I want it to. On Tue, 17

REReplace

For some reason I can't to a replace on the following: dir = D:\\ cfset test = #RERplace(dir,\\,\,ALL)# --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba ---

Re: REReplace

Nevermind... On Mon, 16 Dec 2002 12:29:23 -0500, FlashGuy wrote: For some reason I can't to a replace on the following: dir = D:\\ cfset test = #RERplace(dir,\\,\,ALL)# --- Colonel Nathan R. Jessop Commanding Officer Marine

Login/Password screen

Hi, I know there are alot of custom tags out there that will do what I'm looking for but I want the best one. So this is why I'm asking all of you hoping you've had some experience with some of them. I'd like everything stored in a database. I know some don't do that. Bascially, once the user

RE: Login/Password screen

, if a matching record is found, the queries record count will be 1 and you can authenticate the user, that's quite simplistic but basically all you need. Have a go, you know you want to ;-) -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 13 December 2002 12:43

Re: Login/Password screen

On Fri, 13 Dec 2002 13:48:25 +0100, Jochem van Dieten wrote: Quoting FlashGuy [EMAIL PROTECTED]: I know there are alot of custom tags out there that will do what I'm looking for but I want the best one. So this is why I'm asking all of you hoping you've had some experience with some

Re: Login/Password screen

On Fri, 13 Dec 2002 14:30:01 +0100, Jochem van Dieten wrote: Quoting FlashGuy [EMAIL PROTECTED]: On Fri, 13 Dec 2002 13:48:25 +0100, Jochem van Dieten wrote: Can you post a full list of requirements? - validate users - database for authenitcation - redirection to different URLS

Re: Login/Password screen

to the login screen or what ever screen is needed. If you need help with this, just let me know. HTH Clint - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, December 13, 2002 7:15 AM Subject: RE: Login/Password screen

RE: Login/Password screen

with the server. -Kevin -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 6:43 AM To: CF-Talk Subject: Login/Password screen Hi, I know there are alot of custom tags out there that will do what I'm looking for but I want

Updating two fields

Hi, I need to update two fields in my database. For example, I have two fields called data1 and data2. THe below code updates only data1 field. Whats the correct syntax to also update data2 field at the same time? cfquery name=Update datasource=db dbtype=ODBC UPDATE

Querying a database

Hi, Can the below be easily done from a database? The idea would be to add/remove directories from the database which would be inserted in the code below. This is just a snippet from my cfdirectory cfloop index=LineNo from=#i# to=#i# cfif Session.stDirFileType[i] eq Dir OR

Stripping variable

Hi, I have the following variable (which can change based on directory). Below is the output from some examples: dir = D:\mywork\temp dir1 = D:\mywork\temp\dir1 How can I output only temp or dir1 from the above variables? --- Colonel Nathan

CF and mySQL

There is something wrong with my syntax. I just converted my Access database over to mySQL. Whats wrong with the cfqueryparam? I get ? question marks inserted into the database when I execute the updated code. Before: - cfquery name=update_alias DATASOURCE=Alias Insert into alias

RE: CF and mySQL

I actually get the ? inserted into my two fields in the database. On Tue, 3 Dec 2002 15:23:58 -, Mike Townend wrote: Do you actually get the ? inserted into the DB or does the Query debug show a ? ? -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent

RE: CF and mySQL

: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 15:17 To: CF-Talk Subject: CF and mySQL There is something wrong with my syntax. I just converted my Access database over to mySQL. Whats wrong with the cfqueryparam? I get ? question marks inserted into the database when I execute

RE: CF and mySQL

=CF_SQL_LONGVARCHAR, You are inserting the placeholder. -Mark -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 9:17 AM To: CF-Talk Subject: CF and mySQL There is something wrong with my syntax. I just converted my Access database

RE: CF and mySQL

Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 9:47 AM To: CF-Talk Subject: RE: CF and mySQL I did and I still get ? inserted in the database? cfquery name=update_alias DATASOURCE=Alias UPDATE alias SET env_var = cfqueryparam value=#FORM.env_var

RE: CF and mySQL

Correct. Thats the reason for the cfqueryparam... On Tue, 3 Dec 2002 15:49:04 -, Robertson-Ravo, Neil (RX) wrote: doesn't mySQL use \ for something internally? I had a problem with it ages back can't remember what it was though! -Original Message- From: FlashGuy [mailto

RE: CF and mySQL

On Tue, 3 Dec 2002 17:00:38 +0100, Jochem van Dieten wrote: Quoting FlashGuy [EMAIL PROTECTED]: I did and I still get ? inserted in the database? cfquery name=update_alias DATASOURCE=Alias UPDATE alias SET env_var = cfqueryparam value=#FORM.env_var# cfsqltype

RE: CF and mySQL

Got it. Thanks On Tue, 03 Dec 2002 11:07:55 -0500, FlashGuy wrote: Correct. Thats the reason for the cfqueryparam... On Tue, 3 Dec 2002 15:49:04 -, Robertson-Ravo, Neil (RX) wrote: doesn't mySQL use \ for something internally? I had a problem with it ages back can't

Checking SESSION variable

Hi, I have session variable that contains the directory name session.strFileName. I also have another session variable session.ShowMe that contains multiple directory names (comma-delimited) which i'm setting from my database. Basically, i need to check if the directory session.strFileName

Re: Checking SESSION variable

Actually, the session.strFileName would have no path in it. sesion.strFileName = Temp sesion.ShowMe = D:\Temp,D:\Test On Mon, 02 Dec 2002 11:11:43 -0500, Randell B Adkins wrote: CFIF LISTCONTAINSNOCASE(session.ShowMe,session.strFileName) I think this is what you are asking.

Re: CFEXECUTE and Perl Scripts

Have you tried modifying the Perl script to handle additional arguments being passed at the command prompt. I had a similar problem and fixed it by doing so. On Wed, 27 Nov 2002 14:28:19 -0500, David Adams wrote: I am having a hard time calling a PERL script from a CFEXECUTE tag. It seems to

Re: Listing/adding/deleting checkboxes generated from database - CONTINUED THREAD

Hi, Currently I have the following fields in my database: Database name: test table: tblprofiles fields: strUser_ID (auto-generated) strUserName strGroup strSelect strSelectFlag strShow Contents of above fields for example purposes:

Re: Listing/adding/deleting checkboxes generated from database - CONTINUED THREAD

Hi everyone, Sorry, Please ignore this posting. On Mon, 25 Nov 2002 09:55:11 -0500, FlashGuy wrote: Hi, Currently I have the following fields in my database: Database name: test table: tblprofiles fields: strUser_ID (auto-generated) strUserName strGroup

  1   2   3   >