Re: Baffled by Lost Session

2009-11-01 Thread Randy Adkins
hmm running CF 8 and I have set session variables many times using the CFSET then a CFLOCATION. So not sure this fits. It has something to deal with the Applcaition as I tried one of my other applications and the session stays as programmed. However this ONE does not... baffling. This to break

Baffled by Lost Session

2009-10-31 Thread Randy Adkins
I am baffled on this and probably something tremendously simple that I am overlooking. First the layout: Windows Vista (IIS 7) ColdFusion 9 (Developers Edition) Database: MySQL Internet Explorer 8.0 File Structure: webroot \ (application.cfm and other files) webroot \ admin webroot \ admin \

Re: Users access to a listbox

2009-09-30 Thread Randy Adkins
It is going to list them all based on your code: 1. Your query is returning ALL records 2. your displaying all OPTIONs in the SELECT dropdown but ONLY selecting the ones that was populated in the FORM.COMPANY_NUMBER field. If you only want the SELECT dropdown to return the one in

Re: Using a Listbox to allow Users Access

2009-09-28 Thread Randy Adkins
Depending on how you have your validation structured for permissions, an idea would be: Session.CompanyAccess = '1,2,5,6' Then you can validate it when needed. Now if you are going further to set permissions such as CRUD: Session.CompanyAccess.Permissions_1 = C,R,U,D

Re: Using a Listbox to allow Users Access

2009-09-28 Thread Randy Adkins
Yes, however you will need to validate permissions when needed Ex: CFIF ListFind(Session.companyAccess,thisCompanyID) ... GOOD CFELSE ... BAD /CFIF On Mon, Sep 28, 2009 at 7:14 AM, Damo Drumm damien.dr...@quinn-group.comwrote: Thanks, The first option will suit me so if i set up a field

Re: CF: TimeZoneInfo

2009-09-17 Thread Randy Adkins
/docview.wss?uid=swg21250503 http://www.petefreitag.com/item/171.cfm Hope this helps. Judah On Wed, Sep 16, 2009 at 10:52 AM, Randy Adkins cfdev2...@gmail.com wrote: US Eastern TimeZone (-5) I know the locale is set right: English (US) Any idea how I can check the Java Locale

CF: TimeZoneInfo

2009-09-16 Thread Randy Adkins
Having an issue where are Server Time is correct but when using the Now() option in CF, it is off by 4 hours. *Test Date/Time:* {ts '2009-09-16 16:09:38'} This is what is returned using GetTimeZoneInfo: *ColdFusion Time Zone Info:* DST On: NO UTC Hour Offset: 0 UTC Minute Offset: 0 UTC Total

Re: CF: TimeZoneInfo

2009-09-16 Thread Randy Adkins
locale settings off the top of my head but hopefully that will point you in the right direction. Judah On Wed, Sep 16, 2009 at 9:12 AM, Randy Adkins cfdev2...@gmail.com wrote: Having an issue where are Server Time is correct but when using the Now() option in CF, it is off by 4 hours

Best approach

2009-09-16 Thread Randy Adkins
Looking for the best approach to the following task: allow users to download a checklist to a tablet pc, do some security checks with the tablet pc in hand (not connected to the web). Upon completing the checks, connect to the Internet and upload the results. Then I can parse and add to the

eSignature

2009-07-21 Thread Randy Adkins
Has anyone incorporated eSignatures into a CF application? embedding into a document or anything? Have a client that wants to capture an eSignature from the end user (client) regarding approved documents. TIA! ~| Want to

Re: eSignature

2009-07-21 Thread Randy Adkins
Or if there is a way to use CF to verify that a document (DOC or PDF) has been electronically signed?? On Tue, Jul 21, 2009 at 5:38 PM, Randy Adkins cfdev2...@gmail.com wrote: Has anyone incorporated eSignatures into a CF application? embedding into a document or anything? Have a client

Re: list question

