Have you tried using de() within your evaluate to get past the icky column
names?
-Justin
-Original Message-
From: Steve Milburn [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 02, 2005 2:44 PM
To: CF-Talk
Subject: RE: Query column index number
Yes, I know, and I am using
.
cfoutput query=test
#test.factoid#br/
#test['factoid'][currentRow]#br/
#test[listGetAt(test.columnList,2)][currentRow]#br/
br/
/cfoutput
Cool beans. I never tried accessing it with the row number also, so I'm
glad to see that it works that way at least.
-Justin
e.userID FROM tbl_020eventDetails e)
-Justin
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http
one of the fields from
the DB has an invalid value such as a null or blank string or something? If
you post the error here it may help uncover the issue.
-Justin
~|
Logware (www.logware.us): a new and convenient web-based time
kind of traffic you're expecting, and how much time and money the
client wants to throw at it.
-Justin Scott
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting
with a basic there was
an error screen. If I can find the error in advance through scrubbing or
validation, I'd rather handle it my own way. Just a personal preference I
suppose.
-Justin Scott
~|
Logware (www.logware.us): a new
There's no reason you can't get the exact same result
using exception handling as you're doing now using
conditional logic.
I like to think of it as pre-exception handling :)
-Justin Scott
~|
Find out how CFTicket can
on the CF server down to about 5% on average. It really did help
a LOT. If you're working with smaller tables that don't get a lot of
traffic, you probably won't notice much of a difference, if any.
-Justin Scott
~|
Discover CFTicket
.
-Justin Scott
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222683
Archives
.
-Justin Scott
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222685
Archives
. CFQUERYPARAM would help also.
Unfortunately some people are still using access databases, and don't have
the luxury of stored procedures. I use SQL Server myself, and sp's where
needed. I'm not a zealot one way or the other on what is used. Depends on
the situation.
-Justin Scott
(unSubscriber) to
display/extract your error message.
-Justin Scott
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client
If you do it the way you're doing it, you're comparing strings, not date
objects. You should take the fields you get from the DB and use
createDateTime() to create a CF datetime object, then compare that to now()
instead of comparing strings.
-Justin Scott
I'm trying to implement
() to determine if it is in range. Return value as needed.
-Justin Scott
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message
try to avoid
it.
Having said that, I don't think it matters one bit where you set them. If
they're only used in the cart, set and use them in the cart. No need to use
up memory for people who never go into the cart (not that it really matters
for most sites).
-Justin Scott
...
cffunction name=spaceTest
cfargument name=s type=stringcfsilent
cfreturn -NO MORE SPACE HERE
/cfsilent
/cffunction
Tested in CF 7.
-Justin Scott
~|
Logware (www.logware.us): a new and convenient web
a flush,
you could invoke the CF factory object and force it to flush all queries.
To invoke the factory...
cfset factory = CreateObject(java, coldfusion.server.ServiceFactory)
You can CFDUMP the factory object to find the exact method to call, I don't
remember what it is off hand.
-Justin Scott
announced they would be
closed today, so here we are on a gorgeous, cool breezy day with nothing to
do except read mailing lists g.
-Justin Scott
~|
Find out how CFTicket can increase your company's customer support
efficiency
-Justin Scott
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial
If you download the eval for SQL Server 2000 from Microsoft it includes the
client tools.
-Justin
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 22, 2005 7:49 PM
To: CF-Talk
Subject: OT - MSDE - EM/QA Tools
I've just installed MSDE
that it has some limitations,
but for low-end sites it should work fine.
-Justin Scott
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm
/catch block.
-Justin Scott
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free
around after the first request. I do this on several sites
and then send the original referrer along with contact forms, signup forms,
etc. to track where people are coming from.
-Justin Scott
~|
Logware (www.logware.us): a new
of my friends used this referral form to send whatever it
is to me and it got past my spam filter, I would be updating my filter
rules. Whether something like this will work depends on who you're
targeting it at.
-Justin Scott
experience on your web sites.
-Justin Scott
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com
, an included page, or a custom
tag/module. Request variables must be scoped (like application/session)
IIRC.
-Justin
-Original Message-
From: Duncan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 18, 2005 10:52 PM
To: CF-Talk
Subject: Re: evaluation order of CF scopes
ok so
with,
but that's what it sounds like you're doing).
-Justin Scott
-Original Message-
From: CHANCE, JENNIFER M. (JSC-BJ) (BAS)
[mailto:[EMAIL PROTECTED]
Sent: Monday, October 17, 2005 3:34 PM
To: CF-Talk
Subject: Cfinclude processing
Is there any way to make a page completely process
to change your local query object variable? If you update
the database, you also have to update your query object either manually, or
by running another query (as you've done here). This is normal...
-Justin
~|
Discover CFTicket
far.
-Justin
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221282
you save on the database side anyway? I would
think it would actually take longer, actually. Just my $0.02.
-Justin Scott
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking
I need a query that will return all records that are
set to expire ( column name toexpire - which is just
a date ) in the next 7 days.
select * from mytable
where toexpire ???
WHERE toexpire getdate()
AND toexpire = DATEADD(dd, 7, getdate())
-Justin Scott
are enabled/disabled, or
anything else like that. I'd imagine it's crippled to the point of being
useless for most of us, unfortunately.
-Justin
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application
with that. Dang... I could host most of my customers there
and save quite a bit.
-Justin
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm
sites free of non-functional clutter that
they might have issues with.
-Justin Scott
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project
cfif (IsDefined(form.Dropouts)) and (form.Dropouts is not
),Dropouts = #form.Dropouts#/cfif
Try wrapping the variable in a trim() function when checking for the blank
value.
-Justin Scott
~|
Logware (www.logware.us): a new
.
-Justin Scott
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day
an IP
may be in one zip code on one request, and another zip code on the next
request if two people end up with the same IP from different areas on the
same provider. Unless the IP is known and trusted, never rely on it.
-Justin Scott
Justin, you may be right. Spending thousands of
dollars to have a loan app online that may or may
not be used seems like a silly waste of money to me
All we can do as developers is tell the clients what it will take to make
their dreams come true. It's up to them to do the cost analysis
the same, but need to walk through
the tags within CF, you can output the XML object as a string into a
variable, SR on that variable using CF's functions to get the tags to lower
case, and finally read it back into an XML object again.
-Justin Scott
have your proper IP address listed in the admin.
-Justin Scott | GravityFree
Senior Programmer / Product Engineer
1960 Stickney Point Road, Second Floor
Sarasota | FL | 34231 | 800.207.4431
941.927.7674 | f 941.923.5429
www.GravityFree.com
your experiences have been like in this area. Are
there decent tools for automating the admin-building process, or do you
build them by hand each time? Any input would be appreciated. Thanks!
-Justin Scott | GravityFree=20
Senior Programmer / Product Engineer
1960 Stickney Point Road, Second
something to do with java memory?
Anyone ever seen this? Anyone? Buller?
Justin
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project
So, are you saying JRun4 Updater 6, fixed your 'cflocation/302 blank
response' issues?
We have been seeing it too. It seems to pop up randomly on different
sites.
We're running CFMX 6.1 and are moving to 7 in production next month.
Justin
-Original Message-
From: Adrocknaphobia
Short version:
On a hosted server, when I run a query the GUIDs are returned in as binary when
it should be a string.
This does not happen on my local test box or at the office.
How is this possible? Where do I go from here?
Example: This should be a GUID!
it faster than me anyway ;)
-Justin
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 18, 2005 2:42 PM
To: CF-Talk
Subject: RE: Anyone know of a more elegant way to do this?
You could use Chr(65) though to Chr(90), this will give you
need to use a LEFT JOIN
instead of joining by the WHERE clause.
SELECT m.company
FROM members m LEFT JOIN member_categories d
ON m.member_id = d.member_id
WHERE m.member_id = #session.member_id#
Syntax may be a little off, been a while since I wrote a join off the top of
my head.
-Justin
= #session.member_id#
GROUP BY m.member_id
-Justin
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com
.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2402 - mobile
941.870.5626 - facsimile
~|
Logware (www.logware.us): a new and convenient web
.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2402 - mobile
941.870.5626 - facsimile
~|
Logware (www.logware.us): a new and convenient web-based
phone for details.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2402 - mobile
941.870.5626 - facsimile
~|
Logware
Erm, thats an interesting discussion on the front
page. :)
Did I mention that it's an unmoderated chat system? An interesting
discussion wouldn't surprise me though.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED
, not the cookies CF uses to define its session scope.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2402 - mobile
941.870.5626 - facsimile
at the top
of the file.
ColdFusion NEQ Pascal.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2402 - mobile
941.870.5626 - facsimile
the
ACTUAL original value was. FWIW, the hacker may break the account but will
be unlikely to be able to take the password they reversed and use it
somewhere else.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED
.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2402 - mobile
941.870.5626 - facsimile
~|
Logware (www.logware.us): a new
not use URLs. If you must use a URL, use CFHTTP to
pull it down instead.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2402 - mobile
941.870.5626 - facsimile
Does anyone know of a CFML tool that is similar
to Horde?
I don't know how similar it is to Horde (since I've never used it), but
EcoBuilder has a lot of the features you mentioned.
http://www.ecobuilder.com/
---
Justin D. Scott
Vice President
Sceiron
/sceiron_linkapi_v1.zip
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2402 - mobile
941.870.5626 - facsimile
~|
Logware
Sorry guys, this is working... I was doing
something wrong... Sorry if I've
taken up any of your time... :)
I suspect the solution involved a ; character in a specific spot, but why
don't you post the solution for the archive in case someone else has a
similar issue in the future g.
-Justin
to put something on their bill simply by
sending a specially formatted SMS message or the like (unless you had a
special deal worked out with them as mentioned above). That would be a
major security issue, to say the least.
-Justin Scott
. It's been a while since
I've done this, so the JavaScript code may need to be tweaked to work
properly, but you get the idea.
-Justin Scott
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application
to mind to start with. Hope
that helps...
-Justin Scott
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http
Thanks Justin, but I can't rely on JavaScript...
I don't have your original message handy, but another way may be to have
multiple hidden fields with the ID numbers associated with each submit
button. If the first button was pressed, the code would look for the value
of the first hidden field
ListFirst(ListSort(numbers,'numeric'))
It should, but you'll probably actually have to add the
desc attribute at the end of my suggestion.
Or use listLast() instead.
-Justin
~|
Logware (www.logware.us): a new
will be ignored. There will be no error because CF won't even try
to find it to include.
-Justin Scott
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours
not know. You could try the same
thing with some screen output and have the same result.
-Justin Scott
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners
in somefile.cfm will not be included and compiled at all. In fact,
somefile.cfm doesn't even need to exist here and it will not throw an error
(because it won't try to include it).
-Justin Scott
~|
Logware (www.logware.us): a new
and not free.
I can't remember the name or URL at the moment though.
-Justin Scott
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project
images.
-Justin Scott
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4
cfloop query=q
cfquery name=q2 dbtype=query
select * from q where id = #q.id#
/cfquery
cfwddx action=CFML2WDDX input=#q2# output=variables.pkg
!--- Use variables.pkg to store in the new database here ---
/cfloop
-Justin Scott
Thanks, Justin, that did it. I was trying this route:
cfset qryRowData = queryNew(getVendors.columnlist)
cfloop list=#getVendors.columnlist#
index=i delimiters=,
cfset
querySetCell(qryRowData,i,getVendors[i][getVendors.currentRow])
/cfloop
but was getting a The row number, (0
back at
you. If this is the case, you may need to add a line to your hosts file so
that when you resolve your domain from within the server it will return the
internal LAN address instead of getting the external IP via DNS.
---
Justin D. Scott
Vice President
workstation.
IIRC SATA is hot swappable if you have an array of drives on RAID, where IDE
is not. All of our servers have hot swappable SCSI drives on RAID 5, and I
think SATA works similar with RAID 1 mirroring arrays. I could be
remembering wrong though.
-Justin Scott
to the router for processing.
-Justin Scott
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com
, however,
who can internalize what their client is trying to do and anticipate needs
that they don't even know they have, then create the tools to satisfy those
needs. Keep up your line of thinking and you will be well on your way.
-Justin Scott
of their server offerings. Some of the lowest end servers are
basically PCs in a rack-mount case so they have IDE, but almost anything 2RU
or bigger will have hot-swap SCSI drives.
-Justin Scott
~|
Logware (www.logware.us): a new
You'd be shocked how many different ways there are
to incorrectly spell scissors.
If you're searching against SQL Server, you might think about trying to use
SOUNDEX in your queries to help mitigate misspellings.
http://tinyurl.com/5fkov
-Justin Scott
header in their HTTP response headers, but here's
some code to get you started. Once you have the last modified date, you can
make a decision (in code) as to whether you want to download the rest of the
feed or not. Watch for line wrapping.
-Justin Scott
--- Code Below ---
!--- Get the headers
. Then you can avoid one of your Ifs
entirely...
cfparam name=url.group default=
cfif url.group NEQ 'me'do something here/cfif
-Justin
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start
the show bit to false and break out. This code would be
contained within your RSS output loop.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2402 - mobile
877.678.6011 - facsimile
, more elegant.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2402 - mobile
877.678.6011 - facsimile
~|
Logware
Not much traffic today..is there a US holiday
today I'm not aware of? ;-)
Yes, it's officially called Friday and comes around only once per week I'm
afraid. :-)
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED
of the CFEXECUTE tag to store the output of the
program being run. If the script isn't executing, try putting the Perl
command in a batch file and using CFEXECUTE to run the batch file instead.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
replacement.
cfoutput
input type=text value=#HTMLEditFormat(scope.variable)# /
/cfoutput
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2402 - mobile
877.678.6011 - facsimile
field (on
an update form for example) you should wrap it with HTMLEditFormat() so that
it will not disrupt the form.
Stupid question, yup..
Not at all. A question, in any form, is generally the sign of someone who
is ready and willing to learn.
---
Justin D. Scott
Just because your Big Mac is 99 cents, is it ok
if they drop a few on the floor or leave of the
pickles once in awhile?
Sure, as long as they don't give them to me, and I don't like pickles anyway
g.
cfset variables.could_resist = false
See, it's on topic ;)
-J
and the password is only on-screen for the
person doing the editing for a minute or so.
Hope that helps...
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2402 - mobile
877.678.6011
about where they came from, AND you
can continue to scope properly. Very nice, IMHO.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2402 - mobile
877.678.6011 - facsimile
be included in a CFC
that might need that logic for some reason.
There is a lot more than can be said on this topic, but that's what comes to
mind here at a quarter to one in the morning.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
conscious friends who sometimes ask why I don't wear brands and I tell
them it is too expensive, IMHO.
-Justin Scott
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http
the 404 page in IIS6 to a relative URL to your CF
page it will pass the original URL on the query string along with the 404
response code. The dump should let you find what you're looking for though.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc
don't want people to know you're a brand whore after
all? j/k) it won't allow you to switch back to the no option.
BTW I tried to convince them to use Flex, but they said
it was too expensive :-/
Too expensive for Tommy? Say it ain't so!
-Justin Scott
, a $25.00 transfer fee and a
few hoops are reasonable, IMHO. Try moving a Photoshop license from Mac to
PC and see what happens.
I'm a few days behind on the list, so apologies if this has been beat into
the ground already.
-Justin D. Scott
Section 508 does not deny you using Javascript,
it only forces you to come up with alternative
ways of displaying data.
IOW, writing two interfaces instead of one.
-Justin Scott
~|
Logware (www.logware.us): a new
that Macromedia could work on improving Flash in these areas
though.
-Justin Scott
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Here's what's on my bookshelf. Of these, I
like Mullet /Sano and Spolsky the best:
I would also recommend Don't Make Me Think! by Steve Krug. I would hold
off and wait for the second edition due in July before buying it though.
The first edition is great, but getting a little dated.
-Justin
I would find time to build something that interests you.
That's actually how DtDNS (www.dtdns.com) got started six years ago. I
started tinkering, and a DNS service popped out. Turned into a nice little
side business that pretty much runs itself.
-Justin Scott
doesn't really provide
them with any significant benefit in most cases. There are times where it
comes in handy (like Pizza Hut so I can order the same thing over and over
again easily g), but they should be the exception rather than the rule,
IMHO.
-Justin Scott
terms of programming prowess by having everyone
offer their experience with programming in
general and CF.
Me - 2 years programming - 2 years CF
Hi Will, I have about nine years of programming in general, and just over
six years with ColdFusion.
---
Justin
in advance for any input on this
matter.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2402 - mobile
877.678.6011 - facsimile
601 - 700 of 1291 matches
Mail list logo