Re: invalid parameter binding?

2013-01-25 Thread Greg Morphis
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 wrote: > > > Specifically it doesn't like this: > > case when > > (acp.date_

Re: invalid parameter binding?

2013-01-25 Thread Greg Morphis
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 wrote: > I removed this section of the q

Re: invalid parameter binding?

2013-01-25 Thread Greg Morphis
i, Jan 25, 2013 at 1:28 PM, Greg Morphis wrote: > So, just this: > and c.id = > > ? > > still get [Macromedia][SQLServer JDBC Driver]Invalid parameter binding(s). > > > On Fri, Jan 25, 2013 at 1:20 PM, Dave Watts wrote: > >> >> > This is w

Re: invalid parameter binding?

2013-01-25 Thread Greg Morphis
So, just this: and c.id = ? still get [Macromedia][SQLServer JDBC Driver]Invalid parameter binding(s). On Fri, Jan 25, 2013 at 1:20 PM, Dave Watts wrote: > > > This is what the URL looks like > > > /admin/conference/index.cfm?action=view_attendees&conf_id=6f1e0d6d-c35e-4ea2-9e24-39e0e02d442

Re: invalid parameter binding?

2013-01-25 Thread Greg Morphis
This is what the URL looks like /admin/conference/index.cfm?action=view_attendees&conf_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. and c.id = -- the above gets

Re: invalid parameter binding?

2013-01-25 Thread Greg Morphis
MainGateway.cfc: line 546 * 544 : and c.id = 545 : *546 :* 547 : and ac.is_complete = 1 548 : On Fri, Jan 25, 2013 at 12:47 PM, Greg Morphis wrote: > Also, using this works..

Re: invalid parameter binding?

2013-01-25 Thread Greg Morphis
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 wrote: > Thanks Dave! I've used varchar before and it was working earlier. I had to > change the qu

Re: invalid parameter binding?

2013-01-25 Thread Greg Morphis
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 Ex

invalid parameter binding?

2013-01-25 Thread Greg Morphis
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 ~

Re: sql injection attempt

2013-01-23 Thread Greg Morphis
It was attempted via the URL On Wed, Jan 23, 2013 at 11:57 AM, Rob Voyle 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,

Re: sql injection attempt

2013-01-22 Thread Greg Morphis
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 wrote: > > That's hex for, "?WAITFOR DELAY '00:00:15'" > > On Tue, Jan 22,

sql injection attempt

2013-01-22 Thread Greg Morphis
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 Cold

Re: Tracking Link Click

2013-01-08 Thread Greg Morphis
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 wrote: > > Hello all, > I have a site where once a user registers they are taken to a page with > three links

Re: list of countries and territories

2012-12-03 Thread Greg Morphis
That is awesome.. thanks Russ! On Mon, Dec 3, 2012 at 1:03 PM, Russ Michaels wrote: > > http://countrylist.net/ > > > On Mon, Dec 3, 2012 at 6:43 PM, Greg Morphis wrote: > > > > > Does anyone have or know of a good list of delimited countries and > > terr

list of countries and territories

2012-12-03 Thread Greg Morphis
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! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/

Re: list delimiters question

2012-11-15 Thread Greg Morphis
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 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 > list, whic

Re: list delimiters question

2012-11-15 Thread Greg Morphis
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 wrote: > > not sure what the listgetat 2 is doing? > > > ~| Order the Adobe Coldfusion Anthology now!

Re: list delimiters question

2012-11-15 Thread Greg Morphis
no need to convert it to a array (I was trying to go that route but keeping it a list works fine too) On Thu, Nov 15, 2012 at 8:40 AM, Greg Morphis wrote: > I'm sure there are several ways to do this > http://somesite.com/some_display.cfm?some_id=4184&chapter_id=1

Re: list delimiters question

2012-11-15 Thread Greg Morphis
I'm sure there are several ways to do this http://somesite.com/some_display.cfm?some_id=4184&chapter_id=12120&passage_id=40099 "/> On Thu, Nov 15, 2012 at 8:28 AM, morchella wrote: > > hey guys! > i could use a liitle help. i am trying to get a specific value. in this > example "ch

Re: query: how to return records that are increments of one year old?