2009-05-01 Thread Randy Adkins
If I recall ListFind will return the numeric location of the list (if found). Using that numeric you can do a ListGetAt to get the next and previous. cfset listLoc = ListFind(myList,5) cfset nextItem = listGetAt(myList,listLoc+1) cfset prevItem = listGetAt(myList,listLoc-1) Something like that

Web Services CERT

2008-08-22 Thread Randy Adkins
We are creating a web service (CFC / WSDL) on a box and when I attempt to access it via browser, I am prompted to login (network). We have to lock down alot of items and was wondering if we installed a CERT on the box, would we be able to access the Web Service w/o the login? The CFC functions

Re: Web Services CERT

2008-08-22 Thread Randy Adkins
Well the web service is on an Intranet but will be accesible by other servers within the agency. According to the docs (other developer is no longer here), the cfinvoke command was not utilizing the username/pass auth method. The server has Anonymous Access turned off since it is internal. I can

Sending Mail with CF

2008-08-22 Thread Randy Adkins
Situation (environment): Windows 2003 Server CFMX 7.1 We have a box on the intranet (Anonymous Access turned off) and using CFMAIL to send email to department heads when a user creates a request within the CF Application. Problems is the error in the CF mail.log is: Client was not authenicated

Re: Web Services CERT

2008-08-22 Thread Randy Adkins
If I provide it within the CFAdmin when registering, the account has to reside on the domain I know. Have to find out if we have a default account for this specific use. On 8/22/08, Dave Watts [EMAIL PROTECTED] wrote: Well the web service is on an Intranet but will be accesible by other

Re: Sending Mail with CF

2008-08-22 Thread Randy Adkins
Thats what I thought as well. Just needed clarrification. I am working with the SA to get an account on the LAN for this type of use and the use of Web Services. On 8/22/08, Dave Watts [EMAIL PROTECTED] wrote: We have a box on the intranet (Anonymous Access turned off) and using CFMAIL to

OT: Oracle Query Question

2008-04-30 Thread Randy Adkins
I am trying ot use the to_date function to format the date as just the YEAR but it returns the following error: ORA-1830: date format picture ends before converting entire input string Here is the sql: select to_date(annual_email_sent_date,'') from nh_annual_email_log So to answer a few

Re: CustomTags?

