Re: SOT: Getting data into a web site

2006-06-13 Thread Sam Farmer
If the spreadsheets are in a standard layout you could allow users to upload them. Then in CF connect to the spreadsheet via a datasource and get the data that way. Cheers, Sam F On 6/13/06, Chris Mueller <[EMAIL PROTECTED]> wrote: > Actually, applications like Google Spreadsheets sup

CFC Weird 500 Error

2006-05-22 Thread Sam Farmer
nable(ThreadPool.java:295) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Any ideas? It only just started happening. Cheers, Sam (Cross posted to cfcDev) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241132 Arc

Re: Question about counting in SQL

2006-04-27 Thread Sam Farmer
Chris, You can use the WHERE clause. This should work fine: SELECT Author.AuthorID, Author.AuthorName, COUNT(*) AS NumBooks FROM Author RIGHT JOIN Book ON Author.AuthorID = Book.AuthorID WHERE Book.Active =1 GROUP BY Author.AuthorID Cheers, Sam F On 4/27/06, Chris Mueller <[EMAIL PROTEC

Re: Why is there query.recordcount with non-SELECT queries?

2006-04-20 Thread Sam Farmer
> CF7 has a result attribute on the query tag. It returns a structure of information including the SQL, number of records affected, time and some other stuff. Cheers, Sam ~| Message: http://www.houseoffusion.com/lists.cfm/l

Saving files

2006-04-07 Thread sam clement
This probably doesn't have a coldfusion specific answer but I thought i'd ask anwyay. I'm trying to build an intranet application that will allow users to click on links to open up files. This works fine using cfheader and cfcontent, the file opens nicely in the appropriate application (MS Word o

Read CF Registry Keys -Re Posted

2006-03-22 Thread Sam Komo_ITS
Hi, I am trying to purge client registry keys from coldfusion. I want to do it incrementally. How do I first get the number of records (say 50) that I will like to delete using cfRegistry's Get attribute. Thanks Sam --- [This E-mail scanned for vi

Read CF Registry Keys -Re Posted

2006-03-20 Thread Sam Komo_ITS
Hi, I am trying to purge client registry keys from coldfusion. I want to do it incrementally. How do I first get the number of records (say 50) that I will like to delete using cfRegistry's Get attribute. Thanks Sam --- [This E-mail scanned for vi

Read CF Registry Keys

2006-03-20 Thread Sam Komo_ITS
Hi, I am trying to purge client registry keys from coldfusion. I want to do it incrementally. How do I first get the number of records (say 50) that I will like to delete using cfRegistry's Get attribute. Thanks Sam - Original Message - From: "Raymond Camden" <[EM

CF7 PDF Generation

2006-03-16 Thread Sam Komo_ITS
Hi Can I use cfdocument to format the first page of a report. Essentially the first page to look differently from the rest because headers/logos etc. Thanks Sam --- [This E-mail scanned for viruses.] ~| Message: http

Re: Any way to suppress a tag at the applicaiton level?

2006-03-16 Thread Sam Farmer
The cftimer tag only runs when debugging is turned on AND the option called 'Timer Information' is checked. And hopefully you have debugging turned off in production. Cheers, Sam F On 3/16/06, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > > I was wondering if it'

Re: Strange, strange CFC Error: Null Pointer

2006-03-15 Thread Sam Farmer
Thanks M!ke. I've passed the info on to my host. On 3/15/06, Dawson, Michael <[EMAIL PROTECTED]> wrote: > Sam, I had the exact same problem after I updated to the CF HotFix2. > > I had to completely uninstall CF, then reinstall before it would work > again. > >

Strange, strange CFC Error: Null Pointer

2006-03-15 Thread Sam Farmer
se an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. Cheers, Sam ~| Message: http://www.houseoffusion.com/lists.cfm/lin

Re: getDate()

2006-03-06 Thread Sam Farmer
Its probably because in SQLServer getDate() returns a full date with time information down to the millisecond. Depending on how accurate your dates are this might be a simple fix: dateAdded BETWEEN getDate()-1 and getDate() Cheers, Sam F On 3/6/06, Richard Cooper <[EMAIL PROTECTED]>

Re: cfdocument how to use on a .cfm to print a form?

2006-02-15 Thread Sam Farmer
Something like this is, I think, what you are looking for: Then have a link a href="#cgi.script_name#?print=">Print This/a> Cheers, Sam F On 2/15/06, carol Tobey <[EMAIL PROTECTED]> wrote: > What I need to do is have basically two versions of a .cfm

Re: page layout: cfmodule vs customtags

2006-02-12 Thread Sam Farmer
cfimport is quicker I believe than cfmodule from a processing point of view. On 2/12/06, dave <[EMAIL PROTECTED]> wrote: > you know what i mean ray. > ok lets rephrase thats > > cfmodule vs cfimport > > ~Dave the disruptor~ ~| Me

Re: Smallest, coolest function I ever wrote: Struct()

2006-01-05 Thread Sam Farmer
You could use the built in listToArray myarray = listToArray('homer,marge,bart'); Cheers, Sam F On 1/4/06, Ryan Guill <[EMAIL PROTECTED]> wrote: > How about one for an array? > > This is pretty cool. >

Re: CF Flash Forms and FCKeditor - do they work together?

2005-12-19 Thread Sam Farmer
It won't work. In Flash forms you can only use simple html and nothing anywhere near as complex as required for FCK Editor. Flex has a built in WYSIWYG editor but its not availible to flash forms (though maybe in a future release?) Cheers, Sam F On 12/19/05, David Adams <[EMAIL P

Re: Dumb CF methodology question

2005-12-19 Thread Sam Farmer
I wrote about a framework we use, CFMVC, for CFDJ: http://coldfusion.sys-con.com/read/49185.htm Cheers, Sam F On 12/16/05, Sean Corfield <[EMAIL PROTECTED]> wrote: > On 12/16/05, Phill B <[EMAIL PROTECTED]> wrote: > > I know there is Mach II and Model-Glue out th

Best Practice: Additional Functions in Application.cfc

2005-12-09 Thread Sam Farmer
Start)? Cheers, Sam F ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start trackin