2012-11-14 Thread Greg Morphis
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 wrote: > > > cast(dateadd('y', -1, getdate()) as date) as -- getdate() in MSSQL > > I do not think 2005 supports the "date"

Re: query: how to return records that are increments of one year old?

2012-11-14 Thread Greg Morphis
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 wrote: > cast(dateadd('y',

Re: query: how to return records that are increments of one year old?

2012-11-14 Thread Greg Morphis
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 wrote: > What DB are you using? > > > On Wed, Nov 14, 2012 at 7:43 AM, Eric Bourland

Re: query: how to return records that are increments of one year old?

2012-11-14 Thread Greg Morphis
What DB are you using? On Wed, Nov 14, 2012 at 7:43 AM, Eric Bourland 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 are one year

Re: Rounding, why?

2012-11-12 Thread Greg Morphis
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 wrote: > Something is baffling me.. I'm inserting a value into the database and > it

Re: Rounding, why?

2012-11-12 Thread Greg Morphis
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

Re: Rounding, why?

2012-11-12 Thread Greg Morphis
removing the cfqueryparam , works.. just having #arguments.payment.getamount_paid()# causes it to work fine.. 35.52 is saved as 35.52 in the database. Any ideas as to why this happens? I'm using CF9.0.1 On Mon, Nov 12, 2012 at 11:11 AM, Greg Morphis wrote: > I tried decimal(19,2) and

Rounding, why?

2012-11-12 Thread Greg Morphis
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

Re: SOT: returning data from ajax and displaying it..

2012-09-14 Thread Greg Morphis
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 wrote: > I've got this code: > myspan.innerHTML += '' > for(i=0; imyspan.innerHTML += >

SOT: returning data from ajax and displaying it..

2012-09-14 Thread Greg Morphis
I've got this code: myspan.innerHTML += '' for(i=0; i' + presentation.DATA[i][presentation.COLUMNS.findIdx('TITLE')] + '  (' + presentation.DATA[i][presentation.COLUMNS.findIdx('AUTHOR')] + ')  ' + presentation.DATA[i][presentation.COLUMNS.findIdx('DATE')] + "" } myspan.innerHTML +

Re: cfajaxproxy... not defined return variable.

2012-09-12 Thread Greg Morphis
to > prevent 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 wrote: > > > > Nothing,

Re: cfajaxproxy... not defined return variable.

2012-09-12 Thread Greg Morphis
ck to expand it. Do that - let us know what > you see. > > > On Wed, Sep 12, 2012 at 2:02 PM, Greg Morphis wrote: > > > > I updated the pastebin to include my cfc file too. > > > > In the console I get: > > Arguments[2] > > > > > > demo.

Re: cfajaxproxy... not defined return variable.

2012-09-12 Thread Greg Morphis
reaking work"); > > does it work correctly? Also - can you put this online? It may be a lot > quicker. > > On Wed, Sep 12, 2012 at 1:45 PM, Greg Morphis wrote: > > > > Sure thing Ray, thanks so much for helping. > > > > http://pastebin.com/2M04ZFa

Re: cfajaxproxy... not defined return variable.

2012-09-12 Thread Greg Morphis
ymond Camden wrote: > > 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 wrote: > > > > I've tried returntype of query, string, and even ta

Re: cfajaxproxy... not defined return variable.

2012-09-12 Thread Greg Morphis
I've tried returntype of query, string, and even taking that attribute off still not returning it to back to demo.cfm On Wed, Sep 12, 2012 at 1:01 PM, Greg Morphis wrote: > I noticed that earlier and changed it. It still highlights the > var pId = presentation.DATA[0][0]; >

Re: cfajaxproxy... not defined return variable.

2012-09-12 Thread Greg Morphis
ribute returnformat="json" so you function declaration > should look like: > > output="false" returntype="any" returnformat="json"> > > I have not tested this so it may not fix your problem, but I believe json > isn't a valid returnt

Re: cfajaxproxy... not defined return variable.

2012-09-12 Thread Greg Morphis
ction (presentation) 1. arguments: Arguments[2] 1. 0: null 2. 1: undefined On Wed, Sep 12, 2012 at 12:39 PM, Greg Morphis wrote: > But under Network proxy.cfc shows > Method: GET > Status: (canceled) > Type: Pe

Re: cfajaxproxy... not defined return variable.

2012-09-12 Thread Greg Morphis
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 wrote: > What's weird is if I click on the RequestURL > > > http://localhost:81/resources

Re: cfajaxproxy... not defined return variable.

2012-09-12 Thread Greg Morphis
you will need to consult your logs as to why > proxy.cfc is failing. > > -- > Regards, > Andrew Scott > WebSite: http://www.andyscott.id.au/ > Google+: http://plus.google.com/113032480415921517411< > http://plus.google.com/108193156965451149543> > > > > &g

Re: cfajaxproxy... not defined return variable.

2012-09-12 Thread Greg Morphis
XPROXY'); /* ]]> */ /* <![CDATA[ */ var _cf_proxy=ColdFusion.AjaxProxy.init('/resources/proxy.cfc','proxy'); _cf_proxy.prototype.getAllConferencePresentations=function(tag_id,year) { return ColdFusion.AjaxProxy.invoke(this, "getAllConferencePresentations", { tag_id:tag_id,year:year});}; /* ]]> */

Re: cfajaxproxy... not defined return variable.

2012-09-12 Thread Greg Morphis
u/ > Google+: http://plus.google.com/113032480415921517411< > http://plus.google.com/108193156965451149543> > > > > On Thu, Sep 13, 2012 at 3:04 AM, Greg Morphis wrote: > > > > > This is what's in the proxy.cfc in the network tab.. > > > > > >1. Reque

Re: cfajaxproxy... not defined return variable.

2012-09-12 Thread Greg Morphis
-- > 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:54 AM, Greg Morphis wrote: > > > > > I use both Chrome an

Re: cfajaxproxy... not defined return variable.

2012-09-12 Thread Greg Morphis
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 wrote: > > I haven't used firebug in a long time, as I use Chrome now. But from memory > you should be a

Re: cfajaxproxy... not defined return variable.

2012-09-12 Thread Greg Morphis
imple, my $1 is on the fact that there is nothing being returned from > ColdFusion. > > -- > Regards, > Andrew Scott > WebSite: http://www.andyscott.id.au/ > Google+: http://plus.google.com/113032480415921517411< > http://plus.google.com/108193156965451149543> > > > O

Re: cfajaxproxy... not defined return variable.

2012-09-12 Thread Greg Morphis
> line throwing the error) and sharing what is dumped? > > On Wed, Sep 12, 2012 at 10:53 AM, Greg Morphis wrote: > > > > Thanks Ray for the response, > > I get this in the console when putting a breakpoint on the var pId = ... > > > > _cf_clientid186CD443C74F66

