I'm getting Invalid Parameter Binding on this function
http://pastebin.com/xfh8uLVa
The conf_id variable is a UUID string and if I put the value in the query
and manually run it I get the results back.. But why am I getting this with
cfqueryparam?
Thanks
Thanks Dave! I've used varchar before and it was working earlier. I had to
change the query around a bit and since then I've been getting this error.
But I tried botd idstamp and char(36) and got the exact same error both
times.
I'm using SQL Server 2005. It works find in SQL Server Mgmt Studio
Also, using this works..
c.conferenceUID = '#arguments.conf_id#'
So I'm not sure what the problem is with cfqueryparam
On Fri, Jan 25, 2013 at 12:43 PM, Greg Morphis gmorp...@gmail.com wrote:
Thanks Dave! I've used varchar before and it was working earlier. I had to
change the query around
: and ac.is_complete = 1
548 : /cfif
On Fri, Jan 25, 2013 at 12:47 PM, Greg Morphis gmorp...@gmail.com wrote:
Also, using this works..
c.conferenceUID = '#arguments.conf_id#'
So I'm not sure what the problem is with cfqueryparam
On Fri, Jan 25, 2013 at 12:43 PM, Greg
This is what the URL looks like
/admin/conference/index.cfm?action=view_attendeesconf_id=6f1e0d6d-c35e-4ea2-9e24-39e0e02d442d
I reworked the query to use the ID as opposed to the UID and I'm getting
the same error. But again, if I remove cfqueryparam it works.
cfif structKeyExists(arguments,
So, just this:
and c.id = cfqueryparam value=#arguments.conf_id# /
?
still get [Macromedia][SQLServer JDBC Driver]Invalid parameter binding(s).
On Fri, Jan 25, 2013 at 1:20 PM, Dave Watts dwa...@figleaf.com wrote:
This is what the URL looks like
:28 PM, Greg Morphis gmorp...@gmail.com wrote:
So, just this:
and c.id = cfqueryparam value=#arguments.conf_id# /
?
still get [Macromedia][SQLServer JDBC Driver]Invalid parameter binding(s).
On Fri, Jan 25, 2013 at 1:20 PM, Dave Watts dwa...@figleaf.com wrote:
This is what the URL
Specifically it doesn't like this:
case when
(acp.date_received is not null or ac.payment_method = 'credit')
then 1 -- show init_refund
else 0 -- show nada
end as show_init_refund,
On Fri, Jan 25, 2013 at 1:31 PM, Greg Morphis gmorp...@gmail.com wrote:
I removed this section of the query
What I did was just return the data_received value and I already was
returning the payment_method so I just used CF code to check the values.
Thanks for all your time Dave!
On Fri, Jan 25, 2013 at 2:09 PM, Dave Watts dwa...@figleaf.com wrote:
Specifically it doesn't like this:
case when
It was attempted via the URL
On Wed, Jan 23, 2013 at 11:57 AM, Rob Voyle robvo...@voyle.com wrote:
Hi Greg
As I continue to update my security processes, I'm curious
Was this injection attempt at the url or at a form input.
Thanks
Rob
On 22 Jan 2013 at 11:12, Greg Morphis wrote
I saw some request errors but what were they trying to do?
This is what the onRequest error email showed
declare @q varchar(8000) select @q =
0x57414954464F522044454C4159202730303A30303A313527 exec(@q)
~|
Order the Adobe
Ah so they were just checking to see if they could get something to work
before possibly trying anything real.
Thanks!
On Tue, Jan 22, 2013 at 11:15 AM, John M Bliss bliss.j...@gmail.com wrote:
That's hex for, ?WAITFOR DELAY '00:00:15'
On Tue, Jan 22, 2013 at 11:12 AM, Greg Morphis gmorp
That's what I would do. Send the user to a page that stores the ID of the
movie (or whatever) and then redirect them to the download link.
On Mon, Jan 7, 2013 at 11:42 AM, Bruce Sorge sor...@gmail.com wrote:
Hello all,
I have a site where once a user registers they are taken to a page with
Does anyone have or know of a good list of delimited countries and
territories I can use and import into my DB?
Thanks
~|
Order the Adobe Coldfusion Anthology now!
That is awesome.. thanks Russ!
On Mon, Dec 3, 2012 at 1:03 PM, Russ Michaels r...@michaels.me.uk wrote:
http://countrylist.net/
On Mon, Dec 3, 2012 at 6:43 PM, Greg Morphis gmorp...@gmail.com wrote:
Does anyone have or know of a good list of delimited countries and
territories I
I'm sure there are several ways to do this
cfset FORM.some_url =
http://somesite.com/some_display.cfm?some_id=4184chapter_id=12120passage_id=40099
/
cfset params = listgetat(FORM.some_url,2,?) /
cfset p = listtoarray(params, ) /
cfset chapter_id = 0 /
cfloop array=#p# index=i
cfif
cfdump var=#chapter_id# /
On Thu, Nov 15, 2012 at 8:40 AM, Greg Morphis gmorp...@gmail.com wrote:
I'm sure there are several ways to do this
cfset FORM.some_url =
http://somesite.com/some_display.cfm?some_id=4184chapter_id=12120passage_id=40099
/
cfset params = listgetat(FORM.some_url,2
gets the second item in the list (chapter_id=12345) using the = as a
delimiter
On Thu, Nov 15, 2012 at 8:53 AM, morchella morchella.delici...@gmail.comwrote:
not sure what the listgetat 2 is doing?
~|
Order the Adobe
and the first one is separating the parameters from the URL using the ?
as a delimiter.
On Thu, Nov 15, 2012 at 8:59 AM, Dean Lawrence dean...@gmail.com wrote:
It is treading your form.some_url value as a list separated by a
question mark. The listgetat is retrieving the second value in the
What DB are you using?
On Wed, Nov 14, 2012 at 7:43 AM, Eric Bourland e...@ebwebwork.com wrote:
Greetings. I need some advice again. I need to use CFSCHEDULE to schedule a
task that does the following:
* review all records in table 'membersTable', once per day
* return records that
cast(dateadd('y', -1, getdate()) as date) as -- getdate() in MSSQL
or
trunc(dateadd('y', -1, sysdate)) -- sysdate in Oracle
On Wed, Nov 14, 2012 at 7:46 AM, Greg Morphis gmorp...@gmail.com wrote:
What DB are you using?
On Wed, Nov 14, 2012 at 7:43 AM, Eric Bourland e...@ebwebwork.com
try that first one, I assume your date column in the DB is storing just the
date and not the datetime?
if it's storing datetime there would be a problem and you'd have to cast
that as a date too.
On Wed, Nov 14, 2012 at 7:52 AM, Greg Morphis gmorp...@gmail.com wrote:
cast(dateadd('y', -1
a purely MSSQL way would be
SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, DATEADD(yy, -1, GETDATE(
since 2005 doesn't support that.
On Wed, Nov 14, 2012 at 11:02 AM, Leigh cfsearch...@yahoo.com wrote:
cast(dateadd('y', -1, getdate()) as date) as -- getdate() in MSSQL
I do not think 2005
Something is baffling me.. I'm inserting a value into the database and it's
rounding the number. I don't know where or why this is happening!
On the action page this is what the code looks like when inserting
INSERT INTO mytable
as to why this happens? I'm using CF9.0.1
On Mon, Nov 12, 2012 at 11:11 AM, Greg Morphis gmorp...@gmail.com wrote:
I tried decimal(19,2) and back to smallmoney and still 36.00 gets inserted
into the database table. And changed the type in the cfc to cf_sql_decimal.
On Mon, Nov 12, 2012 at 10
Aha, Google is my friend..
when using cf_sql_decimal you must specify the scale parameter..
scale=2 /
makes it all work.. now to go through and make sure everywhere else I'm
using the cf_sql_decimal I'm providing the scale parameter.
On Mon, Nov 12, 2012 at 11:28 AM, Greg Morphis gmorp
I tried decimal(19,2) and back to smallmoney and still 36.00 gets inserted
into the database table. And changed the type in the cfc to cf_sql_decimal.
On Mon, Nov 12, 2012 at 10:56 AM, Greg Morphis gmorp...@gmail.com wrote:
Something is baffling me.. I'm inserting a value into the database
I've got this code:
myspan.innerHTML += 'ul'
for(i=0; ipresentation.DATA.length; i++) {
myspan.innerHTML +=
'li class=grey_homepage_texta href=' +
presentation.DATA[i][presentation.COLUMNS.findIdx('PATH')]
+ '' + presentation.DATA[i][presentation.COLUMNS.findIdx('TITLE')]
+
Got it.. I just made a long string and then at the end set the innerHTML
value to the string.. works like a charm!
On Fri, Sep 14, 2012 at 2:15 PM, Greg Morphis gmorp...@gmail.com wrote:
I've got this code:
myspan.innerHTML += 'ul'
for(i=0; ipresentation.DATA.length; i
I'm playing around with the cfajaxproxy example on adobe livedocs and
everything looks right, I get
Timestamp: 9/12/2012 10:15:55 AM
Error: TypeError: presentation is null
Source File: http://localhost:81/resources/demo.cfm?reset=1
Line: 44
here's the code I have..
cfajaxproxy cfc=proxy
is being passed to the callback.
On Wed, Sep 12, 2012 at 10:23 AM, Greg Morphis gmorp...@gmail.com wrote:
I'm playing around with the cfajaxproxy example on adobe livedocs and
everything looks right, I get
Timestamp: 9/12/2012 10:15:55 AM
Error: TypeError: presentation is null
Source
before the
line throwing the error) and sharing what is dumped?
On Wed, Sep 12, 2012 at 10:53 AM, Greg Morphis gmorp...@gmail.com wrote:
Thanks Ray for the response,
I get this in the console when putting a breakpoint on the var pId = ...
_cf_clientid186CD443C74F6630BE78C272EDD3CB4E
ColdFusion.
--
Regards,
Andrew Scott
WebSite: http://www.andyscott.id.au/
Google+: http://plus.google.com/113032480415921517411
http://plus.google.com/108193156965451149543
On Thu, Sep 13, 2012 at 2:33 AM, Greg Morphis gmorp...@gmail.com wrote:
Since the line throwing the error is:
var
I use both Chrome and Firebug, can you tell me what or where to look in
Chrome Dev Tools to get you guys the information needed to help?
Thanks
On Wed, Sep 12, 2012 at 11:51 AM, Andrew Scott andr...@andyscott.id.auwrote:
I haven't used firebug in a long time, as I use Chrome now. But from
://plus.google.com/113032480415921517411
http://plus.google.com/108193156965451149543
On Thu, Sep 13, 2012 at 2:54 AM, Greg Morphis gmorp...@gmail.com wrote:
I use both Chrome and Firebug, can you tell me what or where to look in
Chrome Dev Tools to get you guys the information needed to help?
Thanks
/113032480415921517411
http://plus.google.com/108193156965451149543
On Thu, Sep 13, 2012 at 3:04 AM, Greg Morphis gmorp...@gmail.com wrote:
This is what's in the proxy.cfc in the network tab..
1. Request URL:
http://localhost:81/resources/proxy.cfc?method
ColdFusion.AjaxProxy.invoke(this, getAllConferencePresentations, {
tag_id:tag_id,year:year});};
/* ]] *//script
On Wed, Sep 12, 2012 at 12:11 PM, Greg Morphis gmorp...@gmail.com wrote:
This request has no response data available
That's for the proxy.cfc file
On Wed, Sep 12, 2012 at 12:07 PM, Andrew Scott andr
/108193156965451149543
On Thu, Sep 13, 2012 at 3:13 AM, Greg Morphis gmorp...@gmail.com wrote:
The demo.cfm has this at the top and then the rest is the same cfm code
headscript type=text/javascript/* ![CDATA[
*/_cf_loadingtexthtml=img
alt=' ' src='/CFIDE/scripts/ajax/resources/cf/images/loading.gif
But under Network proxy.cfc shows
Method: GET
Status: (canceled)
Type: Pending
Initiator: cfajax.js 147 Script
Size 13B 0B
Time: Pending
On Wed, Sep 12, 2012 at 12:36 PM, Greg Morphis gmorp...@gmail.com wrote:
What's weird is if I click on the RequestURL
http://localhost:81/resources
(presentation)
1. arguments: Arguments[2]
1. 0: null
2. 1: undefined
On Wed, Sep 12, 2012 at 12:39 PM, Greg Morphis gmorp...@gmail.com wrote:
But under Network proxy.cfc shows
Method: GET
Status: (canceled)
Type: Pending
at 12:36 PM, Greg Morphis gmorp...@gmail.com wrote:
What's weird is if I click on the RequestURL
http://localhost:81/resources/proxy.cfc?method=getAllConferencePresentationsreturnFormat=jsonargumentCollection=%7B%22tag_id%22%3A0%2C%22year%22%3A2012%7D_cf_nodebug=true_cf_nocache
I've tried returntype of query, string, and even taking that attribute off
cffunction name=getAllConferencePresentations access=remote
output=false returntype=query returnformat=json
still not returning it to back to demo.cfm
On Wed, Sep 12, 2012 at 1:01 PM, Greg Morphis gmorp...@gmail.com
Camden raymondcam...@gmail.comwrote:
Can you post your entire CFM again? Please use something like pastebin
or gist.github.com so it is in the clear.
On Wed, Sep 12, 2012 at 1:04 PM, Greg Morphis gmorp...@gmail.com wrote:
I've tried returntype of query, string, and even taking that attribute
- can you put this online? It may be a lot
quicker.
On Wed, Sep 12, 2012 at 1:45 PM, Greg Morphis gmorp...@gmail.com wrote:
Sure thing Ray, thanks so much for helping.
http://pastebin.com/2M04ZFaQ
And I'm not sure if this tells you anything, Firebug gives this error:
TypeError
to expand it. Do that - let us know what
you see.
On Wed, Sep 12, 2012 at 2:02 PM, Greg Morphis gmorp...@gmail.com wrote:
I updated the pastebin to include my cfc file too.
In the console I get:
Arguments[2]
demo.cfm:44 http://localhost:81/resources/demo.cfm
why dont you
it from acting like a submit button and refreshing the page.
when i did this in chrome dev tools, i could see the return from
proxy.cfc and the arguments dump.
Azadi
On Thu, Sep 13, 2012 at 4:18 AM, Greg Morphis gmorp...@gmail.com wrote:
Nothing, I clicked the triangle and there's a blank
I moved the cfparams to the top of the page and the characters
stopped displaying
On Wed, Jun 6, 2012 at 1:53 PM, Greg Morphis gmorp...@gmail.com wrote:
What's wrong with this code? It produces this output.. before
cfparams  after params
          cfswitch expression
Doh, I spoke too soon.. it's showing up at the top of the page.. what in the..?
By the way, this is ColdFusion 9.
Thanks!
On Wed, Jun 6, 2012 at 2:27 PM, Greg Morphis gmorp...@gmail.com wrote:
I moved the cfparams to the top of the page and the characters
stopped displaying
On Wed, Jun 6
For the people who have turned their full fledged website into a
mobile ready site.. where do you start?
We have a CF9 website with flash, jquery, and other javascript, some
parts are kinda ugly.. Where do you begin? A whole rewrite?
Can you make a separate site and when a mobile device hits your
We'll probably have to have a separate site because there's just too
much to hide. I appreciate the links and comments Che and Paul!
On Tue, Jul 24, 2012 at 9:52 AM, Paul Vernon
paul.ver...@web-architect.co.uk wrote:
What's the best way to handle making a website mobile friendly?
Well that's
I'm working on a registration system and I'm trying to add the ability to
add perks and discounts based on registration type.
For example, if you register as a bronze sponsor you get a free guest, but
if you sponsor and exhibit you get the free guest plus a discount off the
exhibit fee based on
be in multiple groups, thus the lookup table
On Tue, May 15, 2012 at 2:49 PM, Greg Morphis gmorp...@gmail.com wrote:
I'm working on a registration system and I'm trying to add the ability to
add perks and discounts based on registration type.
For example, if you register as a bronze sponsor you
9:49 AM, Greg Morphis wrote:
I'm working on a registration system and I'm trying to add the ability to
add perks and discounts based on registration type.
For example, if you register as a bronze sponsor you get a free guest,
but
if you sponsor and exhibit you get the free guest plus
Stewart webmas...@sstwebworks.comwrote:
can you set up exhibitor in the sponsor table and link it to it's
acompanying perks?
think of the sponsor table as a level table instead of a sponsor table
On 5/15/2012 10:28 AM, Greg Morphis wrote:
Right there could be multiple sponsor levels per
It's a registrant type too, and the registrant type will get a different
perk than IF it's added to a sponsor level.
Exhibitor may get free access to the bonus event where as Sponsor +
Exhibitor would get whatever perk is associated with that sponsor level +
usually a discount on the exhibitor
:
On Tue, May 15, 2012 at 9:49 AM, Greg Morphis gmorp...@gmail.com wrote:
But how would I add if and only if they're an exhibitor then take, say
300, off the total?
Coupon codes.
-Cameron
--
Cameron Childress
--
p: 678.637.5072
im: cameroncf
facebook http://www.facebook.com
second the mod operator, was going to suggest the same thing:
794622: 254
794623: 255
794624: 0
794625: 1
794626: 2
794627: 3
On Mon, May 14, 2012 at 3:15 PM, Dean Lawrence dean...@gmail.com wrote:
You would use the MOD Operator.
#794625 MOD 256# will return 1, #794626 MOD 256# will return
you should be able to use
form[veteran#v#]
to get the value
On Mon, Apr 30, 2012 at 9:44 AM, Steve LaBadie slaba...@po-box.esu.eduwrote:
I have a form with the results being emailed to the owner of the form. I
have several groups of radio buttons and checkboxes. I am using the
following to
Why not use cfparams on the action page and default the values? You can
even default their value to and then if it equals that inform the user
they need to go back and choose one. Or in your form on either the Yes or
No, use checked=checked to default one or the other to being checked.
On
are on and the same?
Steve LaBadie, Web Manager
East Stroudsburg University
570-422-3999
http://www.esu.edu
slaba...@esu.edu
-Original Message-
From: Greg Morphis [mailto:gmorp...@gmail.com]
Sent: Monday, April 30, 2012 12:12 PM
To: cf-talk
Subject: Re: isDefined inside a cfloop
Why
Not sure if SQL Server has it, but Oracle has a START WITH CONNECT BY
clause that I've used to display a menu. The table had a parentID and
a childID, childern could be parents of other chlidren, for as far as
you wanted to go.
It looks like you'd have to go the recursive way (from the 2 minutes
Kinda off topic for this list, don't you think?
On Mar 11, 2012 8:08 PM, Brian Thornton br...@cfdeveloper.com wrote:
Have you guys seen this video...
-- Forwarded message --
From: Fred Day fs...@msn.com
Date: Mar 11, 2012 9:06 PM
Subject: kony2012
To: Brian Thornton
OK, go back to spamming the cf-jobs list ;)
On Mar 11, 2012 8:43 PM, Brian Thornton br...@cfdeveloper.com wrote:
No... I think it should be on jerrys prediction list...
On Mar 11, 2012 9:23 PM, Greg Morphis gmorp...@gmail.com wrote:
Kinda off topic for this list, don't you think
What am I missing? Need an extra set of eyes.. I've created hundreds
of CFCs.. not sure what I'm missing here..
cfset foo = createobject(component,
com.foosite.sponsorLevel.sponsorLevelDAO).init(DSN =
application.DSN) /
I get The value returned from the init function is not of type
the beans are all showing up without the extra foosite at the
beginning but the DAOs and Gateways are all showing up with it.. so
there's something else going on here
On Fri, Mar 9, 2012 at 1:20 PM, Greg Morphis gmorp...@gmail.com wrote:
What am I missing? Need an extra set of eyes.. I've
Weird. I restarted CF and it's working now. 0_o
On Fri, Mar 9, 2012 at 1:26 PM, Greg Morphis gmorp...@gmail.com wrote:
the beans are all showing up without the extra foosite at the
beginning but the DAOs and Gateways are all showing up with it.. so
there's something else going on here
I have CF 9 developer version running on IIS 7, my server is http://localhost:81
I look in the cfadmin and the debugging options are selected, I check
Application.cfc and I've got
cfsetting
requesttimeout=200
showdebugoutput=true
the IP restrictions and see if that helps.
Also are u sure you don;t have another cfsetting further down your
code disabling the debugging again ?
On Wed, Dec 7, 2011 at 6:53 PM, Greg Morphis gmorp...@gmail.com wrote:
I have CF 9 developer version running on IIS 7, my server is
http
REMOTE_ADDR=::1REMOTE_HOST=::1
right
On Wed, Dec 7, 2011 at 3:36 PM, Carl Von Stetten
vonner.li...@vonner.net wrote:
That looks like a IPv6 address, rather than the #.#.#.# IPv4 addresses.
On 12/7/2011 12:03 PM, Greg Morphis wrote:
Hey Russ, thanks for the tip, removing the IP addresses
I just did a fresh install fall cleaning.. of my PC..
I installed IIS and ColdFusion.. however I think I installed the 32
bit version of CF as oppose to the 64 bit (I had the exe saved in my
backup)
Anyways I have that all sorted out.. if I hit http://localhost/index.cfm
I get a CF error file not
.
On Tue, Nov 29, 2011 at 11:19 AM, Greg Morphis gmorp...@gmail.com wrote:
I just did a fresh install fall cleaning.. of my PC..
I installed IIS and ColdFusion.. however I think I installed the 32
bit version of CF as oppose to the 64 bit (I had the exe saved in my
backup)
Anyways I have that all
, Nov 29, 2011 at 11:32 AM, Greg Morphis gmorp...@gmail.com wrote:
When I installed it I told it to use IIS but I do have IIS 6
compatibility installed.
I may uninstall CF 9 and reinstall it making sure I use the 64 bit version.
Any other things I can look for?
On Tue, Nov 29, 2011 at 10:25 AM
not need to use a different port for each site, you just need
to make sure each site has a different host header.
On Tue, Nov 29, 2011 at 4:40 PM, Greg Morphis gmorp...@gmail.com wrote:
I have the site bound to port 81..
And I get an IIS error message when I hit
http://localhost:81/
but I
So I should be able to add a site, All Unassigned IPs, port 81..
DefaultAppPool and be able to access it by
http://localhost:81/
Right?
Thanks!
On Tue, Nov 29, 2011 at 10:53 AM, Casey Dougall
ca...@uberwebsitesolutions.com wrote:
On Tue, Nov 29, 2011 at 11:50 AM, Greg Morphis gmorp
, but you can use whatever you like
e.g.
127.0.0.1 dev.mydomain1.com
127.0.0.1 dev.mydomain2.com
then set the same host header in IIS for the site
russ
On Tue, Nov 29, 2011 at 4:53 PM, Casey Dougall
ca...@uberwebsitesolutions.com wrote:
On Tue, Nov 29, 2011 at 11:50 AM, Greg Morphis
Leigh, you were right! That's what it was but the problem only reared it's
ugly head with Access with Unicode..
Since I can't reinstall CF on our prod box your solution saved me from
having to replicate the DB in Oracle and then alter the queries to match.
This app may not even be used much more
I was tasked in moving an old app on a CF8 server to a CF7 server. The app
has some cfajax code that I'm not familiar with. I'm hoping someone here
has seen the error..
This is most of an email I sent internally to the person who created in a
few years back but thought I'd also ask a larger crowd
Hmm the only error Firebug shows is the same oForm.auto_approve is
indefined..
it shows a POST to the ajaxfunctions.cfc and it's OK
I looked at the response and I see what looks like what you'd see with CF
debugging turned on, I see the query buried in the response and that looks
okay.. Maybe I'm
That would explain why it worked in Prod and gave a different error too..
holy crap, it's making sense..
Now, is there a way to turn off debugging for ajax response but leaving it
on for other things?
On Fri, Nov 11, 2011 at 10:12 AM, Dave Watts dwa...@figleaf.com wrote:
I looked at the
Ahh... I thought there might be some setting in the cfadmin to change that..
Cool, now I'm getting the same error as on production.. now to start
looking through logs.. thanks!
On Fri, Nov 11, 2011 at 10:27 AM, Dave Watts dwa...@figleaf.com wrote:
Now, is there a way to turn off debugging
I did that, and even have the reverse on the pages where I want to see the
debugging..
but all I get is Syntax error in INSERT INTO statement..
I hate Access!
On Fri, Nov 11, 2011 at 10:41 AM, Russ Michaels r...@michaels.me.uk wrote:
put a cfsetting tag at the top of your ajax pages to
for the variables to make sure they are
all what your are expecting?
I find I have to use multiple techniques to debug apps before
tracking down a problem.
hth,
Rick
-Original Message-
From: Greg Morphis [mailto:gmorp...@gmail.com]
Sent: Friday, November 11, 2011 11:01 AM
And time_taken looks like this
time_off_id Text
employee_id Text
date_takenDate/Time
notes Text
approvedon Date/Time
approvedby Text
actionuserText
actiondate Date/Time
year Number
On Fri, Nov 11, 2011 at 11:52 AM, Greg Morphis gmorp...@gmail.com wrote:
I'm good.. I just
No, date_taken is 11/11/2011
I'll try the createodbcdateformat()..
I've never had to use that with Oracle so it's something else to try
On Fri, Nov 11, 2011 at 12:11 PM, Dave Watts dwa...@figleaf.com wrote:
INSERT INTO time_taken ( time_off_id, employee_id, date_taken, notes,
actionuser,
--
SQLINSERT INTO time_taken ( time_off_id, employee_id, date_taken,
notes, actionuser, actiondate, year ) VALUES ( 'VV', 'e0012345', {d
'2011-11-11'}, '', 'e0012345', {d '2011-11-11'}, 2011 ) DATASOURCE
blurred_text
On Fri, Nov 11, 2011 at 12:13 PM, Greg Morphis gmorp...@gmail.com
So apparently the problem is within the Microsoft Access with Unicode
driver..
However we don't have the ODBC service installed on production.
I googled manually installing it and it mentioned some SequeLink folder in
the db directory..
There's no DB folder or a SequeLink folder..
How can I
I'm trying to follow this page:
http://kb2.adobe.com/cps/191/tn_19135.html
However the directory doesn't exist on our production server..
I copied it from our dev directory to prod..
The page mentions running a CF template:
!--- set this to the location of your cfusion directory ---
cfset
it installed but installed incorrectly..
The bin folder is in slserver54 but the service points to slserver52..
I modified the registry to point to slserver54 but get an error when trying
to launch the service..
something like 'could not start the service, no error was returned, if you
continue
Screw Access.. I'm creating the tables in Oracle and exporting the data..
I'll deal with fixing the queries..
Thanks for all of your help guys!
On Fri, Nov 11, 2011 at 2:42 PM, Greg Morphis gmorp...@gmail.com wrote:
it installed but installed incorrectly..
The bin folder is in slserver54
Yeah, see my other post.. I can't get a simple insert to work from CF
On Fri, Nov 11, 2011 at 4:00 PM, Leigh cfsearch...@yahoo.com wrote:
Not to discourage you from switching, but was there a reason you could not
just use the access unicode driver?
-Leig
I've got an old app that has to move servers and I successfully have
it running on our dev server.
However I can't get the DSN created on our prod server (which should
be the same as dev).
When I try to create it, I get:
Connection verification failed for data source: twst_prod
rereplace(string, [^a-zA-Z0-9-_], , all)
On Fri, Nov 4, 2011 at 9:30 AM, Dennis Belmont
membersh...@dennisbelmont.com wrote:
I'd like to create a function that reviews a string and replaces all
characters that aren't alphanumeric, or a dash or underscore. These will
generally be short
I should have read the rest of your question..
I think you'll have to do it multiple times since it's not a blanket
replace.. but maybe someone else has another idea
On Fri, Nov 4, 2011 at 9:34 AM, Greg Morphis gmorp...@gmail.com wrote:
rereplace(string, [^a-zA-Z0-9-_], , all)
On Fri, Nov 4
due to the lock file, I would
just upsize it to SQL Server if I were and be done with it.
Remember that MSSQL Express is also FREE, so it doesn't need to cost
your client anything,
On Fri, Nov 4, 2011 at 2:32 PM, Greg Morphis gmorp...@gmail.com wrote:
I've got an old app that has to move
Where is this driver at? I just searched the C, D and E drives and
came up empty handed.
On Fri, Nov 4, 2011 at 11:19 AM, Russ Michaels r...@michaels.me.uk wrote:
yes that's the one and yes cf will need to be restarted
On Fri, Nov 4, 2011 at 4:14 PM, Greg Morphis gmorp...@gmail.com wrote
4, 2011 at 4:32 PM, Greg Morphis gmorp...@gmail.com wrote:
Where is this driver at? I just searched the C, D and E drives and
came up empty handed.
On Fri, Nov 4, 2011 at 11:19 AM, Russ Michaels r...@michaels.me.uk wrote:
yes that's the one and yes cf will need to be restarted
On Fri, Nov
is the file you want
On Fri, Nov 4, 2011 at 4:32 PM, Greg Morphis gmorp...@gmail.com wrote:
Where is this driver at? I just searched the C, D and E drives and
came up empty handed.
On Fri, Nov 4, 2011 at 11:19 AM, Russ Michaels r...@michaels.me.uk wrote:
yes that's the one and yes cf will need
this morning I refreshed my local dev and although I haven't have problems
in months.. this morning I get
Element USER is undefined in a Java object of type class
[Ljava.lang.String;.
The line ColdFusion points to is:
cfif session.user.getid() neq 0 and session.user.getsec_id() neq 0
In the
, restarted the service and I'm golden..
On Wed, Nov 2, 2011 at 8:36 AM, Greg Morphis gmorp...@gmail.com wrote:
this morning I refreshed my local dev and although I haven't have problems
in months.. this morning I get
Element USER is undefined in a Java object of type class
What Wysiwyg editor do you guys recommend? We're using the built in
fckEditor and people are complaining about pop up warnings from copying and
pasting from Word. I believe they are browser security issues but I'm trying
to investigate other options
1 - 100 of 701 matches
Mail list logo