Re: Custom Tags Folder

2005-12-07 Thread Sam Farmer
Take a look at using , that may solve your problem, although you will have to change how you call each tag. You can define a custom tag folder in the administrator but they are global settings so would affect all code you run on that machine. Cheers, Sam F On 12/7/05, Brian Peddle <[EM

Re: Bar Code Scanners & ColdFusion

2005-12-01 Thread Sam Farmer
you can install that will do this as well. Do you want CF to produce bar codes or read input from a bar code reader or both? Cheers, Sam F On 12/1/05, jonese <[EMAIL PROTECTED]> wrote: > Anyone have experiance with tying in a bar code scanner and an online > inventory app in CF? Bas

Re: Get path of page calling cfinvoke?

2005-11-29 Thread Sam Farmer
GetCurrentTemplatePath() might get you what you want. But Barney's second paragraph hits the nail on the head. CFC's should never need this type of information (except _perhaps_ for logging?? and if you needed that). Cheers, Sam F On 11/28/05, Barney Boisvert <[EMAIL PROT

Re: PDF Question

2005-11-18 Thread Sam Farmer
e selected method main was not found.But a cfdump of the object lists the method main... Here's the code: pdfObject = createObject("java","com.lowagie.tools.concat_pdf"); pdfObject.main("1.pdf 2.pdf result.pdf"); Cheers, Sam On 11/18/05, Robertson-Ravo, Nei

Re: PDF Question

2005-11-17 Thread Sam Farmer
Yeah, I'm familiar with both createObject and Java. It looks like com.lowagie.tools is the package needed for concatenating. I'll see what I can do. Cheers, Sam F On 11/17/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > I haven't done itbut I've seen the docs

Re: PDF Question

2005-11-17 Thread Sam Farmer
Bryan and Neil, Is there any chance you could post some code showing how you did this? I'm about to start a project where I will need to do exactly this. Thanks, Sam On 11/17/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > > iText from SourceForge will do thatand iTex

cfschedule

2005-11-14 Thread Sam Komo_ITS
Hi Guys, I have a scheduled job that runs every 8 hrs [7AM, 3PM, 11PM]. The job now runs one hour earlier because of the daylight savings time. What can be done to make sure it run at the specified times. Thanks Sam --- [This E-mail scanned for viruses

Re: SQL join a table to a set of values not in a table.

2005-11-03 Thread Sam
SELECT aDATE, DATEcol, VALUEcol FROM aTABLE, ( SELECT TO_DATE('#myMonth#/#i#/2005', 'mm/dd/') aDATE FROM DUAL UNION SELECT TO_DATE('#myMonth#/#i#/2005', 'mm/dd/') aDATE FROM DUAL ) WHERE aD

Re: SQL join a table to a set of values not in a table.

2005-11-03 Thread Sam
SELECT aDATE, DATEcol, VALUEcol FROM aTABLE, (SELECT TO_DATE('09/01/2005', 'mm/dd/') aDATE FROM DUAL UNION SELECT TO_DATE('09/02/2005', 'mm/dd/') aDATE FROM DUAL UNION SELECT TO_DATE('09/03/2005', 'mm/dd/') aDATE FROM DUAL UNION SELECT TO_DATE('09/04/2005', 'mm/dd/') aDATE FROM

Re: Is this possible

2005-10-27 Thread Sam Farmer
It sounds like you already have next Monday worked out after that do something like this: #dateAdd("ww",variables.ii,variables.firstMonday)# Cheers, Sam On 10/27/05, Kurt Kaptein <[EMAIL PROTECTED]> wrote: > > > I need quick advice on if this is possible. > >

Re: will cfimport slow down your page?

2005-10-14 Thread Sam Farmer
I use it all the time and have seen no change in performance. Cheers, Sam On 10/14/05, Johnny Le <[EMAIL PROTECTED]> wrote: > > Hi, > > If you have a library of custom tags, should you use prefix='ct'/> to import the whole library in? This way, I can use > l

Re: security suggestions?

2005-10-14 Thread Sam Farmer
.passwordbecause of the quotes. Try: WHERE Password = '#Hash(form.Password, "SHA-512")#' Cheers, Sam ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and docu

Re: cferror problem

2005-10-14 Thread Sam Farmer
Most likely you have an error in CustomError.cfm. If CF can't call the error template page it gives the error of the original page. Cheers, Sam On 10/14/05, Chad McCue <[EMAIL PROTECTED]> wrote: > > I am running CF7on windows 2003. > > I am trying to use in my applicatio

CFDocument, FlashPaper and Table Borders

2005-10-13 Thread Sam Farmer
; border-bottom : 1px dotted Gray; font : 0.7em Verdana, Geneva, Arial, Helvetica, sans-serif; } Afternoon Chair 6/17/06 All in 6/17/06 Thanks, Sam ~| Logware (www.logware.us): a new and convenient web-based time tracking

CF7 - Conventing HTM Docs TO pdf

2005-07-28 Thread sam komolafe
HI, I am trying to convert an htm document with links to PDF. The PDF created by CF7 does not convert the links to hot/clickable links. Any idea how to do this? Thanks Sam --- [This E-mail scanned for viruses.] ~| Find out

CF7: Conventing HTM Docs TO pdf

2005-07-27 Thread sam komolafe
HI, I am trying to convert an htm document with links to PDF. The PDF created by CF7 does not convert the links to hot/clickable links. Any idea how to do this? Thanks Sam --- [This E-mail scanned for viruses.] ~| Logware

CF7: Conventing HTM Docs TO pdf

2005-07-27 Thread sam komolafe
HI, I am trying to convert an htm document with links to PDF. The PDF created by CF7 does not convert the links to hot/clickable links. Any idea how to do this? Thanks Sam - Original Message - From: "Cary Gordon" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wed

Re: QueryNew() question

2005-05-10 Thread Sam Farmer
In CF7 you can specify the column type: *QueryNew*(*columnlist *[, *columntypelist*]) Sam ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a

RE: Admin API

2005-04-19 Thread Sam Smith
-Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 19, 2005 5:47 PM To: CF-Talk Subject: Re: Admin API Sam also asked me offlist and my suggestion was to try using the Admin API to set the template cache size to zero and then back to the usual

Admin API

2005-04-19 Thread Sam Smith
Hello all, I've been reading through the Admin API for a little while now and it seems that the function that I'm looking isn't exposed through it. What I'm looking for is this. My boss asked me to create an app that would clear the template cache of all our 17 CFMX 7 servers at once. I thought I

Document Imaging

2005-04-08 Thread sam komolafe
Hi, Are there software packages that can be used to read and write image files to SQL Server database? Is this doable in cfmx? Thanks Sam - Original Message - From: "dave" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, April 08, 2005 11:11 AM Subject: RE:

Re: ListAppend and delimiter question

2005-03-30 Thread Sam Farmer
I'll leave it to others to classify it as a bug or a feature. I get around it by doing this: and then when done with all my list appends: Cheers, Sam On Wed, 30 Mar 2005 11:07:53 -0800, Charles Heizer <[EMAIL PROTECTED]> wrote: > Hello, > I have a strange question, I think

Re: Empty list for an IN clause

2005-03-28 Thread Sam Farmer
That will work fine but if there is an empty list you are asking the database to search for a clause that you know it will not find. Depending on your set up this could cause a performance hit. Sam On Mon, 28 Mar 2005 09:27:27 -0800, Ian Skinner <[EMAIL PROTECTED]> wrote: > Ok, this

Re: Empty list for an IN clause

2005-03-28 Thread Sam Farmer
Put the whole clause in a cfif statement: RDT_MOBLID IN () Sam On Mon, 28 Mar 2005 09:19:35 -0800, Ian Skinner <[EMAIL PROTECTED]> wrote: > What is the simplest way to handle the possibility of an empty list for an IN > clause. > > For Example: > RDT_MOBLID IN (

Re: randomize

2005-03-25 Thread Sam Farmer
How about: #queryName.questID[randRange(1,queryName.recordCount)]# Haven't tested it so the randRange may need to be pulled out and set to a variable. Cheers, Sam On Fri, 25 Mar 2005 12:31:51 -0500, CFDEV <[EMAIL PROTECTED]> wrote: > Hi, > > I have a query and i want to

Re: restaurant apps

2005-01-26 Thread Sam
If they do a good lunch crowd fax out the daily specials. dave wrote: > just seeing what ppl are doing with it now days > > the deal is there is 3 restuarants these ppl own and they are giving me a > green light to basically do whatever i want with them > so just checking to see what u guys are

CFC: Object instantiation

2004-12-17 Thread sam komolafe
s the code that I have: Thanks Sam --- [This E-mail scanned for viruses.] ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cf

CFC Generic table update utility

2004-12-13 Thread sam komolafe
Hi everyone, Is there a CFC tool out there that one can use to generate select/insert/update/delete for database tables? Thanks Sam --- [This E-mail scanned for viruses.] ~| Special thanks to the CF Community Suite Silver

Re: CFC instance creation Problem

2004-11-19 Thread sam komolafe
erver. Is there a way to check if CreateObject is disabled? Thanks Sam - Original Message - From: "Raymond Camden" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, November 19, 2004 12:02 PM Subject: Re: CFC instance creation Problem

CFC instance creation Problem

2004-11-19 Thread sam komolafe
Hi, Why am I not able to create an instance of a CFC on my test server using this syntax: It only works using the CFOBJECT syntax. By the way the CreateObject syntax works perfectly on my local PC. I have CFMX 6.1 + updater on both PC's Thanks Sam --- [This E-mail scanned for vi

Re: Looping through lines in a file

2004-08-27 Thread Sam Farmer
You could also use ListToArray instead of multiple listgetat calls.    - Original Message - From: joe velez <[EMAIL PROTECTED]> Date: Fri, 27 Aug 2004 14:53:16 -0400 Subject: Re: Looping through lines in a file To: CF-Talk <[EMAIL PROTECTED]> i know you said cfscript, but why not c

Re: ColdFusion and MVC model...

2004-07-19 Thread Sam Farmer
In addition to others mentioned I have found this site to be very useful: http://www.benorama.com/coldfusion/index.htm Personally I don't like Fusebox and have been trying out other MVC implementations before deciding on one to go forward with. Thanks, Sam [Todays Threads] [This Me

Running CFMX on DOS command line

2004-07-09 Thread Sam komolafe
Hi, I like to run a cfmx template on dos command line.  The file to run for CF5 is cfml.exe.  What is the executable file to run for CFMX. Thanks Sam --- [This E-mail scanned for viruses.] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and

Re: Image details

2004-06-28 Thread Sam Morris
Great! Thanks everyone. This tag looks perfect. sam --- Claude Schneegans <[EMAIL PROTECTED]> wrote: > >>was wondering if anyone has written code that > parses > through an image file and strips out the digital > camera header info. Like the size, resolution and > c

Image details

2004-06-28 Thread Sam Morris
was wondering if anyone has written code that parses through an image file and strips out the digital camera header info. Like the size, resolution and camera used, maybe even date. I opened an image in notepad and see all the info is there but before I spend the time looping through it I figured I

CF adm Image storage

2004-06-17 Thread Sam komolafe
Hi, How do I store image files (attachments from customers) to a SQL Server database using ColdFusion AND is this a better way to store attachements? Thanks Sam --- [This E-mail scanned for viruses.] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings

Cannot display DB Error Page in CFMX

2004-06-10 Thread sam komolafe
Hi all, How do I get the standard CF5 type error page that displays when you have a database error on your development server. The error message usually includes type of error and line error occurs.  I now use CFMX and it gives me a 'cannot display page'  for a database error.

CFFile and Word/PDF document

2004-05-13 Thread sam komolafe
Hi All, How do I View/Display Microsoft Word and/or PDF documents I retrived using CFFILE  into my coldfusion template? Thanks Sam --- [This E-mail scanned for viruses.] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

CFFile and Word/PDF document

2004-05-12 Thread sam komolafe
Hi All, How do I View/Display Microsoft Word and/or PDF documents I retrived using CFFILE  into my coldfusion template? Thanks Sam --- [This E-mail scanned for viruses.] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

CFFILE UPLOAD ???

2004-05-11 Thread sam komolafe
Hi All, How do I append a string value to the name of the file I am upload to the server?   EXAMPLE: File Name to upload is: Readme.txt File Name AFTER Upload: FOO-Readme.txt Thanks Sam Komolafe --- [This E-mail scanned for viruses.] [Todays Threads] [This Message] [Subscription] [Fast

Load Testing Tools

2004-02-26 Thread Sam komolafe
Can someone recommend a good load testing tool for my ColdFusion server.  I have a Compaq Pentium III  DL380 - dual processor server with win2000 server. Thanks Sam --- [This E-mail scanned for viruses.] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

How do I access COM Object properties in CF

2004-01-06 Thread Sam komolafe
Hi,   How do I access COM Object properties using CFObject tag? Thank Sam --- [This E-mail scanned for viruses.] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: website merging error

2003-12-18 Thread Sam Roach
that did it... thanks to all -- Sam -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, December 18, 2003 9:43 AM To: CF-Talk Subject: RE: website merging error > IIS / Coldfusion MX >   > Has anyone ever come across an error with IIS or ColdFusion

website merging error

2003-12-18 Thread Sam Roach
t the refresh button and everything will come up fine 2 out of 3 times...   Other sites on this same server run correctly... here is an example...  Hit refresh a few times... http://www.litewheels.com/menu_page.cfm?page=lw_news_search.cfm &menu=2 Any advice would be helpful...

Re: SQL UNION Trouble

2003-12-09 Thread Sam Farmer
What error message are you getting? Also your column order is different in the two queries which will cause problems.  Make them the same order (email, firstname, lastname) and see if that works. Sam >>> [EMAIL PROTECTED] 12/09/03 11:39AM >>> In the following query I want t

cfstoredproc yields no response

2003-12-04 Thread Sam Farmer
: Thanks, Sam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: value "" cannot convert to number

2003-12-01 Thread Sam Fisher
sure to let you all know. -Sam   - Original Message -   From: Cameron Childress   To: CF-Talk   Sent: Monday, December 01, 2003 3:46 PM   Subject: RE: value "" cannot convert to number   You've not included what you think the value of "ID" is, but if it's &

value "" cannot convert to number

2003-12-01 Thread Sam Fisher
  What is wrong with converting a string to a number, especially when the string is just a concatenation of numbers?   Many thanks,   Sam   The value "" cannot be converted to a number   155 : #ID#   156 : [Todays Threads] [This Message] [Subscription] [

CFINCLUDE within CFLOOP not working

2003-11-13 Thread Sam Komolafe
Hi, How do I dynamically include files using CFINCLUDE within a CFLOOP statement: This does NOT WORK:       Help will be appreciated. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: paragraph formatting using nText with SQL Server

2003-10-22 Thread Sam Fisher
Thanks very much for the advice.  I'll give it a try. -Sam   - Original Message -   From: Matthew Walker   To: CF-Talk   Sent: Wednesday, October 22, 2003 8:11 PM   Subject: RE: paragraph formatting using nText with SQL Server   Right well I think the best solution is to write

Re: paragraph formatting using nText with SQL Server

2003-10-22 Thread Sam Fisher
Hey thanks, Matthew.  I just put it to work and it appears to be doing the trick.  But you're right, I'd prefer not to see the .  How do I hide them? -Sam     - Original Message -   From: Matthew Walker   To: CF-Talk   Sent: Wednesday, October 22, 2003 7:43 PM   Subject: RE:

paragraph formatting using nText with SQL Server

2003-10-22 Thread Sam Fisher
Hi, Can anyone tell me how to maintain paragraph formatting for textarea going into SQL server (nText data type)?  Preferably without VB.  Should I assess the existence of three or more contiguous spaces and then insert a \ in the text where they occur before cfquery INSERT/UPDATE? Thanks, Sam

Re: error: object expected

2003-10-15 Thread Sam Fisher
se they appear as 0 (minus the decimal because of the #INT()# function). I do not get any errors in Netscape 7.1.  Perhaps I'm having a datatype issue between real types and null values - something IE can't handle? Thanks so much for your help. -Sam - Original Message -   From: Ia

Re: error: object expected

2003-10-13 Thread Sam Fisher
Thanks for the tip, Ade.  Before I try cfdump, I wanted to let you know that the error does not occur in Netscape 7.1. -Sam   - Original Message -   From: Adrian Lynch   To: CF-Talk   Sent: Monday, October 13, 2003 11:43 AM   Subject: RE: error: object expected   I think for xhtml you

error: object expected

2003-10-13 Thread Sam Fisher
#x27;ve got for that:   --Select--#Country# Perhaps I shouldn't put the message attribute in the tag. The line where the error occurs is line 25 (char 2), which relates to a tag.  Can I put form elements inside of tables?  Perhaps this is an IE thing? Thanks, Sam [Todays Th

Re: Re:dynamic menus

2003-09-29 Thread Sam Fisher
Thanks, L.  Unfortunately I'm dense and am having trouble making sense of the code you sent me.  Suppose I have two lookup tables, (a) is for three types of Apples [red, golden, grannysmith], and the other (b) is for Nuts [walnut, chestnut, pecan, peanut]. The criteria are such that 1) Each Apple-

dynamic menus

2003-09-28 Thread Sam Fisher
Hi Everyone,I am having trouble again.  I'm trying to create my first dynamic menu drop-down list.  Unfortunately, I don't know how to get the page to refresh (_javascript_:refresh(); ?) when a drop-down selection is made.  The technique I've begun to set up is for the first menu to list some item

Re: convert string of numbers to numeric?

2003-09-26 Thread Sam Fisher
Indeed it does.  In fact, the problem actually stemmed from an incorrect operator that I used for concatenating another variable.  I learned a lot from you.  Thanks very much for your effort.  As I move beyond newbie status, hopefully I can return the favor.-S  - Original Message -   From:

Re: convert string of numbers to numeric?

2003-09-26 Thread Sam Fisher
Problem solved.  THanks for your help, everyone.-S  - Original Message -   From: Sam Fisher   To: CF-Talk   Sent: Friday, September 26, 2003 1:37 PM  Subject: Re: convert string of numbers to numeric?  Thanks for all of your help.  To help out a little more, here're my qu

Re: convert string of numbers to numeric?

2003-09-26 Thread Sam Fisher
Thanks for all of your help.  To help out a little more, here're my queries:  datasource="source" dbtype="ODBC">   INSERT INTO tblTable (name, var1) VALUES ('#userName.name#', '#val ("0" & form.var1)#')   datasource="source" dbtype="ODBC">UPDATE tblTable SET var1=#va

Re: convert string of numbers to numeric?

2003-09-26 Thread Sam Fisher
in the cfinput tag.  - Original Message -   From: Claude Schneegans   To: CF-Talk   Sent: Friday, September 26, 2003 12:45 PM  Subject: Re: convert string of numbers to numeric?  >>I set the default value="0".  In the database?  The default valu in a database is returned when the field is n

Re: convert string of numbers to numeric?

2003-09-26 Thread Sam Fisher
ot a valid  string!  From: Tony Weeg [mailto:[EMAIL PROTECTED]  Sent: 26 September 2003 13:40  To: CF-Talk  Subject: RE: convert string of numbers to numeric?  can you send the whole bit of code? its got to work, there is a way!!!  :) tony   -Original Message-----  From: Sam Fisher [mailto:[EMAIL

Re: convert string of numbers to numeric?

2003-09-25 Thread Sam Fisher
F-Talk" <[EMAIL PROTECTED]>Sent: Thursday, September 25, 2003 3:33 PMSubject: RE: convert string of numbers to numeric?> simply stripping out the .'s maybe?> or is there something Im not getting?>> tony>> >> would do I presume?>> -Original Message->

convert string of numbers to numeric?

2003-09-25 Thread Sam Fisher
Hi Everyone, I have a problem. I am trying to convert a string of numbers to a real data type, unfortunately without success. I read a CF-Talk board discussion about it, but was unable to get it to work. Can anyone help me. I created an input field: Now I need to convert var1 to a number be

RE: Table help

2003-07-10 Thread Sam Roach
You are trying to make 120% width fit inside 100% wide table... Try putting 20% in each.. Text1 Test2 Test234 > > > > Text1 > Test2 > Test234 > > > -Original Message- From: Tony Walker [mailto:[EMAIL PROTECTED] Sent: Thursday, July 10, 2003 4:41 PM To: CF-Talk Subj

RE: MS Access random records

2003-06-18 Thread Sam Roach
nevermind, I got it... -- Sam -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 1:22 PM To: CF-Talk Subject: OT: MS Access random records I need to grab a random 25000 records from a database, no dups.. I found some code online and modified

OT: MS Access random records

2003-06-18 Thread Sam Roach
I need to grab a random 25000 records from a database, no dups.. I found some code online and modified it, but it is to slow... Works great for just a few records.. The query.. SELECT DISTINCTROW old_table.Name INTO new_table FROM old_table WHERE (((InStr(1,rndSet(25500,'old_table'),("," & [id]

Session Variables Dropping

2003-06-06 Thread Sam Komolafe
Server. Thanks Sam ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion

Session Variables Dropping

2003-06-06 Thread Sam Komolafe
Server. Thanks Sam ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion

Session Variables Dropping

2003-06-05 Thread Sam Komolafe
Server. Thanks Sam ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion

RE: Submitting form from

2003-03-26 Thread Sam Roach
-- Sam -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 12:01 PM To: CF-Talk Subject: Submitting form from button. How can I do this? --- Colonel Nathan R. Jessop Commanding Officer

RE: IIS hiding .cfm

2003-03-26 Thread Sam Roach
thanks, that did it.. -- Sam -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 8:54 AM To: CF-Talk Subject: RE: IIS hiding .cfm Which version of ColdFusion are you running? The instructions on that page are for CF5 and below, for CFMX you

RE: IIS hiding .cfm

2003-03-26 Thread Sam Roach
Coldfusion MX... Version 6 -- Sam -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 8:51 AM To: CF-Talk Subject: Re: IIS hiding .cfm Which version of CF? Jerry Johnson >>> [EMAIL PROTECTED] 03/26/03 11:45AM >>> Has a

IIS hiding .cfm

2003-03-26 Thread Sam Roach
fine. Looking online this is the only reference to this that I have found: http://www.maxfusion.co.uk/faq/viewfaq.cfm?QID=63 Is there another step I'm missing with Cold Fusion? -- Sam ~| Archives: http://www.houseoffusion.co

RE: Access date issue

2003-02-27 Thread Sam Roach
you may need to put a # around the date if it is a date field in access.. ex.. #dateformat(bdate, m)# = ###Dateformat(searchdate, "m")### -- Sam -Original Message- From: Rebecca Joy Sherman [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 11:54 AM To: CF-Talk Subje

RE: link checking tool

2003-02-24 Thread Sam Roach
this tool may help. http://home.snafu.de/tilman/xenulink.html -- Sam -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 1:12 PM To: CF-Talk Subject: link checking tool I just had the great fortune of inheriting a gargantuan app that is

RE: (OT, kinda) Does anyone know a source for downloading IE wit hout auto-install?

2003-02-11 Thread Sam Roach
t;ie6wzd.exe /d /s:""#E" The IEAK is nice too, but you may not want to install it on your machine, so this option works but without the customization benefit. -- Sam -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 10:02 A

RE: Convert format

2003-02-05 Thread Sam Roach
val() command -- Sam -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 12:49 PM To: CF-Talk Subject: Convert format Hi All, I've got a query which retrieves the max order number from the db. I want to increment it by one and writ

RE: stop/restart

2003-01-30 Thread Sam Roach
net stop "IIS Admin Service" net start "IIS Admin Service" you also must restart: net start "World Wide Web Publishing Service" net start "FTP Publishing Service" -- Sam -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: T

RE: stop/restart

2003-01-30 Thread Sam Roach
net stop "IIS Admin Service" net start "IIS Admin Service" -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 8:51 AM To: CF-Talk Subject: stop/restart I know this may be a bit OT but does anyone know the command line in a DOS prompt to st

RE: DateTimeFormat

2003-01-27 Thread Sam Roach
Not in one shot but you can do something like: -- Sam -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 1:10 PM To: CF-Talk Subject: DateTimeFormat Hi, I looked at all the functions but can't seem to find a CF function that formats

<    1   2   3   4   >