Dreamweaver's ColdFusion Login Wizard problem

2014-02-24 Thread Scott Williams
Have any of you run into this problem, and if so, were you able to fix it? Scott Williams > > From: Brook Davies >To: cf-talk >Sent: Wednesday, February 22, 2012 9:44 AM >Subject: RE: Ram Disk problem under load > > > >Hi Pete, >

Re: Choosing Today's Records from a MySQL Database

2011-04-29 Thread Scott Williams
.:.:.:.:.:.:.:.:.:.:.:. >Bobby Hartsfield >http://acoderslife.com >http://cf4em.com > > > >-Original Message- >From: Scott Williams [mailto:myscottwilli...@yahoo.com] >Sent: Friday, April 29, 2011 10:20 PM >To: cf-talk >Subject: Choosing Today's Recor

Choosing Today's Records from a MySQL Database

2011-04-29 Thread Scott Williams
Hi geniuses! I have a MySQL table with a field (fieldtype = timestamp) named DateTime, and whenever a record is added to this table, the DateTime field automatically enters the current date and time.  In a query, I want to choose only those records that were entered today, like this: WHERE C

Re: Appending Data into a Table from Another Table in MySQL

2011-04-23 Thread Scott Williams
table2 Azadi On 23/04/2011 11:51 , Scott Williams wrote: > Hello geniuses! > > I've been largely successful exporting my Access database into MySQL, but > have one problem. The SQL dump file for one of my tables is just a smidge too > large to import (the host limits the size

Appending Data into a Table from Another Table in MySQL

2011-04-22 Thread Scott Williams
Hello geniuses! I've been largely successful exporting my Access database into MySQL, but have one problem. The SQL dump file for one of my tables is just a smidge too large to import (the host limits the size to 2048, and my sql file is 2137). Anyway, I just broke the table into two, Table1 a

MySQL Conversion

2011-04-19 Thread Scott Williams
Oy -- I shouldn't have started this one until the weekend. I'm converting from MS Access to MySQL on one of my ColdFusion sites, and having problems converting my Autonumbered Access tables to MySQL format. They just won't import at all. If I remove the primary key and change the format to Int

Re: Printing Envelopes

2011-04-15 Thread Scott Williams
Never mind -- I figured it out. I used CSS and now it's working fine.   Scott From: Scott Williams To: cf-talk Sent: Friday, April 15, 2011 6:11 PM Subject: Printing Envelopes Hi all -- I have a question that's vaguely ColdFusion related. I wan

Re: Printing Envelopes

2011-04-15 Thread Scott Williams
age- > From: Scott Williams [mailto:myscottwilli...@yahoo.com] > Sent: Saturday, 16 April 2011 11:12 AM > To: cf-talk > Subject: Printing Envelopes > > > Hi all -- > > I have a question that's vaguely ColdFusion related. I want to print #10 > envelopes with informat

Printing Envelopes

2011-04-15 Thread Scott Williams
Hi all -- I have a question that's vaguely ColdFusion related. I want to print #10 envelopes with information pulled from a database. That's the CF part, and that's easy. The hard part is getting the text to appear where I want it on the page. I tried using a 4.125" x 9.5" table (which is the

Re: Including multiple variables within a database response

2011-04-02 Thread Scott Williams
, "DECISIONMAKER,MYNAME", "Bob,Scott") On 4/2/2011 12:57 PM, Scott Williams wrote: > LOL -- I was afraid of that! It reminds me of the portrait of Stephen Colbert > standing in front of a portrait of Stephen Colbert standing in front of a > portrait of Stephen Colb

Re: Including multiple variables within a database response

2011-04-02 Thread Scott Williams
t did you read the article I linked to? This does explain how to do exactly what you need and a lot more. On Sat, Apr 2, 2011 at 6:21 PM, Jason Fisher wrote: > > Can use replaceList() instead. > > replaceList(mystring, "DECISIONMAKER,MYNAME", "Bob,Scott") > &g

Re: Including multiple variables within a database response

2011-04-02 Thread Scott Williams
:05:28 AM Subject: Re: Including multiple variables within a database response replace(replace(mystring, "DECISIONMAKER", "Bob", "all"), "MYNAME", "Scott", "all") On Sat, Apr 2, 2011 at 11:00 AM, Scott Williams wrote: > > Wow!

Including multiple variables within a database response

2011-04-02 Thread Scott Williams
Wow! This works great! What if there are multiple things to replace within the variable? For example, you have a string like: "Hi DECISIONMAKER. This is MYNAME." I want to replace DECISIONMAKER with "Bob" and I want to replace MYNAME with "Scott." Scott Will

Including a variable within a database response

2011-04-01 Thread Scott Williams
Hi all -- I have a script that draws some text from a database, and I would like to embed a person's name within the text. For example, the database field contains this text: Hi #name#. How's it going? I would like the #name# to be replaced with a previously defined variable "name." Can Col

Re: Processing Empty Form Fields

2011-03-30 Thread Scott Williams
Hi Les -- That solved my problem. Thanks! Scott - Original Message From: Les Mizzell To: cf-talk Sent: Wed, March 30, 2011 7:08:02 PM Subject: Re: Processing Empty Form Fields > SET Name = Do the below. Will insert a null if the field is empty..

Processing Empty Form Fields

2011-03-30 Thread Scott Williams
Hi all -- I have an edit record form that populates the fields with values from a database. The user can make changes to the information, click the Submit button, and the database is updated. Here's the code for the Update query: UPDATE Accounts Set Name='#form.Name#', PlanYearStartDate='#f

Re: CFSchedule

2011-03-11 Thread Scott Williams
PM, Scott Williams wrote: > > Russ wins! > > That is indeed what was happening. In the Application.cfm file, there's some > code that checks to see if a user has logged in. I moved my files to a >directory > with its own Application.cfm file, which contained no content, a

Re: CFSchedule

2011-03-11 Thread Scott Williams
xclude the scheduled task outside of your login routine or use webserver authentication instead. On Fri, Mar 11, 2011 at 9:00 PM, Scott Williams wrote: > > Hi all -- > > I'm trying to use CFSchedule to have automatic emails sent. I don't have > access > to the CF Admi

CFSchedule

2011-03-11 Thread Scott Williams
Hi all -- I'm trying to use CFSchedule to have automatic emails sent. I don't have access to the CF Administrator, so I'm using the CFSchedule tag. So far it hasn't worked. Here's my code: http://www.studioregionperformers.com/DailyWhatToDoTodayEmail.cfm"; startdate="1/1/2011" starttime="12:0

Re: Check boxes

2011-03-04 Thread Scott Williams
Never mind -- I figured it out. This works: UPDATE aTable SET ColumnA = '#form.var1#' WHERE ColumnB IN (#form.var2#) I had tried using IN in my update query except that I didn't include the parentheses. Scott ~| Order the

Check boxes

2011-03-04 Thread Scott Williams
Hello all -- I have a form that contains checkboxes which sends multiple record numbers to an action form for processing. For example, it would send: formfield1="ABC" formfield2=1,2,3,4,5,6,7 In the database I want to update the formfield1 column to ABC wherever the formfield2 column value i

How to Make Layers Visible with OnMouseOver

2009-08-21 Thread Scott Williams
Hi all -- I can't figure out how to make Layer2 in this document visible when I mouseover the tag around the newbridgecollege.edu link. Can anyone help me with this? Scott * Valley Career College