Which version of ColdFusion? And which Drivers? I am assuming vanilla
DataDirect but you never know, you could be running Microsoft ones or
updated to, I think, DD 3.5.
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a
If you haven't updated the drivers then I would suggest you give that a try
(try both the latest Adobe DataDirect 3.5 and Microsoft SQL 2005 JDBC ones)
You may also want to try a ToString() around the encrypted data as it is
passed in (do they really need to be encrypted? And if so, can't you
Thanks Joseph,
I've used the cfsftp component a few times before, so i might take a
better look into its workings, just for fun :-D
But you're right, using cfexecute is probably going to be the best method
for simplicity and speedy, I'll have a play around and see what I can get
working.
Thanks
Morning Niel,
Thanks for that info, I'm running on MX7 Standard here. As for the
encryption stuff, even with the encryption removed and just standard
values hard coded into the cfproparam (see my last post) I still get the
issue, so its not an encryption issue.
As for my drivers, I'm using what
OK,
Head to Adobe and patch up with the latest culmulitive patch for 7.0.2. I
think the latest drivers are in it, if not use this link
http://kb.adobe.com/selfservice/viewContent.do?externalId=42dcb10asliceId=1
N
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Thanks N,
Ok, so it looks like that cumulative patch was already installed on the
box, I must have placed it on when I built the server and forgotten about
it, I've reinstalled the patch and rebooted the box, So in the system
information page it now lists server version as:
7,0,2,142559
And
Ok, I can't remember if that patch contained the drivers? Did it say it did?
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
Use this to check your current version.
http://www.sargeway.com/blog/rss.cfm?mode=fullmode2=catcatid=12
Search for checking your driver version
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Thanks Niel,
I just ran the code from that site to get my driver versions and it gave
me the following output.
[Macromedia][Oracle JDBC Driver]Driver Version: 3.3.48 (008852.005015.004259)
[Macromedia][DB2 JDBC Driver]Driver Version: 3.3.48 (008852.005015.007851)
[Macromedia][Informix JDBC
Yep, they are out of date. It's a simple case of downloading the drivers (a
jar and a dll) stopping ColdFusion, copying and pasting over the old ones
(backup macromedia_drivers.jar) and restart.
Location where you copy varies on your ColdFusion install type.
Let me know how that fairs.
N
Mate,
I've just spotted a few blog posts that 3.3 is the out of date version
which was listed a bug with the 7.2 update, So I've just updated them
manualy, the log output now says this.
[Macromedia][SQLServer JDBC Driver]Driver Version: 3.50.13
(016217.009407.011311)
So, I'm running 3.5 build
How many rows are currently in the table? You are inserting into?
I may fire up my pc, and run in your table schema and yet out for myself
now!
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Hopefully James will spot this thread.
Everything works perfectly on my ajax related selects form, but I need to add
one last related select. This one would be populated by the course selected.
Let's say I built a new function in the ajax cfc called, getInstructors. I
don't expect anyone to
Hello Mate,
There are only 2 or 3 rows currently in the table, from where I've been
running the stored procs from SSMS.
Maybe it would be worth you trying to replicate the issue, I dont want you
to spend much time on it as I'd feel a little guilty, but you've got the
schema, if you need the
Ok, before I try, truncate the table and then try again and let me know if
it still errors.
Also when inserting all of your varchar values, as it seems these are the
ones erroring, do this in the Insert statement:
CAST(@yourvars AS VARCHAR(255))
Let me know how it goes. Also, did you say it
Hi Neil,
I've just tried an in-line query and that appears to work just fine.
I'm unable to try the other elements as my SSMS seems to have decided to
forget my connection passoword so I cant get connected untill I'm in the
office, doh!
Rob
Well just run a truncate via cfquery, you may also be run an sp drop/create
as well as chances are the DSN has sa rights ;-) or certainly drop/create
rights.
I will try and recreate later so send me everything you have etc and I will
run It against my local install on both Microsoft drivers and
Yes, you'd have a new function just like the one you've already built.
In the html you're returning to handleData() (in your response) you'd
make sure that the select has an onChange() that calls your new
function, which will set up its own mxData and has a different handler
Now why would they go and do a thing like that? :-)
Actually the core files are all CFC based so of course they are going to
bring the syntax into the 2000's
http://www.fusebox.org/index.cfm?fuseaction=documentation.WhatsNewInFusebox5
You can use invoke and instantiate to call a cfc method and
Hi Neil,
I tried the truncate method and that didnt have any effect. I created a
new version of the proc as follows.
cfquery name=LOCAL.qUpdate datasource=SecurityModel
CREATE PROC Proc_Credential_Create
@User_ID INTEGER
What are the respective values of @MemberUsername and @MemberPassword?
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
'TestUsername' and 'TestPassword' is what i've been using for testing.
cfprocparam value=testusername variable=MemberUsername
cfsqltype=cf_sql_varchar /
cfprocparam value=testpassword variable=MemberPassword
cfsqltype=cf_sql_varchar /
Rob
What are the respective values of @MemberUsername and
Hmm, so it failed even when you used these explicit strings? Very odd. I
have seen errors like you had when SQL tries to be smart and convert a value
based on values already in, but usually only via old DTS.
I will check later, when my kids are all in bed!
This e-mail is from Reed
Thanks Neil,
It certainly is very odd, I have no idea what its doing, like you say with
that explicite string definition it should be fine.
I've sent a mail to my SQL guy to see whether he has any suggestions as to
what might be causing the issue.
Thanks mate,
Rob
Hmm, so it failed even when
Well I do a few tests and let you know! :-)
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential and may also be
Most excellent! I'll give this a whirl in the next day or so James!
You dunno how much I appreciate the help dude!
Will
~|
Create Web Applications With ColdFusion MX7 Flex 2.
Build powerful, scalable RIAs. Free Trial
Hello Guys,
I feel like a bit of a putts for asking this, but its the first time I've done
any validation code for a while and I'm feeling a little rusty. I have a string
which I need to ensure contains no spaces, only letters with NO special chars
or numbers.
I was hoping to put each of
Sorry, I should probably have mentioned that I'm after CFML server-side
validation and not a client side solution.
Thanks,
Rob
Hello Guys,
I feel like a bit of a putts for asking this, but its the first time I've
done any validation code for a while and I'm feeling a little rusty. I
have a
cfset str = ABC 123 *$%^ /
cfoutput
Has Spaces: #find( , str)#br /
Has Numbers: #refind([0-9], str)#br /
Has Special Chars: #refind([^\w], str)#
br
br
Clean it up in one shot: #rereplace(str, [^\w], , all)#
/cfoutput
Thank you Bobby, thats a gret help.
Rob
cfset str = ABC 123 *$%^ /
cfoutput
Has Spaces: #find( , str)#br /
Has Numbers: #refind([0-9], str)#br /
Has Special Chars: #refind([^\w], str)#
br
br
Clean it up in one shot: #rereplace(str, [^\w], , all)#
We're in the process of spec'ing a new web server and planning on moving
from our current CF5 based web sites to CF7. This is planeed for the
July/August time period, with early September targeted as a live date.
Anyone have a recommendation to whether it would be wise to do this now,
or
You can purchase cf7 with an upgrade option, which can give you free upgrade
over a specfic number of years.
On 6/18/07, Jim McAtee [EMAIL PROTECTED] wrote:
We're in the process of spec'ing a new web server and planning on moving
from our current CF5 based web sites to CF7. This is planeed
We ported our app from 7 to 8.
We just had to do some updates to Transfer, but that was just a case
of getting the new code.
Everything else ran straight out of the box.
Mark
On 6/18/07, Jim McAtee [EMAIL PROTECTED] wrote:
We're in the process of spec'ing a new web server and planning on
James,
I have it all mostly working. My only issue is this. I'm trying to grab the
value of the course menu, set it to a JS var, so it can be sent in the
arguments.
function populateInstructors() {
var course = document.getElementById(course).value;
more stuff
Do you have a link we can look at?
On 6/18/07, Will Tomlinson [EMAIL PROTECTED] wrote:
James,
I have it all mostly working. My only issue is this. I'm trying to grab the
value of the course menu, set it to a JS var, so it can be sent in the
arguments.
function populateInstructors() {
I haven't had any issues with my older apps on 8. There are a couple of
places that are CF resellers that have a deal that lets you by cf7 now and a
subscription and you get a free upgrade to 8 when it comes out.
Eric
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent:
Do you have a link we can look at?
I setup a test page: http://208.106.220.252/soundings/T8Reporttest.cfm
Click Test eval 1. You'll see it error on the undefined form item. If you
select some data, the error goes away. I assume this is because the course item
is on the page at that point. I
I think anything you find would really be a CF5 to MX+ issue so moving from
7 to 8 would not be a large deal. I remember moving an app from CF5 to MX7
and didn't have much issue and so far moving apps from 7 to 8 have not had
any issues.
J.J.
On 6/17/07, Jim McAtee [EMAIL PROTECTED] wrote:
Just remove this :
addOnLoadEvent(function() {populateInstructors();});
You don't want it to run on page load.
On 6/18/07, Will Tomlinson [EMAIL PROTECTED] wrote:
Do you have a link we can look at?
I setup a test page: http://208.106.220.252/soundings/T8Reporttest.cfm
Click Test eval 1.
I think I might've fixed it james. I did a few ugly little things. :)
First off, I did this in the JS call:
function populateInstructors() {
if (document.evalFilterForm.course)
var course = document.getElementById(course).value;
else
var course = All;
;
Does any one know who to configure Apache to tie different domains to a
particular JRun Application Server?
I have ColdFusion running in one JRUN application server
and have now created a new application server and have Railo running on that
- works fine accessing it via the JRun HTTP Port
When
41 matches
Mail list logo