Thank you all, I used CF first per the first response and got repeats among the
iterations and then tried the SQL version using TOP X and newid() and was
able to make that work with no repeats! Also, thanks to everyone for your
speedy responses and friendliness, I've had experiences with
As a thought experiment (at least), you could eliminate repeats using CF as
follows:
Download http://cflib.org/udf/ListRandomElements and then do this:
cfset thelist =
cfloop index=i from=1 to=#rs.recordcount#
cfset thelist = listappend(thelist, i)
/cfloop
cfloop
Thank you, John!
In fact, I will try that as my humble site is in the early-development stage
and although I'm learning CF for work (I'm actually a Network Admin, not a Web
Dev), I'm also learning as much as I can about it for my own enrichment and to
'round myself out.' I suppose it would
It's because that's the way cfoutput works. Try something like this:
cfoutput
cfloop index=i from=1 to=#rows#
cfset displayRow = randrange(1, rs.recordcount)
br /h3#displayRow# #rs.first[displayRow]# #rs.last[displayRow]#
#rs.flag[displayRow]#/h3br /
/cfloop
/cfoutput
On Fri, Jan 11,
Because that is what you ate telling it to do.
Start from row x, and then output the next 4 rows.
If you want to get 5 random rows then you need to create a loop from 1 to
5, inside that loop generate your random number, then get that row.
To get a specific row from a query use
If you're wanting rows to be sorted randomly, you should be doing this at
the database level. That's one of the items RDBMS's are really good at. For
SQL Server, check out the post below.
http://stackoverflow.com/questions/848872/select-n-random-rows-from-sql-server-table
On Fri, Jan 11, 2013
Here's an excellent resource for random row generation using SQL.
http://www.petefreitag.com/item/466.cfm
~|
Order the Adobe Coldfusion Anthology now!
I was assuming he was just doing a learn CF exercise. If not, agreed he
should do it in SQL Server.
On Jan 11, 2013 4:52 PM, Chester Austin chesteraus...@gmail.com wrote:
Here's an excellent resource for random row generation using SQL.
http://www.petefreitag.com/item/466.cfm
On Friday 27 Apr 2007, Brian Wright wrote:
pages using https:// instead of http:// which means I shouldn't use
relative links in pages that should be called using SSL since relative
links (e.g. /members/file1.cfm) would default to http:// and not https://.
The browser should stay stuck to HTTP
I am building pages in CFML and using the application file to
password protect certain areas of the site for members only.
Certain information entered by members may be sensitive so I
went ahead and had an SSL cert installed. When integrating
CFML with SSL, I assume I don't need to load
cfset structDelete(session.cart, data, false) /
cfset structDelete(session.cart, groupID, false) /
That'll remove the 'data' and 'groupID' keys from the session.cart
structure. The 'false' is in there so an exception isn't raised if
the variable is missing. I believe 'false' is the default
hi michael.
you can do this
cfset goodBye = structDelete(session.cart,data,false)
cfset goodBye = structDelete(session.cart,groupID,false)
tony
On 10/25/05, Michel Deloux [EMAIL PROTECTED] wrote:
Hi all
I have one simple form with this fields:
CFIF IsDefined('URL.a') AND URL.a IS e
!---
Here's what I'd suggest...
1) Learn how to use CFCs properly. Place your business logic in CFCs and
then build your display pages to call your CFCs.
2) Next learn how to write custom tags with start and end tags like this:
container:box
...content...
/container:box
And use them to build
cfquery name=checkforrecord datasource=
SELECT ID
FROM MyTable
WHERE Field = mycriteria
/cfquery
cfif checkforrecord.recordcount IS 0
!--- Insert a record here---
cfelse
!--- update a record here or ignore the insert request ---
/cfif
Paul
[Todays Threads]
[This Message]
THANK YOU!!! :-D
You are the Man!! This is what I have searched the doc the last 4 hours for!!!
Kevin
- Original Message -
cfquery name=checkforrecord datasource=
SELECT ID
FROM MyTable
WHERE Field = mycriteria
/cfquery
cfif checkforrecord.recordcount IS 0
!--- Insert a record
You need double quotes around the /mm/dd/
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[EMAIL PROTECTED]
[EMAIL PROTECTED] 1/27/2003 10:56:11 AM
I have an Access table with a
This is the last thing that I tried #DateFormat(NOW(),
'/mm/dd')#. Any ideas?
Instead of using CF to insert the current date, you can use the Access SQL version,
which I believe is Now().
INSERT INTO
yourTable
(
theDate
)
VALUES
(
Now()
)
I haven't done it in Access in a while and each
I tried it without any luck. However I found the following on cfhub.com that
worked: #CreateODBCDate(Now())#
thanks,
Luis
-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 10:06 AM
To: CF-Talk
Subject: Re: Newbie question-Inserting
You don't format it. Just use a=#Now()#.
Andy
-Original Message-
From: Luis Lebron [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 9:56 AM
To: CF-Talk
Subject: Newbie question-Inserting the current date into Access
I have an Access table with a Date/Time field. I have tried
I use
'#DateFormat(Now(), MM/DD/)#'
-Original Message-
From: Andy Ousterhout [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 11:19 AM
To: CF-Talk
Subject: RE: Newbie question-Inserting the current date into Access
You don't format it. Just use a=#Now()#.
Andy
-Talk
Subject: RE: Newbie question-Inserting the current date into Access
I use
'#DateFormat(Now(), MM/DD/)#'
-Original Message-
From: Andy Ousterhout [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 11:19 AM
To: CF-Talk
Subject: RE: Newbie question-Inserting the current date
,Neil (RX) wrote:
dont do it using CF, let Access enter the data using Now() as a default
value, its one less SQL Transaction to doand it saves typing
And it kills code portability. If you do it using a DBMS built-in
command, use the SQL standard CURRENT_TIMESTAMP (if Access supports
Your code, we nd ya code
-Original Message-
From: Hawkes, Keith A CIV [mailto:KAHawkes;rroads.med.navy.mil]
Sent: 22 October 2002 12:30
To: CF-Talk
Subject: Newbie Question on Looping
I've recently taken a position to webify things and Cold Fusion is the
tool de jour. I'm
Keith,
I've recently taken a position to webify things and Cold Fusion is the
tool de jour. I'm having trouble with an aspect and I'm sure someone here
has been through this before.
It's a common personnel db with a common objective - I need to do a
morning
roster with five different types
My guess would be your not recieving/acting on whats passed from the
checkboxs correctly .. They only pass to the action page if ticked ..
otherwise nothing appears.
SteG.
-Original Message-
From: Hawkes, Keith A CIV [mailto:KAHawkes;rroads.med.navy.mil]
Sent: 22 October 2002 12:30
To:
the NET Work
-Original Message-
From: Steve Green [mailto:sgreen;centlaw.com]
Sent: Tuesday, October 22, 2002 4:48 AM
To: CF-Talk
Subject: RE: Newbie Question on Looping
My guess would be your not recieving/acting on whats passed from the
checkboxs correctly .. They only pass to the action
attributes is the scope that is used within a custom tag. it's the variables passed
during the custom tag call.
so...
CF_FOO VAR1=BAR VAR2=BAZ
within the custom tag, ATTRIBUTES.var1 and .var2 would be BAR and BAZ, respectively.
christopher olive
cto, vp of web development, vp it security
It has to do with custom tags. If for example, i have a custom tag
cf_jim attrib1=test
In the template jim.cfm, the variable attributes.jim would return test.
- j
-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 3:52 PM
To: CF-Talk
Attributes scoped vars are local vars usually used in custom tags and reside in
server memory.
Success is a journey, not a destination!!
Doug Brown
- Original Message -
From: Thane Sherrington [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 08, 2002 12:52 PM
Hi I posted earilier, just so you know how far up the learning curve I
am.
I know that UDF urlform2attribute uses attributes to convert all form
and urls to attributes.
I just don't get how they quite realate to Local/instance/variable
variables.
-Original Message-
From: Thane
: Monday, April 08, 2002 4:14 PM
To: CF-Talk
Subject: Re: Newbie question on variables
Attributes scoped vars are local vars usually used in custom tags and
reside in
server memory.
Success is a journey, not a destination!!
Doug Brown
- Original Message -
From: Thane Sherrington [EMAIL
At 04:58 PM 4/8/2002 -0400, you wrote:
So with Fusebox(I assume that's the context we are all in...) why do
they copy everything to attributes instead of variables.
Is it because the custom tag can't access variables? If so this
answers my question.
If you want my take on this.. ( since you
So with Fusebox(I assume that's the context we are all in...)
why do they copy everything to attributes instead of variables.
Is it because the custom tag can't access variables? If so
this answers my question.
Custom tags can certainly access the Variables scope - although it's a
: Newbie Question
Well, I'd LIKE to run them on the same machine, but I guess that's not go
nna
be possible from what people are teeling me here, so I guess I'm gonna ha
ve
to learn MySQL (Oh Joy! Another learning curve cuz I have nothing but
time...!) Which is why I bought the RAQ in the first place
At 05:24 PM 2/22/02 -0500, you wrote:
Hi Guys -
I just purchased a Cobalt RAQ from Sun, and installed cold fusion
version 5 on the server. I have a couple of Access Databases that I want
to use as my ODBC data sources. I know there is an odbc driver available
for NT Boxes, but what about my
Well, I'd LIKE to run them on the same machine, but I guess that's not go
nna
be possible from what people are teeling me here, so I guess I'm gonna ha
ve
to learn MySQL (Oh Joy! Another learning curve cuz I have nothing but
time...!) Which is why I bought the RAQ in the first place...Cuz it was
Well nuthin wrong with learning a new thing. Plus you can offer clients
a cheaper solution and get more business.
Doug Brown
- Original Message -
From: Jeffrey Cohen [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, February 22, 2002 7:37 PM
Subject: Re: Newbie
You can tell the ADMIN not to ask for the password by editing your registry:
If you are familiar with REGEDIT go in there and navigate to the following
key:
HKEY_LOCAL_MACHINE\ALLAIRE\COLD FUSION\CURRENT VERSION\SERVER in here you
will see a listing of KEYS on the right,
Scroll down untiil you
Take a look at using verity and CFCOLLECTION
Doug
- Original Message -
From: Steven Lancaster [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, November 02, 2001 8:09 AM
Subject: Newbie question
I new to this list and new to CF. I have a question though. I have a
, November 02, 2001 10:49 AM
To: CF-Talk
Subject: Re: Newbie question
Take a look at using verity and CFCOLLECTION
Doug
- Original Message -
From: Steven Lancaster [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, November 02, 2001 8:09 AM
Subject: Newbie question
I new
If someone searched multiple key words like
Baseball football soccer
And you are searching on
'Baseball football soccer%'
The whole string 'baseball football soccer' would
Have to appear the % only implies that any records with
Baseball football soccer AND THEN SOME, would appear.
Take Dougs
To: CF-Talk
Subject: RE: Newbie question
Do you know of a resource that I can look at to give me more info.?
Steven Lancaster
WebMaster
Core Laboratories
6316 Windfern
Houston, TX 77040
mailto:[EMAIL PROTECTED]
http://www.corelab.com
-Original Message-
From: Douglas L. Brown
Try this, sloppy code but hope it helps:
Jason Larson
[EMAIL PROTECTED]
html
head
titleUntitled/title
/head
body
cfif Form.Keyword NEQ
CFQUERY NAME=search DATASOURCE=search
SELECT ID, title, Description, hyperlink, keywords
FROM search
[EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, November 02, 2001 10:47 AM
Subject: RE: Newbie question
Well the CF Help files themselves have quite a bit of info on how to use
that tag.
Also check Allaires Knowledge base and support forums for more info.
Kelly
www.webdiva.org
Just use replace, but with an empty substring2.
replace(yourstring,GETRIDOF,,all)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 09, 2001 2:35 PM
To: CF-Talk
Subject: Newbie Question
What's the function for removing certain word
Does the file have a .cfm extension, and is your web server configured to
use ColdFusion ?
Do the CF examples (from the installer) run ?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
Manuel,
The book says that we should obtain the values which correspond
with those fields.It seems like ColdFusion doesn't recognize his tags
I don't know why
Can anybody tell me what could be happenig?
Does the page have the extension .cfm or .dbm?
Are you accessing the page via a
I've got a problem and I can't solve it.
I'm trying to follow a book example
That is the code:
html
headtitleColdfusion Informe Barcos/title/head
body
!-- Coldfusion query --
cfquery name=Datos datasource=SGBD_SIPLA dbtype=ODBC
username=podsd password=23524
Select C01010, C01015
In your query, get rid of the single quotes.
it should look like this
cfquery name=Datos datasource=SGBD_SIPLA dbtype=ODBC
username=podsd password=23524
Select C01010, C01015 from SIG00010 where C01010 =7327720
/cfquery
Ryan Edgar
Web Applications Developer
Biznet Solutions
133 - 137
Sorry, ignore that!! Didnt read the mail properly.
DOH!
-Original Message-
From: Ryan Edgar
Sent: 31 July 2001 11:57
To: CF-Talk
Subject: RE: Newbie question
In your query, get rid of the single quotes.
it should look like this
cfquery name=Datos datasource=SGBD_SIPLA dbtype
Hello newbie...welcome to my club :-)
The only thing I see wrong with your code is the comment tags...these should be !---
---, not !-- --
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Tuesday, July 31, 2001 5:37 AM
Subject: Newbie question
Hi all
: Newbie question
Hello newbie...welcome to my club :-)
The only thing I see wrong with your code is the comment tags...these should
be !--- ---, not !-- --
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Tuesday, July 31, 2001 5:37 AM
Subject: Newbie question
Hi
That's true, CF comments should be !---. This way, they
don't appear in the resulting HTML. Do a View Source and
you'll see there not in there.
But your ultimate problem is that ColdFusion isn't touching
the code in the first place. If you do a View Source on
what you're getting now, you'll
RMC on the server name. On the pop menu there is a delete option
Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm
- Original Message -
From: Burns, Iain (CTO) [EMAIL PROTECTED]
To: CF-Talk
on your files tab you will see Allaire FTPRDS click on that and you'll be
able to view all the RDSs. Right click on the invalid one and choose
delete.
-Original Message-
From: Burns, Iain (CTO) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 14, 2001 10:00 AM
To: CF-Talk
Subject: newbie
You have to edit your registry. If you're not comfortable with doing that
then just leave well enough alone.
Otherwise Run regedit:
HKEY_CURRENT_USER\Software\Allaire\Studioxx\RemoteServers (where xx is
cfstudio version)
and delete the ones you don't want
might also be under
How do I delete invalid RDS servers? Can't find this in the Studio Help.
Windows Explorer, open up RDS, Right Click, Delete Server
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
Websites for the real world
Select Allaire FTP RDS in the file browser within Studio, then right click
on the RDS and select 'delete'
Hope that helps
Will
-Original Message-
From: Burns, Iain (CTO) [mailto:[EMAIL PROTECTED]]
Sent: 14 June 2001 15:00
To: CF-Talk
Subject: newbie question
How do I delete invalid
thanks Janine and Marius!
Iain Burns
Web Development (CTO)
D.C. Public Schools
[EMAIL PROTECTED]
Tel (202)442-5664 (direct line)
-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 14, 2001 10:20 AM
To: CF-Talk
Subject: RE: newbie question
on your
Thank you Clint and Rodney for your answers!
Melissa
"Bruce, Rodney" wrote:
Melissa
I haven't seen an answer back to you yet, so here is one possibly way.
IF (assuming here) you are displaying all items for sale, with a text box to
enter number of each item customer wants to buy: i.e
Melissa
I haven't seen an answer back to you yet, so here is one possibly way.
IF (assuming here) you are displaying all items for sale, with a text box to
enter number of each item customer wants to buy: i.e (123, Shovels,
garden, []) (side comment you may want to display price):
!--small
try:
cfoutput query="equipment"
input type="text" name="Item_#id#" size="20" maxlength="50" value="#item#"brbr
/cfoutput
This will generate the result you want.
HTH
-- Original Message --
From: Melissa Fraher [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
in studio? Right click and delte server.
- Original Message -
From: "Manolo Rivero" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, March 22, 2001 4:53 AM
Subject: Newbie question again
Hi all
My current problem is that I don't know hot to remove a RDS server from
You need to specify the database column in the where clause.
So for example, if the database column is called Month, then you need to say
WHERE Month = #Datepart(m, completedate)#
Or
WHERE Month = #Month(completedate)#
HTH
N
on 23/03/01 8:12, Francis, Jennifer at [EMAIL PROTECTED] wrote:
I have a date field (completedate) stored in my database. I want
to be able
to pull out all of the records by a selected month for a
month-end report.
Is there an easy way of doing this? I've tried
where datepart('m', completedate)='#month#'
but I keep getting an "invalid
I've used this before
WHERE dep_date BETWEEN #startDate# AND #endDate#
your start date should be the 1st (1-#month#-#year(now())#) of the month and
end date being the last of the month (31-#month#-#year(now())#)
-Original Message-
From: Francis, Jennifer [mailto:[EMAIL
In SQL datepart function, you don't need quotes around the "datepart"
argument, and since it's a numeric value, you don't need quotes around
#month#.
-Original Message-
From: Francis, Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 3:12 PM
To: CF-Talk
Subject: Newbie
This means that you are browsing it in your studio and that you have not
created a development mapping to the server you are working from. This can
be resolved in two ways, depending on whether you are using a full server or
a local version with PWS (or whatever). The key to either is that you
make sure that you set the development mappings in studio
here's how:
go to options in the menu bar settings browse. then click development
mappings. set the studio and server path (your web root) and the set the
browser path (most likely, http://127.0.0.1/ or http://localhost)
HTH
G
At 05:20 PM 2/23/01 -0600, you wrote:
How do you access Arguments passed to the server in a URL. (GET args or
SEARCH args is what I usually call them)
for example...
http://localhost/index.cfm?productid=23userid=2
I'm evaluating ColdFusion, and have come across this issue and I can't
seem to
Url variables are passed in the url scope. You variable would be
url.productid or url.userid.
In ColdFusion scoping is optional. You could access url parameters without
any scoping at all.
Also in CF 4.5+ all url variables are stored in a structure, so
#StructKeyList(url)# will output all url
How do you use the value stored in thisRecord (the incrementing number)
to access the correct record? I have it looping the right number
of times, but I can only output the first record over and over.
myquery.fieldname[thisRecord]
Joby Bednar
Director of Internet Design
iNEOgroup.com
At 06:35 PM 2/1/01 -0600, you wrote:
I want to use CFLOOP such as
CFLOOP INDEX="thisRecord" FROM="1" TO="#myquery.recordCount#"
instead of CFOUTPUT QUERY= to display a series of returned records.
How do you use the value stored in thisRecord (the incrementing number)
to access the correct
queryname.fieldname[#]
So, if your query is named "mystuff" and the field is "myfield", you get to
row 3 with:
mystuff.myfield[3] or in your case mystuff.myfield[thisRecord]
-Original Message-
From: Geoff Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 4:36 PM
To:
Geoff,
To loop over a query you must use the following syntax.
cfloop query="QueryName" startrow="1" endrow="x"
cfoutput#QueryName.MyFirstColumn#/cfoutput
/cfloop
The startrow and endrow are optional and can be left out. But remember to
surround all your column references with a
I guess you could use
CFOUTPUT with startrow=yourCounter and maxrow =1
laszlo
Geoff Hoffman wrote:
I want to use CFLOOP such as
CFLOOP INDEX="thisRecord" FROM="1" TO="#myquery.recordCount#"
instead of CFOUTPUT QUERY= to display a series of returned records.
How do you use the
Hi Athlene,
The Application.cfm file should not have any HTML in the file, otherwise
that get's put on the page.
The CFAPPLICATION tag should be the first thing in the file. After that you
can set your session variables, and output header code etc etc
Nick
From: "Gieseman, Athelene" [EMAIL
I'm trying to use session variables for the first time. I've gone into CF
Administrator and registered the ODBC to use session and client variables.
I also added an Application.cfm file to the top directory where the app
resides. The following is all I have in that file:
Don't put html in
Remove the HTML code from the application.cfm file. (And BTW it would have
come up with a blank page the first time wouldn't it?)
The application.cfm is really where you should be storing your variable
declarations - your global variables. E.g. Your login management would be
placed within this
Leave out the html page stuff. Make the file something like:
cfapplication name="ISBudgetApp"
clientmanagement="Yes"
sessionmanagement="Yes"
setclientcookies="Yes"
HTH,
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
I'm trying to use session variables for the first time. I've gone into
CF
Administrator and registered the ODBC to use session and client
variables.
I also added an Application.cfm file to the top directory where the app
resides. The following is all I have in that file:
Don't put html in
That was it! Thank you to all who answered.
Athelene
-Original Message-
From: Nick Slay [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 09, 2001 4:54 PM
To: CF-Talk
Subject: Re: Newbie Question about Application.cfm
Hi Athlene,
The Application.cfm file should not have any HTML
Many and vast thanks to everyone who replied to my question about the checkboxes.
It's incredible how long one can beat their head against a wall at what
would seem like the obvious (I guess it keeps me humble, bleck).
Thanks,
Tammy Schilling
On 11/13/00, Tammy Schilling penned:
I'm
That's why my cube has rubber walls
- Original Message -
From: "Tammy Schilling" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, November 16, 2000 7:46 AM
Subject: Re: newbie question, checkboxes
Many and vast thanks to everyone who replied
When you say you can't get the form to work, do you mean you are getting
error messages or it's just not behaving as expected? If you paste any
error messages you get into your posting, it helps people help you.
One issue may be that an unchecked checkbox will result in NO form element
being
try this
CFQUERY DATASOURCE="LLL"
UPDATE Attendance
SET January = '#Form.January#'
WHERE ID = #ID#
/cfquery
try the #Form.January#
this tells cf to put the value of the form field named January into the DB
field named January
- Original Message -
From: "Tammy Schilling"
here is how I update my dal customers info DB from an update form
cfquery datasource="ADSL_DSN"
UPDATE ADSLCustomers SET OrderNumber='#Form.OrderNumber#',
OrderPhoneNumber='#Form.OrderPhoneNumber#',
CompanyName='#Form.CompanyName#',
ContactFirstName='#Form.ContactFirstName#',
On 11/13/00, Tammy Schilling penned:
I'm relatively new to CF. I'm trying to design an interface for a local
non-profit that holds monthly meetings to track attendance at those
meetings. I have an Access db with a table called Attendance. This
tables columns are the ID for each member and one
Put this code in your application.cfm
cfif NOT ISDEFINED("Client.rollCount")
cfset Client.rollCount = 1
!--- Try to set a cookie for testing later ---
cfcookie name="isOn" value="testing"
cfset application.addtoken =
"cfid=#client.cfid#cftoken=#client.cftoken#"
cfelse
!--- If cookies are
Good point.
John McKown, VP of Business Services
Delaware.Net, Inc.
-Original Message-
From: Jon Tillman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 17, 2000 1:12 AM
To: [EMAIL PROTECTED]
Subject: RE: Newbie Question - Testing for Cookie Acceptance and
BrowserHawk
On Thu
How can I test to make sure that a client has cookies enabled in both
Netscape AND IE?
You can't! The user is only going to visit with one at a time, and you won't
be able to "see" the settings for the other one. However, if you're tracking
somebody, you can force them to log into your system,
On Thu, 17 Aug 2000, Dave Watts spewed forth into the void:
How can I test to make sure that a client has cookies enabled in both
Netscape AND IE?
You can't! The user is only going to visit with one at a time, and you won't
be able to "see" the settings for the other one. However, if
Hi John,
You could write a few lines of CF to convert the CSV file into a query (using
CFHTTP), then cfoutput the query and insert each record into a db table. If there's a
way to use a CSV file as a datasource, I'm not aware of it. Even if there is a way,
you'd
be better off transferring
I think you can treat a csv file as an ODBC datasource, you
just need to have the driver for it.
RPS
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
I have a customer that is a car dealership. They want to put their car
inventory online.
The company that makes their inventory database tells me that the
data store
is not ODBC compliant, but that they could output a CSV text file
that they
will auto-FTP to our servers in the middle of
-
From: Ryan [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 10:08 AM
To: [EMAIL PROTECTED]
Subject: Re: Newbie Question - Creating Data Source for CSV text file
I think you can treat a csv file as an ODBC datasource, you
just need to have the driver for it.
RPS
For SQL7, this works fine inside CF:
BULK INSERT Victor
FROM 'D:\FR\FileResource\VictorJPGs\CSVs\July212000\101-200.csv'
WITH
(
FIELDTERMINATOR=',',
ROWTERMINATOR='
'
)
best, paul
At 10:28 AM 8/11/00 -0400, you wrote:
CF Gurus,
I have a customer that is a car dealership. They want to put
I've done it. It's tricky, but I had to go into the NTServer control panel
and define a DSN there. Once that was done, the CF Administrator could see
it and configure it for ColdFusion. (We have a partner site FTP 6 csv
files into our server every night so we always have up todate
Administrator. But if you don't, you should be able to just create
it from ODBC32 under the Control Panel.
Athelene
-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 10:23 AM
To: [EMAIL PROTECTED]
Subject: RE: Newbie Question - Creating
From: "Philip Arnold - ASP" [EMAIL PROTECTED]
You can use CSV files for ODBC datasource, but don't! The main reason is
that ODBC holds onto sources like that once it's got them
Make a link table in Access which talks to the CSV - this is the much
preferred solution as you can
1 - 100 of 113 matches
Mail list logo
