Something like this maybe?
dataObject[1][1] = "myField"; // field name
dataObject[1][2] = "myValue"; // value
dataObject[1][3] = "myDataType" // data type
and #dataObject[i][1]# =
Thats off the dome so it could be wrong some.
Mary Jo Sminkey wrote:
>> Anyone
>Anyone have a good way of doing this and keep safe from SQL injection?
Do you have any information at all about the field types/columns being
included? There are certainly ways to handle this if you just have something
like a string of words you want to search on or known phrases, such that you
: any ideas
You are effectively throwing open the door to any hacker, then asking how to
stop them from coming in and stealing your stereo. :)
Why do you want to do this? Perhaps there is a better way?
On Wed, May 14, 2008 at 1:44 PM, Chad Gray <[EMAIL PROTECTED]> wrote:
> I would like to
You are effectively throwing open the door to any hacker, then asking
how to stop them from coming in and stealing your stereo. :)
Why do you want to do this? Perhaps there is a better way?
On Wed, May 14, 2008 at 1:44 PM, Chad Gray <[EMAIL PROTECTED]> wrote:
> I would like to leave my Query open
> (Technically, you should never delete a record. Just mark it
> "no show" or something of that nature.)
That's not true. There are cases where you want to "soft delete" records,
and (many other) cases where you want to actually delete the record.
Dave Watts, CTO, Fig Leaf Software
http://www.f
Also.. if you are using SQL server...
Create a user in SQL server with the least amount of rights. NEVER USE THE
SA ACCOUNT!
Allow only select.
Deny delete, insert, update if it is not needed. (Technically, you should
never delete a record. Just mark it "no show" or something of that nature.)
U
the variables in the where statement ???
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 14, 2008 1:45 PM
To: CF-Talk
Subject: any ideas
I would like to leave my Query open to take in any number of where
statements.
IE:
SELECT *
FROM Jobs
WHERE 1=1
And also suggest they update their text. If it didn't sell, it might
be the ad, not the item.
On 8/17/06, Kevin Aebig <[EMAIL PROTECTED]> wrote:
> If you're really set on having it automated, just do a mail-out at the end
> of the month reminding the sellers to either re-subscribe their ads or
>
tp://acoderslife.com
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 17, 2006 4:04 PM
To: CF-Talk
Subject: Re: Any ideas
As I posted earlier, I want to offer another month free if their item "does
not sale". Not only does this cause peo
As I posted earlier, I want to offer another month free if their item "does not
sale". Not only does this cause people to want to use the service, but it gives
the site more product for people to look at when they browse. Any ideas other
than mine?
I think that was the point. Don't worry abou
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 17, 2006 2:57 PM
To: CF-Talk
Subject: RE: Any ideas
As I posted earlier, I want to offer another month free if their item "does
not sale". Not only does this cause people to want to use the service, but
it gives the site mor
al Message -
From: "Jim Davis" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Thursday, August 17, 2006 7:49 AM
Subject: RE: Any ideas
> > -Original Message-
> > From: Doug Brown [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, August 16, 2006 11:37 P
> -Original Message-
> From: Doug Brown [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 16, 2006 11:37 PM
> To: CF-Talk
> Subject: Any ideas
>
> In my classifieds, I want to give the customer the ability to re-post
> their ad for free for another month if they do not sale the item. Can
o: CF-Talk
Subject: RE: Any ideas
> -Original Message-
> From: Doug Brown [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 16, 2006 11:37 PM
> To: CF-Talk
> Subject: Any ideas
>
> In my classifieds, I want to give the customer the ability to re-post
> their ad
y, August 16, 2006 9:42 PM
Subject: Re: Any ideas
> I would leave it up to the ad "owner" to turn the ad off by manually
setting
> it to sold. There is really no other way to do this, they will be
> encouraged to do so as they do not want to keep getting emails and
contacts
I would leave it up to the ad "owner" to turn the ad off by manually setting
it to sold. There is really no other way to do this, they will be
encouraged to do so as they do not want to keep getting emails and contacts
from people when they do not have the stuff anymore.
my .02
Paul Giesenhage
Are you using ColdFusion's own CreateUUID() functions? These are not valid
MSSQL UUID's. You need something like the MSSQLCreateUUID() UDF at
http://www.cflib.org/udf.cfm?ID=512.
Peter Tilbrook
Transitional Services - Enterprise eSolutions
Centrelink (http://www.centrelink.gov.au)
2 Faulding Stree
Well - that's a GUID value - are you calling it as a number anyplace?
Trying to do math on it or use an aggregate mathematical function?
Posting some code would be the best way to help.
Jim Davis
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004
it ended up being a few things
Dave
- Original Message -
From: "Jann VanOver" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, February 15, 2003 1:23 AM
Subject: Re: any ideas on this error?
> On 2/13/03 1:26 PM, &qu
On 2/13/03 1:26 PM, "Dave Lyons" <[EMAIL PROTECTED]> wrote:
> Parameter validation error for function DATEDIFF.
> The value of the parameter 2, which is currently "CreateDateTime(Now())",
> must be a class java.util.Date value.
>
Did you mean createOdbcDateTime(Now()) ???
~~
Thursday, February 13, 2003 11:43 PM
Subject: Re: OK, lets start overRe: any ideas on this error?
> great that finally seems to work!
> thank you:)
> the only flaw is that on the last day, the days left should read 0 but it
> still says 1 day left.
>
> I'm sure a qu
ROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 6:05 PM
Subject: Re: OK, lets start overRe: any ideas on this error?
> Ooops. Error in calculation. My original script used minutes and I
goofed
> on the conversion to seconds.
>
thanks everyone!
I'm sure i can get the rest
Dave
- Original Message -
From: "Jeff Garza" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 6:05 PM
Subject: Re: OK, lets start overRe: any ideas on this er
Ooops. Error in calculation. My original script used minutes and I goofed
on the conversion to seconds.
timeleft = DateDiff("s", Now(), deadline);
daystogo = Int(timeleft /86400);
leftover1 = timeleft - (daystogo * 86400);
hourstogo = Int(leftover1/3600);
leftover2 = leftover1 - (hourstogo * 36
esult, ", ");
}
> -Original Message-
> From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 14 February 2003 11:23 a.m.
> To: CF-Talk
> Subject: Re: OK, lets start overRe: any ideas on this error?
>
>
> ok, that
February 13, 2003 5:23 PM
> To: CF-Talk
> Subject: Re: OK, lets start overRe: any ideas on this error?
>
>
> ok, that may work
> solves the error and returns this: 159679
> so should i just format that? to show the time left?
>
>
> Dave
>
> - Orig
IL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 3:22 PM
Subject: Re: OK, lets start overRe: any ideas on this error?
ok, that may work
solves the error and returns this: 159679
so should i just format that? to show the time left?
Dave
-- Original Message --
From: "Dave Lyons" <[EMAIL PROTECTED]>
>maybe i have a corrupt file
When in doubt . .. restart the server :)
Scott
Scott Brady
http://www.scottbrady.net/
~~~
ginal Message -
> From: "Scott Brady" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, February 13, 2003 5:10 PM
> Subject: Re: OK, lets start overRe: any ideas on this error?
>
>
> > -- Original M
a date.
Jerry Johnson
>>> [EMAIL PROTECTED] 02/13/03 05:08PM >>>
sorry charlie but i get the same error:(
- Original Message -
From: "charlie griefer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003
lets start overRe: any ideas on this error?
> Try this:
>
> > -Original Message-
> > From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, February 13, 2003 5:00 PM
> > To: CF-Talk
> > Subject: OK, lets start overRe: any ideas o
IL PROTECTED]>
Sent: Thursday, February 13, 2003 5:10 PM
Subject: Re: OK, lets start overRe: any ideas on this error?
> -- Original Message --
> From: "charlie griefer" <[EMAIL PROTECTED]>
> >no quotes around now()
> >
Try this:
> -Original Message-
> From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 13, 2003 5:00 PM
> To: CF-Talk
> Subject: OK, lets start over....Re: any ideas on this error?
>
>
> heres what i need
>
> i have to make
gt;
>
>
>
> HTH,
>
> Jeff Garza
>
> - Original Message -
> From: "Dave Lyons" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, February 13, 2003 2:59 PM
> Subject: OK, lets start over..
-- Original Message --
From: "charlie griefer" <[EMAIL PROTECTED]>
>no quotes around now()
>
Not sure if this affects the error or not, but you also don't need the single quotes
around "s", and if deadline is a datetime object, get rid of those quotes, as
sorry charlie but i get the same error:(
- Original Message -
From: "charlie griefer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 5:07 PM
Subject: Re: OK, lets start overRe: any ideas on this
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 2:59 PM
Subject: OK, lets start overRe: any ideas on this error?
heres what i need
i have to make this small auction page for my competitors client.
what i need right now is to be able to show on the detai
:
14 :
15 :
16 :
Dave
- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 4:40 PM
Subject: RE: any ideas on this error?
> send the code ur using
>
> ...tony
>
Dave Lyons wrote:
>heres what i need
>
>i have to make this small auction page for my competitors client.
>what i need right now is to be able to show on the details page how much
>time is left before the end of the auction.
>see: http://www.real-singles.com/auctionCFM/detail.cfm?auctionID=25
>
>o
right on! thanks
Dave
- Original Message -
From: "Jesse Houwing" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 5:04 PM
Subject: Re: any ideas on this error?
> Dave Lyons wrote:
>
> >right, but see
value.
>
> The error occurred in C:\Inetpub\wwwroot\auctionCFM\datediff.cfm: line
> 14
>
> 12 :
> 13 :
> 14 :
> 15 :
> 16 :
>
>
>
>
>
>
>
>
> Dave
>
> - Original Message -
> From: "Tony Weeg" <[EMAIL P
;
> >
> > jk
> >
> >
> > - Original Message -
> > From: "Matthew Walker" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, February 13, 2003 4:39 PM
> > Subject: RE: any ideas on
Dave Lyons wrote:
>right, but see i have no idea because look at all the other crap they throw
>in there.
>thats 1 big complaint i would have on the live docs, is that they add all
>those forms crap and its hard to tell how to really use it.
>I wish they wouldnt put everything into a form because
uot;, must be a
class java.util.Date value.
The error occurred in C:\Inetpub\wwwroot\auctionCFM\datediff.cfm: line
14
12 :
13 :
14 :
15 :
16 :
Dave
- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
ROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, February 13, 2003 4:39 PM
> Subject: RE: any ideas on this error?
>
>
>> Maybe you could show us the whole thing
>>
>> > -Original Message-
>> > From: Dave L
What are you trying to do?
> -Original Message-
> From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 13, 2003 4:44 PM
> To: CF-Talk
> Subject: Re: any ideas on this error?
>
>
> yeah that works tony but you know what im trying to d
u already have the code tony
Dave
- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 4:40 PM
Subject: RE: any ideas on this error?
> send the code ur using
>
> ...
funny, i usually only hear that from the ladies! hahahaha
jk
- Original Message -
From: "Matthew Walker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 4:39 PM
Subject: RE: any ideas on this error?
> Mayb
yeah that works tony but you know what im trying to do
and that doesnt work
- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 4:32 PM
Subject: RE: any ideas on this error?
&g
CTED]]
Sent: Thursday, February 13, 2003 4:36 PM
To: CF-Talk
Subject: Re: any ideas on this error?
using just Now() throws the same error
Dave
- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, F
needs to be written.
i love MM but its confusing to a dumbass like me!
but at least I eat good pie:)
dave
- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 4:31 P
Maybe you could show us the whole thing
> -Original Message-
> From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 14 February 2003 10:36 a.m.
> To: CF-Talk
> Subject: Re: any ideas on this error?
>
>
> using just Now() throws the same error
>
&g
using just Now() throws the same error
Dave
- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 13, 2003 4:30 PM
Subject: RE: any ideas on this error?
> why use all thatcan u just
cfmx
#DateDiff('m',Now(),'01/01/1970')#
gives me -397
it works fine.
...tony
Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337
-Original Message---
Dave Lyons wrote:
> Parameter validation error for function DATEDIFF.
> The value of the parameter 2, which is currently "CreateDateTime(Now())", must
>be a class java.util.Date value.
You are using CreateDateTime() incorrectly. First, the syntax is different:
http://livedocs.macr
why use all thatcan u just use
Now()
...tony
Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337
-Original Message-
From: Dave Lyons [mailto:[
Sudheer, I used to do this sort of work as an Allaire/Macromedia consultant
and can give you an insight on how we handled this at that time. Before I
start I should mention we used a fairly high-end application stress tool
called Segue Silk_Performer. This enabled us to create an increasing load
get no more than 5 people non-technical or juniors and start using it.
On Mon, 15 Apr 2002, Chakka, Sudheer wrote:
> Hi,
>
> We have a Content Management system which is completely coded and
> tested by the Coders during development.
>
> The system is written in ColdFusion and methodolo
I have always found the best way is to get non-developers to go through the
site, use the system and write down things as they happen.
People who have never seen the site before. Don't give them any more
direction than you would the client, and let them go.
At 03:57 PM 4/15/2002 -0500, you wro
t Sandy, what
you're doing sounds like what I'm trying to do.
I'd really like to look at your code.
Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks
-Original Message-
From: Sandy Clark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 1:28 AM
To: CF-Talk
Subje
PROTECTED]>
Sent: Tuesday, January 01, 2002 6:47 PM
Subject: RE: Any ideas on how to do this please?
> To you too Mike, I am in Victoria so I am not affected but I feel for
> those that do live in those areas.
>
> I actually did something similar for Siemens Corporation about 2 years
&g
hat I'm trying to do.
I'd really like to look at your code.
Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks
-Original Message-
From: Sandy Clark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 1:28 AM
To: CF-Talk
Subject: RE: Any ideas on how to do this
e the window that keeps popping up, (this is a demo after
all).
I'll try to dig up the code and post it for those who are interested.
-Original Message-
From: Office [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 1:45 AM
To: CF-Talk
Subject: RE: Any ideas on how to do t
al Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 2 January 2002 1:22 AM
To: CF-Talk
Subject: RE: Any ideas on how to do this please?
Andrew, Kym, thanks for your interest in my problem. Happy New Year to
y
ou.
I'm not sure where in Oz you are Andrew, but I hope neither of
Sorry seeing words on a screen really doesn't help,
but hopefully we can help you out more.
-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 2 January 2002 1:22 AM
To: CF-Talk
Subject: RE: Any ideas on how to do this please?
Andrew, Kym, thanks for your i
TED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 01, 2002 6:22 AM
Subject: RE: Any ideas on how to do this please?
> Andrew, Kym, thanks for your interest in my problem. Happy New Year to
y
> ou.
> I'm not sure where in Oz you are Andrew, but I hope ne
da
te
listings, and the periodic listings?
Does that make it clearer?
Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks
-Original Message-
From: Kym Kovan [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 31, 2001 1:04 PM
To: CF-Talk
Subject: Re: Any ideas on how to do this please?
H
Hi Mike,
>I am embarking on a sub-project to allow suitably authorised users to input
>events to my web site, to be displayed a month before the event happens, and
>automatically deleted after the event is over. I want the users to be able
>to put in an event as being held on a specific date, w
Mike I am not sure I understand it, but wouldn't it be easier to store
the creation date, then the type of event (weekly, monthly etc) then do
a routine check on the DB to see if the date has passed and not pull it
out.
CF has many date functions that will allow the ability to get the day of
the
so do alternating rows by CSS as defined by W3C.
In praticallity though no browser I'm aware of supports it properly.
-Original Message-
From: Scott Weikert [mailto:[EMAIL PROTECTED]]
Sent: January 19, 2001 13:14
To: CF-Talk
Subject: Re: any ideas?
Or...
(up higher in the file)
Then
Or...
(up higher in the file)
Then
--Scott
- Original Message -
From: "Russel Madere" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 7:53 AM
Subject: RE: any
Use:
Russel
Russel Madere, Jr. Senior Web Developer
ICQ: 5446158 http://www.TurboSquid.com
Some days you eat the bear; some days the bear eats you.
==
Jay,
How about the following nested Iif statement?
I don't exactly understand what your conditions/results are, but I use this
sort of 3-way If statement all the time in Excel. An example:
MyVal LT 5, return "< 5"
MyVal GTE 5, AND LTE 10 return "5-10"
MyVal GT 10, return "> 10"
And you ca
No b/c IIF() is a true/false evaluation. Mod 3 would simply be the two
colours in a false, true, true arrangement.
-Original Message-
From: Scott, Andrew [mailto:[EMAIL PROTECTED]]
Sent: January 17, 2001 23:24
To: CF-Talk
Subject: RE: any ideas?
Wouldn't changing the mod 2 to mod
Wouldn't changing the mod 2 to mod 3 do the trick:-)
regards
Andrew Scott
Senior Cold Fusion Application Developer
-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: 18 January 2001 07:52
To: CF-Talk
Subject: any ideas?
does anyone know how i can make this tag outpu
IIF in an Inline IF statement, so only has boolean TRUE and FALSE (ie.
two states). If you want to vary between more use a switch/case setup again
dependent on the mod and rowcount. The nicest thing about the iif() is it's
inline and clean looking in your code; any type of if/elseif or switch
s
76 matches
Mail list logo