Re: cfajaxproxy... not defined return variable.

2012-09-12 Thread Greg Morphis
gt; > console.dir(arguments) to see what is being passed to the callback. > > > On Wed, Sep 12, 2012 at 10:23 AM, Greg Morphis wrote: > > > > I'm playing around with the cfajaxproxy example on adobe livedocs and > > everything looks right, I get > > "Ti

cfajaxproxy... not defined return variable.

2012-09-12 Thread Greg Morphis
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.. // Use an asynchronous cal

Re: Strange characters displaying..

2012-08-08 Thread Greg Morphis
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 wrote: > I moved the stopped displaying > > On Wed, Jun 6, 2012 at 1:53 PM, Greg Morphis wrote: >> Wh

Re: Strange characters displaying..

2012-08-08 Thread Greg Morphis
I moved the wrote: > What's wrong with this code? It produces this output.. "before > cfparams  after params" > >                    >                          >                              before cfparams >                             

Re: Making a website mobile friendly

2012-07-24 Thread Greg Morphis
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 wrote: > >> What's the best way to handle making a website mobile friendly? > > Well that's a loaded question and the

Making a website mobile friendly

2012-07-24 Thread Greg Morphis
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 you

Re: handling perks or discounts

2012-05-15 Thread Greg Morphis
On Tue, May 15, 2012 at 9:49 AM, Greg Morphis 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

Re: handling perks or discounts

2012-05-15 Thread Greg Morphis
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 fee

Re: handling perks or discounts

2012-05-15 Thread Greg Morphis
9:33 AM, Scott Stewart wrote: > > 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 co

Re: handling perks or discounts

2012-05-15 Thread Greg Morphis
of joins > > On 5/15/2012 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

Re: handling perks or discounts

