yeah..
http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-pa9.htm
On Tue, May 6, 2008 at 11:12 AM, Greg Morphis [EMAIL PROTECTED] wrote:
cfcase value=x,y
I believe that works
On Tue, May 6, 2008 at 11:08 AM, Scott Stewart
[EMAIL PROTECTED] wrote:
Hey All,
Can
Doesn't int() just string anything after the decimal away? so
5. would be 5?
rnd(5.9) would be 6. ceil(5.99) would also be 6.
On Tue, May 6, 2008 at 5:40 PM, Brad Wood [EMAIL PROTECTED] wrote:
My coworker ran into this today. We were able to reproduce it on CF 6,
7, and 8.
Yeah.. that's how I'd do it..
the text field's name would include a _#id# and use the '_' to find the ID..
Good job
On Fri, May 2, 2008 at 9:33 AM, Jason Congerton
[EMAIL PROTECTED] wrote:
Hi
I need to update the price of multiple products using one form i.e
Product Price
Shoes
Oracle NUMBER does allow for decmials..
For testing, try inserting a decmial value into it yoursefl
insert into foo (myNumVal) values (3.14)
and then select from it..
Might be in your CF code that it's taking it off.
On Wed, Apr 30, 2008 at 7:59 AM, daniel kessler [EMAIL PROTECTED] wrote:
I
'' isnt a date recognized..
try to_char()
to_char(myDate, '')
That should work for you
On Wed, Apr 30, 2008 at 11:06 AM, Ian Skinner [EMAIL PROTECTED] wrote:
Randy Adkins wrote:
So to answer a few questions:
Yes, the field within the oracle database is a true date time field.
Do
cfset #cookiemainline# = 'X'
WTH? maybe you mean
cfset cookiemainline = 'X'
you're assigning the value to what CF translates cookiemainline into..
Most of the time, you don't need #'s in CF functions
so, you dont need cfif #myValue#..
just do a cfif myValue
to test the query
there's the CF-Jobs list... bunch of peeps there
On Wed, Apr 23, 2008 at 2:13 PM, Robert Harrison
[EMAIL PROTECTED] wrote:
I used to see CF Jobs on this list but haven't seen that in awhile.
Am I allow to send out a CF job notice on the list or is that verboten now?
Robert B. Harrison
You could use the ArrayToList function..
That will convert your array to a list and then just select from table
where id in cfqueryparam cf_sql_type=cf_sql_number
value=#myList# list=true /
something like that
On Tue, Apr 22, 2008 at 8:24 AM, Richard White [EMAIL PROTECTED] wrote:
hi
i
Only if you want it to work ;)
He fixed that himself.. congrats.
On Tue, Apr 22, 2008 at 9:55 AM, morgan l [EMAIL PROTECTED] wrote:
Does the IN clause need to be enclosed in parens?:
SELECT subjectID, firstName, lastName from subjects where subjectID
in (cfqueryparam
Depends.. will this be entirely CF and does the client's time matter?
We have a Flex/Java/Oracle schedule app that at first used dates/times
but trying to work with clients time versus the server's time was a
headache..
Anyways we switched pretty quickly to having a year column, weeknbr
column,
What do you mean?
current week's dateformat?
now() grabs the date and time..
dateformat() formats the date in whatever way you want.. I've always
saved formatting for the output..
On Tue, Apr 22, 2008 at 1:58 PM, Nate Willard [EMAIL PROTECTED] wrote:
Ian,
Great point about the years, I feel
the closest I could get was
select *
from foo
order by rpad(col, 10, '0')
But it does not the results you're asking.
On Thu, Apr 3, 2008 at 4:49 PM, Andy Matthews [EMAIL PROTECTED] wrote:
Paul...
What DBMS are you using? In MySQL 5, sorting a numeric column apparently
defaults to sorting
You can treat the form name as a list and use the listgetat() (use '_'
as the delimiter) to get the various parts of the string.
On Wed, Apr 2, 2008 at 9:23 AM, Sehlmeyer, Jason [EMAIL PROTECTED] wrote:
Wondering if anyone can help me out. First off, what I'm trying to do
is grab a list of
Yeah that just seemed like the logical thing to do..
Have a good one!
On Tue, Apr 1, 2008 at 12:02 AM, Mike Little [EMAIL PROTECTED] wrote:
ok guys, i think all is resolved quite nicely. am now inputting all stock
levels in just the product_to_product_options (thank god for those table
I'll second the numberformat()..
On Tue, Apr 1, 2008 at 9:47 AM, Bruce Sorge [EMAIL PROTECTED] wrote:
CFLib.org has a UDF that does this:
http://cflib.org/udf.cfm?ID=239
Paul Ihrig wrote:
how would i trim the results below
i only want the numbers after the zeros.
Maybe have a default or generic option, set the id to 0.. That way
ALL stock totals will be in one table instead of 2.
It'd make it easier to query also.
On Mon, Mar 31, 2008 at 7:45 PM, Mike Little [EMAIL PROTECTED] wrote:
help! i am stuck...
ok, for my product catalogue i have included a
It wouldn't be null you could make it 0.
Having the product stock in one table would make it easier to maintain also
On Mon, Mar 31, 2008 at 8:12 PM, Mike Little [EMAIL PROTECTED] wrote:
hmmm... yes this could be an option. i was a little unsure of the default
record for the ptpo table eg.
Why would you need to run it multiple times?
Just do a query minus the product_id filter, turn that into a struct
or just return the whole query.
Also, just an FYI, shouldn't an index page be more of a summary than detail?
On Sun, Mar 30, 2008 at 7:01 PM, Mike Little [EMAIL PROTECTED] wrote:
Unless I'm not getting something (it is late in the afternoon.. need
caffeine)..
Can't you use the body onload=javascript:myFunc(...); /
On Tue, Mar 25, 2008 at 3:36 PM, Claude Schneegans
[EMAIL PROTECTED] wrote:
to be sure to count the page in the event that a user clicks away to
another
Ah.. I see.. you're wanting to do it without editing all the pages..
dunno there...
On Tue, Mar 25, 2008 at 3:55 PM, Greg Morphis [EMAIL PROTECTED] wrote:
Unless I'm not getting something (it is late in the afternoon.. need
caffeine)..
Can't you use the body onload=javascript:myFunc
But can't you put a cflock / around the query that inserts the
record and retrieves the last ID?
On Mon, Mar 24, 2008 at 8:59 AM, Mark Fuqua [EMAIL PROTECTED] wrote:
What if you have four concurrent users (or four hundred if your app get
popular!), what happens if user two gets user three's id
Here's an snippet of my onRequestStart, yeah you can check for session
variables in there..
cfif structkeyexists(session.user,emplid) and
structkeyexists(url,group_id)
cfset qGroups =
application.userGateway.getGroupsForUser(emplid =
session.user.emplid)/
you definitely don't want to use CLOB...
That's a Character Large OBject.. meaning don't use that unless you
need to store LARGE amounts of data, larger than 4000 characters (on
Oracle, may be a different size for Access).
If they're both numeric values use cf_sql_type = cf_sql_number or
decmial
Also considering you said I have also tried not using the
CFqueryparam thing at all but that
doesn't work
I don't think it's a cast issue... I think it's something else
On Tue, Mar 18, 2008 at 11:54 AM, Dominic Watson
[EMAIL PROTECTED] wrote:
Hi Paul, what error message are you seeing?
Paul..
try this...
wrap the query in cfoutput's like
cfoutput
insert into Student_Status (Student_ID,Status_ID)
values (#lastID#, #i#)
/cfoutput
Take the output and run it in Access and see if you get the same error
message..
On Tue, Mar 18, 2008 at 12:03 PM, Greg Morphis [EMAIL PROTECTED
since their's INTs in the database, you can leave off the double quotes..
On Tue, Mar 18, 2008 at 12:08 PM, Greg Morphis [EMAIL PROTECTED] wrote:
Paul..
try this...
wrap the query in cfoutput's like
cfoutput
insert into Student_Status (Student_ID,Status_ID)
values (#lastID#, #i
cannot be converted to simple values.
The cfdumps are still correct. The insert statement with values(117,2)
works in Access.
Any ideas on what is happening with those vars?
Paul
Greg Morphis wrote:
Paul..
try this...
wrap the query in cfoutput's like
cfoutput
insert
immediately before the loop and indeed a cfdump
returns the correct/expected value. I have also tried cfset VAR...
Greg Morphis wrote:
Is this inside a cffunction? If not change
cfset var lastID=#getLastID()#
to
cfset lastID=#getLastID()#
and can you post the code for getLastID
Does Access have a random number generator function?
You could do something like this
select fooCol1, fooCol2, fooCol3, randrange(1,10) as rnd_col
from fooTbl
where a = this
and b = that
order by rnd_col
something like that would work smooth... every time the page is
refreshed the order
It wouldnt need to work with CF???
Just Googled this..
Int((100 * Rnd) + 1)
Will give a random number between 1 and 100.
So using the above technique..
select fooCol1, fooCol2, fooCol3, Int((100 * Rnd) + 1) as rnd_col
from fooTbl
where a = this
and b = that
order by rnd_col
Should work.. and
Just another reason to kick Access in the balls and move on to a better DB...
On Fri, Mar 14, 2008 at 12:21 PM, C S [EMAIL PROTECTED] wrote:
It wouldnt need to work with CF???
Yes, it would. More specifically with the Access drivers used by CF.
I have not tried the code you posted. But I
So I'm looking around for some real good CFC OOP tutorials.. I'd like
to get your ideas and where you learned about it.
Preferably that are complete (walk you through everything step by
step) and provide some decent real world examples and is using best
practices...
I've been reading one at
So there were modifications done to our staging server on Friday..
today the staging server is not working..
directory listing works fine.. but if I click on a .cfm page I get
page cannot be displayed in IE.. in FF the page is blank.
I can remote into the server and hit the CF Admin on the
on regular port but same box).
Any tips, ideas, things to look at, etc would be very appreciated
On Mon, Mar 10, 2008 at 3:00 PM, Greg Morphis [EMAIL PROTECTED] wrote:
So there were modifications done to our staging server on Friday..
today the staging server is not working..
directory listing
PM, Charlie Griefer
[EMAIL PROTECTED] wrote:
On Mon, Mar 10, 2008 at 12:00 PM, Greg Morphis [EMAIL PROTECTED] wrote:
So there were modifications done to our staging server on Friday..
today the staging server is not working..
directory listing works fine.. but if I click on a .cfm page I
: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2008 2:01 PM
To: CF-Talk
Subject: page cannot be displayed
So there were modifications done to our staging server on Friday..
today the staging server is not working..
directory listing works fine.. but if I click
of Windows.
It sounds like your mappings might be fine-- I'm out of ideas for now
without knowing more about what actually changed on your servers.
~Brad
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2008 2:35 PM
To: CF-Talk
Subject: Re
To complicate the matter staging is clustered.. there's 2 instances of
it running..
I run the Jrun4\bin\jrun.exe and I see them listed with status of Running
On Mon, Mar 10, 2008 at 3:59 PM, Greg Morphis [EMAIL PROTECTED] wrote:
I wasn't involved in what was done just in the clean up...
I did
.
~Brad
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2008 3:00 PM
To: CF-Talk
Subject: Re: page cannot be displayed
I wasn't involved in what was done just in the clean up...
I did see them playing around with JRun.. but when I try
Looks like it's corrected. isapi caching was turned off
man I need to do some research on this stuff incase something else gets FUBAR..
Thanks Brad for the help with this..
On Mon, Mar 10, 2008 at 4:37 PM, Greg Morphis [EMAIL PROTECTED] wrote:
It's on port 8000.
How can I tell the following
What usually causes this error?
I have a bean Query.cfc, named of course Query..
When I init the bean I get the following error message...
The value returned from function init() is not of type Query. If the
component name is specified as a return type, the reason for this
error might be
A Query being a reserved work.. I knew it was going to bite me
eventually.. Better caught now then later.
Thanks!!.. I changed it to QueryB and viola.. it worked!
On Wed, Mar 5, 2008 at 11:56 AM, Ian Skinner [EMAIL PROTECTED] wrote:
Greg Morphis wrote:
What usually causes this error
.
cheers,
barneyb
On Wed, Mar 5, 2008 at 8:56 AM, Jochem van Dieten
[EMAIL PROTECTED] wrote:
Greg Morphis wrote:
I have a bean Query.cfc, named of course Query..
When I init the bean I get the following error message...
The value returned from function init
QueryB for QueryBean was what I was thinking..
On Wed, Mar 5, 2008 at 12:14 PM, Dominic Watson
[EMAIL PROTECTED] wrote:
But will I run into the name issue later? If so, I can change it now
and be done with it..
Possibly though probably not. Regardless, I would change the name to
there's nothing wrong with it.. but from what I've seen Beans are just
named what they are..
User bean is User.cfc
Group bean is Group.cfc
etc..
I'm still learning the whole OO concept so I'm following a couple
online tutorials..
Anyways the Query bean holds queries, their Id, name, and
really like some better error messages instead of CF just stopping
(only happens in errors within the CFC) what it's doing...
On Tue, Mar 4, 2008 at 3:31 AM, Tom Chiverton
[EMAIL PROTECTED] wrote:
On Monday 03 Mar 2008, Greg Morphis wrote:
No, no aborts.. and yeah.. it returns something
deleting and re-creating the
APPLICATION.userGateway object after you've been making these changes,
right?
On Tue, Mar 4, 2008 at 10:59 PM, Greg Morphis [EMAIL PROTECTED] wrote:
Naaa.. I mean we do have an error template but it normally fires with
errors..
If I misspell something on a .cfm
...
On Tue, Mar 4, 2008 at 10:15 AM, Tom Chiverton
[EMAIL PROTECTED]
wrote:
On Tuesday 04 Mar 2008, Greg Morphis wrote:
I have the timeout set for 30 seconds for testing... but as I said
below, I wonder if created it twice once in the act_login.cfm page and
once in the application.cfc file
AM, Tom Chiverton
[EMAIL PROTECTED] wrote:
On Tuesday 04 Mar 2008, Greg Morphis wrote:
I have the timeout set for 30 seconds for testing... but as I said
below, I wonder if created it twice once in the act_login.cfm page and
once in the application.cfc file was causing the problems
It's
So I'm trying to learn the whole OO stuff behind CF..
I've got a user gateway, dao, bean created.. but something is up with
one of the functions...
I'm creating the gateway in the application.cfc
cfset application.userGateway = createObject(component,
cfc.users.UserGateway).init( DSN =
:query
Roles:
Access: public
Output: false
I'm baffled!
On Mon, Mar 3, 2008 at 4:14 PM, Greg Morphis [EMAIL PROTECTED] wrote:
So I'm trying to learn the whole OO stuff behind CF..
I've got a user gateway, dao, bean created.. but something is up with
one of the functions
To make your query more readable, can you alias your tables?
SELECT g.groupid, g.groupimage, g.groupname, g.groupcity, g.state,
g.voicingid, g.groupcontactperson, g.country, g.region,
gtx.groupid, gtx.grouptype, gt.grouptype
FROM tblgroups g, tblgrouptypes gt, tblgrouptypes_x
if it is in fact
returning anything? Your function looks correct...
Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com
Greg Morphis wrote:
So I'm trying to learn the whole OO
Why are you storing the whole statement? Why not just the variables?
Maybe I'm missing something, but I would just store the variables in
the database.. not the whole statement.
On Wed, Feb 27, 2008 at 11:28 AM, Ian Skinner [EMAIL PROTECTED] wrote:
Brad Wood wrote:
To dynamically create CF
It may be faster for YOU, but I doubt it'll be faster for your users.
You're pulling a bit of text, and then you have to parse it looking
for words to replace and then evaluate the result..
I think it would be faster to have the pages.. a .cfm for each
statement and just query the DB for the 2
I
exampled earlier. Then the whole thing is turned into a PDF and
E-mailed.
ColdFusion handles the replacing of the variables part pretty well. I
have never had it cause a performance issue yet.
~Brad
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent
Are you getting an error?
You don't actually say what the problem is.
Most people, when they put the action page and form page together use
a hidden form value to know when to process
cfparam name=form.process default=0 /
cfif form.process eq 0
form name=...
input type=hidden name=process
First off, try a little troubleshooting of your own.
Output Form.foundOn and see what value it is. Is it a list? What is it?
Or dump the whole Form and check values.
You'll find people are a lot more willing to help those who at least
try to help themselves. They do not like doing the work for
then please provide the values.. we can't help what we don't know.
output the values and post them
On Thu, Feb 21, 2008 at 12:52 PM, erik tom [EMAIL PROTECTED] wrote:
First off, try a little troubleshooting of your own.
Output Form.foundOn and see what value it is. Is it a list? What is it?
Then why can't you just save the form field with multiple values to
your database? unless I'm misunderstanding you.
You can save the list to your DB in a varchar field and then pull it
out and set the value to a list..
On Feb 20, 2008 11:03 AM, erik tom [EMAIL PROTECTED] wrote:
I have a drop
FWIW let CF do the formatting for you, store it the way the DB handles it.
On Feb 19, 2008 5:29 PM, Will Tomlinson [EMAIL PROTECTED] wrote:
In MySQL 5, I'm storing a date in a date field. It stores it as 2008-19-2.
But my client wants to let users filter records using this format:
02/19/2008
Not sure this is the most efficient but you could do something like:
cfset fooDate = createdatetime(2008,2,19,15,07,0) /
cfset gooDate = createdatetime(2009,2,25,18,0,10) /
cfoutput#fooDate# | #gooDate#/cfoutputbr /
cfset fDate = gooDate - fooDate /
cfset days = int(fDate) /
cfset hoursfull =
of the alphabet. Then, do a cartesian join to join that table to
itself, three other times. Concatenate the fields and you should have each
combination.
That would get the first part without consideration of the second part.
m!ke
_
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent
in more
{
strings = f(foreach+letter, more-letter)
}
return strings
}
HTH.
--Ben Doom
Greg Morphis wrote:
anyone else? I was hoping to do this in CF alone?
Thanks
On Wed, Feb 13, 2008 at 6:59 PM, Dawson, Michael [EMAIL PROTECTED
Hey that's pretty smooth. I appreciate it!!
On Thu, Feb 14, 2008 at 1:27 PM, Jeff Price [EMAIL PROTECTED] wrote:
Try this chunk of code. I leave it up to you to add in a remove duplicates
feature. Check cflib.org for some handy functions to do that.
NOTE: I found it easier to build a list
Given a string, e.g. ABCD
I need to come up with all combinations of letters
eg
ABCD
ABDC
ACBD
ACDB
And exlude strings like '', 'AAAB' unless you pass a string with
duplicate characters
If I pass the string AAAB then it'd return:
AAAB
AABA
ABAA
BAAA
yes, I know that and it's that part that I need help with which is why
I posted here.
Thanks
On Feb 13, 2008 5:34 PM, Mark Mandel [EMAIL PROTECTED] wrote:
Recursion is your friend ;o)
Mark
On Feb 14, 2008 9:57 AM, Greg Morphis [EMAIL PROTECTED] wrote:
Given a string, e.g. ABCD
I need
) +
remainingchars.substring(j+1, remainingchars.length)); //recursive
call
That's how it's done in Javascript.. I just can't convert it to ColdFusion..
On Feb 13, 2008 6:44 PM, Mark Mandel [EMAIL PROTECTED] wrote:
What have you got so far?
Mark
On Feb 14, 2008 10:58 AM, Greg Morphis [EMAIL PROTECTED] wrote:
yes
Xtreme-Host is a one man show and he's as pathetic as they come.
I really enjoyed the service up until about June 07 and then it all
went to sh*t.
I'm moving my domain away from there myself.. Hopefully it'll go smoothly..
You can read up on sooo many problems here:
UPDATE table
SET foo = '',
Moo = '',
Goo = ''
leave out the WHERE clause.. it'll empty all rows
On Jan 4, 2008 9:47 AM, Chad Gray [EMAIL PROTECTED] wrote:
Is there anyway to clear the data in a row in a database without using
UPDATE table
SET foo = '',
Moo = '',
Goo = ''
ah yeah then delete the row and readd it..
On Jan 4, 2008 10:11 AM, Ben Doom [EMAIL PROTECTED] wrote:
He wants to clear all *columns*, not rows.
--Ben Doom
Greg Morphis wrote:
UPDATE table
SET foo = '',
Moo = '',
Goo = ''
leave out the WHERE clause.. it'll empty all rows
the SQL statement like requires a %..
for example..
select * from froo where name like 'G%'
will return all names that starts with G..
So try something like
select * from tbl where name like '% ';
That will catch anything with a trailing space.
Just a heads up..
On Jan 3, 2008 9:03 AM, morchella
'
where money could be any last name or character.
On Jan 3, 2008 10:17 AM, Greg Morphis [EMAIL PROTECTED] wrote:
the SQL statement like requires a %..
for example..
select * from froo where name like 'G%'
will return all names that starts with G..
So try something like
select * from
use a subquery..
select sum(foo) as daSum
from
(
select count(goo) as foo
from table
where hoo = 1
)
On Jan 1, 2008 12:14 PM, Paul Ihrig [EMAIL PROTECTED] wrote:
yeah
i was trying to sum on the result of the count
if i do this i only get the last result, not the sum of all
cfquery
/cfquery
but now i cant call the variable total to show with in my page?
it shows Sumtotal just fine..
i have tried
get_totals.derived_table.total
get_totals.total
derived_table.total
On Jan 1, 2008 1:32 PM, Greg Morphis [EMAIL PROTECTED] wrote:
use a subquery..
select sum(foo) as daSum
#
) AS derived_table
/cfquery
On Jan 1, 2008 2:38 PM, Greg Morphis [EMAIL PROTECTED] wrote:
use
query.sumtotal
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http
I wouldnt worry about the server...
Just do your menu query and loop over the query to build the li
tags.. outside the loop close the ul tag..
If the menu wont change too often you could cache the menu query for
however long.
On Dec 26, 2007 10:00 PM, Rick Faircloth [EMAIL PROTECTED] wrote:
Hi,
http://www.ibm.com/developerworks/opensource/library/os-ad-trifecta6/
looks like you can use cast to round values
On Dec 9, 2007 8:25 AM, Adrian Lynch [EMAIL PROTECTED] wrote:
If ROUND isn't there, look for another rounding function like CEILING, FLOOR
etc.
Adrian
-Original
Can you provide the code you're using to store those numbers?... if
the data type is correct, then maybe it's how it's breaking the number
down and storing it in the DB that needs some work.
On Nov 1, 2007 11:39 AM, Rick Faircloth [EMAIL PROTECTED] wrote:
Hi, all.
I know that sounds simple
I have a multi-server configuration install of CF7..
I get to the screen where it asks me where CF MX 7 is located
with a default C:\Jrun4 selected.
That's where my Jrun install is..
C:\JRun4\
CF root is : C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\
When I hit Okay with the default C:\Jrun4
also.. I've made sure no CF service is running in services.msc
I didnt see a Jrun service in there however I did run
jrun -stop from the command line and all servers have stopped.
On 10/9/07, Greg Morphis [EMAIL PROTECTED] wrote:
I have a multi-server configuration install of CF7..
I get
found this
http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?catid=143threadid=1168251#4184437
I didnt have 7.0.1 installed, just MX 7.. running that updater first..
Thanks
On 10/9/07, Greg Morphis [EMAIL PROTECTED] wrote:
also.. I've made sure no CF service is running
What RDBMS? That would help mucho...
On 10/8/07, Dennis Powers [EMAIL PROTECTED] wrote:
I am having a total mental block with this select query and I am hoping
someone might be able to unstick my thought process;
I have a table Looking something like this (abbreviated for the list)
Make them log into your website.. one vote per login.
Other than that, I doubt you'd be able to always block a dupe voter..
On 10/4/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
All, We all know the scenario, we want to limit the amount of time a person
can vote or at least vote within a
True.. I don't believe you can then.. However you can make it such a
pain that would deter most people.
Force log in, unique to email, verify email, use CAPTCHA. Record IP, etc..
a combination of all those would deter a lot of people.
On 10/4/07, Tom Chiverton [EMAIL PROTECTED] wrote:
On
why do you have to use a single select statement? Thats pretty limiting there..
On 9/28/07, Brad Wood [EMAIL PROTECTED] wrote:
This one's been bugging me for a day now. I don't think this is
possible, but before I gave up I thought I would ask. (Yes Rick, I
googled it first)
As usual, the
select t.order_num, t.product_name, t.datetime_created
from test t,
(
select order_num, max(datetime_created) maxdt
from test
group by order_num
) t2
where t2.order_num = t.order_num
and t2.maxdt = t.datetime_created
1 query, but 2 selects = gets what you want
On 9/28/07, Greg Morphis
reminds me of
http://www.homestarrunner.com/sbemail10.html
On 9/22/07, Adkins, Randy [EMAIL PROTECTED] wrote:
One issue, is your probably getting an error from: FORM.TIMEDATE_PERIOD
does not exist.
Unless the form is being submitted from a previous form.
Are you submitting the form right
If I'm reading it right..
set up a form variable
cfparam form.selectedMonth = /
I'd define a CSS clss for hightlightedTD that alters the background
color, or something
Then during the output..
td class=cfif form.selectedMonth eq
foo.selectedMonthhighlightedcfelsenormal/cfif#foo.data#/td
notepad++ is pretty cool
On 9/20/07, Chris Martin [EMAIL PROTECTED] wrote:
I've been using TextPad since 1998...haven't seen any reason to switch,
but am curious to see what everyone else is using for a text editor out
there.
Chris Martin
You could also pass the order by via URL, and that would cut the
cfcases by half.
On 9/17/07, Jochem van Dieten [EMAIL PROTECTED] wrote:
Vince Collins wrote:
That suggestion works. However, in an example of a query with 10
columns and assuming you want to allow desc and asc, does
I dont like using the order by 2 stuff simply because if the query has
42 columns, and it's 27 I'm looking for, it's a bitch to find.. it's
easier to read MONTHDATE or whatever.
Plus if the query changes, whoops.. gotta recount the items (unless
its a small change of course)
On 9/17/07, Vince
Not sure if your DB supports this but with Oracle I can select the
columns from the table..
select column_name
from user_tab_columns
where table_name = 'MY_TABLE'
Granted this would require 2 trips to the database, 1 to get the
column names, then check to see if your sortby variable is in that
Just have one table, do not worry about the size of the table, it's
negligible. If it's a site that requires a login, save their login id,
the search term and the date (it does not matter if you intend on
using it now, you might later). You do not need a counter, you can
count using the SQL query.
That's what databases are for tho.. to be 'quite big' ;). We have
tables that have hundreds of millions rows. And as long as they're
properly indexed (partitioned is super nice too) they'll fly. Don't
worry about having a big db table, unless you're limited on space in
the DB.
On 8/23/07, Raymond
Not I.. hate coffee
On 8/11/07, Will Tomlinson [EMAIL PROTECTED] wrote:
So, hands up all those who do *not* have this excellent CF site as their
homepage?
http://www.coffeereview.com/
Shame on you! What could be more perfect - CF and coffee?
Shame on them. They need better error
better error handling and the use of cfqueryparam.. Prime candidate
for SQL injection..
On 8/11/07, Greg Morphis [EMAIL PROTECTED] wrote:
Not I.. hate coffee
On 8/11/07, Will Tomlinson [EMAIL PROTECTED] wrote:
So, hands up all those who do *not* have this excellent CF site
Yeah it sucks balls to have to be on 10 different lists... The problem
is that not everyone is on those lists.. Where as here, everyone is.
On 7/30/07, Ben Nadel [EMAIL PROTECTED] wrote:
Oh man! But I'm only on Talk/Newbie :( ... It's cool, I have work to do
anyway :)
dump the cookie and take a look.. perhaps it got saved wrong..
On 7/10/07, Ian Skinner [EMAIL PROTECTED] wrote:
Can you directly look at the source code on the remote server and
confirm that it contains the code you expect it to?
I've noticed that some of the cfajax stuff doesnt work with IE6.0..
and I know why.. IE6.0 doesnt follow standards but I wonder if Adobe
plans on addressing that...
On 7/9/07, Peter Tilbrook [EMAIL PROTECTED] wrote:
Great news from the the CF dev team - expect at least one more release
301 - 400 of 701 matches
Mail list logo