Re: Baffled by Lost Session

[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 it apart line by line.

On Sat, Oct 31, 2009 at 8:06 PM, Jason Fisher  wrote:

>
> I don't remember what version of CF you said you were running (and the
> HoF site's not responding), but using CFLOCATION directly after CFSET
> session.blah = form.foo will actually fail to set the session in CF6.1
> and before.  Can't remember if this affects 7 or not, but I don't think so.
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327886
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Baffled by Lost Session

[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 \ index.cfm
 webroot \ admin \ profile.cfm

ok, I can pull up the website, type in the login information and will be
logged into the site successful and can see the administration home page
located at: webroot\admin\index.cfm

The Application.cfm file is located at the webroot level (there are no other
application files (cfm or cfc) in this structure
here is my CFAPP tag:

CFAPPLICATION NAME="myTestSite" SETCLIENTCOOKIES="YES" SESSIONMANAGEMENT=
"Yes" SESSIONTIMEOUT="#CreateTimeSpan(0, 0, 20, 0)#"


Now, while I am on the admin home page, if I go to profile.cfm (which is
located in the SAME folder, it loses the session).
I can dump the session scope on the admin home page, and the cfid and
cftokens are there, all my session variables are there.
But as soon as I go to another page, it seems as the session is destroyed
and all variables are lost. as now the cfid and tokens are different.
hmm, just checked and it does not seem to be setting the client cookie
either (Internet Explorer 8.0)


Anyone else have this issue? I have many sites and all are acting the
same...


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327854
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Users access to a listbox

[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
FORM.COMPANY_NUMBER

then this would work:



[#COMPANY_Number#]


*** Now this is true if FORM.COMPANY_NUMBER is a SINGLE VALUE not a list.

If you FORM.COMPANY_NUMBER is a LIST, then it would be similar to:





On Wed, Sep 30, 2009 at 4:49 AM, Damo Drumm wrote:

>
> Hi, at the minute when i add a user to the database they can view all
> companies on a list box. Im trying to reduce this so they will only have
> access to what i enter in a table called USERSvCOMPANYACCESS, which has the
> Users Key and the Company Number in it. Im using the below code, but its
> displaying all company numbers I enter to that table, rather than just the
> numbers I have chosen for that one user.
>
> Can anyone help me out here?
>
> 
> select COMPANY_Number,USERS_Key
> from USERSvCOMPANYACCESS
> ORDER BY COMPANY_Number
> 
>
> 
>   COMPANY_Number)>selected>
> [#COMPANY_Number#]
> 
> 
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326772
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Using a Listbox to allow Users Access

[Randy Adkins]

Yes, however you will need to validate permissions when needed

Ex:

... GOOD

... BAD




On Mon, Sep 28, 2009 at 7:14 AM, Damo Drumm wrote:

>
> Thanks, The first option will suit me
> so if i set up a field in My Users table called CompanyAccess,
> then followed by the correct code it will be able to pick out wheather or
> not I can access it depending which numbers I have entered in my
> CompanyAccess field
>
> >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"
> >Session.CompanyAccess.Permissions_2 = "R"
> >Session.CompanyAccess.Permissions_3 = "C,R,U"
> >
> >(CRUD = Create, Read, Update, Delete)
> >
> >
> >
> >
> >On Mon, Sep 28, 2009 at 6:01 AM, Damo Drumm  >wrote:
> >
> >>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326695
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Using a Listbox to allow Users Access

[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"
Session.CompanyAccess.Permissions_2 = "R"
Session.CompanyAccess.Permissions_3 = "C,R,U"

(CRUD = Create, Read, Update, Delete)




On Mon, Sep 28, 2009 at 6:01 AM, Damo Drumm wrote:

>
> Hi, I have a drop down list on a form showing a list of Companies, which
> ive linked to a table called Company,
> Im trying to use this list to give access for each username,
> at them min when someones name is added to the Table (Users) they have
> access to all Companies on the list box, im trying to change this so i can
> give each person access to only the companies I require
> Can someone help me out on how I go a bout doing this?
> Thanks
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326686
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CF: TimeZoneInfo

[Randy Adkins]

Excellent... This worked:  http://www.petefreitag.com/item/171.cfm

Adding the argument to the Java args worked!!



On Wed, Sep 16, 2009 at 4:25 PM, Judah McAuley  wrote:

>
> That sounds about right then. Being -5 plus being in DST would result
> in it being 4 hours off if it were displaying UTC.
>
> I don't really know the internals of the JVM and timezones. I think
> that part of it will depend on which version of the JRE you are
> running. Doing a bit of quick googling comes up with the following
> articles which may be of some help:
>
> http://www-01.ibm.com/support/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 
> wrote:
> >
> > US Eastern TimeZone (-5)
> > I know the locale is set right: English (US)
> >
> > Any idea how I can check the Java Locale?
> >
> >
> >
> > On Wed, Sep 16, 2009 at 1:15 PM, Judah McAuley 
> wrote:
> >
> >>
> >> What is your time zone? Should you be on UTC or are you in a different
> >> time zone? If you are not on UTC then you ought to have an offset
> >> listed there and I'm going to guess that your Java Locale is messed
> >> up. CF doesn't get local time zone info (I believe) from your system
> >> but rather from Java. If the Java locale is incorrect, CF will be
> >> incorrect. I don't actually know how to change your Java 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 
> wrote:
> >> >
> >> > 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 Offset: 0
> >> >
> >> > In the Date/Time options in the Server's control panel (W2k3), the DST
> is
> >> > checked. Thus the proper time on the server is accurate.
> >> >
> >> > Any idea why CF is off?
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326379
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Best approach

[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 master database.

Thought?

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326364
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CF: TimeZoneInfo

[Randy Adkins]

US Eastern TimeZone (-5)
I know the locale is set right: English (US)

Any idea how I can check the Java Locale?



On Wed, Sep 16, 2009 at 1:15 PM, Judah McAuley  wrote:

>
> What is your time zone? Should you be on UTC or are you in a different
> time zone? If you are not on UTC then you ought to have an offset
> listed there and I'm going to guess that your Java Locale is messed
> up. CF doesn't get local time zone info (I believe) from your system
> but rather from Java. If the Java locale is incorrect, CF will be
> incorrect. I don't actually know how to change your Java 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  wrote:
> >
> > 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 Offset: 0
> >
> > In the Date/Time options in the Server's control panel (W2k3), the DST is
> > checked. Thus the proper time on the server is accurate.
> >
> > Any idea why CF is off?
> >
> >
> >
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326362
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CF: TimeZoneInfo

[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 Offset: 0

In the Date/Time options in the Server's control panel (W2k3), the DST is
checked. Thus the proper time on the server is accurate.

Any idea why CF is off?


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326354
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: eSignature

[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  wrote:

> 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 reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324784
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

eSignature

[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 reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324782
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: list question

[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.





Something like that anyway... syntax may not be right but you get the idea


On Fri, May 1, 2009 at 10:13 AM, Scott Stewart wrote:

>
> Hey all..
>
>
>
> I have a ColdFusion list of orderIDs generated from a query..
>
> The list drives a pair of hrefs (next and previous)
>
>
>
> The user will click on a link from another page which opens an order
> detail.
>
> At the top of the detail page are the next and previous links.
>
>
>
> How can I determine the next item in the list and the previous item in the
> list, given that the selected item is not list first or list last..
>
>
>
> Thanks
>
>
>
> sas
>
>
>
> --
> Scott Stewart
> ColdFusion Developer
> 4405 Oakshyre Way
> Raleigh, NC 27616
> (h) 919.874.6229 (c) 703.220.2835
>
>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322103
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Sending Mail with CF

[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 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"
> >
> > We have the mail server setup in the CF Admin and it
> > validates when we choose to verify connection.
> >
> > We are not passing a username/password in the CFMAIL tag as
> > the FROM line is purely dynamic based on is doing the request.
> >
> > Example:
> > I am logged in (racf2008) to the domain (intranet). Using
> > Windows Authenication to get some information. Then I
> > generate a new request that is sent to out Marketing shop
> > -- Sender: [EMAIL PROTECTED]   to: [EMAIL PROTECTED]
> >
> > Problems is the mail goes to the spool directory, fails when
> > sending, moves message to Undeliv.
> > CF Log reads: "Client was not authenicated"
> >
> > Any ideas on how to get this to work w/o using Anonymous
> > Access turned on?
>
> That's not how SMTP Authentication works. You can't grab the credentials
> from the user represented by the "From" address, because your application
> doesn't have those credentials and can't impersonate that user. You'll need
> a set of credentials that the CF server can use to send mail, and you'll
> need to embed them in the CF Administrator or the CFMAIL tag.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
>
> Fig Leaf Software provides the highest caliber vendor-authorized
> instruction at our training centers in Washington DC, Atlanta,
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more information!
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311430
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Web Services & CERT

[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 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 call it directly but when setting it up in CFADMIN, it
> > throws the error mentioned previously.
>
> If your web service uses web server authentication in IIS, you'll need to
> provide a username and password in CFINVOKE or when you register the
> service
> in the CF Admin.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
>
> Fig Leaf Software provides the highest caliber vendor-authorized
> instruction at our training centers in Washington DC, Atlanta,
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more information!
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311427
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Sending Mail with CF

[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"

We have the mail server setup in the CF Admin and it validates when we
choose to verify connection.

We are not passing a username/password in the CFMAIL tag as the FROM line is
purely dynamic based on is doing the request.

Example:
I am logged in (racf2008) to the domain (intranet). Using Windows
Authenication to get some information. Then I generate a new request that is
sent to out Marketing shop
-- Sender: [EMAIL PROTECTED]   to: [EMAIL PROTECTED]

Problems is the mail goes to the spool directory, fails when sending, moves
message to Undeliv.
CF Log reads: "Client was not authenicated"

Any ideas on how to get this to work w/o using Anonymous Access turned on?


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311425
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Web Services & CERT

[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 call it directly but when setting it up in CFADMIN, it throws the
error mentioned previously.

So I am at a loss right now. (Still learning all the security meassures and
locked down items).



On 8/22/08, Dave Watts <[EMAIL PROTECTED]> wrote:
>
> > 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 just fine, I have tested it to ensure they
> > are no errors present. The error when registering via CF Admin is:
> > "Error creating web service. Please check the web service
> > name and/or url."
> >
> > That is basically what the error reads. Thus lead me to run
> > the CFC locally and found the login issue. I can not pass the
> > username/password via CFInvoke tag as other people externally
> > would be accessing the Web Service.
>
> How you can access the web service is entirely controlled by the
> configuration of the server hosting the web service. But, I don't
> understand
> the part about why you can't pass the username and password. Will the
> external people connect outside of your app? If so, they'll need usernames
> and passwords, or you'll have to have the authentication turned off.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
>
> Fig Leaf Software provides the highest caliber vendor-authorized
> instruction at our training centers in Washington DC, Atlanta,
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more information!
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311423
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Web Services & CERT

[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 just fine, I have tested it to ensure they are no errors
present. The error when registering via CF Admin is:
"Error creating web service. Please check the web service name and/or url."

That is basically what the error reads. Thus lead me to run the CFC locally
and found the login issue. I can not pass the username/password via CFInvoke
tag as other people externally would be accessing the Web Service.

Anyone have any thughts/comments on this?


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311400
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

OT: Oracle Query Question

[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 questions:
Yes, the field within the oracle database is a true date time field.
Yes, I already tried: to_date(...,'YEAR') and to_date(...,YEAR)
Yes, I googled it as well and using similar syntax as:
http://www.oradev.com/oracle_todate.jsp
http://www.oradev.com/oracle_date_format.jsp

What am I doing wrong?


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304510
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CustomTags?

[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 of the ThreeSelectsRelated Customtag?
> >
> > It is no longer in the Macromedia site.
> >
> > TIA!
> >
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CustomTags?

[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 · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Access to SQL Server

[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


> In Access you can set the primary key to auto number - how do you do this
in
> SQL Server?  I would assume that has something to do with this error that
I
> am getting:
>
>   Error Diagnostic Information
>   ODBC Error Code = 23000 (Integrity constraint violation)
>
>
>   [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the
value
> NULL into column 'UserID', table 'SaraLee.dbo.ChockUsers'; column does not
> allow nulls. INSERT fails.
>
>
>
> Thanks!
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF and Hit Counter

[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 different visitor lets call Visitor B
which is using the same ISP (Dial-up) and happens to have the
same IP as Visitor A, so you check the database table and see
the person has already visited the site considering the IP is present
which in fact this could be a brand new person.

Unless you are just trying to identify where you main traffic comes
from then this is fine, but to get an very close accurate Hit Couter
on new visitors it is a bit hard.

DAMN THEM DIAL-UPS...



- Original Message -
From: "Steve Oliver" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, January 27, 2002 8:39 PM
Subject: RE: CF and Hit Counter


> I don't see anything wrong with doing it that way.
> It won't cause any performance loss unless you get overloaded with hits
> all at once.
> But if your sites traffic generally comes from the same people, that way
> would work just fine.
>
> __
> steve oliver
> cresco technologies, inc.
> http://www.crescotech.com
>
>
> -Original Message-
> From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, January 27, 2002 8:35 PM
> To: CF-Talk
> Subject: CF and Hit Counter
>
>
> Hi all,
>
> I am in the process of writing a hit counter app in java, but in the
> meantime, I have thrown a little something together in CF and wanted to
> get some feedback on it.
>
> I have a SQL Server backend to this site and what I do is in the
> application.cfm page, I check for the existence of a variable called
> session.visitor. If it exists, it means that the application already ran
> the next part which is the code to look at the users IP and check for it
> in a table in my DB... if there is a match it sets the variable
> session.visitor again, and if no match is found it adds a record and
> then sets the variable.
>
> Is there anything wrong with the way I do this?...is there a more
> efficient way?
> Just so you know, I am unable to use cookies on this site.
>
> Mike
>
>
>
> 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: extracting data from a huge text file

[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 would
be suitable solution.




- Original Message -
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 24, 2002 7:19 PM
Subject: Re: extracting data from a huge text file


> Forget about using CF to read a file that big unless you've got a lot of
> memory in the server.  If CF is your only tool for actually getting the
data
> into your database, you might use something like Perl to first break the
> file up into many smaller files, then run those through CF.  If you're a
bit
> more proficient at Perl, just use Perl to read the file and insert the
data
> in the db and be done with it.
>
> Jim
>
>
> - Original Message -
> From: "Chris Giminez" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, January 24, 2002 5:09 PM
> Subject: extracting data from a huge text file
>
>
> > I'm trying to retrieve data and put it into a database from a text file.
> > The text file is over 100MB with  (I'm guessing) around 260,000 records,
> each record contains 85
> > fields.
> >
> > I tried to create a conditional loop at each line break, which works
fine
> if I am working on a
> > smaller version of the file, but chokes on the 100MB monster. Is there a
> more efficient way to deal
> > with this other than looping through it or is there a way to break this
> file up into smaller chunks
> > and deal with it piece by piece?
>
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: OT-PayPal Limitations

[Randy Adkins]

Message from PayPal Representative:

The maximum amount of money you can send through PayPal is $10,000 per
transaction.  If you need to send more than $10,000, you can make multiple
transactions to add up to your total amount.  The minimum amount of money
you can send per transaction is $0.01.

Please note, before users confirm a bank account or add a valid credit
card, their sending limit will be $0, even if there is a PayPal balance in
the account.  If a user registers a valid credit card, the user will have a
$1,000 sending limit.  PayPal requires an additional form of verification
before a member can send more than $1000 using his/her PayPal Account.*  To
raise your sending limit, you must confirm a bank account.  Once your bank
account is confirmed, your sending limit will be lifted.  Also, once your
bank account is confirmed, your PayPal charge limit will be unlimited,
subject to credit availability from your credit card company.

- Original Message -
From: "Stephen M. Aylor" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 24, 2002 6:55 PM
Subject: Re: OT-PayPal Limitations


> Certain PayPal Merchants used to be able to put a link on their web page
for
> a certain item as a BUY NOW deal .  what I did to over come this - as
a
> PayPal merchant, on a couple items ... I emailed the link and it allowed
the
> payer to fill in credit card data and buy a $3,000 item, and banga- all
done
> not even a paypal user - but they could use their CC.
>
> 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: OT-PayPal Limitations
>
>
> > 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 Message-
> > > From: s slargo [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, January 24, 2002 12:14 PM
> > > To: CF-Talk
> > > Subject: OT-PayPal Limitations
> > >
> > >
> > > PayPal requires that our customers add a bank account to make large
> > > purchases w/a credit card at our site.  Does anyone know where the
> cutoff
> > > for requiring the bank account is?  I've heard $200, $2000, $1000, my
> > tests
> > > show it is $650.  Is is customer specific?  Would it be possible to
get
> > > around this feature by breaking our product into smaller packages
(lets
> > say
> > > 1/4 the size and price) and just have our customers go through the
> > purchase
> > > 4 times to get the quantity they actually desire?  I can't figure out
a
> > way
> > > to test this stuff without handing out my real credit card number.  I
> > know,
> > > maybe its time for us to go with a real credit card processor.  Let me
> > know
> > > what you guys think.
> > > Thanks!
> > >
> > > _
> > > _
> > > ___
> > > Join the world's largest e-mail service with MSN Hotmail.
> > > http://www.hotmail.com
> > > _
> > > _
> > > 
> > > Get Your Own Dedicated Windows 2000 Server
> > >   PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
> > >   Instant Activation · $99/Month · Free Setup
> > >   http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
> > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> > >
> >
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: OT-PayPal Limitations

[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 Message-
> From: s slargo [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 24, 2002 12:14 PM
> To: CF-Talk
> Subject: OT-PayPal Limitations
>
>
> PayPal requires that our customers add a bank account to make large
> purchases w/a credit card at our site.  Does anyone know where the cutoff
> for requiring the bank account is?  I've heard $200, $2000, $1000, my
tests
> show it is $650.  Is is customer specific?  Would it be possible to get
> around this feature by breaking our product into smaller packages (lets
say
> 1/4 the size and price) and just have our customers go through the
purchase
> 4 times to get the quantity they actually desire?  I can't figure out a
way
> to test this stuff without handing out my real credit card number.  I
know,
> maybe its time for us to go with a real credit card processor.  Let me
know
> what you guys think.
> Thanks!
>
> _
> _
> ___
> Join the world's largest e-mail service with MSN Hotmail.
> http://www.hotmail.com
> _
> _
> 
> Get Your Own Dedicated Windows 2000 Server
>   PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
>   Instant Activation · $99/Month · Free Setup
>   http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Oracle 8.1.5 & CF5

[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 · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Oracle Connection?

[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 ODBC connection thru CF to the native
Oracle box.

Thoughts

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Dynamically sortable table data

[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]>
Reply-To: [EMAIL PROTECTED]
date: Fri, 11 Jan 2002 12:39:12 -0800

>Does anyone know of a way to make database output in a html table sortable

>by any chosen column after the data is output to the table.  I am trying t
o
>avoid CFGRID because of the numerous JVM issues with CF5.0.
>
>Mike Brunt
>Sempra Energy
>213.244.5226
>
>"Smith & Wesson - the original point and click interface."
>
>
>
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Merchant Accounts?

[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 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

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

[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
Subject: Dave or someone -- Help me with error msg!!!


> I just started a $90 a month ISP account with ColdFusion and a
> database.
> Help confirmed that I actually got my tables over, and that the error
> is on my side.
>
> This is the error I get and beneath it is the code: (Don't laugh -- I
> have done ColdFusion at UPS for two years...)
>
> Error Occurred While Processing Request
> Error Diagnostic Information
> ODBC Error Code = 28000 (Invalid authorization specification)
>
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> 'jgrn123'.
>
>
>
> The error occurred while processing an element with a general
> identifier of (CFQUERY), occupying document position (2:1) to (2:64).
>
>
> Date/Time: 01/04/02 14:28:08
> Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows 98)
> Remote Address: 24.128.190.210
>
>
> This is my coldfusion code:
>
> 
>
>   SELECT *
>   FROM ultra
>
> 
> 
> 
> 
> 
> 
> 
> 
> #Name#
> 
> 
> 
> 
> 
>
> Thanks Julia Green, Julia Computer Consulting
> Email:  [EMAIL PROTECTED]
>
> --- Dave Watts <[EMAIL PROTECTED]> wrote:
> > > I was looking through the list archives at recommedations
> > > for protecting images - ie, not allowing images files to
> > > be called directly from the browser. The main recommendations
> > > seem to involve CFCONTENT. The site I will be working on
> > > will require this, and will also potentially be quite high
> > > traffic. I was wondering how well cfcontent works under load
> > > in situations like this.
> >
> > It's going to run every request through CF, which is going to
> > significantly
> > increase the amount of work CF has to do. The same issue comes up
> > with
> > regular HTML pages - if you want to force authorization using CF, you
> > might
> > map .html to be processed by CF, but there's a serious performance
> > penalty.
> >
> > You can address this by either finding an alternative that doesn't
> > require
> > runtime processing (with CF or any other CGI tool), or by ensuring
> > that your
> > CF servers can handle the load by getting more and/or bigger ones.
> >
> > > Also, the other recommendation was to get the web server to handle
> > > this. I will be on IIS5 on Win2K, on shared hosting, but my host is
> >
> > > usually quite accomodating when it comes to setting things up for
> > me.
> > > How would you restrict calling images through IIS? Does it involve
> > > setting the image file types to be handled by the CF server, so
> > > Application.cfm is called before each? Is this better (in terms of
> > > performance) than using CFCONTENT for the same purpose?
> >
> > To the best of my knowledge, the only way to get IIS to handle this
> > for you
> > is to set the appropriate permissions on each image file, and have
> > IIS force
> > authentication against requests for those files. There's very little
> > overhead in that, but it would require that you have a Windows
> > account for
> > the user to use, and it wouldn't directly integrate with your
> > application,
> > in the sense that the user would get a browser authentication popup
> > window.
> >
> > You might be able to do something better by writing an ISAPI
> > extension (or
> > looking for an existing ISAPI extension) which checks for the
> > existence of
> > some token (a cookie or URL variable, for example) before allowing
> > the
> > request to be processed. I haven't written any ISAPI extensions
> > myself, and
> > suspect it's a bit more complicated than most CF programming, but I'd
> > guess
> > that it would perform better for this specific task.
> >
> > Dave Watts, CTO, Fig Leaf Software
> > http://www.figleaf.com/
> > phone: 202-797-5496
> > fax: 202-797-5444
> >
>
> 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF editing software - vote

[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 has not crashed at all since I did a clean install of Win2K.  It was
awefull when installed on Win98.  Upgrade if you can!!

Rich

-Original Message-
From: Stewart McGowan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 09, 2000 8:11 AM
To: CF-Talk
Subject: RE: CF editing software - vote


Actually I don't particularly like studio, it crashes too often for me.

Stew


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: CFSchedular

[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.

Then used CFSchedule to call that template.

HTH

-Original Message-
From: Venkata Ramakrishna [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 12:52 AM
To: CF-Talk
Subject: CFSchedular


Hi all,
I have a problem with my CFScheduler or i think so(iam
using CF 4.5).
I have scheduled a mail application to be fired at a
particular time.The schedular log file shows that the
operation has been fired and the submission is done.
The required effect i.e the mails getting sent is not
observed.

If the file is run from the browser,then the mails are
being sent.

Any one has got an idea about what may the problem??

Please help me out.My boss is kicking me in the ass
day in and day out.

Thanks.

__
Do You Yahoo!?
Thousands of Stores.  Millions of Products.  All in one Place.
http://shopping.yahoo.com/


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Hosting Question???

[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,
Rich


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: CFMAIL ERROR

[Randy Adkins]

Nice website however your MAILTO tags do not work.
Try using "mailto:[EMAIL PROTECTED]"
use the QUOTES!

Also when doing a lookup for travel accommodations
it generated the following:

Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (11:1) to (11:52).


Date/Time: 11/07/00 05:35:10
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
Remote Address: 159.142.134.132
HTTP Referer:
http://australianaccommodation.com/austonline/signupwork/accomm/signup/enter
_password.cfm




















-Original Message-
From: AustralianAccommodation.com Pty. Ltd.
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 07, 2000 8:23 AM
To: CF-Talk
Subject: CFMAIL ERROR


the following code works fine when there is only one record that meets the
cfquery condition


select *
from retail
where activestatus= 'b'






#website#/austonline/marketing/businessadvert.cfm?adminid=#advert.adminid#&c
ategory=shops



however when there is more than one record that meets the condition the
system generates the following error

Error Diagnostic Information
unknown exception condition

TagCFMail::sendMessage

The error occurred while processing an element with a general identifier of
(CFMAIL), occupying document position (14:1) to (18:47).


I look forward to your suggestions



Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Email: [EMAIL PROTECTED]
Developers Of:
  Website: www.AustralianAccommodation.com
  Website: www.AccommodationNewZealand.com




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Hosting

[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 message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: CFPOP.... Help!

[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 CFPOP tags. It
seems to allow me to do each seperately, but when I put
them both on the same page, I get a bizarre error
message "[IN-USE] Maildrop locked by another
session"

Any ideas?

Thanks!

Norman Elton
Information Technology
College of William & Mary


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: checkboxes

[Randy Adkins]

Look dude, if you read what he asked it said
'ONLY THE BOX THAT WAS CHECKED' this indicates
ONE not multiples...

Thus the best solution is radio buttons.

I am not as petty to get into name calling as
you have illustrated your maturity.




-Original Message-
From: Scott, Andrew [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 25, 2000 7:15 PM
To: CF-Talk
Subject: RE: checkboxes


You Idiot Randy! It was nice to see another solution to the opposite of his
problem, however he did say he wanted a list of the selected items and radio
buttons don't allow multiple selections as you point out:-)

regards

Andrew Scott
Senior Cold Fusion Application Developer
ANZ eCommerce Centre
* Ph 9273 0693
* [EMAIL PROTECTED]


-Original Message-----
From: Randy Adkins [mailto:[EMAIL PROTECTED]]
Sent: 26 October 2000 01:09
To: CF-Talk
Subject: RE: checkboxes


You can use radio buttons to better do what you wish.

Something like:







This way when the 2nd one is checked the first one
becomes 'unchecked'. Thus the value is now 2.

If you must use check boxes, I would do something like:






Only problem is when you test to see if thisbox1 isdefined
and insert it into the DB, what happens is if both
box 1 and 2 was checked. Thus I would use the radio buttons.

HTH

Randy


-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 25, 2000 9:58 AM
To: CF-Talk
Subject: checkboxes


Hi,

I have 5 checkboxes on a form, and I want to submit to a database only the
box that was checked.  How can I do this?

Thanks



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Credit card validation service?

[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 web)?
I would like to be able to verify if a credit card is valid before
passing the email along to billing.

I know I can validate the NUMBER, using mod10, but I would like to
pass some service the number, name on card, exp date, etc and see
if its valid, and maybe even see if a purchase of $XX would go through.

Thanks for any info.

Ryan



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Validate Multiple docs

[Randy Adkins]

Yes, you can use variables to determine what validation
to process on the given page.

Example:



' Process for step one
' Example: ADD RECORD TO DATABASE

' Process for step one
' Example: DELETE RECORD FROM DATABASE
..
..
..




-Original Message-
From: j p [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 25, 2000 3:42 PM
To: CF-Talk
Subject: Validate Multiple docs


Can you use CF Studio to validate multiple pages??
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: checkboxes

[Randy Adkins]

You can use radio buttons to better do what you wish.

Something like:







This way when the 2nd one is checked the first one
becomes 'unchecked'. Thus the value is now 2.

If you must use check boxes, I would do something like:






Only problem is when you test to see if thisbox1 isdefined
and insert it into the DB, what happens is if both
box 1 and 2 was checked. Thus I would use the radio buttons.

HTH

Randy


-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 25, 2000 9:58 AM
To: CF-Talk
Subject: checkboxes


Hi,

I have 5 checkboxes on a form, and I want to submit to a database only the
box that was checked.  How can I do this?

Thanks



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Error Number 1450 (Win NT)

[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 looking.

-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 26, 2000 9:33 AM
To: CF-Talk
Subject: Error Number 1450 (Win NT)


This is a multi-part message in MIME format.

--=_NextPart_000_0015_01C03F2F.B61ADB00
Content-Type: multipart/alternative;
boundary="=_NextPart_001_0016_01C03F2F.B61ADB00"


--=_NextPart_001_0016_01C03F2F.B61ADB00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello all  got a new error today and am baffled. I have an application
that allows a user to update a small amount of text from a form. However,
for the past 2 days, it's been returning the following error:

Error writing data from web server to the Cold Fusion Application Server

Windows NT Error number 1450 occurred.

The application has worked fine for 3 months without errors and nothing is
different on the server at all  anyone know the root of this? Or even
encountered it before?

Any help appreciated.

Joshua Miller
Web Development
Eagle Technologies Group, Inc.
Business Solutions for the Next Generation
www.eagletgi.com
[EMAIL PROTECTED]


--=_NextPart_001_0016_01C03F2F.B61ADB00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






Hello =
all  got a=20
new error today and am baffled. I have an application that allows a user =
to=20
update a small amount of text from a form. However, for the past 2 days, =
it's=20
been returning the following error:
 
Error =
writing data=20
from web server to the Cold Fusion Application =
Server
 
Windows NT Error=20
number 1450 occurred.
 
The =
application has=20
worked fine for 3 months without errors and nothing is different on the =
server=20
at all  anyone know the root of this? Or even encountered it=20
before?
 
Any =
help=20
appreciated.
 
Joshua MillerWeb =
Development
Eagle Technologies Group, =
Inc.
Business Solutions for the Next=20
Generation
http://www.eagletgi.com/">www.eagletgi.com
mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]
 

--=_NextPart_001_0016_01C03F2F.B61ADB00--

--=_NextPart_000_0015_01C03F2F.B61ADB00
Content-Type: text/x-vcard;
name="Joshua Miller.vcf"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="Joshua Miller.vcf"

BEGIN:VCARD
VERSION:2.1
N:Miller;Joshua
FN:Joshua Miller
ORG:Eagle Technologies Group, Inc.;Web Development
TITLE:Web Developer
NOTE;ENCODING=3DQUOTED-PRINTABLE:Joshua Miller=3D0D=3D0AWeb Site =
Development=3D0D=3D0AEagle Technologies Group, Inc.=3D
=3D0D=3D0ABusiness Solutions for the Next =
Generation=3D0D=3D0Ahttp://www.eagletgi.co=3D
[EMAIL PROTECTED]=3D0D=3D0A=3D0D=3D0A =3D0D=3D0A=20
TEL;WORK;VOICE:(304) 456-4942
TEL;HOME;VOICE:(304) 456-4942
ADR;WORK:;Clarksburg, WV;HC 63 Box 52c;Arbovale;WV;24915;United States =
of America
LABEL;WORK;ENCODING=3DQUOTED-PRINTABLE:Clarksburg, WV=3D0D=3D0AHC 63 Box =
52c=3D0D=3D0AArbovale, WV 24915=3D0D=3D0AUnited States=3D
 of America
URL:
URL:http://www.eagletgi.com
ROLE:Web Application Developer
BDAY:2826
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20001005T135238Z
END:VCARD

--=_NextPart_000_0015_01C03F2F.B61ADB00--



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Slightly OT: Cable Modem and TZO

[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 straight IP address, please beware
that @Home service updates their Gateway periodically thus
in your network properties the Gateway is no longer valid.

Things to consider. Sorry but I think it is the few things you
should know prior to doing so. I do have a friend who has been
doing his from home with @Home service.



-Original Message-
From: Debbie McDaniel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 24, 2000 2:32 PM
To: CF-Talk
Subject: Slightly OT: Cable Modem and TZO


Hi everyone,

I am currently subscribed as a @Home (cable modem) user. I would like to
host my own personal CF website (.com) on my own server. Has anyone ever
heard of TZO? Is anyone hosting their own server using @Home (with or
without TZO)?

Thanks,

Deb



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Problem with email form validation

[Randy Adkins]

Sorry use this:

Form_OnSubmit = False
Exit Function

Just remember if you give the form a name then substitute it in JavaScript


-Original Message-
From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 24, 2000 2:21 PM
To: CF-Talk
Subject: Re: Problem with email form validation


I'm sorry, but it still submits the form.
It must be because of the scripts created by ColdFusion.


- Original Message -
From: "Christopher Olive, CIO" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 24, 2000 12:02 PM
Subject: RE: Problem with email form validation


> you need to add a "return false;" in there.  like this
>
>   function CheckEmail() {
>if(!ValidEmail(document.EmailForm.Email)) {
>alert("#data.a73#");
>return false;
>}
>return true;
>   }
>
> otherwise, the script will always return true, and always think the email
is
> correct.
>
> chris olive, cio
> cresco technologies
> [EMAIL PROTECTED]
> http://www.crescotech.com
>
>
>
> -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.
>
> I am using the CFINPUT 's "Required" and "Message"
> options.  They work great, except that I want to
> go further with the email verification.
> I inserted a script to verify the format of the
> email address.  The problem is that if all the
> fields are correct except for the email format, this scripts
> correctly tells me that the email is not in a proper format,
> but after I click on OK, the form is sent anyways.
>
> Here is one of the scripts I tried:
>
> 
>   function ValidEmail(item) {
>var lsAT;
>var lsDOT;
>
>lsAT = item.value.indexOf("@");
>lsDOT = item.value.indexOf(".");
>
>if (lsAT == -1 || lsDOT == -1 || item.value.indexOf(" ") != -1 || lsAT
+
> 1 >= lsDOT ) {
> return false;
>}
>return true;
>   }
>
>   function CheckEmail() {
>if(!ValidEmail(document.EmailForm.Email)) {
>alert("#data.a73#");
>}
>return true;
>   }
>
>  
>
>
> Any help would greatly be apreciated.
> TIA!
> _
> Michael
>
> --
--
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a
> message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

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

[Randy Adkins]

You can use the CFX_Zip which is what I use to compress files.
It has the ability to create a ZIP file, update a ZIP file,
uncompress a zip file, etc...

It is on the Allaire site as well.

HTH

-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 24, 2000 12:49 PM
To: CF-Talk
Subject: RE: What If You Don't Know The File Type?




At this point, we're not storing any information about the files in a db (we
will eventually, but we're not to  that point yet). Does  have
a method for determining the type of file (jpeg, pdf, sit)?  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 are on Macs and would probably prefer stuffit
archives).

H.


=
Howard Owens
Web Producer
InsideVC.com
mailto:[EMAIL PROTECTED]
=

> -Original Message-
> From: Steve Martin [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, October 24, 2000 9:12 AM
> To:   CF-Talk
> Subject:  RE: What If You Don't Know The File Type?
>
> Once a file has been uploaded using CFFILE you have access to a bunch of
> FILE variables. Two of these variables will help you out here:
> FILE.ContentType
> FILE.ContentSubType
> For example, if a GIF file is uploaded, whether it has a .gif extension or
> not then the above variables will contain the values: image, gif
> respectively. You can store these values in your db against the file
> reference and combine them (image/gif) for use in CFCONTENT when
> delivering
> the files.
>
>


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

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

[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 Know The File Type?






I have a site where users can upload files to the server.  There is a vast
array of file types they can upload (PDF, all kinds of images, zipped
files, .sit files, etc.).

For the administrator, I have a page that displays all of the files in the
upload directory.  The admin can then click on a link to download the
file.  I want to use CFContent for this procedure, but CFContent requires
that you specify the file type.  But We don't know what the file type might
be.

How do I get around this requirement on CFContent?  What are the options.

H.

=
Howard Owens
Web Producer
InsideVC.com
mailto:[EMAIL PROTECTED]
=




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Problem with email form validation

[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.

I am using the CFINPUT 's "Required" and "Message"
options.  They work great, except that I want to
go further with the email verification.
I inserted a script to verify the format of the
email address.  The problem is that if all the
fields are correct except for the email format, this scripts
correctly tells me that the email is not in a proper format,
but after I click on OK, the form is sent anyways.

Here is one of the scripts I tried:


  function ValidEmail(item) {
   var lsAT;
   var lsDOT;

   lsAT = item.value.indexOf("@");
   lsDOT = item.value.indexOf(".");

   if (lsAT == -1 || lsDOT == -1 || item.value.indexOf(" ") != -1 || lsAT +
1 >= lsDOT ) {
return false;
   }
   return true;
  }

  function CheckEmail() {
   if(!ValidEmail(document.EmailForm.Email)) {
   alert("#data.a73#");
   }
   return true;
  }

 


Any help would greatly be apreciated.
TIA!
_
Michael



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Access question

[Randy Adkins]

We all must remember Access is mainly
a desktop database. It was never designed
as a database backend for web data or to
withstand simultaneous hits.

I used Access as well for the database
backend but had so many end user request to
the DB that I had to move up to a more
robust database backend such as SQL 7.0.

Now things are just fine.

If you do not make many calls to the DB then
Access is fine. But all in all, your decision
should be based on the number of hits, the
type of data help within the database.

Access can hold a vast amount of data. At one
time, I had over 600,000 records 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
Subject: RE: Access question


Sure, it can "handle" simultaneous Access from many users.  A bunny might be
able to handle a wolf for about 2 seconds, then it dies.  Same with Access.
I've had sites crash every 2 minutes using Access, move it to SQL and it
works fine.

Use SQL.  Don't screw with Access.

AJ

-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 12, 2000 10:27 AM
To: CF-Talk
Subject: RE: Access question


It can handle simultaneous Access.  Access is just a toned down version of
SQL (which it sounds like you already know).  You should base your decision
to upsize to SQL purely on the performance of your site and size that your
database grows to.  As far as simultaneous access is concerned, obviously
SQL will be better but may be overkill depending on the amount of traffic
that goes through the database.  In the words of someone else using this
usergroup (I think it was Bill!) - "Don't provide a Star Trek solution to a
Babylon 5 problem"

Apollogies Bill if I miss quoted you!

--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
--


-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]]
Sent: 12 October 2000 16:05
To: CF-Talk
Subject: RE: Access question


Thanks for the quick reply.

At this point I am more concerned about simultaneous access. Can it handle
simultaneous access from  many users or is SQL better for this.

Thanks Andy.

Robert O.

>-Original Message-
>From: Andy Ewings [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, October 12, 2000 8:49 AM
>To: CF-Talk
>Subject: RE: Access question
>
>
>How much data is in the table?  I would be extremely surprised if this was
>due to there being too much data in the table.  I think the maximum size of
>an Access mdb is approx 2gb but I aint sure about this.  I know
>that you can
>have a whole load of records in a table though (millions) not that you'd
>want to of course for performance reasons.  Run some test to pull out
>records yo know are there.  If it finds them then I'll bet that the login
>details they are using are incorrect.  Are you sure that the error message
>you get implies that no row was found when the query was run.  Have you got
>you db integrity set up so that the login details supplied make up the
>promary key of the table?
>
>--
>Andrew Ewings
>Project Manager
>Thoughtbubble Ltd
>--
>
>
>-Original Message-
>From: Robert Orlini [mailto:[EMAIL PROTECTED]]
>Sent: 12 October 2000 15:33
>To: CF-Talk
>Subject: Access question
>
>
>Hello,
>
>I have an Access database of email login addresses in an Access 2000 table.
>Outside users that have registered enter their login address and then are
>sent via a .cfm form to a URL.
>
>Yesterday my .cfm form started rejecting some users saying it
>could not find
>their address in the table. Is it conceivable that Access is now reaching
>its limit for what I need?
>
>I'm presuming now is the time to start using SQL.
>
>Any suggestions or hints?
>
>Thanks
>
>Robert O.
>HW Wilson
>
>---
>-
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>---
>---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or

RE: Anyone know how to use CFPOP?

[Randy Adkins]

The error I am getting is show below.
Also we are not using Netscapes InboxDirect
or using multipart/mixer or related material.
Nor the 8bit MIME and there is no attachments.

The simple message of

To: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
Subject: Help Me
Body:
Does this work yet???

Like I said no attachments or anything
out of the norm. I only get the error
with GETALL. The GETHEADERONLY and DELETE
work fine.

Error is as follows:

> Error Diagnostic Information
> unknown exception condition
> CFMLInterpreterImp::executePCode
> Date/Time: 10/03/00 13:40:49
> Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)


Thanks for helping this is really bugging me.



-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 04, 2000 11:34 AM
To: CF-Talk
Subject: Re: Anyone know how to use CFPOP?


>From the
ColdFusion 4.0 Release Notes
Updated October 5, 1998

a.. CFPOP throws an error when reading email messages that have a certain
date/time convention. This appears to be related to messages from Netscape's
InboxDirect or some other email that uses MDT instead of GMT. The error
message is (1858):

Error Occurred While Processing Request
Error Diagnostic Information
An error has occurred while processing the expression:
DateFormat(ParseDateTime(Mail.Date,"POP"),"ddd, d mmm ")
b.. CFPOP crashes when retrieving messages with action="GetAll" that contain
Content-Type: multipart/mixed or multipart/related. (6235)
c.. CFPOP doesn't recognize 8-bit attachment headers encoded by MIME. (6880)
d.. If an attachment's name is base64 encoded, CFPOP can not retrieve the
message, it times out. CPU usage pegs to 100%, and the memory use climbs.
After it times out not all memory is released. (7233)


Justin 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 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; MSIE 5.5; Windows NT 5.0)
>
>
> *** IP has been masked for this email ***
>  server="999.999.999.999" username="myname" password="mypass">
>
> NONE
> 
> #support_headers.from#
> 
>
> Thanks for any assistance you can give.
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
>


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Anyone know how to use CFPOP?

[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
CFMLInterpreterImp::executePCode
Date/Time: 10/03/00 13:40:49
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)


*** IP has been masked for this email ***


NONE

#support_headers.from#


Thanks for any assistance you can give.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CFPOP Experts????

[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: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 04, 2000 1:13 PM
Subject: CFPOP Experts


> 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; MSIE 5.5; Windows NT 5.0)
>
>
> *** IP has been masked for this email ***
>  server="999.999.999.999" username="myname" password="mypass">
>
> NONE
> 
> #support_headers.from#
> 
>
> Thanks for any assistance you can give.
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
>


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CFPOP Experts????

[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; MSIE 5.5; Windows NT 5.0)


*** IP has been masked for this email ***


NONE

#support_headers.from#


Thanks for any assistance you can give.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Reliability of CFSCHEDULE in CF 4.5.1

[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 more reliable in v4.5.1 than in past releases?  I've never
trusted it, always using Windows AT to run batch files launching templates.
Just wondering if Allaire has finally gotten a handle on all the past
problems.

I need to develope somethiing for an environment running 4.5.1 and would
like an idea of whether or not I should waste my time screwing around with
CFSCHEDULE.

Jim


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Expert??

[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 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Help using CFPOP

[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; MSIE 5.5; Windows NT 5.0)


*** IP has been masked for this email ***


NONE

#support_headers.from#


Thanks for any assistance you can give.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CFPOP

[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; MSIE 5.5; Windows NT 5.0)


*** IP has been masked for this email ***


NONE

#support_headers.from#


Thanks for any assistance you can give.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Date last modified (Access 2000)

[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: CF-Talk
Subject: Date last modified (Access 2000)


Is it possible to get the date that an Access 2000 database (linked via
ODBC) was last modified, regardless of whether it was done manually or
through CF???


Seth Ward


This message has been checked for all known viruses, by Star Internet,
delivered through the MessageLabs Virus Control Centre.
For further information visit:
http://www.star.net.uk/stats.asp


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Help? CF Error

[Randy Adkins]

Can anyone explain this?:

unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Unknown CF Error

[Randy Adkins]

Can anyone explain this?:

unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Encrypting a credit card field...

[Randy Adkins]

You can use the standard encrypt and decrypt in Cold Fusion.






Then decrypt it as needed:






-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 27, 2000 10:46 AM
To: CF-Talk
Subject: Encrypting a credit card field...


Good day,

I am looking for a solution for encrypting a credit card field with CF 4.5
and SQL 7.

I know about CFX_PGP.  It sounds like just what I need but I would like to
know if there are other solutions.  Does any one know of  any other
encryption custom tag or of a stored proc for SQL 7 that will encrypt a
field with a fair amount of security?

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770





--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Simple SQL Question

[Randy Adkins]

If you are adding 3 records to the DB then you do this:

INSERT INTO Data(Fieldone) Values('#form.dat1#)



INSERT INTO Data(Fieldone) Values('#form.dat2#)



INSERT INTO Data(Fieldone) Values('#form.dat3#)


If the form.dat1 + form.dat2 + form.dat3 is data to be entered into the ONE
field as a sum
then


INSERT INTO Data(Fieldone) Values('#alldata#)





- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 14, 2000 6:12 PM
Subject: Simple SQL Question


> Ok I want to "conjugate" 3 fields when i am inserting into a database.
>
> this is what i have, but it won't work, am i missing something???
>
> 
> INSERT INTO Data(data1)
> VALUES('#FORM.dat1# #FORM.dat2# #FORM.dat3#')
> 
>
>
> ?
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CF 4.5

[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 Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Email - Reply-to:

[Randy Adkins]

I take it that CFMAILPARAM is in CF 4.5?
I found nothing in 4.01

-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 14, 2000 8:05 AM
To: [EMAIL PROTECTED]
Subject: Re: Email - Reply-to:


CFMAILPARAM
CFMAILPARAM can either attach a file or add a header to a message. If you
use CFMAILPARAM, it is nested within a CFMAIL tag. You can use more than one
CFMAILPARAM tags within a CFMAIL tag in order to attach one or more files
and headers.

See also CFMAIL.

Syntax


or

...



~Justin

- Original Message -
From: "Randy Adkins" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 14, 2000 1:01 PM
Subject: Email - Reply-to:


> 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??
>
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
>


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Email - Reply-to:

[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??


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: E-mail Question

[Randy Adkins]

What about a reply-to??

I tried to place it in the body of the message but still replied to the
person in the FROM attribute



- Original Message -
From: "Peter Tilbrook" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 13, 2000 6:19 PM
Subject: RE: E-mail Question


> BCC is supported in CF 4.5.x. See:
>
>  BCC="blind_copy_to"
> SUBJECT="msg_subject"TYPE="msg_type"MAXROWS="max_msgs"
> MIMEATTACH="path"QUERY="query_name"GROUP="query_column"
> GROUPCASESENSITIVE="yes/no"STARTROW="query_row"
> SERVER="servername"
> PORT="port_ID"MAILERID="headerid"TIMEOUT="seconds">
>
> Peter Tilbrook
> Internet Applications 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:[EMAIL PROTECTED]]
> Sent: Thursday, 14 September 2000 6:01
> To: [EMAIL PROTECTED]
> Subject: E-mail Question
>
>
> 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
>
>
> --
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

E-mail Question

[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


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: ODBC

[Randy Adkins]

DUH!! I mean with CF Code.
I do believe anyone who is using CF can use
the Administrator or the Control Panel.

Does anyone know a way to determine if an ODBC exists
using CF Code?



-Original Message-
From: Mark Warrick [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 11, 2000 1:19 PM
To: [EMAIL PROTECTED]
Subject: RE: ODBC


Sure, Open up the Control Panel and look for it.

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business 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
>
>
> 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=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

ODBC

[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=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: ISP Recs

[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 come for me to move
on, and I'd like to hear from any of you who feel positive enough about your
ISP to recommend them. Please respond off list, thanks.

Criteria:
Relatively inexpensive
Full CF support and expertise
Courteous in handling problems
Little or no server down time
Two pluses would be  a) a host that caters to fusebox sites without charging
for custom tag installation (or which allows user to install his/her own),
and b) little or no charge for ODBC dsn setup, or facility to allow user to
do it.

Thanks,
--John Allred

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Web Host Ratings

[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


Occasionally, the topic comes up about host reliability, etc.  Isn't there a
web site where they rate the web hosting operations?  Does anybody know
where that is?

Thanks,
Dave



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Session timeout?

[Randy Adkins]

You almost have it, but try to see if a
session variable exists.

Example:






-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 10:01 AM
To: [EMAIL PROTECTED]
Subject: Session timeout?




Hello all.
   Is there a way to find whether the session timed out.If
the session timed out display the logon page.

Some like




but i cant get this work.

Appretiate any comments.

thanks
Joe


-
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Mail Servers?

[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 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 23, 2000 11:39 AM
To: [EMAIL PROTECTED]
Subject: Re: Mail Servers?


I think it could be,

try www.sendmail.org
--
Neil Middleton
Technical Director
Stez Media
01737 212282

- Original Message -
From: JustinMacCarthy <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 23, 2000 4:20 PM
Subject: Re: Mail Servers?


> Free ? Surely not on NT ...
>
> ~Justin
>
> - Original Message -
> From: "Neil Middleton" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, August 23, 2000 4:02 PM
> Subject: Re: Mail Servers?
>
>
> > lets see, a good cheap mail server?
> >
> > Seems you'll be wanting sendmail, it's superb and above all FREE.
> >
> > --
> > Neil Middleton
> > Technical Director
> > Stez Media
> > 01737 212282
> >
> > - Original Message -
> > From: Kelly Matthews <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, August 23, 2000 2:58 PM
> > Subject: Mail Servers?
> >
> >
> > > Are there any GOOD yet not too expensive mail servers out there? We
> > > currently
> > > have exchange no matter what we do we cant get CF to work with
exchange
> as
> > > long
> > > as Relaying is shut down.  So we wanted to install another mail server
> for
> > > CF
> > > that can bypass exchange. Meaning we dont want a mail server, like
some,
> > > that still
> > > POINTS to another mail server. We want a mail server that can send out
> > SMTP
> > > mail on it's own, i dont care about receiving mail. Any
recommendations?
> > > Kelly
> > >
> > > Stay current with what's happening on AirportNet. Subscribe to our
> > > Announcement list today: http://www.airportnet.org/email.htm
> > >
> > > ---
> > > Kelly Matthews
> > > Internet Development Coordinator
> > > AAAE
> > > 703.578.2509
> > > [EMAIL PROTECTED]
> > > http://www.airportnet.org
> > > ---
> > >
> >



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: #cgi.http_referer# and IE

[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 [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 2:09 PM
To: '[EMAIL PROTECTED]'
Subject: RE: #cgi.http_referer# and IE


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

In the calling form, you could pass a hidden field w/ the name of the
form page.

Something like:




Hope that helps.

Best regards,
Zac Bedell

> -Original Message-
> From: Michael Slatoff [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 22, 2000 1:51 PM
> To: [EMAIL PROTECTED]
> Subject: #cgi.http_referer# and IE
>
>
> I have a form that sets a session.variable and then redirects to
> the cgi.http_referer. It works fine in Netscape 4.74 but IE 5.5
> doesn't like it.
>
> 
> 
> 
>
> Does anyone know of a work around?
>
> Micahel
>
>
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or send a message to
> [EMAIL PROTECTED] with 'unsubscribe' in the body.
>

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.3 for non-commercial use 
Comment: Please use PGP!!!

iQA/AwUBOaLBograVoMWBwRBEQKtwwCgtTquo/XztW4ixxE5vetvXeaNF5IAnj8A
dugk9Y5uMn9YLwibP3hoYVJD
=z0tu
-END PGP SIGNATURE-

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Coldfusion Training..

[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 company that we just did a CF solution for, wants CF training, from
: Beginner- Intermediate.
:
: Do any of you know of any resources that we can send them to if we don't
: wish to do this ourselves?
:
: And if we do decide to do this ourselves, are there training materials
: available from Allaire or elsewhere for this?
:
: -Gel
:
:
: --

: Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
: To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFHTTP Question

[Randy Adkins]

That was it. Thanks, I just overlooked that one.
Man, if it was a snake I would be DEAD!!

It happens to us all at one time or another.


- Original Message -
From: "David E. Crawford" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 07, 2000 1:32 PM
Subject: Re: CFHTTP Question


: This is a multi-part message in MIME format.
:
: --=_NextPart_000_0607_01C00095.813B5410
: Content-Type: text/plain;
: charset="Windows-1252"
: Content-Transfer-Encoding: quoted-printable
:
: CFHTTP QuestionYou have to specify the PORT as an attribute for CFHTTP =
: as 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 to do a CFHTTP POST and post data to a form.=20
:
:   However using the exmaple shown below, I get a HTTP 404 Error.=20
:   Both files reside in the same directory. I have checked and re-checked =
:
:   the spelling of the files.=20
:
:   Any idea whats wrong?=20
:
:   THIS IS CFHTTP_5.CFM=20
:
:   http://test.fss.gsa.gov:81/sales/cfhttp_6.cfm" =
: method=3D"POST">=20
:=20
:=20
:=20
:=20
:   =20
:
:   #cfhttp.filecontent#=20
:
:
:
:   THIS IS CFHTTP_6.CFM=20
:
:   =20
:   =20
:   CFHTTP Post Test=20
:   =20
:
:   =20
:   The following was posted via cfhttp_5.cfm=20
:   =20
:   =20
:   =20
:   Form: #form.form_test#=20
:   URL: #url.url_test#=20
:   Cookie: #cookie.cookie_test#=20
:   CGI: #cgi.cgi_test#=20
:
:   =20
:   =20
:   =20
:
:   =
: -=
: -=20
:   Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20
:   To Unsubscribe visit =
: http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta=
: lk or send a message to [EMAIL PROTECTED] with =
: 'unsubscribe' in the body.
:
:
: --=_NextPart_000_0607_01C00095.813B5410
: Content-Type: text/html;
: charset="Windows-1252"
: Content-Transfer-Encoding: quoted-printable
:
: 
: CFHTTP Question
: 
: 
: 
: 
: 
: You have to specify the PORT as an =
: attribute for=20
: CFHTTP as opposed to placing it directly in the URL.
:  
: DC
:  
: 
:   - Original Message - 
:   From:=20
:   mailto:[EMAIL PROTECTED]" =
: [EMAIL PROTECTED]>Randy=20
:   Adkins 
:   To: mailto:[EMAIL PROTECTED]"=20
:   [EMAIL PROTECTED]>[EMAIL PROTECTED] 
:   Sent: Monday, August 07, 2000 =
: 17:29
:   Subject: CFHTTP Question
:   
:   I am using an example straight out of the Advanced =
: book of=20
:   CF. I want to do a CFHTTP POST and post data =
: to a=20
:   form. 
:   However using the exmaple shown below, I get a HTTP =
: 404=20
:   Error. Both files reside in the same =
: directory. I have=20
:   checked and re-checked the spelling of the=20
:   files. 
:   Any idea whats wrong? 
:   THIS IS CFHTTP_5.CFM 
:   <cfhttp url=3D"http://test.fss.gsa.gov:81/sales/cfhttp_6.cfm"=20
:   target=3D_blank>http://test.fss.gsa.gov:81/sales/cfhttp_6.cfm"=20
:   method=3D"POST">  <cfhttpparam=20
:   name=3D"form_test" type=3D"formfield" value=3D"1">  <cfhttpparam type=3D"URL" name=3D"url_test" =
: value=3D"2">=20
:    <cfhttpparam type=3D"CGI" =
: name=3D"cgi_test"=20
:   value=3D"3">  <cfhttpparam =
: type=3D"COOKIE"=20
:   name=3D"cookie_test" value=3D"4"> </cfhttp> 
:   <cfoutput>#cfhttp.filecontent#</cfoutput>=20
:   
:   THIS IS CFHTTP_6.CFM 
:   <html> <head>=20
:   <title>CFHTTP Post Test</title> =
: </head> 
:   <body> The following =
: was posted=20
:   via cfhttp_5.cfm<br> <br> =
: <br> <cfoutput> =
: Form: #form.form_test#<br> URL:=20
:   #url.url_test#<br> Cookie:=20
:   #cookie.cookie_test# CGI: =
: #cgi.cgi_test# 
:   </cfoutput> </body>=20
:   </html> 
:   =
: --=20
:   Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
:   =
: target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/=20
:   To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
: lists/cf_talk"=20
:   =
: target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
: p;body=3Dlists/cf_talk=20
:   or send a message to [EMAIL PROTECTED] with =
: 'unsubscribe' in=20
:   the body.
:
: --=_NextPart_000_0607_01C00095.813B5410--
:
: --

: Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
: 

CFHTTP Question

[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 wrong?

THIS IS CFHTTP_5.CFM

http://test.fss.gsa.gov:81/sales/cfhttp_6.cfm" method="POST">
 
 
 
 


#cfhttp.filecontent#


THIS IS CFHTTP_6.CFM



CFHTTP Post Test



The following was posted via cfhttp_5.cfm



Form: #form.form_test#
URL: #url.url_test#
Cookie: #cookie.cookie_test#
CGI: #cgi.cgi_test#





--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: ACCESS - Not a valid Bookmark

[Randy Adkins]

Steve --- Thanks.

This is only temporary anyway. We are migrating from
MS Access (YUK) to SQL 7.0

Again, thanks for the quick turnaround.


- Original Message -
From: "Steve Martin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 03, 2000 8:06 AM
Subject: RE: ACCESS - Not a valid Bookmark


: Your database is slightly corrupt. The term 'bookmark' is refering to what
: is essentially a cursor position within the table you are looking at. We
: have come across this from time to time and it's a beatch to fix. The
Repair
: option doesn't always fix the problem 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 97 you get the error:
: >
: > Not a valid Bookmark.
: >
: > Can anyone explain this?
: >
: >
: > --
: > 
: > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
: > To Unsubscribe visit
: > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
: _talk or send a message to [EMAIL PROTECTED] with
: 'unsubscribe' in the body.
:
: --

: Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
: To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

ACCESS - Not a valid Bookmark

[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 Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Mail / Database Integration

[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.


So then you can use the query and database it:

Insert into
tblMail(Mail_from,Mail_to,Mail_Subject_Mail_Message_ID,Mail_Message)

Values=('#get_mail.from#','#get_mail.to#','#get_mail.subject#',#get_mail.mes
sagenumber#,'#get_mail.body#')


This is in fact if the CFPOP returns a mail message from messagenumber=1404.
If you are getting ALL messages, wrap the CFQUERY around with  

HTH

- Original Message -
From: "Claremont, Timothy S" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 28, 2000 12:08 PM
Subject: Mail / Database Integration


: I've been wondering if e-mail sent to a specific account could have its
text
: entered automatically into a database?  For example, subject gets stripped
: and loaded in a SUBJECT field;   text between the keywords SUMMARY and
: SUMMARY END  gets loaded into a SUMMARY field , etc.
:
: Got any thoughts to point me in the right directions?
:
: 
: Tim Claremont
: Xerox Corporation
: 
: --

: Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
: To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Question about Multiple Order By

[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 in seattle, i want to be able
to
: sort them accordingly.
:
: So is it possible to do two order by commands within the SQL statement?
:
: -kev
: --

: Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
: To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

File Read

[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 in each line.
One line does have a max length but when read using CFFILE
it eliminates all the spaces thus counting the characters would not work.

Thanks for your help.



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: cookies?? or what to use

[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 another.


- Original Message -
From: "Lewis Steven" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 8:56 AM
Subject: Re: cookies?? or what to use


: This is a multi-part message in MIME format.
: --BE503D82797F5FE2D22281E4
: Content-Type: text/plain; charset=us-ascii
: Content-Transfer-Encoding: 7bit
:
: Why would you want to use session variables when the CGI.HTTP_REFERER
seems to a more logical solution.
:
:
:
: Anthony Geoghegan wrote:
:
: > Hi Kim,
: > Session Variables can be used for this purpose.
: >
: > Regards,
: > Anthony Geoghegan.
: > Lead Developer,
: > IFTN
: > www.wow.ie
: > mailto:[EMAIL PROTECTED]
: >
: > |-Original Message-
: > |From: Kim Ahlbrandt [mailto:[EMAIL PROTECTED]]
: > |Sent: 15 July 2000 19:07
: > |To: [EMAIL PROTECTED]
: > |Subject: cookies?? or what to use
: > |
: > |
: > |Ok, I'm new to the list...and new to using coldfusion.  I need
: > |to ensure
: > |that users can only go through the system in a certain order
: > |(they must fill
: > |out forms in a particular order and should not be allowed to
: > |come into any
: > |page of the system without first going through the previous
: > |pages).  Does
: > |anyone know how this is best achieved.  Any advice will be helpful.
: > |
: > |Thanks, Kim
: > |[EMAIL PROTECTED]
: > |___
: > |_
: > |Get Your Private, Free E-mail from MSN Hotmail at
: > http://www.hotmail.com
: >
:
> --
--
: > --
: > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
: > To Unsubscribe visit
: > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
: > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
: > the body.
:
> --

: > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
: > To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
:
: --BE503D82797F5FE2D22281E4
: Content-Type: text/x-vcard; charset=us-ascii;
:  name="lewis_steven.vcf"
: Content-Transfer-Encoding: 7bit
: Content-Description: Card for Steven Lewis
: Content-Disposition: attachment;
:  filename="lewis_steven.vcf"
:
: begin:vcard
: n:Lewis;Steven
: tel;fax:703-845-3939
: tel;work:703-845-3996
: x-mozilla-html:FALSE
: adr:;;
: version:2.1
: email;internet:[EMAIL PROTECTED]
: fn:Steven Lewis
: end:vcard
:
: --BE503D82797F5FE2D22281E4--
:
: --

: Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
: To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Can someone explain this?

[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'."






--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

What???

[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'."








--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CF Server halts

[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 attempting a named pipe operation and the call returned
a 232 failure code. It is often seen with errors 17824 and 1608, and has
similar causes.


- Original Message -
From: "Neil Robinson" <[EMAIL PROTECTED]>
To: "CFList" <[EMAIL PROTECTED]>
Sent: Thursday, July 13, 2000 9:13 AM
Subject: CF Server halts


:
: I'm getting the following errors in the server.log file, they're ocurring
on
: no particular template or time interval, and the same error happens on two
: seperate servers.  Both are running NT4/IIS4/sp6a and CFserver 4.5.1. and
: primarily use an Oracle 7.3 ODBC connection.
:
: "Error","TID=229","07/13/00","12:43:45","Windows NT error number 232
: occurred."
:
: "Error","TID=229","07/13/00","12:47:50","Error number 232 occurred while
: attempting to write the reply to the web server."
:
: Both servers, for no apparent reason (unless it's a known issue?) then
have
: these symptoms:
:
: - No response to any CF template requests, resulting in an ODBC Error Code
=
: () after a timeout interval, this then happens on any datasource, even a
: local MDB file
: - CF and IIS Services continue to run, nothing is logged in the NT event
log
:
: On one server this happens after 1-2 hours and the other server it's
around
: 10 hours, both are at testing stages at the moment so they aren't even
: handling any requests.
:
: Anyone got any ideas?
:
: Thanks in advance.
:
: Neil Robinson
: --

: Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
: To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: still not working

[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, boatyear, address, city,
phone, state, zip, emailaddress )


- Original Message -
From: "gregg Kachel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 06, 2000 11:18 AM
Subject: still not working


: Hi, thanks for all of your help. I'm still struggling with the connecting
: the two tables. I did as Mark suggested and checked for required fields,
the
: only one I have is the primary keys wich are autonumbered (memberid for
: memberlist, id for members) I linked the tables together with memberID but
: that doesn't seem to help.  Also as Nick suggested I took out the ''s from
: my number fields, and put the inserts in correct order. So far this is
what
: i have:
: 
:
: insert into memberlist(firstname,lastname, boat, boatyear, address, city,
: phone, state, zip, emailaddress, )
: values( '#firstname#', '#lastname#', '#boat#', #boatyear#, '#address#',
: '#city#', '#phone#'  '#state#',#zip#, #emailaddress#')
: 
:
: 
: insert into members(firstname,lastname, username, password, emailaddress)
: values( '#firstname#', '#lastname#', '#username#', '#password#',
: '#emailaddress#')
: 
:
: The error is:
: ODBC Error Code = 37000 (Syntax error or access violation)
:
:
: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
: statement.
:
:
:
: The error occurred while processing an element with a general identifier
of
: (CFQUERY), occupying document position (2:1) to (3:17).
:
:
: Date/Time: 07/06/00 09:26:49
: Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
: Remote Address: 192.168.0.55
: HTTP Referer: http://www.houseboatmagazine.com/admin/vhc/newaddprofile.cfm
: Template: D:\Inetpub\wwwroot\CFDOCS\a
: Web\houseboat\admin\vhc\newaddprofile2.cfm
:
: Thanks again, I'm getting very frustrating, I know this should be fairly
: easy and straight forward.
:
: Gregg
:
: --

: Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
: To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Importing of ASCII Files

[Randy Adkins]

If there any way to import a standard ASCII text file into
a DB using CF?

I can read the file using the CFFILE function but the
variable is smash together where the text file is set as
predetermined spaces and lengths of field data.

I can possible using CFFILE and increment the counter
of characters to read each time but I know there should
be an easier way.

Thanks.



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Numberformat

[Randy Adkins]

Use the DollarFormat which will give you $0.00 format

Thus your numbers
#Dollarformat(199)# = $199.00
#Dollarformat(15.99)# = $15.99
#Dollarformat(5.99)# = $5.99

If using in a table just align that data cell to the right for
aligning the cents column.




- Original Message -
From: "LM" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 26, 2000 1:21 PM
Subject: Numberformat


I need help with the NumberFormat function. I need to format 3 dollar sign
values so that they are right aligned. The numbers vary in length for ex:
$199.99
 $15.99
  $5.99
Is there a way to specify the number of digits to display at all times?
Thanks for your help.




Get free email and a permanent address at http://www.netaddress.com/?N=1

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: scheduled tasks - problems....

[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.


- Original Message -
From: "steven broadbent" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 22, 2000 9:48 AM
Subject: scheduled tasks - problems


>Hi All
>
>I'm using CF 4 on NT.  I'd heard of reported problems using scheduled
> tasks in CF Administrator so I set up a simple
>template to add the date/time to a table every hour.  It worked fine.
>
> Now when I come to run a real scheduled task,  it is totally ignored.
> Nothing shows in the schedue log.  The template itself is
fine,
> but just won't run as a scheduled task.   I'm confident I've set up the
> template name etc correctly in CF
> administrator.  Can anyone shed some light on this - any help would be
most
> appreciated.
>
>
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: -- help.

[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:  -- help.


> hi.
>
> Im new to this list...ive been looking for a list like this for
> ages...obviously I haven't looked too hard otherwise I would've
> found this a while ago!
>
> Anywho...my issue is this:
>
>  name="??" sort="name">
>
> what should go in the name value ?  especially if I want to list the
entire
> contents of the directory.
>
> Miles.
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: StoredProcs

[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;





- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, May 25, 2000 1:14 PM
Subject: RE: StoredProcs


> > Here is a question for people who have knowledge in Stored
> > procedures 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 analyzer and it stated Order By is not
> > support by SQL.
>
> I don't have any trouble ordering my recordsets in SPs. Can we see the SP
> code?
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

StoredProcs

[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 analyzer and it stated Order By is not support by SQL.

What gives?


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Form Field Validation - No Spaces

[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 analyzer and it stated Order By is not support by SQL.

What gives?


- Original Message -
From: "Dick Applebaum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 25, 2000 9:26 AM
Subject: Re: Form Field Validation - No Spaces


> 
>...contains data
> 
>... spaces only
> 
>
>
> At 8:13 AM -0500 5/25/2000, Andrew C. Davis wrote:
> >I have a form that has fields that, when validated, allow the user to
> >enter "spaces".  I want to be able to check for fields that contain only
> >spaces and then inform the user that they must enter text.  How do I do
> >this?
> >
> >Andrew C. Davis ([EMAIL PROTECTED])
> >TAMMIS Website Administrator / Systems Administrator
> >Metrica, Inc. * San Antonio, TX
>
>---
---
> >Archives: http://www.eGroups.com/list/cf-talk
> >To Unsubscribe visit
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
> >k or send a message to [EMAIL PROTECTED] with
> >'unsubscribe' in the body.
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Strip directory path to get just file name

[Randy Adkins]

This will strip the SCRIPT_NAME and leave you with the actual
filename that is being served up to the server.





- Original Message -
From: "cf kaizen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 19, 2000 12:41 PM
Subject: Strip directory path to get just file name


> Hi All,
>
> If my value in a string is
>
> c:\webshare\wwwroot\site\filename.cfm
>
> , how I just strip it down so I can dump filename.cfm
> into a variable?
>
> I am thinking that I should access the above string
> from the right side, looping through each character
> until I get to the first "\". However, I don't know
> where to start with the code (and, I left both cfwacks
> books at home :(
>
> Any help is very much appreciated!
>
> Thanks!
> Andy
>
> __
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: New Virus [loveBug copy] *.*

[Randy Adkins]

"I have a fiz for a newly released virus, but I can't tell all the good
people at CFtalk about it cause Randy Atkins will have a hissy
fit...geezzz."

HAHAHHAHHA
Your a real comdiean.

Just who are you speaking about??
Look before you type.

Just history repeats itself.
If you want information on a new VIRUS,
join a Virus List.





- Original Message -
From: "Brook Davies" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 19, 2000 12:18 PM
Subject: Re: New Virus [loveBug copy] *.*


> Randy, smarten up man. Thats the stupidest thing I've ever heard and not
> even worth .02 cents. I for one, and I think most would agree with me,
that
> if you are privilege to information about a wide spread virus, please tell
> everyone you know. This is a public service.Don't discourage people from
> posting this kind of information.
>
>
> "I have a fiz for a newly released virus, but I can't tell all the good
> people at CFtalk about it cause Randy Atkins will have a hissy
fit...geezzz."
>
>
>
> At 10:00 AM 19/05/00 -0400, you wrote:
> >Randy, chill out man. The original poster was just trying to help out the
> >group. If his message was totally off the wall, 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 -
> >From: "Randy Adkins" <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>
> >Sent: Friday, May 19, 2000 8:56 AM
> >Subject: Re: New Virus [loveBug copy] *.*
> >
> >
> > > 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 me
> > >
> > >
> > >
> > >
> > > - Original Message -
> > > From: "Paul Ihrig" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Friday, May 19, 2000 7:41 AM
> > > Subject: OT: New Virus [loveBug copy] *.*
> > >
> > >
> > > > Just a heads Up!
> > > > Seems to be a love bug copy cat.
> > > > Except instead of *.JPG it goes for *.*
> > > >
> > > > * Payload <http://www.symantec.com/avcenter/refa.html>: Overwrites
> > > > files
> > > > * Payload trigger <http://www.symantec.com/avcenter/refa.html>: .VBS
> > > > email attachment is executed
> > > > * Large scale e-mailing
<http://www.symantec.com/avcenter/refa.html>:
> > > > Sends itself to all addresses in Microsoft Outlook Address Book
> > > > * Modifies files <http://www.symantec.com/avcenter/refa.html>:
> > > > Overwrites every file on the system that is not currently in use
> >including
> > > > mapped local drives. Files in the root directory of any drive will
not
> >be
> > > > affected.
> > > > * Degrades performance <http://www.symantec.com/avcenter/refa.html>:
> > > > Could clog email servers
> > > > * Causes system instability
> > > > <http://www.symantec.com/avcenter/refa.html>: Overwrites critical
system
> > > > files
> > > > Target of infection <http://www.symantec.com/avcenter/refa.html>:
> > > Overwrites
> > > > all files that are not currently in use regardless of extension.
> > > >
> > > >
> > > > Good Luck too all.
> > > >
> > > > -paul
> > > >
> > > > Web Developer, NBBJ
> > > > Work: [EMAIL PROTECTED]
> > > > 614 241-3534
> > > > Home: [EMAIL PROTECTED]
> > > > 614 449-1681
> > > > [EMAIL PROTECTED]
> > > > icq: 47658358
> > > >
> > >
> >
> --
> > > 
> > > > Archives: http://www.eGroups.com/list/cf-talk
> > > > To Unsubscribe visit
> > >
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list

Re: Is anyone interested.... online demo ready

[Randy Adkins]

Small problem:

Selected Code Generator
Select Database: TEST
Table Selected:  ContactPhone
Code to Generate:  Select
Select Colums:   ContactID, PhoneID, and TypeID are CHECKED.

Error:You need to choose at least on field to view.

HTH


- Original Message -
From: "Clint Tredway" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 19, 2000 10:04 AM
Subject: Is anyone interested online demo ready


> Ok, the code is almost ready for release. If you would like to see what is
> working right now, go here.
> http://216.91.204.248/dbtool/index.cfm
>
> There are some things that I am going to change/improve today and over the
> weekend. I would like to get everyones opinion on the first run version.
>
> Here is what it does:
> Allows viewing of columns in chosen tables and the data in those columns.
>
> Generates SELECT,INSERT,UPDATE,DELETE code based on the table/fields
chosen.
>
> Planned for the next release:
> Stored Procedure Generator
> Add/Drop Tables/Fields
> Add/Update/Delete data in the database
>
> Possible additions:
> MSAccess Support
>
> I would be very appreciative if I could get some feedback within the next
> few days.
>
> Thanks,
>
> Clint
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: New Virus [loveBug copy] *.*

[Randy Adkins]

Again... there is that ASSUMPTION

Well that spoke for itself.


- Original Message -
From: "Brian P. Doyle" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 19, 2000 9:22 AM
Subject: RE: New Virus [loveBug copy] *.*


> yes, I noted that there was no ? present.  My 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] *.*
>
>
> Well actually if you can read correctly, I do not recall using a ?
> in my statements to form a question.
>
> So nothing was asked.
>
> Just another person that assumes.
>
> Well we all know what they say about ASSUMPTIONS.
>
>
>
> - Original Message -
> From: "Brian P. Doyle" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, May 19, 2000 9:01 AM
> Subject: RE: New Virus [loveBug copy] *.*
>
>
> > just because you asked,
> >
> > I'm going to a graduation party this weekend
> >
> > -Original Message-
> > From: Randy Adkins [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, May 19, 2000 8:56 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: New Virus [loveBug copy] *.*
> >
> >
> > 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 me
> >
> >
> >
> >
> > - Original Message -
> > From: "Paul Ihrig" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Friday, May 19, 2000 7:41 AM
> > Subject: OT: New Virus [loveBug copy] *.*
> >
> >
> > > Just a heads Up!
> > > Seems to be a love bug copy cat.
> > > Except instead of *.JPG it goes for *.*
> > >
> > > * Payload <http://www.symantec.com/avcenter/refa.html>: Overwrites
> > > files
> > > * Payload trigger <http://www.symantec.com/avcenter/refa.html>: .VBS
> > > email attachment is executed
> > > * Large scale e-mailing <http://www.symantec.com/avcenter/refa.html>:
> > > Sends itself to all addresses in Microsoft Outlook Address Book
> > > * Modifies files <http://www.symantec.com/avcenter/refa.html>:
> > > Overwrites every file on the system that is not currently in use
> including
> > > mapped local drives. Files in the root directory of any drive will not
> be
> > > affected.
> > > * Degrades performance <http://www.symantec.com/avcenter/refa.html>:
> > > Could clog email servers
> > > * Causes system instability
> > > <http://www.symantec.com/avcenter/refa.html>: Overwrites critical
system
> > > files
> > > Target of infection <http://www.symantec.com/avcenter/refa.html>:
> > Overwrites
> > > all files that are not currently in use regardless of extension.
> > >
> > >
> > > Good Luck too all.
> > >
> > > -paul
> > >
> > > Web Developer, NBBJ
> > > Work: [EMAIL PROTECTED]
> > > 614 241-3534
> > > Home: [EMAIL PROTECTED]
> > > 614 449-1681
> > > [EMAIL PROTECTED]
> > > icq: 47658358
> > >
> >
>
> --
> > 
> > > Archives: http://www.eGroups.com/list/cf-talk
> > > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
> >
>
> --
> --
> > --
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
> >
> >
>
> --
> 
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAI

Re: New Virus [loveBug copy] *.*

[Randy Adkins]

Well actually if you can read correctly, I do not recall using a ?
in my statements to form a question.

So nothing was asked.

Just another person that assumes.

Well we all know what they say about ASSUMPTIONS.



- Original Message -
From: "Brian P. Doyle" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 19, 2000 9:01 AM
Subject: RE: New Virus [loveBug copy] *.*


> just because you asked,
>
> I'm going to a graduation party this weekend
>
> -Original Message-
> From: Randy Adkins [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 19, 2000 8:56 AM
> To: [EMAIL PROTECTED]
> Subject: Re: New Virus [loveBug copy] *.*
>
>
> 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 me
>
>
>
>
> - Original Message -
> From: "Paul Ihrig" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, May 19, 2000 7:41 AM
> Subject: OT: New Virus [loveBug copy] *.*
>
>
> > Just a heads Up!
> > Seems to be a love bug copy cat.
> > Except instead of *.JPG it goes for *.*
> >
> > * Payload <http://www.symantec.com/avcenter/refa.html>: Overwrites
> > files
> > * Payload trigger <http://www.symantec.com/avcenter/refa.html>: .VBS
> > email attachment is executed
> > * Large scale e-mailing <http://www.symantec.com/avcenter/refa.html>:
> > Sends itself to all addresses in Microsoft Outlook Address Book
> > * Modifies files <http://www.symantec.com/avcenter/refa.html>:
> > Overwrites every file on the system that is not currently in use
including
> > mapped local drives. Files in the root directory of any drive will not
be
> > affected.
> > * Degrades performance <http://www.symantec.com/avcenter/refa.html>:
> > Could clog email servers
> > * Causes system instability
> > <http://www.symantec.com/avcenter/refa.html>: Overwrites critical system
> > files
> > Target of infection <http://www.symantec.com/avcenter/refa.html>:
> Overwrites
> > all files that are not currently in use regardless of extension.
> >
> >
> > Good Luck too all.
> >
> > -paul
> >
> > Web Developer, NBBJ
> > Work: [EMAIL PROTECTED]
> > 614 241-3534
> > Home: [EMAIL PROTECTED]
> > 614 449-1681
> > [EMAIL PROTECTED]
> > icq: 47658358
> >
>
> --
> 
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: New Virus [loveBug copy] *.*

[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 me




- Original Message -
From: "Paul Ihrig" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 19, 2000 7:41 AM
Subject: OT: New Virus [loveBug copy] *.*


> Just a heads Up!
> Seems to be a love bug copy cat.
> Except instead of *.JPG it goes for *.*
>
> * Payload : Overwrites
> files
> * Payload trigger : .VBS
> email attachment is executed
> * Large scale e-mailing :
> Sends itself to all addresses in Microsoft Outlook Address Book
> * Modifies files :
> Overwrites every file on the system that is not currently in use including
> mapped local drives. Files in the root directory of any drive will not be
> affected.
> * Degrades performance :
> Could clog email servers
> * Causes system instability
> : Overwrites critical system
> files
> Target of infection :
Overwrites
> all files that are not currently in use regardless of extension.
>
>
> Good Luck too all.
>
> -paul
>
> Web Developer, NBBJ
> Work: [EMAIL PROTECTED]
> 614 241-3534
> Home: [EMAIL PROTECTED]
> 614 449-1681
> [EMAIL PROTECTED]
> icq: 47658358
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Passing a formfield along a multi-form page

[Randy Adkins]

If you are using sessions, then push the data into a session variable
and then you can call it on whichever page you need.

Thus eliminating the HIDDING problem.


- Original Message -
From: "Britta Wingenroth" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 18, 2000 2:18 PM
Subject: Passing a formfield along a multi-form page


> This should be so simple  I've got a site going online on Friday, and
I
> can't finish the shopping cart becuase of this!  Please help!
> Thanks!
>
> I have a page of cfoutput in my form.
> I snared the whole page by repeating it and enclosing it in
> a textarea tag, like so:
>
> 
> actual page output
> 
> page output repeated
> 
> 
> 
>
> Now this is pretty ugly, even set to row1 col1, but at least it works.
The
> problem is that I can call this textarea on the next page and display it,
> but that's not what I want to do.  I want to hide it on the first page it
> comes to and display it on the one that comes after that, so I have to
pass
> it invisibly.
>
> I've tried
> and invisible field
>
> 
> then trying to pass it inside the form
> 
>
> and just assuming it is getting passed and putting a simple
> 
> which outputs it in that page and does not hide it at all.
>
> How DO you do this?
>
> Thanks for any help!
> Britta
>
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: COM Woes

[Randy Adkins]

do you mind changing your address book to CF_TALK instead of
CF-TALK so I dont have to create a new filter for your messages??

Much Appreciated.

- Original Message -
From: "Dave Wilson" <[EMAIL PROTECTED]>
To: "Justin MacCarthy" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, May 18, 2000 8:18 AM
Subject: Re: COM Woes


> Justin,
>
> Thanks, but I solved the problem very shortly after posting. Turned out it
> was a permissions issue after all, but not with the CF server. The problem
> was with the software for which the COM object was designed. The software
> was written entirely in UNIFace (don't know if you've heard of it),
however,
> one of the configuration files was mapping the objects using UNC notation,
> which was causing the problems when passwords were changed. The UNIFace
> developer changed this to an absolute drive path and all worked fine.
>
> Dave
> Dave Wilson
> Internet Technology Manager,
> BizNet Solutions
>
> 
> Co-Founder CFUG Ireland
> http://www.cfug.ie
>
> 224, Lisburn Road
> Belfast BT9 6GE
>
> Tel: 02890 225 776
> Fax: 02890 223 223
> web: http://www.biznet-solutions.com
>
> email: [EMAIL PROTECTED]
> - Original Message -
> From: Justin MacCarthy <[EMAIL PROTECTED]>
> To: Dave Wilson <[EMAIL PROTECTED]>
> Sent: Thursday, May 18, 2000 9:53 AM
> Subject: Re: COM Woes
>
>
> > Hi Dave , give me the com & the your calling template and I'll have a go
> >
> > ~Justin
> > - Original Message -
> > From: Dave Wilson <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, May 17, 2000 8:25 PM
> > Subject: COM Woes
> >
> >
> > > Hi all,
> > >
> > > I've just gone back to an old problem I had a few weeks ago regarding
> the
> > > cfobject tag and connecting to COM objects.
> > >
> > > Essentially, in the past I was having problems connecting to the
Objects
> > in
> > > question -"Class not registered" error message.
> > >
> > > At the time, Dave Watts suggested to test connection via VB and check
> the
> > > User account under which CFServer is running.
> > >
> > > OK, I managed to get everything working nicely earlier in the week
with
> > > using a brand new machine, fresh install of CF, third party software
> which
> > > uses the objects and the COM objects themselves.
> > >
> > > Now, I've gone back to my templates and am getting the "Class not
> > > registered" error message again. The only thing I can think of that
has
> > > changed now is the User account under which CF is running. Have tested
> the
> > > COM objects using VB successfully. So how do I change the account
which
> CF
> > > runs under?
> > >
> > > The only account change was the actual password (default NT
> Administrator
> > > account). If the problem is in fact down to something as trivial as
> > changing
> > > the NT Administrator password, surely this would lead to problems for
> many
> > > others, as it is good practice to regularly change system passwords,
> > > especially on servers exposed to the public web.
> > >
> > > Thoughts and insights to this much appreciated,
> > >
> > > Dave
> > >
> > > Dave Wilson
> > > Internet Technology Manager,
> > > BizNet Solutions
> > >
> > > 
> > > Co-Founder CFUG Ireland
> > > http://www.cfug.ie
> > >
> > > 224, Lisburn Road
> > > Belfast BT9 6GE
> > >
> > > Tel: 02890 225 776
> > > Fax: 02890 223 223
> > > web: http://www.biznet-solutions.com
> > >
> > > email: [EMAIL PROTECTED]
> > >
> >
>
> --
> > 
> > > Archives: http://www.eGroups.com/list/cf-talk
> > > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
> > >
> > >
> >
> >
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.