2012-05-15 Thread Greg Morphis
erk_groups_lookup > perkID > groupID > > a perk can of course be in multiple groups, thus the lookup table > > > > On Tue, May 15, 2012 at 2:49 PM, Greg Morphis wrote: > > > > > I'm working on a registration system and I'm trying to add the ability to

handling perks or discounts

2012-05-15 Thread Greg Morphis
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 th

Re: High school algebra problem

2012-05-14 Thread Greg Morphis
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 wrote: > > You would use the MOD Operator. > > #794625 MOD 256# will return 1, #794626 MOD 256# will return 2, etc. > Tha

Re: isDefined inside a cfloop

2012-04-30 Thread Greg Morphis
es it matter that form and the action page 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] > S

Re: isDefined inside a cfloop

2012-04-30 Thread Greg Morphis
Why not use 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 Mon, Apr

Re: isDefined inside a cfloop

2012-04-30 Thread Greg Morphis
you should be able to use form["veteran#v#"] to get the value On Mon, Apr 30, 2012 at 9:44 AM, Steve LaBadie wrote: > > 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 check for the emp

Re: Display a list of Parent and Child pages by Sort Order, with children arranged under their respective parents

2012-03-24 Thread Greg Morphis
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 o

Re: Fwd: kony2012

2012-03-11 Thread Greg Morphis
OK, go back to spamming the cf-jobs list ;) On Mar 11, 2012 8:43 PM, "Brian Thornton" wrote: > > No... I think it should be on jerrys prediction list... > On Mar 11, 2012 9:23 PM, "Greg Morphis" wrote: > > > > > Kinda off topic for this list,

Re: Fwd: kony2012

2012-03-11 Thread Greg Morphis
Kinda off topic for this list, don't you think? On Mar 11, 2012 8:08 PM, "Brian Thornton" wrote: > > Have you guys seen this video... > -- Forwarded message -- > From: "Fred Day" > Date: Mar 11, 2012 9:06 PM > Subject: kony2012 > To: "Brian Thornton" > > http://www.youtube.com

Re: The value returned from the init function is not of type

2012-03-09 Thread Greg Morphis
Weird. I restarted CF and it's working now. 0_o On Fri, Mar 9, 2012 at 1:26 PM, Greg Morphis 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 her

Re: The value returned from the init function is not of type

2012-03-09 Thread Greg Morphis
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 wrote: > What am I missing? Need an extra set of eyes.. I've created

The value returned from the init function is not of type

2012-03-09 Thread Greg Morphis
What am I missing? Need an extra set of eyes.. I've created hundreds of CFCs.. not sure what I'm missing here.. I get "The value returned from the init function is not of type com.foosite.sponsorLevel.sponsorLevelDAO." my be

Re: debugging doesn't display on local sevrver

2011-12-07 Thread Greg Morphis
REMOTE_ADDR=::1REMOTE_HOST=::1 right On Wed, Dec 7, 2011 at 3:36 PM, Carl Von Stetten 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 I

Re: debugging doesn't display on local sevrver

2011-12-07 Thread Greg Morphis
ry removing all 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 wrote: >> >> I have CF 9 developer version running on IIS

debugging doesn't display on local sevrver

2011-12-07 Thread Greg Morphis
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 And yet, there's no debugging at the bottom showing queries ran, structures, etc. Is it because I have it

Re: CF 9 with IIS 7

2011-11-29 Thread Greg Morphis
live domain for consistency, 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

Re: CF 9 with IIS 7

2011-11-29 Thread Greg Morphis
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 wrote: > > On Tue, Nov 29, 2011 at 11:50 AM, Greg Morphis wrote: > >> >> That

Re: CF 9 with IIS 7

2011-11-29 Thread Greg Morphis
do 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 wrote: >> >> I have the site bound to port 81.. >> And I get an IIS error message when I hit >&

Re: CF 9 with IIS 7

2011-11-29 Thread Greg Morphis
29, 2011 at 11:32 AM, Greg Morphis 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? >>

Re: CF 9 with IIS 7

2011-11-29 Thread Greg Morphis
nstall in IIS 7. > > > On Tue, Nov 29, 2011 at 11:19 AM, Greg Morphis 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 s

CF 9 with IIS 7

2011-11-29 Thread Greg Morphis
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

Re: cfajax error

