>>FYI you CAN get Access running on 08r2 with CF 64bit. It just takes some
work.
Exact, the trick is to define the ODBC database first, then link it to CF with
the administrator.
Once it is done, it works perfectly.
~|
Order
>>it could just as easy be said about frameworks
Let's say it then ;-)
The only framework I use is the one I've developped myself.
When a proble arises, I can look into it, understand it, and correct it easily.
~|
Order the Ad
>>I have robot updaters and inserters too (made all the more robotic with the
help of cfdbinfo figuring out the field types),
This is what I do, but using my own CFX_ODBCinfo I developped years before
cfdbinfo was available,
and I'm still using it because cfdbinfo doesn't work for Access databa
>>but if I remember correctly the currency data type only accepts 2 decimal
>>places.
I know, and my form only supplies 2 decimal places. Java adds all these
decimals, due to floating approximation errors.
And it does not explain whay there is an error with 57.49 and not with 57.50.
Anyway, I
Hi,
Weird problem this morning.
I have a CFINSERT which fails in an Access database with an error
"[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Data type mismatch in criteria expression. "
First, there is no criteria since it's only an insert.
Secon
>>I was just being anal about it.
That's our job, we are analysts aren't we? ;-)
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://w
>>I wouldn't do that. Seems a bit improper to me.
Well, IMO it depends on how you need to share data between levels of the tag
- If you need to share any level data between all levels, then getBaseTagData
is the only solution
- If you need to share the same data between all levels, the request.
>>So lets say that I passed a query into the attributes scope of the parent,
You can also define your query in the request scope and have it availiable at
all levels.
~|
Order the Adobe Coldfusion Anthology now!
http://www.am
>>It seem like a hack to get around something that should work.
Don't forget that syntax is checked at compile time and if at execution.
See this code for instance:
table rows go here
This would generate an opening http://www.amazon.com/Adobe-Coldfusion-Anthology/dp
>>To replace CFX_ValidEmail, I'd look at performing an MX lookup on the domain
Thanks for your feedback.
This is what I have implemented in my address validation function used by my
forms.
>>and then if you need to do an SMTP check, you'd have to implement a short
SMTP client that "pretends"
>>I use it to avoid duff mail addresses producing
spam triggers
Do you know that checking if a user exists without actually sending a message
can also tag you as a potential spammer?
~|
Order the Adobe Coldfusion Anthology n
>>Unfortunately, there isn't really a reliable way to check if a user
exists other than sending an email to that address and getting a
response.
Right, and I even add
and getting a response... from a user who knows that he has a spam folder
somewhere and who knows how to look in it.
But I'm no
Thanks, but the notice "All our CFX tags and tools are for the Windows platform
only." makes me think this tag is written in C, not Java.
I am hesitating installing new tags on my server.
Although I have a 64bit server, I had to install the 32 bit version of CF
because of some heritage CFXs, an
>>You need to use nslookup
Yes, this is what I end up doing.
Here is a function that returns the name of the mail server id there is on, or
an empty string if there is not.
(tested on Windows)
houseoffusion.com = #nslookup("houseoffusion.com")#
homeoffusion.com =
Hi,
I just lost about 2 hours digging in my mail server logs to find why a user did
not get his message sent by CF to finally find out the guy entered a typo in
his domain name...
So, I know that verifying that an email address exists is utopic, but verifying
that at least some mail server exi
>>you can get to it through getPageContext().
Exactly what I was looking for.
Thanks a lot.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive
Hi,
Since error messages include the number of the line where the error occured, I
suppose this line number is stored somewhere in the compiled code.
Does any one knows how to get this number ?
I mean anywhere in the code even when no error occured.
~~~
>>Modern browsers will remember form details and auto fill them if you go
back to same page especially if you didn't submit the form.
Do you have an example?
Well, if they do so, it's all right, but if they do not, they should not allow
to resubmit a page with method GET when it was first requ
Hi,
I recently discover a problem with IE 10, may be previous versions as well, and
although it is not directly related to CF, I thought I could share.
Here is the problem:
I get sometimes weird errors on my sites and the logs show that the user got
directly to an update template without filling
>>How would you perform CSS pre-processing with CF?
Well, if the job is just to create dynamic CSS, CF can do the same way it can
create dynamic HTML.
It can either create static .CSS files whenever styles muste be changed. For
instance, in my CMS I have a styles editor with all parameters sto
>>But why rewrite
the wheel when documented frameworks already exist
Learning another language to do what can be done as easily by the language I've
been using for years looks like reinventing the wheel to me.
~|
Order the Ad
Apparently, this looks like a CSS prepocessor.
But I do not see anything that cannot be done with CF.
So what is the advantage of using yet another technology?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/A
>>In the query: DuesExpire = >0>NULL#CreateODBCDate(FORM.DuesExpire)#,
So I suppose you're using the variable DuesExpire in the SQL code.
In that case, since the ODBCDate contains single quotes, the pseudo function
Preserve single quotes should be used, ie:
DuesExpire = #preserveSingleQuotes(Du
Pretty nice idea indeed; I'll give a try.
Thanks.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-ta
>>If you just want better reporting for SMTP to track bounces, rejections,
failures etc,
Yes, this is mostly what I'm looking for.
>>but the anti-spam is basic content filtering,
DNSBL etc, there is no Bayesian engine ,
Anti-spam is not a problem, I'm fondamentally opposed to anti-spam systems
>>For our marketing messages, we use Marketo.
We don't send marketing messages and I'm not looking for a third party solution.
We offer a complete Content management and email system, with SMTP and POP
servers.
I want to be able to control both of them more precisely.
When I get a call like "I'
Hi,
I'm presently using MailEnable on my server. It's a good program, but I need to
build a system
to follow up messages.
My customers (associations) send messages to their members and some messages do
not go through for many reasons.
They need to have confirmations and reasons of failures.
The
Ok, I have more information about this problem.
In the CSV file, if I replace all semicolons by commas, it works perfectly.
The problem is that, either under W 7 or W 2008, it seems that one can set the
delimiter and some other format parameters in odbcad32.exe, but they are not
saved anywere,
>>You might try passing delimiter=';' as an additional dsn parameter.
BINGO!
The problem is that the file Schema.ini is not properly updated by the 32 bit
ODBC Administrator.
In my W 7 file I see Format=Delimited(;) which is correct, but in the W 2008
file I have Format=CSVDelimited
I set Deli
I finaly found the problem:
When you open the ODBC Administrator, you first select the database you want to
update,
you click on configure, you see the name of your datasource, fine,
then you click Options, you still see the name of the datasource you are
configuring,
then you click Define forma
Hi,
since I moved my applications from a 2003 server to Windows 2008, I have a
problem reading a database defined on a .CSV file through the ODBC socket
driver.
The problem seems to be with the ODBC driver.
I have the 32 bit version of CF installed an I use the odbcad32.exe 32 bit ODBC
adminis
>>and it's just a CFX DLL, you shouldn't really
need an installer. Copy the DLL to the new server, then register it
within the CF Administrator.
Yeah, but there is also another DLL to be stored under Windows/system32 if I
remember well.
~~~
>>I love using it. It is super-fast
It used to be THE solution for managing images some times ago, but with CF 10,
I think CFIMAGE is about as good as ImageCR.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.c
>>Not "gregorian date". Gregorian is a kind of calendar.
Yes, but a date in the gregorian calendar is a gregorian date.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/143027215
>>I am interfacing with a webservice and the dates returned are in Gregorian
>>format.
There is no gregorian format as such, but dates in the gregorian calendar.
All dates nowadays are in the gregorian calendar, since end of XVI century.
~~
>>I have been asked to add standard meta tags to the web pages.
If they were talking about Key word meta tags, just tell them they are ignored
by Google.
Google will only index real text content.
~|
Order the Adobe Coldfusion
>>but there is no record on the mail server
Are you sure the mesages are not in the undelivered folder?
I was having the same issue until I realized that my mail server had a limit of
1000 messages sent per hour.
So after this limit was reached, messages were simply refused and stored by CF
in
>>what company in the business of
selling stuff, isn't interested in selling stuff?
For instance a company who bought the company who baught Macromedia
because they where intersted in former Macromedia products like Flash, but not
really in other stuff like CF.
~~~
>>Problem: new ones all
come with Windows 8 so it looks like I'll be buying (unless I can find
freebies) some new development tools.
I'm usint CF Studio (identical to Homesite) and it runs perfectly under Windows
7 64bits.
Just make sure it runs in compatibility Windows XP mode.
~
>>Maybe they would just Google it.
Google is a good tool but not an excuse for having a poor home page.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffu
>>but it does seem like Adobe marketing, and to some point Adobe development,
>>is asleep at the wheel. I can hear them snoring from here.
They could start by giving CF the place it deserves on ther Web site.
How many steps do we have to go through before we find a single page about CF
in th
>>I finally pulled the plug on the 64 but and installed the 32 bit CF version.
I'm also using CF 32bit, but it is because of some 32bit CFXs, but I did have
the 64bit running with Access datasources.
I have Access 2003 installed on the server, may be you need it to bring the
correct 32bit driv
>>You cannot natively run msaccess on 64bit windows as there is no 64bit jet
driver,
Actually you can.
Look for C:\Windows\SysWOW64\odbcad32.exe
This is a 32bit ODBC Data source Administrator.
Use it to define your System DSN first, then in the CF Administrator define
your datasource with the M
>>Why on earth would you forbid HEAD?
I thought it was, because the response was not 200, but it is not.
The response is actaully 206, which is normal.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-C
>>I think if you have FP installed and you use IE and
you have things configured a certain way, FP will just try to see if
the site supports FP Extensions.
Ok, but then, if he is using IE, shouldn't MSIE appear somewhere in the user
agent ?
IF the user agent is "Mozilla/4.0 (compatible; MS Fron
>>FrontPage is an HTML authoring tool from Microsoft.
So, do I suppose well if I suppose the user is trying to see if he can edit my
site if it is accessible to FrontPage and is not protected?
~|
Order the Adobe Coldfusion An
Hi,
My sites are hit on a regular basis by this agent: Mozilla/4.0 (compatible; MS
FrontPage 14.0)
- it makes requests with methods OPTIONS or HEAD which are forbiden in my sites;
- it makes requests for pages that does not exist, like
- /_vti_inf.html
- /_vti_bin/shtml.exe/_vti_rpc
The
>>Care to share?
To share no, but to document, yes.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/c
>>Has anyone found a replacement for client side validation that is even
close to CFform in terms of comprehensiveness of data types it validates
against?
Yeap, I've developped my own client side validation system.
At thet time CFFORM did not allow for messages other than in English.
I use a ho
>>If so, this won't work because I don't use an actual button with
a type of "submit". The "submit" button for my form is just a regular
button that triggers an AJAX function that sends the data to a CFC
for further processing and then submission in the CFC to Authorize.net.
From this you can c
>>Um, did you search CFLib?
Hmmm I searched for something else one hour ago, didn't find it so I decided to
make it myself, needed this reEscape() function and forgot to search again :-(
Thanks.
~|
Order the Adobe Coldfusion
Hi,
CF10 provides a new function: reEscape() which as it says escapes regexp
control characters in a string.
I would need such a function but I'm uder CF9.
Has any one heard of a function that would do the same thing?
Thanks.
~
>>You can disable UAC. This is probably not a good idea, though, especially if
>>it's not your server.
It is a dedicated server, but it is certainly not a good idea indeed.
>>it's very easy to just open a single command prompt as Administrator and
use that to launch any specific actions that
>>It tells you how to add "Open With Notepad as Administrator"
Very good! It works!
Thanks a lot, very clever solution.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/143027215
>>Right click the program used to edit, and choose run as administrator, then
>>open the file from within the application.
Thanks, I know I can do that, my question is how to bypass this hassle?
>>You can't get admin rights that I know of by right clicking a file and
>>choosing edit.
But
>> If so, you should be
able to open any program from that prompt and have it use
Administrator privileges.
I can run any program as administrator if I right click on the progam exe file
in Windows Explorer,
But I cannot set its privilege level in its properties.
This is annoying, because if I
Hi,
I'm installing CF9 on a new W2008 dedicated server.
This server has a level of security which is driving me crazy.
I log as Administrator and I cannot modify any xml file even with bloc-notes :
access denied, even when the CF service is stopped.
When I try to set bloc-note to run as administ
Hi,
I'm trying to install solr collections for my sites unde CF9, so I installed
Solr Server, but when I try to create a collection in the administrator, I get
this error :
« fr_FR. must be one of the ColdFusion supported locales ».
But fr_FR is the Java Default Locale in the CF administrator.
>>Is there a way around this?
Just create empty columns when they are missing, ie:
*SELECT*
first_name,
last_name,
off1_name,
off2_name,
off3_name,
atty_id,
email
FROM newstuff
UNION
SELECT
first_name,
last_name
>>Find out why I use LinkedIn.
Who cares? ;-)
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk
>> you might even go to prison over it.
;-))
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/
You need to use the preserveSingleQuotes () pseudo function ie:
#preserveSingleQuotes(sqlStatement)#
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffu
Hi,
I'm considering installing my applications on a new dedicated server and in
particular on a SSD server.
Has any one any experience with this configuration?
How good is it?
~|
Order the Adobe Coldfusion Anthology now!
http:/
>>Ssd makes the most difference to rdbms like mysql or mssql which involves
lots of iops
This is what I was mostly thinking of, and for any database system.
Thanks.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazo
Hi,
I'm considering installing my applications on a new dedicated server and in
particular on a SSD server.
Has any one any experience with this configuration?
How good is it?
~|
Order the Adobe Coldfusion Anthology now!
http:/
>>It appears that a google bot somehow hijacks the user session,
It is not a good idea to associate the IP to a session.
Some providers assign a new IP to each HTTP requst, AOL for example.
Google Bot also can request your site from many different IPs.
~
>>2. Only query the primary keys, and then loop over that list grabbing x
records at a time and doing a new query to get all rows for those keys.
This is a pretty good method.
I tested it on a database containing about 45 records with a seach template.
I give a very loose criterion on purpos
>>I downloaded and reviewed the h.cfm file -- yeah, it is pretty clever.
The file itself is some tool designed to be used by developers, probably not
developed by rhe hacker himself. He just found a way to store it on servers.
>>but how did that hacker place the h.cfm file in /CFIDE/ to begin
>but i think the way this one works quite ingenious.
I'm not sure if it is as much ingenious as the breach is gross, frankly.
Have you seen how the schedule task could have been set?
~|
Order the Adobe Coldfusion Anthology now
Well, I see. Then it definitely looks like a Firefox issue. Have you try with
Explorer?
I don't see what you can do from CF.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/14302
>>
>>This works great for viewing the file, but the name of the file is
>>"classroom.pdf"
since there is multiple handouts the user is likely to overwrite previously
saved
files
Well, if the file name is "classroom.pdf", it must be because you have handout
set to "classroom.pdf", no?
~~
You need two tags: one to set the file name, one to send return the document
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.h
>>It seems however that it went from talking about using Javascript with
Coldfusion to using Javascript by itself..
So what ? This forum is for CF users. Are you a CF user who does not use
Javascript?
~|
Order the Adobe Coldf
>>Is there then a way to save the vars that came back to the client from the
>>server cfc into cf session scope,
The best would be to save it while still on the server from the cfc.
But you must make sure the session Id is transmitted to the cfc, otherwise it
will define a new session.
>>Hi Claude, perhaps the only way to do it with ajax in a 1 step process is to
>>send the screen size vars to the cfc, then based on the results from the cfc
>>have js append something to the image source path so a different set of
>>image files loads.
Probably, if you absolutely want to u
>>I think your still not understanding the power of AJAX.
I think you still don't understand the point that Ajax is simply not the best
solurion in this instance.
>>You can use AJAX to completely build a page on the fly,
Yes, of course you can, but when you can do better and simpler not usin
>>This is the point in ajax, to send.data.from client side to server side.
May be, but the point is still that when Ajax does it, the page that needed the
data is already at client side, so it is too late.
For sending data to the server, there is still good old FORMs.
Ajax is more useful to get
>>Its a workable solution for getting
Now, the trick I gave was only to deal with the specific problem as you defined
it, but there would be an even better solution.
I suppose the user has to go through some other page before he gets images.
So why not simply transmit the screen size before wit
>>But you cannot get these values ntil after he page loads
The page loads but reloads immediately sending the values in the same time.
It is still a two steps process, but in this case, the first step is automatic
and transparent to the user.
>>so using ajax is perfectly valid way to send dom
>>It seems there's no way to avoid the 2nd step either redirect or form post.
The problem is not with using POST or GET, the problem is using Ajax.
Ajax is good for many things, but not for this one.
Just as you first attempt did, the Ajax call will be performed from client
side, AFTER the temp
>>When I first loaded the page I received an error, after I refreshed the
error went away.
This method won't work either, because the Ajax function will be executed after
the output of the page is already on client side.
This is why you get an error at the first call. So you have to call the
t
You could also check in the logs, if something wrong happens, it should be
tracable in the mail log.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
>>I found this somewhat related article.
Well, no it is not the same. This one seems to deal with an error when setting
the SRC attribute by Javascript, which is not what I'm doing.
Whet I have is a page like "myPage.cfm" which has an >Article does not mention it, but I believe the (with whic
>> it looks like you need a space between
mondossier.cfm and type=#type#
No, type here is a parameter in the url, not an attribute for http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353
>>Is it possible the IFrame src is getting redirected to the "root"
It would be if the file is not found, but the file exists and it works with all
other browsers, including IE8.
Only IE9 seems to have trouble.
And if it was redirectected, there would be a trace of it in the HTTP logs
For insta
>>Try ./file.cfm
Ok, I tried, but it makes no difference.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/gr
Hi,
One of my customers is having a very weird problem with an IFRAME in my site.
Here is the code in file mondossier.cfm:
type is blank
With all browsers, including my own Explorer it works perfectly.
This is the trace how it look in tje server log when the page works normaly:
GET 575 6
>>Actually there is a setting in the cfadmin for a pagetodisplay on timeouts.
Thanks. Didn't know that.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffu
>>I would be guessing this is a page time out, only because there seems to be
a number of cfhttp calls going on.
Right, the time required for the HTTP calls represents a high percentage of the
total time in the loop, so chances the time limit occurs during the HTTP are
high.
But I still don't
>>Then that indicates that there is no error...
There was an error, a timeout error.
A far as I can remember, timeout errors were thrown, even while executing a
CFHTTP request.
~|
Order the Adobe Coldfusion Anthology now!
htt
>>it is because your dumping the
cfcatch which actually does contain the error that occurred.
I don't understand what you mean.
The dump never occurs, thus the error is not catched.
Anyway the problem was simply a time limit of 60 sec by default.
This is weird because exception type is Any by d
Hi,
I have an application that reads pages in a loop using CFHTTP.
It works well, but when the number of pages read reaches some variable
threshold,
the application seems to abort from inside the CFHTTP command.
Roughly, the code looks like this:
Output something 1
>>I'm sure I haven't check it. Where is that option?
Ok, got it! in the CF service.
I checked it, and now it does call CF Studio, although it looks like it creates
another desktop instance especialy for the application, opens plenty of windows
and asks many questions before I can access the p
>>Are you sure you've checked the "interact with the desktop" option?
It's not checked by default.
I'm sure I haven't check it. Where is that option?
>>When you run PKZIP, is it running as a console application or as a GUI?
Yes a console application, that' why it works.
>>I eventually fixed the problem by forcing a locale fro the
JVM in the ColdFusion Administrator by adding the following JVM
arguments: -Duser.language=en -Duser.country=AU.
Hey! How about that! It solved my problem.
I added -Duser.language=fr -Duser.country=CA and now it works.
Thanks a lot!
>>I notice that this invalid date is in american format (mm/dd/), though
>>My system local is set for French, thus the date format should be dd/mm/
I think I will have to wait until dec 1st, the the date will be valid in both
formats, and hopefuly I'll see where it is used.
>>I would suggest you just delete the task from neo-cron.xml and start again
and see if the issue persists
Finaly, the trouble seems not to be with the sceduled tasked.
The date-time which is declared invalid is actualy rhe time I open the
administrator Scheduler page.
This time must be used t
>>Try neo-cron.xml (should be in the \lib folder under your ColdFusion
installation).
Thanks, I found it.
But my assumption was wrong. The date is not contained in this file, it is
simple the date-time at the moment I open the scheduler.
How could this date be wrong?
~
Hi,
When I open the Scheduler in the CF administrator (CF 9), I get the error:
"11/26/2012 1:58:00 PM is an invalid date format.
Fist I don't see why it is ivalid.
But I'd like to see if I can modify it.
I suppose all the information about scheduled tasks is stocked in some XML
file, but where?
>>That's not going to work unless (a) all components (CF, CFStudio,
browser, web server) are on the same machine, and (b) the service logs
on as SYSTEM and is allowed to interact with the desktop.
All these conditions are met.
And I already use CFEXECUTE with other applications to run applicatio
101 - 200 of 518 matches
Mail list logo