Hi all,
Back in the office after a day out and about and I missed a nice re-hash of stuff a while back about INT v UUIDs but there was a missing item in there that no-one seems to have picked up. An INT that is created by your own code rather than an AutoincrementingID of some form.
We have a tab
Whatever works - mainly 1 (int - identity/auto increment) but considering 2
with UUID().
Peter Tilbrook
Transitional Services - Enterprise eSolutions
Centrelink (http://www.centrelink.gov.au)
2 Faulding Street
Symonston ACT 2609
Tel: (02) 62115927
Flash MX 2004 update now available.
Details at:
http://www.macromedia.com/devnet/mx/flash/articles/whatsnew_2004_faq.html
Peter Tilbrook
Transitional Services - Enterprise eSolutions
Centrelink (http://www.centrelink.gov.au)
2 Faulding Street
Symonston ACT 2609
Tel: (02) 62115927
Important:
maybe search by their name, or phone number or some other identifying
information?
then pull up a list of possible matches, and an order date? who knows,
thats a design
question you have to decide on, i think id is fine, well, i used to, not
sure now.
tony
-Original Message-
From: Eric Ho
But in my instances, a phone rep needs to pull up an order number from the
orders table from a phone call. "hi, I am calling about this number". Can't
use a UUID, has to be a number of some sort. That has to exist in the
table...so I am just duplicating work by having both???
But if this thing
yeah, but how often do i manually put an order number in somewhere?
usually its from a link or some other method that the order number or
whatever gets in the url string. but then again, you can do whatever
you like, just doesnt seem like something that is necessary to create if
you already are cr
but the UUID is a long text field, right... xx-xx-xx or
whatever...
Hard for people to remember that as a client id or order idI would
think...or am I on the wrong page here?
Regards,
Eric
"The reasonable man adapts himself to the world; the unreasonable one
persists in trying
you could use the uuid as your order number, no need for the autoIncrId
field, i dont think?
-Original Message-
From: Eric Hoffman [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 11:09 PM
To: CF-Talk
Subject: RE: Primary key preference quick poll
So then, in theory, if we are u
So then, in theory, if we are utilizing the int autoid to generate a
customer number or order numberwe in theory should/could still be using
UUID() for future growth potential...does that make sense, a UUID as the PK
and still use the autoid int field...spose it doesn't matteris that how
y'
> CS dust up?
http://cfg11n.blogspot.com/2003_09_01_cfg11n_archive.html
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
CZ - Czech Republic (CS before 1993) (i guess)??
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 11:02 PM
To: CF-Talk
Subject: RE: Primary key preference quick poll
and in doing this, even with a large table, you find no performance hit
on sql
> Unless your database is going to house a terabyte worth of info, the
> perofrmance hit is negligable and you will be all set for merges in
depending on the db, the performance difference between int & varchar isn't
trivial for JOINs.
[Todays Threads]
[This Message]
[Subscription]
[Fast
and in doing this, even with a large table, you find no performance hit
on sql server indexing that column and/or query on that table and using
that column in the where clause?
tony
-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 10:51 PM
To
CS dust up?
_
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 11:15 PM
To: CF-Talk
Subject: Re: Primary key preference quick poll
> No two country codes are the same - makes a good natural primary key.
There is no need to create synthetic key in this situat
I've begun to use UUIDs much more often these days...
Stace
_
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: November 10, 2003 10:43 PM
To: CF-Talk
Subject: RE: Primary key preference quick poll
UUIDs
Unless your database is going to house a terabyte worth of info, the
pero
> No two country codes are the same - makes a good natural primary key.
There is no need to create synthetic key in this situation (and additional
index on the country code column). However, for most cases I use synthetic
key - just to make sure I don't run into a wall one day.
country codes in fa
Well, i guess that depends.
For me:
1. If the PK will be used as FK in other table -> UUID.
2. If this is just a surrogated key, or a simple key in a relation table,
which won't be used in other table, then i prefer to use identity
Rizal
At 09:09 AM 11/11/2003, you wrote:
>Why do you prefer
>1.
Country codes have an official format and abbreviation.. the abbreviation is
unique and can always be used as the key.
Check the US gov sites for the list...
_
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 10:43 PM
To: CF-Talk
Subject: Re: Primary key preferen
I used to be a fan of identities until a recent discussion with a friend
about them. I still think that identities are great for small tables,
but if you will need to mix information from replicated databases, it
would become a pain. Also, I like the idea of having a globally unique
key for a rec
yeah, that makes sense.
tony
-Original Message-
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 10:43 PM
To: CF-Talk
Subject: Re: Primary key preference quick poll
No two country codes are the same - makes a good natural primary key.
There is no need to create
No two country codes are the same - makes a good natural primary key. There is no need to create synthetic key in this situation (and additional index on the country code column). However, for most cases I use synthetic key - just to make sure I don't run into a wall one day.
TK
- Original M
UUIDs
Unless your database is going to house a terabyte worth of info, the
perofrmance hit is negligable and you will be all set for merges in
replication, easier time porting to different platform, etc...
I have never been a big fan of identities and have never worked with any
DBAs who have
but that doesnt explain why no ID's with an INT as its datatype.
lets blow this one out!
you search the archives.
-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 10:40 PM
To: CF-Talk
Subject: RE: Primary key preference quick poll
U
UUIDs
Unless your database is going to house a terabyte worth of info, the
perofrmance hit is negligable and you will be all set for merges in
replication, easier time porting to different platform, etc...
I have never been a big fan of identities and have never worked with any
DBAs who have
even then, no matter what, you can always find a way to use an int.
why with country codes?
tony
-Original Message-
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 10:24 PM
To: CF-Talk
Subject: Re: Primary key preference quick poll
Almost always int, rarely a
Almost always int, rarely a char (like country codes etc).
TK
- Original Message -
From: Sutton Yamanashi
To: CF-Talk
Sent: Monday, November 10, 2003 9:09 PM
Subject: Primary key preference quick poll
Why do you prefer
1. int (Identity / auto_increment)
2. char maybe wi
Thanks,
I had changed the default value in the neo-runtime.xml (if memory serves
me correctly) file to iso8859-1
maybe Ill change it over again and try
this.
Yves Arsenault
Carrefour Infotech
5, Acadian Dr.
Charlottetown, PEI
C1C 1M2
[EMAIL PROTECTED]
(902)368-1895 ext.242
-Original
In my eyes it depends on what type of a application that you are building.
For ones that need to be a little more secure than others, I use
uniqueidentifier with the default set to NewID().
Most anything else, I will agree with Tony.
Ricky
_
From: Tony Weeg [mailto:[EMAIL PROTECTED]
oh, and why...cause integer fields, would almost have to index better
that a mixed character field. even tho' its a native sql server data
type
i cant imagine that its easier to index than a simple integer field.
tony
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Mo
id int auto increment
tony
-Original Message-
From: Jeff Garza [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 9:13 PM
To: CF-Talk
Subject: RE: Primary key preference quick poll
I prefer Identitity myself... we don't do any cross server replication,
so
we don't need UUIDs.
I prefer Identitity myself... we don't do any cross server replication, so
we don't need UUIDs.
Cheers,
Jeff
_
From: Sutton Yamanashi [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 7:09 PM
To: CF-Talk
Subject: Primary key preference quick poll
Why do you prefer
1. int (
Why do you prefer
1. int (Identity / auto_increment)
2. char maybe with CreateUUID()
3. varchar
other?
Thanks!
-sutton
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
When you have an XML record with a missing element (not just an empty
element), what's the best way to test for it?
I'm using CFTRY/CFCATCH, and it seems there must be a better way:
myXMLDoc.data.star[idx].image.XMLText)>
I can't control the format of the source.. Just the p
Preserve single quotes worked.
- Original Message -
From: Jeff Garza
To: CF-Talk
Sent: Monday, November 10, 2003 5:29 PM
Subject: Re: Dynamic SQL
You probably have to wrap your query in a PreserveSingleQuotes() function. By default, CF will escape single quotes in variables
The "users" in this case are fellow programmers who know SQL
- Original Message -
From: Mosh Teitelbaum
To: CF-Talk
Sent: Monday, November 10, 2003 5:30 PM
Subject: RE: Dynamic SQL
First off, standard security warnings about letting people type in SQL
free-form:
BAD PRO
This is in an intranet and it's just for me :) HEHEHE it's for testing purposes too.
- Original Message -
From: Philip Arnold
To: CF-Talk
Sent: Monday, November 10, 2003 5:21 PM
Subject: RE: Dynamic SQL
Are you frigging insane?
How about if someone types in "drop table
Weird indeed.
Try this in the dsp_myvariablepage.cfm page.
Peter Tilbrook
ColdFusion Applications Developer
ColdGen Internet Solutions
Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com
4/73 Tharwa Road
Queanbeyan, NSW, 2620
AUSTRALIA
Telephone: +61-2-6284-2727
Mobile: +61
Michael,
As long as you have proper indexing setup on the table, there shouldn't
be an issue with querying it. You can also run a Trace on the table,
once it is use, to see if any additional indexes can be created, based
on the actual usage stats of the table
Dave
-Original Message-
> For that matter, I wonder what happens when someone searches on the data.
This is a cms with no string functions in the picture. It uses an arbitrary
numeric sorting system, so we're safe on that score. If we can store and
retrieve, with functioning simple search, we should be OK... maybe.
goo
Thanks guys! I was figuring close to a million records potentially. I gather
from Jochem's question that a million is not "prohibitively large?" :)
Even to be querying on all the time? And Dave's comment about modifying
your db schema was interesting. I didn't know that. Any db fundamentals book
For that matter, I wonder what happens when someone searches on the data. This is a cms with no string functions in the picture. It uses an arbitrary numeric sorting system, so we're safe on that score. If we can store and retrieve, with functioning simple search, we should be OK... maybe.
Some
> You would not want to have a single QUIZ table with a
> composite key of COURSE_ID and QUIZ_ID because potentially
> this table would become prohibitively large, correct?
While it might become large - very large, even - I don't think it would
become prohibitively large. The same is true for yo
Cohen, Michael wrote:
> Say you've got a COURSE table that represents many courses. New courses will
> always be being added to the table. Each course will have many quizzes and
> questions that need to be stored. You would not want to have a single QUIZ
> table with a composite key of COURSE_ID a
At 06:45 PM 11/10/2003 -0500, you wrote:
>I think you have to delete every file (and subdirectory) inside a directory
>before you can delete the directory itself.
>
>
>-sutton
While do I sometimes suspect (when this subject comes up) that I'll see a
thread the next day titled "UN-deleting a direc
Say you've got a COURSE table that represents many courses. New courses will
always be being added to the table. Each course will have many quizzes and
questions that need to be stored. You would not want to have a single QUIZ
table with a composite key of COURSE_ID and QUIZ_ID because potentially
I think you have to delete every file (and subdirectory) inside a directory
before you can delete the directory itself.
-sutton
_
From: brob [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 3:51 PM
To: CF-Talk
Subject: Deleteing a directory
I am using CFDIRECTORY to delete a
> After some testing I can say its a magic bullet. I've got Russian,
English and Chinese text on the same page, stored in the same mySQL 4.0 text
field record.
i believe its storing the actual utf-8 encoded text rather than ucs2 (ala
sql server, java & cf). in any case and before you get too gidd
Wrap your form var in preservesinglequotes().
And wrap your head in a bunch of foam rubber. You have a beating coming from this someday soon, methinks. Sure hope for your sake you've thought this one out real well.
--
---
Matt Robertson, [EMAIL PROTE
Action pack is for MS Sales Partners to use in their own business. It's to
give the partners and their staff real life exposure to the products, to
have them using all the latest stuff internally. To sell MS products you
have to have a relationship with a distributor, and each distributor makes
t
First off, standard security warnings about letting people type in SQL
free-form:
BAD PROGRAMMER [whack!] BAD PROGRAMMER [whack! whack!]
That said, how about posting the exact error message so we can get a better
idea of what's going on.
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (
You probably have to wrap your query in a PreserveSingleQuotes() function. By default, CF will escape single quotes in variables passed to a CFQUERY tag.
HTH,
Jeff
- Original Message -
From: brob
To: CF-Talk
Sent: Monday, November 10, 2003 4:11 PM
Subject: Dynamic SQL
Hey
I'm trying to export a XML file from a XML variable, and the following code
has worked for the last several weeks, but now is throwing the Dreaded NULL2
Error*:
some xml tags
...then, this throws an error:
#ToString(Export)#
...but this does not:
...so, it must be the ToString()
Thanks all! :)
- Original Message -
From: David Delbridge
To: CF-Talk
Sent: Monday, November 10, 2003 4:24 PM
Subject: Re: Deleteing a directory
Brob,
Look for a custom tag in the Developer's Exchange, called
"CF_DeleteDirectory." Does exactly what Mosh describes, recu
I had this happening just a few days ago, wrap the SQL with a
PreserveSingleQuotes() and you should be fixed right up!
Hatton
-Original Message-
From: brob [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 6:12 PM
To: CF-Talk
Subject: Dynamic SQL
Hey guys I am allowin
Are you frigging insane?
How about if someone types in "drop table x" where x is the name of your
table?
Anyways, what about apostrophies? are they using those? If so, remember
that CF doesn't naturally put them as SQL apostrophies - which is what
PreserveSingleQuotes() is for
-Original Me
are you INSANE?
Perhaps you're having issues with quotes? CF will automatically escape them
from variables that are output within CFQUERY tags. Try wrapping the
variable with the preserveSingleQuotes function.
cheers,
barneyb
-Original Message-
From: brob [mailto:[EMAIL PROTECTED]
I wrote:
>Or is this connection string some sort of magic bullet?
After some testing I can say its a magic bullet. I've got Russian, English and Chinese text on the same page, stored in the same mySQL 4.0 text field record.
In addition to the connection string, I have
at template top, and
Hey guys I am allowing user to run SQL scripts by typing them into a textarea and submitting them. But for ome reason i keep on getting some syntax error, even though I did an output test of the script on the page and the script looks alright. Any hints? thanks
[Todays Threads]
[This Message]
> I don't believe you can use StructDelete() on scopes.
Within CFMX, you can use StructDelete, or any other structure function, on
almost any scope, as they are all exposed as writeable structures.
> Although, you may not be able to set values in the form
> scope either as some scopes have becom
You've gotta have a chuckle at MM's "Yoda" speak for the current site of
the day - Star Wars: Clone Wars.
Why is it everyone seems to does this when referencing anything Star Wars?
Heh!
Check out the game at http://www.cartoonnetwork.com/clonewars/index.html
Peter Tilbrook
Transitional Services
Brob,
Look for a custom tag in the Developer's Exchange, called
"CF_DeleteDirectory." Does exactly what Mosh describes, recursively
through all files and subs.
If you can't find it, give me a holler off-list and I'll send you a copy
of the original distribution.
Dave
--
David M. Delbridge
Ci
Thanks Steve, but that didn't work either. I get the same error. Remember
the exact same code works fine in my production environment the only
differences are Dev is Win XP and Apache with MS SQL Dev Edition on the same
box and the production is on Win 2K Server with IIS and MS SQL is on
separa
The code works, but since variables changed over to structures in CF MX I am
get the error with cfinsert and cfupdate.
Thanks,
Andrew
-Original Message-
From: chris kief [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 5:00 PM
To: CF-Talk
Subject: RE: CF MX 6.1 Migration issue
StructDelete on the Form scope works just fine, as does setting form values:
chris
From: Matt Liotta [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 1:49 PM
To: CF-Talk
Subject: Re: CF MX 6.1 Migration issue
>
>
>
>
>
And - at least with MSAccess you can (when designing the table) set a
default attribute (correct term?) of Now() to a date field so that Access
automatically can "update" or insert the date whenever a new record is
created.
Peter Tilbrook
Transitional Services - Enterprise eSolutions
Centrelink (h
>
>
>
>
>
>
>
>
I don't believe you can use StructDelete() on scopes. I would rewrite
the code as follows.
Although, you may not be able to set values in the form scope either as
some scopes have become read-only.
Matt Liotta
President & CEO
Montara Softwar
Jonathan,
I believe that Identity needs a seed. Also, I know that the limit on the
size of a row is somewhere around 8000.
Try:
create table [RADIOPrimary].[dbo].[testform2] (
[testform2ID] int NOT NULL IDENTITY (1, 1) PRIMARY KEY,
[testcolumn] varchar(7000) NULL,
[CMSUseOnlyS
Don't know DOS? Heh! I still use it to a degree with even the crappy new
WinXP.
For gods sake be VERY careful with the CFEXECUTE command. If it was a
hosting providers server I would be VERY surprised you would be able to use
the command (and others) at all.
Peter Tilbrook
Transitional Services -
I've seen this before, but one question remains unanswered: does this work to fix mySQL versions that are prior to 4.1 (which is still designated 'alpha')? According to mySQL AB, thats the first version thats Unicode compatible.
Or is this connection string some sort of magic bullet?
Building m
My first guess, it's the quotes causing your trouble. Use
PreserveSingleQuotes()
INSERT INTO PingResults ( DomainName,
StartTime,
Dfield1,
Dfield2,
Dfield3,
Dfield4)
VALUES (
'#PreserveSingleQuotes(session.RecordArray[1])#',
'#PreserveSingleQuotes(session.RecordArray[2])#',
'#PreserveSin
Bryan:
I usually just replace the double-quotes with " (the double-quote
entity) using the following code:
Replace(myValue, '"', """, "ALL")
However, a lot of people tend to just go with the JSStringFormat() function.
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email:
Anybody have experience using the CFLDAP tag with MS Active Directory? I am
using this tag for the first time, and having trouble parsing information to
get what I want. Any help would be most appreciated! I'm don't even know
enough to fully express my problems, other I can only get the top leve
I am migrating an application for a coworker.
This code was operation on a CF 5 server, but is no longer valid on a 6.1
server. Is that a valid statement?
datasource="#REQUEST.AppDSN#" formfields="#variables.my_table_fields#">
Thanks,
Andrew
[Todays T
Create a batch file and use RMDIR. here's a link to syntax.
http://www.easydos.com/rmdir.html
You can also use to do this.
-Mark
-Original Message-
From: brob [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 3:07 PM
To: CF-Talk
Subject: Re: Deleteing a directory
Can someon
Yves,
You should add the following line into MySQL 'Connection String' of advanced setting.
useUnicode=true&characterEncoding=iso-8859-1
Then,
>So I'm forcing CFMX to use iso-8859-1.
It's not required.
Thanks,
--
Hiroshi
>-Original Message-
>From: Yves Arsenault [mailto:[EMAIL PROTEC
almost EVERY TIME you include the content of a CF variable onto an HTML page
you will want to wrap it in "HTMLEDITFORMAT()"
so your input would look like:
Jann
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 1:08 PM
To: CF-Talk
Subject:
I am completely stumped on this one. I'm trying to execute this query on my
development box (Win XP Pro, CFMX 6.1, MS SQL Server 2000 Development,
Apache 2):
CREATE TABLE [RADIOPrimary].[dbo].[testform2] (
[testform2ID] int NOT NULL IDENTITY PRIMARY KEY,
[testcolumn] varchar (8000) NULL
Log into the CF Admin > Data Sources > Choose your MySQL DSN
Add to your Connection String:
useUnicode=true&characterEncoding=ISO8859_1
HTH,
Adrian
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Hey Yves!
I was having the same problem on win2k mx 6.1 mysql version 3.xxx whatever
it was, if I recall the webserver was IIS but it was the same problems you
described... accents converted to ? . I had to resort to setting all the
encodings to iso-8859-1. I noticed though that accented charac
Hey All,
Old issue, but I'm checking the consensus
Let's say we have this:
and the form posts back to itself which kicks in some validationan error
is found and the form is re-displayed along with an error message and
populated with exatly what the user typed (pretty standard stuff).
S
Can someone possibly help me out and help me write a CFEXECUTE to delete a whole directory, as well as make a copy of it? please. I dont know MS DOS or whatever it is u need to know hehehehe
- Original Message -
From: Scott Weikert
To: CF-Talk
Sent: Monday, November 10, 20
Yves Arsenault wrote:
>
> It had to do with MySQL's encoding, 3.23.58 not being compatible with
> UTF-8 from what I found.
>
> So I'm forcing CFMX to use iso-8859-1.
>
> Now my pages come out as expected.
>
> I have one question if anyone would there be any draw backs to doing
> this?
CFDIRECTORY can't delete a directory unless there are no files or
subdirectories. You'll have to use a combination of CFFILE and CFDIRECTORY
to make sure the top-level directory is empty before deleting it.
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTEC
Yves Arsenault wrote:
>
> I'm running CFMX 6.1, Apache 2.0.48 and MySQL 3.23.58.
>
> I'm a bit confused at this behavior... I converted an access db to mysql
> using a conversion tool. I log in to webmin, look at the data in my tables,
> everything looks fine. Characters such as "?,?,?".. all dis
Finally,
It had to do with MySQL's encoding, 3.23.58 not being compatible with
UTF-8 from what I found.
So I'm forcing CFMX to use iso-8859-1.
Now my pages come out as expected.
I have one question if anyone would there be any draw backs to doing
this?
Thanks,
Yves
-Original Mess
At 01:50 PM 11/10/2003, you wrote:
>I am using CFDIRECTORY to delete a directory. then I get an error saying
>that it can't be delted because the directory is NOT EMPTY. s
Generally what you need to do is do a CFDIRECTORY on that dir, loop over
the contents and use CFFILE to de
Although not eloquant, I wrote a PERL script to redirect STDERR to STDOUT so that CF could grab it in it's CFEXECUTE variable.
So it means that to do one task, I have to call two processes.
Hope this dialogue helps others.
Dave Adams
[Todays Threads]
[This Message]
[Subscription]
[Fast Uns
#sessions["#key#"].emplid#
each session is stored in the sessions structlooking at the above code.
so loop through this struct and hit the data in each session. Assuming that you set session.emplid for each users session, the above should list the emplids for the current sess
I am using CFDIRECTORY to delete a directory. then I get an error saying that it can't be delted because the directory is NOT EMPTY. s
Can anyone help? lol
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Sounds good to me. I'll try it. Thx Ryan.
RO
-Original Message-
From: Ryan Kime [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 3:35 PM
To: '[EMAIL PROTECTED]'
Cc: Robert Orlini
Subject: RE: Scheduled email
Hey Robert,
Why not try it this way...once the user login=2, add a
Hey Robert,
Why not try it this way...once the user login=2, add a record to a table
which records the email address, name, and a timestamp. Then write a
scheduled event in cf admin which runs a page (daily) containing SQL that
checks the "login=2 table" for #DateFormat(DateAdd("d", -3, now()),
Thanks to all of you that gave me the OK to upgrade to XP with CF 4.52.
But... If I am just making web sites with cf, would you recommend XP Pro or
XP Home?
My income depends on my productivity, and when I have to re-learn a piece
of software, that reduces my productivity. In addition, I ha
Send them to (or you can do it for them)
http://www.licenseonline.com/qq2/LicenseOnlineStorefront/Lobby.asp
You will be requested to enter your Partner ID number If you don't have one,
apply for one
==
Stop spam on your domain, use our gateway!
For hosting s
Or to just resort any query...
-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 2:07 PM
To: CF-Talk
Subject: RE: queryNew question...
Che:
You can use Query of Query to filter the dynamically built query.
--
Mosh Teitelb
How can you get the info from the session var? I get a number as well as a time stamp like the following when I use that code to loop through the list. I set the session id for their user based on their userid. It is the user id I want to use to query to get the user information. So When I output t
You can't. As far as I know ActionPack is licensed for internal use
only.
Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division
-Original Message-
From: Haggerty, Mike [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2
never mind...i've got it!
-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 3:07 PM
To: CF-Talk
Subject: RE: queryNew question...
Che:
You can use Query of Query to filter the dynamically built query.
--
Mosh Teitelbaum
got any code samples...or psuedo code...i'm drawing a blank!
-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 3:07 PM
To: CF-Talk
Subject: RE: queryNew question...
Che:
You can use Query of Query to filter the dynamically bui
Che:
You can use Query of Query to filter the dynamically built query.
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003
How does one query against a query that was created with the queryNew
function.
I can sucessfully build a query...I just can't filter against it. Any ideas?
Che Vilnonis
Application Developer
Advertising Systems Incorporated
8470C Remington Avenue
Pennsauken, NJ 08110
p: 856.488.2211
f: 856.488.19
1 - 100 of 140 matches
Mail list logo