> 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
> I need to parse and search xml data using coldfusion
> where tags are not always using the same case. (i.e.
> sometimes and sometimes .
> While parsing is case-insensitive, xmlsearch is not.
>
> Is there a search and replace that would convert all
> tags to lowercase letters?
Is there a reason
> 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 an
> I know that one can get a geographic location for a
> given IP, but does anyone know if there is a way to
> get the Zip Code a user is in from their IP?
No, as one ISP can service many zip codes, and in many cases many states.
The addresses are rotated out dynamically to users in most cases, so
> We have a potential customer that is a bank (a small
> local one). They want to be able to have people fill
> out a loan application online, but are worried about
> security, etc.
A couple of things to consider if you can...
* Put the SQL Server on its own box connected to the web server on a
> "")>,Dropouts = #form.Dropouts#
Try wrapping the variable in a trim() function when checking for the blank
value.
-Justin Scott
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start t
For those of you who build sites that require a back-end administrative
area, what do you commonly use for those back-end areas? In my
experience and from talking with other developers, the admin areas are
one of the most tedious and repetitive development tasks we encounter.
I'm wondering what yo
> So, I'm working on a dev box here in the office, and I'd
> like to turn debugging on for some work I'm doing, but for
> various reasons, I don't want it to be on for anyone that
> is browsing sites. What I'd like it to do is to have
> debugging turned on for me only. I see that you can
> specif
A regular expression would work out much better for this. Look for a single
character at the end, if found, reReplace() to a new variable using a
backreference to duplicate whatever letter is there already. I'd write the
code for you but I'm too busy at the moment. If Jochem is around he can do
> 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#
I think you may also need a GROUP BY...
SELECT m.company
FROM members m LEFT JOIN member_categories d
ON m.member_id = d.member_id
WHERE m.member_id = #sessio
> I must be losing it...
Your first query is returning four rows because there are four matching
results from the member_categories table, so it is returning m.company for
each one of those. If you only want it to return one record from members no
matter how many are in member_categories, you nee
> 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
Sce
ffice
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
~|
Lo
want innerHTML, not innerText.
-----------
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
again
with the new IP.
-----------
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)
give you a new session.
When I say "session" cookies I'm talking about cookies that expire when the
browser closes, not the cookies CF uses to define its session scope.
---
Justin D. Scott
Vice President
Sceiron Interacti
they can
still break the account, but there is still no way of knowing what 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
> 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 P
ower/template_blocks/banner.cfm.
> But if I go to the url that it could not find, I find the file fine.
CFINCLUDE only works with file system paths (full path or relative, or with
CF mappings). It does not use URLs. If you must use a URL, use CFHTTP to
pull it down instead.
--
er to manage.
-------
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.lo
/tools/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
~|
L
> We're talking about SMS messaging and the possibility
> of billing our customers through their mobile phone
> bill. I understand how the CF part technically works,
> SMS gateways and stuff. What I don't know is how we
> actually bill them. Does anyone have any links or
> know where I can go to
> 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 .
-Justi
> 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,
> I need to create a form with 15 minutes blocks that
> people can choose a block to sign up for. The page
> is receiving a variable for the number of blocks the
> person needs (1 =15 mins, 2 =30 mins, etc) and it
> has to be able to check the datasource if those
> spots are already taken for the
> I have a form with multiple submit buttons. Each
> button has a unique associated id value. I want to
> pass the associated id value with the submit
> button that is pressed.
If you can rely on JavaScript in your environment, set a hidden form field
that will contain the ID but default it to be
> 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 and conven
> This merges the code into a single class which
> it compiles.
>
> It is no different than
>
> If (x){
> Code 1;
> } else {
> Code2;
> }
Actually, that isn't true. CF complies each file to the cache individually,
so if you do this...
The code in somefile.cfm will not be included and c
> The easiest way to tell: Add a tag to
> each file. Second easiest: Add a tag to
> each file.
Actually, that wouldn't work. If it included the code for both but only
executed one of them, the one that was not executed would not have its
CFMAIL or CFLOG run, and you would still not know. You
> In the following does CF include only one page on the
> fly, or does it bring in both pages, but execute the
> code in only one?
>
>
>
>
>
>
That will only try to bring in and execute the page for the include that
gets hit. The other will be ignored completely. You can test this by t
> Is there a way to check the timestamp on an rss
> feed before actually having to retrieve the
> entire feed? I thought I had remembered something
> in the past... but have no idea where I saw it..
Someone else said no, but there actually is. It relies on the publisher
including a last-modified
> 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
~~~
> I was told by a few people that SCSI is fairly
> old technology and that today's IDE is "better"
> as is SATA. What are your thoughts?
I'm not a hardware expert, so SATA and newer IDE drives may be as good if
not better. However, the last time I looked Dell and HP only offer SCSI in
most of th
> Is it not standard practice to log all searches
> to your db?
Depends on the application and the client's needs. It's really your job as
a developer to make your client's life easier by providing them with tools
they can use to run their business (assuming they want to pay for them, of
course).
> Yes, true and that's what I meant - that if
> the IP resolves to a local IP on the host then
> the traffic is not routed.
Right, but if the server is behind a NAT router it will usually have a
different IP address than the one that the domain resolves to in DNS, so the
request would be sent out
> If you had to chose between two hard drives,
> which one would you buy?
That depends on what you want to use it for, specifically. If you're just
serving web pages with ColdFusion, either will do just fine. If your web
sites will have massive amounts of content (binary files, images, whatever)
uot; that CFHTTP is throwing 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.
----------
> Thanks, Justin, that did it. I was trying this route:
>
>
>index="i" delimiters=",">
> querySetCell(qryRowData,i,getVendors[i][getVendors.currentRow])>
>
>
> but was getting a "The row number, (0) is out of bound." error.
Just as an FYI, you were getting that error because you didn
> I'm completely rebuilding an old app, and for a variety
> of reasons, I would like to "store" the data for a
> given record from the old database in a field in a new
> table in a new database. In other words, I'm returning
> a query that has 1k records and 7 columns of data per
> record; I would
> I guess you are talking about:
> http://www.alagad.com/index.cfm/name-aic
That would be the one.
> It's definitely more features-rich, but I wouldn't
> call it "more robust" :-)
It's early .
> I am not sure it can resize GIF
According to their documentation it can read GIF, JPG and PNG. It
> If you are on CF 6.1+ you can try this one:
> http://www.olimpo.ch/tmt/cfc/tmt_img
That only supports JPG and PNG files, oddly. You would think GIF files
would also be included, but, oh well. I recall there being another CFC that
used Java calls to do the same thing, but it was more robust and
> It seems to me, that to use a url variable (or any type
> really) that I have to check for the variable before I
> can use it, otherwise I receive an error saying that
> it doesn't exist.
It's good practice to CFPARAM all of your URL and FORM variables into
existence before you try using them.
> >
> >Display this feed entry
> >
>
>
>
>Display this feed entry
>
I like Jochem's solution better than mine. Less code, more elegant.
-------
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceir
break the list down and search for each work individually. If one
is found, set 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.sceir
t same variable content in a form 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.
-----
. So you really don't need to do all that manual character
replacement.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 -
ot;variable" attribute 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 Preside
> 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.
ww
> 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
.
See, it's on topic ;)
-J
~
ext field and
all of the FireFox issues go away 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.5
can 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.sce
ever. You no longer have to worry 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 - mob
ithin your 404
handler. IIRC if you set 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. Sco
> > Too expensive for Tommy? Say it ain't so!
> It is too expensive, imho. Folks keep saying that
> 12,000 isn't much, but that's not the whole picture.
My point was that they should be able to afford it with the prices they
charge for their merchandise. A sort of irony because I have some "bra
> 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 and con
> They did a soft launch with Tommy Hilfiger (advertising
> to come out shortly)
> http://shop.tommy.com/shop?dsp=804&pcr=804&R=1366
As an aside on this, when it asks "Select your Tommy Hilfiger flag logo
preference" if you select either position and then decide you don't want
their logo (maybe yo
software, 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.
> I dont like the fact that the controls dont meet
> the basics of accessibility.
Flash is, by nature, not an "accessible" medium. If you need your web site
to meet certain accessibility requirements, Flash is probably not for you.
Sure, Flash is cool and makes our lives as developers easier, but
> 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
~
> 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.
-Just
> But to this day, Radio Shack, and many others,
> still ask for at least your zip code before
> ringing up a sale. And every time I get a
> haircut, one of the simplest services, I am
> asked to provide my telephone number so they
> can track me.
Does their ability to track you provide you with
> Thanks, yes, that's what I had before. But since
> I wanted the items to be separated by a comma,
Ah, I didn't catch that earlier in the thread...
#relatedWordName#,
-------
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sce
;re not using
, the only changes CF will make is to add a semicolon to the
end of the query, IIRC.
-----------
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2402 - mobile
877.6
>
>
> #valuelist(ViewRelatedWords.relatedWordName, ", ")#
>
>
ValueList() is meant to take a column and create a list out of the values.
To do what you're asking would require looping through the query...
#relatedWordName#
----------
ly transactions that
we've worked with in the past. Thanks in advance for any input on this
matter.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341
with ColdFusion.
-------
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 (www.logware.us): a new and convenient
> Any one interested in CF10 seats?
You have ColdFusion 10?!? Can I buy access to your time machine for a
little while? ;)
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2
imeFormat(now(), 'hh:mm:ss')#" to put it in the format indicated. Be sure
to use the correct GMT offset for your time zone.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - o
s as well.
-------
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 (www.logware.us): a new and c
he \mailroot\pickup directory and the IIS spooler will grab them and
attempt delivery immediately, effectively bypassing the ColdFusion e-mail
spooler. Do this in batches to 1,000 every minute or so and they should all
go out within half an hour.
-------
Justin D
an
this can address.
-----------
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
~|
Find out how CF
> About Us | Contact Us | Advertising | Home |
>
> Is there a way using MOD or something to drop the last one?
When outputting the delims...
#query.link_stuff#
|
-------
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.co
rprise
Manager gets cranky if I try to load 40,000 records at once.
-----------
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2402 - mobile
877.6
...
> Please share any thoughts or opinions
Not sure what you're looking for. All the tags you had listed do completely
different things.
-----------
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341
> SQL is looking for ('su','dm','ie')
> HOw do I pass that value instead of ('su,dm,ie')
#ListQualify(list, qualifier [, delimiters ] [, elements ])#
So in your case...
WHERE thisvalue in (#ListQualify(dbfield, "'")#)
-
> One thing I found using a SOHO router is
> that it doesn't support loopback,
Some do, as we did not have that problem here when we had a local dev
server. We use the LinkSys WRT45G unit and it always worked well for us in
this regard.
-------
Justin D.
editor to they could crop, remove redeye, etc., then have the finished
product uploaded to the server. Would prefer something in Flash to ensure
cross-browser/platform support, but we'll look at other options as well.
TIA for any thoughts on this issue.
-------
> I would recommend using a UDF path in the code
> and running CF as a user that has access to it
> instead of using a mapped drive letter.
Doh, as others have said, it's UNC not UDF. I've got functions on the brain
today.
-Justin
~~~
able it. Port 80 software also has a tool called ZipEnable (I
think) that will help configure compression in IIS6.
-----------
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2402 - mobile
877.678
t instead of using a mapped drive letter.
-------
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341 - office
941.320.2402 - mobile
877.678.6011
ques
on it (of which the cfoutput issue was one) you could see measurable speed
gains on individual page loads. Since this was an issue now two versions
back, it's really not worth discussing at this point. As I said, it's just
a matter of coding style at this point.
-----
use. If you
were to give the client something like FTP Voyager you may be able to script
that in some way as well. I know there are scriptable FTP clients out
there.
-------
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
any here in town that does basically what you're talking
about call RemoteData. They have more information about their processes at
www.remotedata.net.
-----------
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
941.378.5341
gt; 3-4) CFSET statements to CFSCRIPT. Again, in CFMX
that is not an issue as far as I know.
In any case, it's just a matter of coding style at this point.
-----------
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED]
94
ble.
As for e-mailing results, you can have a process that runs every X minutes
and checks for changes to their directory that would trigger an e-mail alert
of some kind.
-----------
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceiron.com
[EMAIL PROTECTED
(pf or ipf I forget which) and interface
bridging before and it works well if you have a relatively small group of
servers to protect and have the time to dedicate to learning the software.
If you have the money I'd go with a hardware appliance though for a variety
of reasons.
d be mistaken.
-----------
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
~|
Discover CFTicket
> I may be wrong but I think this is exactly what
> the first part of IsCreditCard() does.
Now that I actually read the description and look in more detail at the
code, that is correct.
---
Justin D. Scott
Vice President
Sceiron Interactive, Inc.
www.sceir
e added to the existing entry
an cflib, or if someone wants to submit it as a separate entry they are free
to do so. Here's the code (watch for wrapping)...
function luhn(cc_num) {
// luhn() - Version 1.00
// Written by Justin D. Scott of Sceiron Interactive, Inc.
// Use: luhn(card_number);
//
101 - 189 of 189 matches
Mail list logo