2011-11-15 Thread 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 s

Re: Manual install ODBC services ColdFusion MX7

2011-11-11 Thread Greg Morphis
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 wrote: > > Not to discourage you from switching, but was there a reason you could not > just use the access unicode driver? > > > -Leig > >

Re: Manual install ODBC services ColdFusion MX7

2011-11-11 Thread Greg Morphis
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 wrote: > it installed but installed incorrectly.. > The bin folder is in slserver54

Re: Manual install ODBC services ColdFusion MX7

2011-11-11 Thread Greg Morphis
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 to

Manual install ODBC services ColdFusion MX7

2011-11-11 Thread Greg Morphis
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: Error Occurred: #cfcatch.message##cfcatch.detail# Is there

Re: cfajax error

2011-11-11 Thread Greg Morphis
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 downlo

Re: cfajax error

2011-11-11 Thread Greg Morphis
) 55 : -- 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 Fr

Re: cfajax error

2011-11-11 Thread Greg Morphis
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 wrote: > > > INSERT INTO time_taken ( time_off_id, employee_id, date_taken, notes, > > actionuser, actiondate, ye

Re: cfajax error

2011-11-11 Thread Greg Morphis
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 wrote: > I'm good.. I just n

Re: cfajax error

2011-11-11 Thread Greg Morphis
Faircloth > wrote: > > > > What about setting up some alerts with your AJAX variables > > or using console.log in firebug for the variables to make sure they are > > all what your are expecting? > > > > I find I have to use multiple techniques to debu

Re: cfajax error

2011-11-11 Thread Greg Morphis
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 wrote: > > put a cfsetting tag at the top of your ajax pages to override debug > out t

Re: cfajax error

2011-11-11 Thread Greg Morphis
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 wrote: > > > Now, is there a way to turn off debugging for ajax response

Re: cfajax error

2011-11-11 Thread Greg Morphis
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 wrote: > > > I looked at the response and I see w

Re: cfajax error

2011-11-11 Thread Greg Morphis
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

cfajax error

2011-11-11 Thread Greg Morphis
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

Re: Access with Unicode error

2011-11-04 Thread Greg Morphis
Low traffic and it wont be used for long, we have an Oracle database if I ever wanted to port it over. Thanks! On Fri, Nov 4, 2011 at 2:14 PM, Russ Michaels wrote: > > unless it is  very low traffic DB, i'd still upsize it to MSSQL > > On Fri, Nov 4, 2011 at 7:04 PM, Gr

Re: Access with Unicode error

2011-11-04 Thread Greg Morphis
ri, Nov 4, 2011 at 4:32 PM, Greg Morphis 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 wrote: >>> >>> yes that's the one and yes

Re: Access with Unicode error

2011-11-04 Thread Greg Morphis
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 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 wrote: >>

Re: Access with Unicode error

2011-11-04 Thread Greg Morphis
d then you cannot back it up 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 wrote: &

Re: Stripping out special characters...

2011-11-04 Thread Greg Morphis
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 wrote: > rereplace(string, "[^a-zA-Z0-9-_]", "", &q

Re: Stripping out special characters...

2011-11-04 Thread Greg Morphis
rereplace(string, "[^a-zA-Z0-9-_]", "", "all") On Fri, Nov 4, 2011 at 9:30 AM, Dennis Belmont 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 strings, and the functio

Access with Unicode error

2011-11-04 Thread Greg Morphis
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 com.inzoom.adojni.C

Re: element undefined in String

2011-11-02 Thread Greg Morphis
disregard.. I put in a default session.user variable on the page indicated in the error and it pointed me to an error in a CFC I had overlooked late yesterday.. I had typed wrote: > this morning I refreshed my local dev and although I haven't have problems > in months.. this morning I get > > El

element undefined in String

2011-11-02 Thread Greg Morphis
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: In the Application.cfc OnSessionStart I have: This has worked for a long

Re: Wysiwyg editor

2011-10-24 Thread Greg Morphis
That's exactly what I thought. In fact I found a solution how to get rid of the error message. I appreciate the reply! On Oct 24, 2011 5:41 PM, "Russ Michaels" wrote: > > the copy and paste is a firefox security setting, they are going to > get it with any WYSIWYG editor.The message actually tel

  1   2   3   4   5   6   7   8   >