2002-03-14 Thread Randy Adkins
Here is what they sent me. - Original Message - From: laszlo [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 8:33 PM Subject: Re: CustomTags? Same problem here, any post will be appreciated laszlo Randy Adkins wrote: Does anyone have a copy

CustomTags?

2002-03-13 Thread Randy Adkins
Does anyone have a copy of the ThreeSelectsRelated Customtag? It is no longer in the Macromedia site. TIA! __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation ·

Re: Access to SQL Server

2002-02-08 Thread Randy Adkins
In the field which you have make sure it is set to NOT allow NULLS and check the IDENTITY field and set the seed to 1 and the increment to 1 - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 08, 2002 10:35 AM Subject: Access to SQL Server

Re: CF and Hit Counter

2002-01-27 Thread Randy Adkins
Well it is fine however take into consideration those users who may visit your site could be on dial-up. So per-say at 11:00AM you get Visitor A to come to your site and you set the session.visitor since it was not set and the IP Address was not present in your table. Then at 1:00PM you get a

Re: OT-PayPal Limitations

2002-01-24 Thread Randy Adkins
Do you know a way around that or do you go with another carrier? - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 5:18 PM Subject: RE: OT-PayPal Limitations It's definitely $1000.00. -Original

Re: OT-PayPal Limitations

2002-01-24 Thread Randy Adkins
. This was a while back ... Id have to fiddle aroud with that service again to see if that still owrks but worth a look seee for ya. Steve - Original Message - From: Randy Adkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 1:26 PM Subject: Re

Re: extracting data from a huge text file

2002-01-24 Thread Randy Adkins
You can use Perl or Visual Basic and write an EXE to handle it. I had a huge file as such and it would contain about 500k records. It was a historical file containing about 5 years of data. If it is a SQL database, look at using the DTS package If per say an Access database, either Perl or VB

Oracle Connection?

2002-01-14 Thread Randy Adkins
What is the rule of thumb for assigning a max number of connections to a Native Oracle ODBC connection? It currently is set to 100. However my thinking would be that if more than 100 concurrent users hit the ODBC, that the system resources would begin to drain and a possibility of losing the

Oracle 8.1.5 CF5

2002-01-14 Thread Randy Adkins
Has anyone experienced CF5 losing connection to the Oracle ODBC running on a Windows NT 4.0 platform? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation ·

Re: Dynamically sortable table data

2002-01-11 Thread Randy Adkins
Only two ways I can think of is either dumping the contents into Javascript and calling a function to redisplay the contents or refreshing the page using using a dynamic variable for sorting. -- Original Message -- from: Brunt, Michael [EMAIL PROTECTED]

Merchant Accounts?

2002-01-09 Thread Randy Adkins
I am curious to know who CF Developers use for online credit card processing? I was looking over PayPal and LinkPoint. What are some of the others and basically what is the cost? I know with PayPal is can be as low as 2.2% and $ .30 per transaction. Thanks in advance Randy

Re: Dave or someone -- Help me with error msg!!!

2002-01-04 Thread Randy Adkins
You may need to supply a password with the query for it to authenicate to the SQL server. Basically it stats that the user account you entered is invalid. - Original Message - From: Julia Green [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 04, 2002 2:38 PM

RE: CF editing software - vote

2000-11-09 Thread Randy Adkins
Actually I run CF Server 4.5.1 and Studio 4.5 on Win98 and runs fine. I have yet to have it crash or lock up. -Original Message- From: Auction Hard Drive [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 09, 2000 10:38 AM To: CF-Talk Subject: RE: CF editing software - vote Studio

RE: CFSchedular

2000-11-08 Thread Randy Adkins
Make sure you are calling the scheduled template from a standard PORT 80. CFSCHEDULE does not work on any odd port such as port 8088. We had the same problem and after speaking to an Allaire Representative, that was the issue. We moved all our scheduled tasks to a standard port 80 directory.

RE: Hosting Question???

2000-11-07 Thread Randy Adkins
I heard http://www.virtualscape.com is rated #1 by CFHUB -Original Message- From: Auction Hard Drive [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 07, 2000 9:35 AM To: CF-Talk Subject: Hosting Question??? Where can I get the best bang for my buck in a Cold Fusion Host? Thanks,

Hosting

2000-11-05 Thread Randy Adkins
Anyone know a good CF Hosting which provides CFSchedule? Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a

RE: CFPOP.... Help!

2000-10-26 Thread Randy Adkins
What mail server software are you using? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 26, 2000 1:09 PM To: CF-Talk Subject: CFPOP Help! I'm trying to download all the mail on a POP3 mailbox, then delete it. I am currently using two

RE: Error Number 1450 (Win NT)

2000-10-25 Thread Randy Adkins
1450 ERROR_NO_SYSTEM_RESOURCES Insufficient system resources exist to complete the requested service. Something seems to be running that is drawing all the CPU memory thus without the available memoery CF shuts down. Try to see what is running to drawn the memory. Sorry just a place to start

RE: checkboxes

2000-10-25 Thread Randy Adkins
You can use radio buttons to better do what you wish. Something like: input type="Radio" name="itemsselected" value="1" input type="Radio" name="itemsselected" value="2" input type="Radio" name="itemsselected" value="3" input type="Radio" name="itemsselected" value="4" input type="Radio"

RE: Validate Multiple docs

2000-10-25 Thread Randy Adkins
Yes, you can use variables to determine what validation to process on the given page. Example: cfif cgi.http_referer is "pageone.cfm" ' Process for step one ' Example: ADD RECORD TO DATABASE cfelse cgi.http_referer is "pagetwo.cfm" ' Process for step one '

RE: Credit card validation service?

2000-10-25 Thread Randy Adkins
There is authorized.net which I have been reviewing and seem good. -Original Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 25, 2000 3:56 PM To: CF-Talk Subject: OT: Credit card validation service? Anyone ever heard of a credit card validation service (via the

RE: Problem with email form validation

2000-10-24 Thread Randy Adkins
Added form.submit = false at the end when it fails validation -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 10:51 AM To: CF-Talk Subject: Problem with email form validation Hi! I was wondering if there was a way arond this problem.

RE: What If You Don't Know The File Type?

2000-10-24 Thread Randy Adkins
Is it possible to ZIP all files received. This way it will cut down on the bandwidth required to download the files as well. Just an option -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 11:42 AM To: CF-Talk Subject: What If You Don't

RE: What If You Don't Know The File Type?

2000-10-24 Thread Randy Adkins
)? In the docs, the only attribute I saw was "type" and all that seems to do is tell you whether it's a file or a directory. And to the post from Randy Adkins ... how do you zip the files once they're on the server? And what if they need to be a .sit file (the people downloading these files a

RE: Slightly OT: Cable Modem and TZO

2000-10-24 Thread Randy Adkins
I was doing some myself. You can host it via IP Address if you run a static IP from @Home. If you want a web address such as www.myplace.com or something then you have to see who will host your DNS record. Last time I checked @Home would not do that unless it was a business. Also if you use

RE: Access question

2000-10-12 Thread Randy Adkins
within ONE table. A total of 12 tables and not quite 1 million records in total but enough to bog access down with the numerous hits. Just my 2 cents! Randy Adkins -Original Message- From: Aaron Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 12, 2000 10:33 AM To: CF-Talk

CFPOP Experts????

2000-10-04 Thread Randy Adkins
I am having problems with CFPOP. I am attempting to POP the server and get a message. (See bottom for code) However I get the following error: Error Diagnostic Information unknown exception condition CFMLInterpreterImp::executePCode Date/Time: 10/03/00 13:40:49 Browser: Mozilla/4.0 (compatible;

RE: CFPOP Experts????

2000-10-04 Thread Randy Adkins
Cold Fusion - 4.01 -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 04, 2000 8:18 AM To: CF-Talk Subject: Re: CFPOP Experts What version of CF? ~J - Original Message - From: "Randy Adkins" [EMAIL PROTECTED] To: "

Anyone know how to use CFPOP?

2000-10-04 Thread Randy Adkins
Cold Fusion Server version 4.01 Cold Fusion Studio version 4.0 I am having problems with CFPOP. I am attempting to POP the server and get a message. (See bottom for code) However I get the following error: Error Diagnostic Information unknown exception condition

RE: Anyone know how to use CFPOP?

2000-10-04 Thread Randy Adkins
stin MacCarthy - Original Message - From: "Randy Adkins" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, October 04, 2000 4:25 PM Subject: Anyone know how to use CFPOP? Cold Fusion Server version 4.01 Cold Fusion Studio version 4.0 I am ha

CFPOP

2000-10-03 Thread Randy Adkins
I am having problems with CFPOP. I am attempting to POP the server and get a message. (See bottom for code) However I get the following error: Error Diagnostic Information unknown exception condition CFMLInterpreterImp::executePCode Date/Time: 10/03/00 13:40:49 Browser: Mozilla/4.0 (compatible;

Help using CFPOP

2000-10-03 Thread Randy Adkins
I am having problems with CFPOP. I am attempting to POP the server and get a message. (See bottom for code) However I get the following error: Error Diagnostic Information unknown exception condition CFMLInterpreterImp::executePCode Date/Time: 10/03/00 13:40:49 Browser: Mozilla/4.0 (compatible;

Expert??

2000-10-03 Thread Randy Adkins
Anyone an expert with CFPOP or may think they know quite a bit about it??? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit

RE: Reliability of CFSCHEDULE in CF 4.5.1

2000-10-03 Thread Randy Adkins
I have been using the CFSCHEDULE in 4.01 and 4.51 and runs great for me. Server platform: Windows NT SP 4 -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 03, 2000 4:20 PM To: CF-Talk Subject: Reliability of CFSCHEDULE in CF 4.5.1 Is CFSCHEDULE any

Unknown CF Error

2000-10-02 Thread Randy Adkins
Can anyone explain this?: unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit

Help? CF Error

2000-10-02 Thread Randy Adkins
Can anyone explain this?: unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit

RE: Date last modified (Access 2000)

2000-10-02 Thread Randy Adkins
Yes. You can do a cfdirectory to the file and that will give you the following: filename (#name#) file size (#size#) file date (#datelastmodified#) attributes (#attributes#) HTH -Original Message- From: seth ward [mailto:[EMAIL PROTECTED]] Sent: Monday, October 02, 2000 1:49 PM To:

RE: Encrypting a credit card field...

2000-09-27 Thread Randy Adkins
You can use the standard encrypt and decrypt in Cold Fusion. cfset thisValue = "#cc_info#" cfset mykey = "fubar" cfset Encrypted_info = encrypt(thisValue,mykey) Then decrypt it as needed: cfset origvalue = decrypt(thisvalue,"fubar") -Original Message- From: Mark W. Breneman

Email - Reply-to:

2000-09-14 Thread Randy Adkins
Does anyone know a way to add the header reply-to: to a cfmail message? I tried it in the first line fo the body and does not work. I want to send an email from one account but have it replied to at another account. Any ideas??

RE: Email - Reply-to:

2000-09-14 Thread Randy Adkins
"sender" ...more attibutes... CFMAILPARAM FILE="file-name" or CFMAILPARAM NAME="header-name" VALUE="header-value" ... /CFMAIL ~Justin - Original Message - From: "Randy Adkins" [EMAIL

CF 4.5

2000-09-14 Thread Randy Adkins
Does anyone have a link to the white paper of CF 4.5 and what features are provided that CF 4.01 does not have or what improvements were made? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To

Re: Simple SQL Question

2000-09-14 Thread Randy Adkins
If you are adding 3 records to the DB then you do this: cfquery name"addit" datasource="whatever" INSERT INTO Data(Fieldone) Values('#form.dat1#) /cfquery cfquery name"addit" datasource="whatever" INSERT INTO Data(Fieldone) Values('#form.dat2#) /cfquery cfquery name"addit" datasource="whatever"

E-mail Question

2000-09-13 Thread Randy Adkins
Question 1.: Has anyone seen a tag or know how to use CFMail for sending a message to a BCC?? Question 2: Can you use CFMAIL to send a message to someone but have a DIFFERENT reply to address? Thanks in advance --

Re: E-mail Question

2000-09-13 Thread Randy Adkins
ns Developer Aspect Computing Pty. Ltd. 19-25 Moore Street Turner, ACT, 2612 AUSTRALIA http://www.aspect.com.au Phone: (02) 6247 7677 Fax: (02) 6249 1620 Mobile: 0428 765 020 ACT ColdFusion Users Group - http://203.37.24.198 -Original Message- From: Randy Adkins [mailto:[E

ODBC

2000-09-11 Thread Randy Adkins
Is there a way to test to see if an ODBC exists? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a

RE: ODBC

2000-09-11 Thread Randy Adkins
Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Randy Adkins [mailto:[EMAIL PROTECTED]] Sent: Monday, September 11, 2000 9:35 AM To: [EMAIL PROTECTED] Subject: ODBC

RE: ISP Recs

2000-09-08 Thread Randy Adkins
www.Shanje.com -Original Message- From: John Allred [mailto:[EMAIL PROTECTED]] Sent: Friday, September 08, 2000 9:42 AM To: [EMAIL PROTECTED] Subject: ISP Recs I know this pops up all the time, but I wonder if I couldn't get some recommendations on a good Cold Fusion ISP. The time has

RE: Web Host Ratings

2000-08-29 Thread Randy Adkins
can you change your address book to read cf-talk@houseoffusion so I do not have to make yet another filter for it? Greatly appreciated -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 29, 2000 8:35 AM To: CF-Talk Subject: OT: Web Host Ratings

RE: Session timeout?

2000-08-24 Thread Randy Adkins
You almost have it, but try to see if a session variable exists. Example: cfif not isdefined("session.access") cflocation url="../login.cfm" /cfif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 10:01 AM To: [EMAIL

RE: Mail Servers?

2000-08-23 Thread Randy Adkins
If your using NT, you can get SendMail. It is NOT Expesive but is definately not free. It has a web interface already to manage. I have been running it for sometime and have no problems sending mass emails out by the truckloads. www.sendmail.com -Original Message- From: Neil Middleton

RE: #cgi.http_referer# and IE

2000-08-22 Thread Randy Adkins
I did a test with one page, created a form, sent them to another page and with the http_referer, had them redirected back where they came from. TO test it I ran a session variable as a counter. Worked fine in IE 5.5 and Netscape 4.73 -Original Message- From: Zachary Bedell

CFHTTP Question

2000-08-07 Thread Randy Adkins
I am using an example straight out of the Advanced book of CF. I want to do a CFHTTP POST and post data to a form. However using the exmaple shown below, I get a HTTP 404 Error. Both files reside in the same directory. I have checked and re-checked the spelling of the files. Any idea whats

Re: CFHTTP Question

2000-08-07 Thread Randy Adkins
s opposed to placing it directly in the URL. : : DC : : - Original Message -=20 : From: Randy Adkins=20 : To: [EMAIL PROTECTED]=20 : Sent: Monday, August 07, 2000 17:29 : Subject: CFHTTP Question : : : I am using an example straight out of the Advanced book of CF.=20 : I want

Re: Coldfusion Training..

2000-08-07 Thread Randy Adkins
Depending on your location, I have attended Figleaf's training and found it to be very good and thorough. www.figleaf.com - Original Message - From: "Angél Stewart" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 07, 2000 3:24 PM Subject: Coldfusion Training.. : A

ACCESS - Not a valid Bookmark

2000-08-03 Thread Randy Adkins
Has anyone noticed this problem when updating a record within MS Access 97 you get the error: Not a valid Bookmark. Can anyone explain this? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To

Re: ACCESS - Not a valid Bookmark

2000-08-03 Thread Randy Adkins
lem either. Sorry. : : Steve : : -Original Message- : From: Randy Adkins [mailto:[EMAIL PROTECTED]] : Sent: Thursday, August 03, 2000 12:59 : To: [EMAIL PROTECTED] : Subject: ACCESS - Not a valid Bookmark : : : Has anyone noticed this problem when updating a record : within MS Access

Re: Mail / Database Integration

2000-07-28 Thread Randy Adkins
Yes, you can use the CFPOP and get the mail message and database the subject, from, to, message. Using the query name for the CFPOP tag, then have it POP a particular message. cfpop action="GETALL" name="get_mail" messagenumber="1404" server="my.pop3.com" username="myname" password="mypass" So

File Read

2000-07-24 Thread Randy Adkins
Does anyone know how to read an ASCII File which contains spaces and need it to be just like that into a variable. In otherwords, Visual Basic had a function line LINE INPUT #1 I want to read each line and each space into a cf variable. Some lines contains upto 20 spaces between data elements

Re: Question about Multiple Order By

2000-07-24 Thread Randy Adkins
Order By Name, City - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 24, 2000 4:00 PM Subject: Question about Multiple Order By : Ok, can i do this? I mean i want to order by name first, then i want to : orderby city, so if we have kevin and john

Re: cookies?? or what to use

2000-07-18 Thread Randy Adkins
One thing on using CGI.HTTP_REFERER is that NOT all businesses, networks (admins) pass those variables. I have experienced where I used that cgi variable and various of networks either block that variable or something as it is not being established or passed when a user goes from one page to

Re: CF Server halts

2000-07-14 Thread Randy Adkins
232 The pipe is being closed. [OS/2 and NT] This can occur if a named pipes connection is lost during a read. Error 232 is a standard system error code which is documented in a number of popular reference works, including the WINERROR.H file included in Microsoft Visual C++. SQL Server was

What???

2000-07-14 Thread Randy Adkins
What does it mean by OCCLUDE and CF_TagName Construct??? "Warning","TID=355","07/13/00","08:17:10","In a CF_TagName construct custom tag file 'C:\CFUSION\CustomTags\K_Tags\BrowserCheck.cfm' will occlude custom tag file 'C:\CFUSION\CustomTags\R_Tags\BrowserCheck.cfm'."

Can someone explain this?

2000-07-14 Thread Randy Adkins
What does it mean by OCCLUDE and CF_TagName Construct??? "Warning","TID=355","07/13/00","08:17:10","In a CF_TagName construct custom tag file 'C:\CFUSION\CustomTags\K_Tags\BrowserCheck.cfm' will occlude custom tag file 'C:\CFUSION\CustomTags\R_Tags\BrowserCheck.cfm'."

Re: still not working

2000-07-06 Thread Randy Adkins
Actually you have an EXTRA comma in yout INSERT line: You have an extra comma after the emailaddress and before the ). insert into memberlist(firstname,lastname, boat, boatyear, address, city, phone, state, zip, emailaddress, ) Should be: insert into memberlist(firstname,lastname, boat,

Re: cfdirectory -- help.

2000-06-23 Thread Randy Adkins
The name is the name of the query that all the directory results are dumped into. So you can use the contents of the query to search as you would a query. - Original Message - From: "miles" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 22, 2000 2:21 PM Subject:

Re: scheduled tasks - problems....

2000-06-23 Thread Randy Adkins
Make sure the scheduled task is running on a normal port 80 and not something else. This was one problem an Allaire Representative noted when we contracted him to visit to resolve the problem. Other than that, just make sure your settings are correct for the time to start and end the task.

Re: Form Field Validation - No Spaces

2000-05-25 Thread Randy Adkins
Here is a question for people who have knowledge in Storedprocedures and SQL 7.0 backing. I am using CFSTOREDPROC and passing my variables into it without a problem. My Stored Proc in SQL is using the Order by clause. This does not work.. Any idea on another solution? I have used the query

StoredProcs

2000-05-25 Thread Randy Adkins
Here is a question for people who have knowledge in Storedprocedures and SQL 7.0 backing. I am using CFSTOREDPROC and passing my variables into it without a problem. My Stored Proc in SQL is using the Order by clause. This does not work.. Any idea on another solution? I have used the query

Re: StoredProcs

2000-05-25 Thread Randy Adkins
SELECT Company_Name, YR, Sum(Sales_Amt) AS SalesAmt, Schedule_Group, Section, Part FROM Sales WHERE (YR = @Last_Year AND (MO BETWEEN '10' AND '12')) OR (YR = @This_Year AND (MO BETWEEN '01' AND '09')) GROUP BY Company_Name, YR, Schedule_Group, Section, Part ORDER BY Company_Name; -

Re: New Virus [loveBug copy] *.*

2000-05-19 Thread Randy Adkins
Seems as if people forgets that this is a Cold Fusion mailing list. At the rate this list is going, next topics would be: How to make Thanksgiving Dinner. What to buy for Christmas. Who cares about what someone is doing this weekend. My two cents ... take it or leave... does not matter to

Re: New Virus [loveBug copy] *.*

2000-05-19 Thread Randy Adkins
y comments were sarcasm, although obviously lost. My only assumption is that you would have understood that. -Original Message----- From: Randy Adkins [mailto:[EMAIL PROTECTED]] Sent: Friday, May 19, 2000 9:14 AM To: [EMAIL PROTECTED] Subject: Re: New Virus [loveBug copy] *.* Wel

Re: New Virus [loveBug copy] *.*

2000-05-19 Thread Randy Adkins
ll, I'd be right there with ya hammering him but that type of message could actually save one of us from some major pain. Rey Bango Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." ----- Original Message

Re: Strip directory path to get just file name

2000-05-19 Thread Randy Adkins
This will strip the SCRIPT_NAME and leave you with the actual filename that is being served up to the server. cfset pagename = #RemoveChars(CGI.SCRIPT_NAME,1,1)# - Original Message - From: "cf kaizen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 19, 2000 12:41 PM Subject:

Re: Javascript and IE4.0

2000-05-16 Thread Randy Adkins
Works fine but if you click CANCEL it prompts with a Runtime Error Line 49 Error: This command is not supported. on line: onClick="WebBrowser1.ExecWB(6,1)" - Original Message - From: "Jason Egan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 16, 2000 3:52 PM Subject:

Re: Kind Of Off Topic

2000-05-16 Thread Randy Adkins
This can work however, I have experienced users coming from networks which BLOCK the CGI variable. I was using the HTTP_REFERER for validation purposes. Without the variable I could not validate the data. Thus another solution had to be developed. So keep in mind, even with CGI.HTTP_REFERER

Re: Have I set a record?

2000-05-15 Thread Randy Adkins
Greg, I agree. This use to be a nice list for information. However it seems recently it has turned into a chat line. So many things off-topic. Sorry for this POST. But we are CF programmers here to help with other CF problems. Not discuss lives thoughts and so-called great wisdoms. Lets try

Re: Anyone have any knowledge of CFCONTENT?

2000-05-15 Thread Randy Adkins
pplication/unknown'. That seems to work beautifully. Jason Egan Konnections, INC. -Original Message----- From: Randy Adkins [mailto:[EMAIL PROTECTED]] Sent: Monday, May 15, 2000 6:38 AM To: [EMAIL PROTECTED] Subject: Anyone have any knowledge of CFCONTENT? I am trying to use CFConten

CFCONTENT and File Download

2000-05-12 Thread Randy Adkins
I am trying to use CFContent to serve up files for downloading. I have various of file types ranging from TXT, XLS, EXE, ZIP, and DOC files. EXE and ZIP files are working correctly. However if I use TXT, XLS, and DOC files, they will be opened in the browser or I get a message of:

Re: DayofWeek()

2000-05-12 Thread Randy Adkins
This function returns 6 for me: cfset myday = #Dayofweek(Now())# cfoutput#myday#/cfoutput Try checking the DATE on the server. - Original Message - From: "David E. Crawford" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, May 12, 2000 11:01 AM Subject: DayofWeek() I

SQL ID

2000-05-12 Thread Randy Adkins
Anyone know how to input a unique id within an SQL database? I have a field called Client_ID as uniqueidentifier and do NOT allow NULLS but it will not insert the ID as MS Access does. Thanks in advance. -- Archives:

Re: DayofWeek()

2000-05-12 Thread Randy Adkins
The other is set as Friday May 12, 2000, 15:24 (UTC). Dave - Original Message ----- From: Randy Adkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 12, 2000 15:13 Subject: Re: DayofWeek() This function returns 6 for me: cfset myday = #Dayofweek(Now())# cfou

CFContent

2000-05-12 Thread Randy Adkins
I am trying to use CFContent to serve up files for downloading. I have various of file types ranging from TXT, XLS, EXE, ZIP, and DOC files. EXE and ZIP files are working correctly. However if I use TXT, XLS, and DOC files, they will be opened in the browser or I get a message of:

  1   2   >