Re: SOT: external css not displaying

2010-04-06 Thread Greg Morphis
eferring to the printouts you get or what you see on the computer screen? Updating SSL certs is unlikely to be related to whatever CSS problems you are encountering. -Mike Chabot On Tue, Apr 6, 2010 at 12:41 PM, Greg Morphis wrote: > >

SOT: external css not displaying

2010-04-06 Thread Greg Morphis
We just renewed the IIS certs on our servers yesterday and today an app that uses external CSS is not formatting. It's almost as if the CSS file isn't found though it's in the same directory as the files. Everything works locally and our staging server. The CSS file is being called: any ideas wh

Re: Validating that only .5 decimal gets through?

2010-02-19 Thread Greg Morphis
That works unless you try something like 2.05 isValid : #isValid# isValid : YES but should fail On Sat, Feb 20, 2010 at 1:28 AM, Kevan Stannard wrote: > > This might do: > > > > > On 20 February 2010 17:41, Marie Taylore wrote: > >> >> I have an app that I need to validate that they enter

Re: Validating that only .5 decimal gets through?

2010-02-19 Thread Greg Morphis
I like Jerry's answer but this works too #i# works no workie so basically you're subtracting the integer value from the value and if the remainder equals 0 or .5 then it succeeds.. if not then fails On Sat, Feb 20, 2010 at 12:46 AM, Jerry Johnson wrote: > > multiple by 2, and check i

Re: getting min value based on inputs

2009-09-25 Thread Greg Morphis
They use it for 100+ line accounts. Umm yeah, not going to happen. Thank for your time though Brad, good solution for learning purposes. On Tue, Sep 8, 2009 at 10:51 AM, Greg Morphis wrote: > Thanks brad! We use Oracle but I should be able to adapt your solution to it. > I'd like

Re: getting min value based on inputs

2009-09-08 Thread Greg Morphis
> Original Message ---- >  Subject: Re: getting min value based on inputs >  From: Greg Morphis >  Date: Sun, September 06, 2009 10:20 am >  To: cf-talk > > >  The idea is that all lines add up to the total minutes entered in any >  possible way because in the

Re: getting min value based on inputs

2009-09-06 Thread Greg Morphis
The idea is that all lines add up to the total minutes entered in any possible way because in the end they'll share the minutes. 1 line at 10,000 minutes would fail because there are no plans of that size. Priority is on cost, not so much on minutes. For example if you entered 9100 minutes and 10

Re: getting min value based on inputs

2009-09-05 Thread Greg Morphis
-- > >  Subject: getting min value based on inputs >  From: Greg Morphis >  Date: Fri, September 04, 2009 2:37 pm >  To: cf-talk > > >  I was wondering if this is even possible. >  given a list of plans... > > > > ~

getting min value based on inputs

2009-09-04 Thread Greg Morphis
I was wondering if this is even possible. given a list of plans... CodePrice Minutes PLANA $25.00 0 PLANB $32.00 200 PLANC $42.00 500 PLAND $52.00 750 PLANE $63.00 900 PLANF $84.00 1,400 PLANG $105.00 2,100 PLANH $155.00 4,000 PLANI $210.00 6,0

Re: Getting a count from a group in cfquery

2009-05-05 Thread Greg Morphis
probably a couple ways to do this.. in Oracle I'd use the over partition by analytic function. SELECT COUNT(groupID) over (partition by groupID) as thisCOUNT, emailID, emailADDRESS, emailDATE, groupID FROM log_email WHERE emailID = ORDER BY emailDATE desc then you dont need the

Re: SQL server - Order totals by month, even without month data

2009-03-25 Thread Greg Morphis
Create a dummy table with the information for the current year and preform a UNION to your existing data On Wed, Mar 25, 2009 at 6:26 AM, Will Tomlinson wrote: > > I have your typical tblorders. I'm trying to query it to get order totals by > month, and I'm outputting them in > > All goes fine

Re: bean? anything wrong?

2009-03-16 Thread Greg Morphis
never mind, the other bean uses string for everything.. so my problem isnt in the bean On Mon, Mar 16, 2009 at 11:42 AM, Greg Morphis wrote: > Sorry for the long post but I've been working on this for a few days > and have got nowhere > I'm working with flex and cf and I hav

bean? anything wrong?

2009-03-16 Thread Greg Morphis
Sorry for the long post but I've been working on this for a few days and have got nowhere I'm working with flex and cf and I have a bean.. it looks okay but just testing it with an init() function is giving me an error The argument HEADLINE_ID passed to function init() is not of type numeric I'm

Re: Sort database records as a human not a computer.

2009-03-16 Thread Greg Morphis
Ian, you could do something like this... select * from footest order by (case when title like '"%' then substr(title, 2, length(title)) when title like 'a %' then substr(title, 3, length(title)) when title like 'an %' then substr(title, 4, length(title)) when title like 'the %' then substr(title,

Re: Flat File as a Database?

2009-01-26 Thread Greg Morphis
What about databases you dont have to install? Like sqlite? I don't think CF has the greatest compability with it (I think I ran into problems with using cfqueryparam and OOP) but it'd certainly be better than working with a freaking .txt file. Just my 2 pennies.. and yea, I'll take the change On

Re: need some database advice

2009-01-13 Thread Greg Morphis
I've heard that NOT EXISTS works better with a larger set of records.. If it's only a few I heard that NOT IN would be better to use. Of course this is just what I heard from our Oracle DBA a few years ago. So YMMV... best choice is to run a test.. load 50K rows and check. On Tue, Jan 13, 2009

Re: problem to diplay results horizontally

2008-12-22 Thread Greg Morphis
correction it's not default to block.. it's "list-item"... On Mon, Dec 22, 2008 at 12:05 PM, Greg Morphis wrote: > the element display property is defaulted to block, try setting > up some css, change the inline property of the element to > "inline". &g

Re: problem to diplay results horizontally

2008-12-22 Thread Greg Morphis
the element display property is defaulted to block, try setting up some css, change the inline property of the element to "inline". I'm no css guru but that might get your started On Mon, Dec 22, 2008 at 11:57 AM, alex poyaoan wrote: > hi everybody > > I have this code and it works fine except

Re: CFEclipse "intellisense" doesn't work

2008-10-26 Thread Greg Morphis
That was it, thanks! I wonder why that isnt enabled by default.. Anywho, thanks again! On Sun, Oct 26, 2008 at 6:14 PM, AJ Mercer <[EMAIL PROTECTED]> wrote: > Try right-click the project folder and select Add/Remove CFE Nature > > > On Mon, Oct 27, 2008 at 7:05 AM, Greg Morphis

CFEclipse "intellisense" doesn't work

2008-10-26 Thread Greg Morphis
I can't get the intellisense to work within cfeclipse.. I had eclipse3.2 installed, I dumped that and downloaded eclispe europa.. I downloaded and installed CFEclipse (1.3.2 beta) but when I type in a CF function, for example "http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www

Re: Inexpensive student/developer oriented CF hosting?

2008-10-13 Thread Greg Morphis
godaddy is pretty cheap for basic stuff.. not sure if they allow createobject() and what other tags are blacklisted there On Mon, Oct 13, 2008 at 8:02 AM, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > Yes, ,and that's what we're using at school. However, the server is inside > the firewall only,

Re: i'll pay through paypal anyone who can debug my code

2008-10-02 Thread Greg Morphis
Or you can just ask here for free and most of the users here will happily help you.. Let us know the problem you're getting (CF error with robust enabled). The code in question and the desired results.. On Thu, Oct 2, 2008 at 4:13 PM, Phillip Perry <[EMAIL PROTECTED]> wrote: > Hi, > > I have b

Re: Firefox redirects to machine's IP address?

2008-09-29 Thread Greg Morphis
alhost:8300/ URL? > > And what URL exactly is FireFox getting redirected to? > > -Ryan > > > Greg Morphis wrote: > > If it were a webserver redirect issue wouldnt it affect both IE and FF? > > I have Apache on here(Tomcat 5.5 for Flex) however with CF I instal

Re: Firefox redirects to machine's IP address?

2008-09-29 Thread Greg Morphis
I uninstalled FF3 and installed 2.0.0.17 and it's working now.. On 9/29/08, Greg Morphis <[EMAIL PROTECTED]> wrote: > If it were a webserver redirect issue wouldnt it affect both IE and FF? > I have Apache on here(Tomcat 5.5 for Flex) however with CF I installed > the Jrun

Re: Firefox redirects to machine's IP address?

2008-09-29 Thread Greg Morphis
If it were a webserver redirect issue wouldnt it affect both IE and FF? I have Apache on here(Tomcat 5.5 for Flex) however with CF I installed the Jrun option... On Mon, Sep 29, 2008 at 10:39 AM, Ryan Stille <[EMAIL PROTECTED]> wrote: > Greg Morphis wrote: >> If I type in http:/

Re: Firefox redirects to machine's IP address?

2008-09-29 Thread Greg Morphis
BTW I'm using Firefox 3.0.2 on Windows XP. I checked the hosts file, there's only 1 entry localhost 127.0.0.1 On Mon, Sep 29, 2008 at 10:16 AM, Greg Morphis <[EMAIL PROTECTED]> wrote: > If I type in http://localhost:8300/ into Firefox it goes to the > machine's IP

Firefox redirects to machine's IP address?

2008-09-29 Thread Greg Morphis
If I type in http://localhost:8300/ into Firefox it goes to the machine's IP address and I get a Network error.. In IE this works fine.. it takes me to my CF root directory.. What gives? ~| Adobe® ColdFusion® 8 software 8 is the m

Re: cf8 on linux

2008-09-27 Thread Greg Morphis
I moved the cfide directory under /Home/public_html and it works.. Thanks On Sat, Sep 27, 2008 at 3:05 AM, Greg Morphis <[EMAIL PROTECTED]> wrote: > I think I see what the problem is and what you're asking.. > I installed the cfamin to /var/www but I have apache2 pointing to &g

Re: cf8 on linux

2008-09-27 Thread Greg Morphis
I think I see what the problem is and what you're asking.. I installed the cfamin to /var/www but I have apache2 pointing to /Home/public_html/ Is there a way to change that or is a reinstall necessary? On Sat, Sep 27, 2008 at 2:48 AM, Greg Morphis <[EMAIL PROTECTED]> wrote: >

Re: cf8 on linux

2008-09-27 Thread Greg Morphis
/etc/apache2 On Sat, Sep 27, 2008 at 2:36 AM, Mark Mandel <[EMAIL PROTECTED]> wrote: > Where is the default directory pointed on your apache install? > > Mark > > On Sat, Sep 27, 2008 at 5:30 PM, Greg Morphis <[EMAIL PROTECTED]> wrote: >> trying to set up coldfusi

cf8 on linux

2008-09-27 Thread Greg Morphis
trying to set up coldfusion 8 on linux kubuntu and getting a 404 error.. I have apache2 installed and chose that as the webserver.. apache2 works.. I hit http://localhost/ and get the phpinfo() but adding /CFIDE/administrator I get a 404 error.. The requested URL /CFIDE/administrator/ was not found

Re: (ot) Best development laptop

2008-09-26 Thread Greg Morphis
I use a Dell D630 2Ghz intel core 2 duo processor, 2 GB of RAM for work. It could use another gig of RAM to make it sweeter but it's not bad at all. I run multiple instances of Toad, IE, Firefox, Eclipse, CF (development), at times add Dreamweaver to that list.. all with no problems. At home I have

Re: cf 7.0.2 freezes on install

2008-09-18 Thread Greg Morphis
Doh Running in Windows 2000 compatibility works too.. not sure why it doesnt work normally.. must be a problem with the image they use to set up the laptops... Anyways.. this is resolved.. thanks! On Thu, Sep 18, 2008 at 10:02 AM, Greg Morphis <[EMAIL PROTECTED]> wrote: > The silen

Re: cf 7.0.2 freezes on install

2008-09-18 Thread Greg Morphis
The silent install works, thanks Ryan! On Thu, Sep 18, 2008 at 9:08 AM, Greg Morphis <[EMAIL PROTECTED]> wrote: > I downloaded 3 versions.. one from Adobe, one from FigLeaf and one we > had that all the other developers use(on our dev server). I've > downloaded it on this

Re: cf 7.0.2 freezes on install

2008-09-18 Thread Greg Morphis
d it on my home PC or laptop and transfer it over. On Thu, Sep 18, 2008 at 8:58 AM, Azadi Saryev <[EMAIL PROTECTED]> wrote: > re-download cf mx 7 installer as Brad had suggested. the one you have is > probably corrupt. > > Azadi Saryev > Sabai-dee.com > http://www.sabai-d

Re: cf 7.0.2 freezes on install

2008-09-18 Thread Greg Morphis
g http://img140.imageshack.us/my.php?image=ss4ri9.jpg So what the hell? Any Adobe guys reading the forums that might have suggestions? CF 8 is installing fine but our dev and prod server is CF 7.0.2. I really need to get 7.0.2 installed. On Tue, Sep 16, 2008 at 7:51 AM, Greg Morphis <[EMAIL PROTECTED]>

Re: cf 7.0.2 freezes on install

2008-09-16 Thread Greg Morphis
l as making sure there are no anti-virus programs >> messing with you. >> >> ~Brad >> >> - Original Message - >> From: "Greg Morphis" <[EMAIL PROTECTED]> >> To: "CF-Tal

Re: cf 7.0.2 freezes on install

2008-09-15 Thread Greg Morphis
Status: SUCCESSFUL Additional Notes: NOTE - Required Disk Space: 435,411,528; Free Disk Space: 67,402,153,984 INSTALLATION WAS CANCELLED BY USER DURING PRE-INSTALLATION On 9/15/08, Greg Morphis <[EMAIL PROTECTED]> wrote: > I received a new laptop from work and

cf 7.0.2 freezes on install

2008-09-15 Thread Greg Morphis
I received a new laptop from work and am trying to set it up.. I downloaded cf 7.0.2 and clicked on install. I got through all of the options, chose multiserver, built in server and when I click "ok" to start installing it just freezes.. I can click Cancel but the window is not showing any progress

Re: kinda OT : sqlite "statement is not executing "

2008-09-02 Thread Greg Morphis
Tue, Sep 2, 2008 at 12:12 AM, denstar <[EMAIL PROTECTED]> wrote: > On Mon, Sep 1, 2008 at 8:39 AM, Greg Morphis wrote: >> Okay, odd even further... >> I remove the CFQueryparams and the row gets added, no error.. >> >> So why would cfqueryparam be causing a "stat

Re: kinda OT : sqlite "statement is not executing "

2008-09-01 Thread Greg Morphis
Can you put it into verbose > mode, if not? > :D > > -- > A cheerful frame of mind, reinforced by relaxation... is the medicine > that puts all ghosts of fear on the run. > George Matthew Adams > > > On Mon, Sep 1, 2008 at 12:01 AM, Greg Morphis wrote: >> I was actuall

Re: kinda OT : sqlite "statement is not executing "

2008-08-31 Thread Greg Morphis
> -- > Reason itself is fallible, and this fallibility must find a place in our > logic. > Nicola Abbagnano > > On Sun, Aug 31, 2008 at 10:43 PM, Greg Morphis wrote: >> I have CF 8 connecting to SQLite3 via the sqlitejdbc v053 driver. >> When I call the creat

kinda OT : sqlite "statement is not executing "

2008-08-31 Thread Greg Morphis
I have CF 8 connecting to SQLite3 via the sqlitejdbc v053 driver. When I call the create method of my CFC I get this error Error Executing Database Query. statement is not executing The error occurred in C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\testCF\cfc\myApp\appDAO.cfc: line 92 The st

Re: Here's an interesting little problem...

2008-08-26 Thread Greg Morphis
Yeah but you can do the same with a case statement... which was introduced in Oracle 9i.. Plus there's no reason to select it unless you intend on using it later. Just do select class from classes order by decode(lower(class),'aa',1,'a',2,...) just FYI On Tue, Aug 26, 2008 at 2:31 PM, Eric Rober

Re: Here's an interesting little problem...

2008-08-26 Thread Greg Morphis
Rick, did you want to see AA D C B A or D C B A AA ? On Tue, Aug 26, 2008 at 12:25 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > Sounds like a good idea to me. > > I'll give it a shot. > > Thanks, > > Rick > >> -Original Message- >> From: Dave Phillips [mailto:[EMAIL PROTECTED] >> Sen

Re: delete rows w/o creating new file

2008-08-22 Thread Greg Morphis
Are you taking and uploading the .csv file? If so, you could leave the header info and just ignore the first few lines (if it's static). On Fri, Aug 22, 2008 at 11:01 AM, MJ R <[EMAIL PROTECTED]> wrote: > Hello Everyone, > > I m wondering if there is any way to delete first few rows in csv file >

Re: syntax error in from clause on godaddy hosting

2008-08-18 Thread Greg Morphis
Probably not a good idea to post your DSN on a shared hosting box.. The query looks good... I think USER is a reserved word in queries.. but I don't know why it would have worked and then not.. On Mon, Aug 18, 2008 at 8:45 AM, kevin pieto <[EMAIL PROTECTED]> wrote: > We moved our site over to a n

Re: speaking of jQuery

2008-08-14 Thread Greg Morphis
Doh!! never mind.. the functions have to be placed in the document.ready function.. On Thu, Aug 14, 2008 at 1:02 PM, Greg Morphis <[EMAIL PROTECTED]> wrote: > Are the tutorials on jQuery.com accurate? > The reason I ask is because I want to play around with jQuery, I > download

speaking of jQuery

2008-08-14 Thread Greg Morphis
Are the tutorials on jQuery.com accurate? The reason I ask is because I want to play around with jQuery, I downloaded the .js file. I placed it in /root/common/javascript/ named jquery.js I checked out the page on jQuery.com, How jQuery Works and nothing works... This works which means I'm using

Re: SQL injection attack on House of Fusion

2008-08-11 Thread Greg Morphis
Actually is was Dave Morris who originally used rape to compare the 2. Rick was just responding.. On Mon, Aug 11, 2008 at 10:23 AM, Mark Kruger <[EMAIL PROTECTED]> wrote: > Rick, > > While your argument is well put, perhaps we could choose a slightly less > inflammatory analogy than rape. We have

Re: SQL injection attack on House of Fusion

2008-08-11 Thread Greg Morphis
CHOP away at > our systems until they find that one hole we didn't catch, and then blame it > on the victim! > > Dave Morris > > > >> -Original Message- >> From: Greg Morphis [mailto:[EMAIL PROTECTED] >> Sent: Monday, August 11, 2008 9:04 AM >>

Re: SQL injection attack on House of Fusion

2008-08-11 Thread Greg Morphis
Ummm but is it not your website that YOU left vulnerable? If you didn't have access to cfqueryparam then you should have used an alternate approach. I'm sure they exist even for CF 4.0, a little extra time at the beginning validating variables would save so much grief now right? And from what I'm h

Re: SQL injection attack on House of Fusion

2008-08-08 Thread Greg Morphis
Preach it Brother Ben! On Fri, Aug 8, 2008 at 10:50 AM, Ben Forta <[EMAIL PROTECTED]> wrote: > Yep, I turned e-mail notifications off too, leave it on and you can > inadvertently turn blocking SQL injection attacks into a self-imposed DoS > attack. Fun stuff. > > On the plus side, it's nice to see

Re: (ot) Flex mailing list

2008-08-05 Thread Greg Morphis
flexcoders yahoo group... high traffic On Tue, Aug 5, 2008 at 4:25 AM, Will Swain <[EMAIL PROTECTED]> wrote: > There's the House of Fusion one of course. Not very high traffic though. > > > -Original Message- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: 05 August 2008 10:21 > To:

Re: Reloading CFC's?

2008-08-03 Thread Greg Morphis
When creating and testing my CFCs I usually set my applicationtimeout to 1 minute, that seems to work well for me for this very same problem. On Sun, Aug 3, 2008 at 10:14 AM, James Holmes <[EMAIL PROTECTED]> wrote: > Is the CFC in the application scope? If so, you need to have some way > of re-cre

Re: Checking if a date is within a date range

2008-08-01 Thread Greg Morphis
If you're wanting coldfusion to check, you could do something like: sdate = #sdate# edate = #edate# It's there Nope On Fri, Aug 1, 2008 at 12:58 PM, Greg Morphis <[EMAIL PROTECTED]> wrote: > if your database supports BETWEEN, >

Re: Checking if a date is within a date range

2008-08-01 Thread Greg Morphis
if your database supports BETWEEN, you can select foo from my_tbl where my_date between start_date and end_date or are you wanting to do that in ColdFusion? On Fri, Aug 1, 2008 at 12:46 PM, <[EMAIL PROTECTED]> wrote: > Hey all. > > I've got a fiscal year that runs from July of a year to June of

Re: (ot) Eclipse Question

2008-07-30 Thread Greg Morphis
If you're using CVS you can ignore the .project file when committing the changes then use CVS to export the files to your dev environment. That's what we do anyways... > -Original Message- > From: Dave Phillips [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 30, 2008 10:01 AM > To: CF-T

Re: Right of @ Replace email

2008-07-28 Thread Greg Morphis
Yeah, sorry I'm in DB land.. but I knew it would help get you to where you needed to be. On Mon, Jul 28, 2008 at 1:54 PM, Paul Ihrig <[EMAIL PROTECTED]> wrote: > thanks Greg > instr isnt a function in CFC > but you lead me to > #right(getaUser.usr_email, find('@', getaUser.usr_email))# > > which i

Re: Right of @ Replace email

2008-07-28 Thread Greg Morphis
what about something like right(email, instr(email,'@')+1, len(email)) note: didn't test On Mon, Jul 28, 2008 at 1:32 PM, Paul Ihrig <[EMAIL PROTECTED]> wrote: > i know i have done this befor > i am trying to get the values of an email address from right of the AT @ > symbol. > so far i can get

Re: (ot) URL Hack Attempt Leaves Me Scractching My Head... To Ben Forta

2008-07-25 Thread Greg Morphis
If you spent more time securing your variables then it wouldnt be much of a problem.. E.G if you create a database field lname char(50), in CF check the length before passing that variable to your CFQUERY.. There's isnumeric() to check for numbers, there's ways to help protect yourself from this wi

Re: Form Spam Attack

2008-07-24 Thread Greg Morphis
captcha is nice On Thu, Jul 24, 2008 at 9:42 AM, Robert Harrison <[EMAIL PROTECTED]> wrote: > Great - first the SQL injection attack, now a web contact form spam attack. > > When you're using a contact form to send email, what can you do to prevent a > bot from spamming the form? > > One of my sit

Re: (ot) Stupid HTML Question

2008-07-23 Thread Greg Morphis
Wim, your code worked on Firefox just fine, but not in IE as he asked for. On Wed, Jul 23, 2008 at 8:52 AM, Wim Lemmens <[EMAIL PROTECTED]> wrote: > That's what you wanted, no? > > You say "I actually want the text that doesn't fit to be hidden". > That's what you get. > > Please explain correctly

Re: Why won't this work to give me a list of photos?

2008-07-19 Thread Greg Morphis
What's #index# ? you dont have that variable declared anywhere.. should be #photo# right? On Sat, Jul 19, 2008 at 10:13 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > What's wrong with this code? > > (I don't get an error message from CF, just an IE Error 500...) > > Thanks, > > Rick > > file="e

Re: loop over list question

2008-07-15 Thread Greg Morphis
One way to troubleshoot this is to remove the and replace with See what you're generating and passing to the DB Copy the output and place it in your DB GUI and run it.. You'll find out pretty quick if it's CF or the DB.. So you have all your fields in one huge list? You could loop over the

Re: Is there a way to do this?

2008-07-07 Thread Greg Morphis
names of the > cities selected and then place them on top. Then run > another query to get all the cities in order. (Which > seems to be what your single query does, too, Greg). > Usually, I put the selected item in a single select > on top and then list the rest, including the se

Re: Is there a way to do this?

2008-07-07 Thread Greg Morphis
You could do something like (not tested) select distinct city, orderby from ( select city, 2 as orderby from table where city < foo_city union select city, 1 as orderby from table where city >= foo_city ) order by orderby, city that would tack the prior cities onto the end On Mon, Jul 7, 2008 at

Re: Why would this query return this error?

2008-07-04 Thread Greg Morphis
maybe he intends on caching it? or perhaps it was cached and he's reruning the query to clear the cached query? On Fri, Jul 4, 2008 at 5:28 PM, Will Tomlinson <[EMAIL PROTECTED]> wrote: >> > cachedWithin="#CreateTimeSpan(0,0,0,0)#"> >> > > Rick, is this some CF2 technique I missed out on? Whatsup

Re: Why would this query return this error?

2008-07-04 Thread Greg Morphis
ver, the thing that's really my problem now (and was before I ran into >> this issue), >> is that I'm not getting any of the "office" data returned in the query. >> A dump of these 10 records say "empty" for o.mls, o.office_name, and >> o.displ

Re: Why would this query return this error?

2008-07-04 Thread Greg Morphis
you have the properties table aliased as 'p'.. On Fri, Jul 4, 2008 at 11:10 AM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > Hi, all... > > Why would this query return this error: > > 'Unknown column 'properties.mls_number' in 'on clause' > > Here's the query: > > cachedWithin="#CreateTimeSpan(0,0

Re: Select records for a given year from a date column, Oracle.

2008-06-19 Thread Greg Morphis
Add an function based index on the column. We have several million row tables and this is no problem. On Thu, Jun 19, 2008 at 10:36 AM, Wim Lemmens <[EMAIL PROTECTED]> wrote: > About Greg's sugestion: where to_char(date_column, '') = '2008' > > This will only work if you're not dealing with a

Re: Select records for a given year from a date column, Oracle.

2008-06-19 Thread Greg Morphis
Ian, use select * from table where to_char(date_column, '') = '2008' On Thu, Jun 19, 2008 at 10:05 AM, Ian Skinner <[EMAIL PROTECTED]> wrote: > Brain dead morning. > > How does one select records for a given year from an Oracle date column, > thus ignoring the month, day and time portions of

Re: (ot) javascript help

2008-06-11 Thread Greg Morphis
because isn't an element of ? try removing the tabbedTicket or use getElementById On Wed, Jun 11, 2008 at 12:34 PM, Chad Gray <[EMAIL PROTECTED]> wrote: > Can any javascript gurus tell me why this does not work? I want the tag > to display on the page so I get a carriage return between the two

Re: do not increase counter is returns 0

2008-06-03 Thread Greg Morphis
Erik, why can't you just exclude those records in the SQL? select hours,minutes from TimesOnline where empID=#EID# and coursename like 'Activity Programming%' and (hours != 0 and minutes != 0) ?? On Tue, Jun 3, 2008 at 1:19 PM, Eric Roberts <[EMAIL PROTECTED]> wrote: > Please ignore the but

Re: CF with PostgreSQL

2008-06-02 Thread Greg Morphis
I use it at home.. I like it.. it's a little hefty for small things though. On Mon, Jun 2, 2008 at 3:03 PM, Wil Genovese <[EMAIL PROTECTED]> wrote: > I have a general question. how many of you (us) CF'ers are using > PostgreSQL for their database? > > I've been using PostgreSQL for about 5 years.

Re: Syntax Error In Update Statement

2008-05-23 Thread Greg Morphis
Holy F!?!?!?! .. surely you don't have the password, phone number, fax number, email and company name. I think this email just gave every DB person on this list a heart attack. Clob is for storing GIGS of data. Those are varchar's if not numeric.. Fix your query first and then let us k

Re: Syntax Error In Update Statement

2008-05-23 Thread Greg Morphis
If it's numeric in the DB it should NOT be cf_sql_clob On Fri, May 23, 2008 at 3:34 PM, morgan l <[EMAIL PROTECTED]> wrote: > The query you posted (UPDATE HomeCareCompany) is not the query reporting the > error ( UPDATE Physician ) > > On Fri, May 23, 2008 at 3:28 PM, <[EMAIL PROTECTED]> wrote: >

Re: Syntax Error In Update Statement

2008-05-23 Thread Greg Morphis
e= (param 11) , Fax= '' WHERE ID= > (param 12) > VENDORERRORCODE 3092 > > > > -Original Message- > From: Greg Morphis [mailto:[EMAIL PROTECTED] > Sent: Friday, May 23, 2008 4:25 PM > To: CF-Talk > Subject: Re: Syntax Error In Update Statement

Re: Syntax Error In Update Statement

2008-05-23 Thread Greg Morphis
Also.. what is location? Do yow know what a CLOB is? That's a HUGE character field.. can that not be a varchar? On Fri, May 23, 2008 at 3:25 PM, <[EMAIL PROTECTED]> wrote: > I actually want that field to be a 0 if no data was entered on the form. > > > -Original Message- > From: Charlie G

Re: Syntax Error In Update Statement

2008-05-23 Thread Greg Morphis
What error does CF give? On Fri, May 23, 2008 at 3:14 PM, Patrick Hedgepath <[EMAIL PROTECTED]> wrote: > Can anybody see the syntax error that CF8 keeps giving me for this query? The > query was made by DW CS3 and worked until I added a new field by hand > (Location). I can't see any reason it w

Re: Can ColdFusion detect if Flash is available?

2008-05-21 Thread Greg Morphis
CF = server.. Flash is client.. so I wouldn't think so.. if I was wrong it wouldn't be the first time On Wed, May 21, 2008 at 3:24 PM, K Simanonok <[EMAIL PROTECTED]> wrote: > I'd like to be able to detect if a user's browser will support Flash, and > ideally be able to tell if the version is

Re: CF Store Locator - almost there - order results

2008-05-20 Thread Greg Morphis
Well since your queries don't match it's hard to come up with an exact answer but assuming the second_query.zip is the ZIP code for the first query.. select * from dbo.tblStores where phone <> '' AND lat IS NOT NULL AND long IS NOT NULL AND active = 1 AND zip IN ( select zip fromzip where

Re: CF Store Locator - almost there - order results

2008-05-20 Thread Greg Morphis
You have ZIPs with leading zeros.. which means they are characters, not numbers have you tried IN ('0','1','2')... Plus you wouldn't necessarily need 2 queries.. A subquery would work.. select * from tbl_a where col in (select * from tbl_2)... Or course I'd probably use exists if yo

Re: MMS in ColdFusion?

2008-05-19 Thread Greg Morphis
I tried adding the project in Eclipse and it shows 100+ errors. So I have mainly been messing with the standalone folder.. I tried to compile the .java file using the command javac MM7MessageSender.java and got this.. MM7MessageSender.java:507: cannot find symbol symbol : class MessagingException

Re: MMS in ColdFusion?

2008-05-16 Thread Greg Morphis
How can I add to the generated XML? there's not an option for it in the send.bat file? Thanks On Fri, May 16, 2008 at 3:35 PM, Greg Morphis <[EMAIL PROTECTED]> wrote: > I found it in C:\vaspsdk\src\samples\standalone > Same error.. > http code 500 > > 235 [Thread-0]

Re: MMS in ColdFusion?

2008-05-16 Thread Greg Morphis
threads each with 1 iterations 0 iterations succeeded Messages per sec: 1.8281536 On Fri, May 16, 2008 at 3:19 PM, Greg Morphis <[EMAIL PROTECTED]> wrote: > I see in the DEBUG that it has > my_id > > I changed this in the MessageSender file.. > request.setVaspID( "myRealVa

Re: MMS in ColdFusion?

2008-05-16 Thread Greg Morphis
I see in the DEBUG that it has my_id I changed this in the MessageSender file.. request.setVaspID( "myRealVaspId" ); is there some other place in the src/ folder that defaults this to "my_id" ? the windows text search sucks On Fri, May 16, 2008 at 3:10 PM, Greg Morph

Re: MMS in ColdFusion?

2008-05-16 Thread Greg Morphis
each with 1 iterations 0 iterations succeeded Messages per sec: 0.92764384 On Fri, May 16, 2008 at 3:04 PM, Greg Morphis <[EMAIL PROTECTED]> wrote: > dammit.. I don't need to put in a port number either. But I get a damn > error message > "port out of range" > &

Re: MMS in ColdFusion?

2008-05-16 Thread Greg Morphis
dammit.. I don't need to put in a port number either. But I get a damn error message "port out of range" On Fri, May 16, 2008 at 2:54 PM, Greg Morphis <[EMAIL PROTECTED]> wrote: > behind a firewall here at work.. no gtalk for me. > I'll give that a try.. Thanks >

Re: MMS in ColdFusion?

2008-05-16 Thread Greg Morphis
behind a firewall here at work.. no gtalk for me. I'll give that a try.. Thanks On Fri, May 16, 2008 at 2:46 PM, Rich <[EMAIL PROTECTED]> wrote: > Greg, > I did a quick scan of the SDK source, and username / pass are required > attributes. You can test and see if you can pass guest / dummy creden

Re: MMS in ColdFusion?

2008-05-16 Thread Greg Morphis
Cool I appreciate it. I've got the vaspid, vasid, url, short code, and xml schema. username and password is not required. I looked in the MM7MessageSender.. I only see the vaspid to edit.. I played with the send.bat in the standalone folder and modified the url there.. I keep getting C:\vaspsdk\sam

Re: MMS in ColdFusion?

2008-05-16 Thread Greg Morphis
ags, so you would need to look at > using one of the JAVA webservice libraries. > > I'm sure you will still find aggregators which give you the basic REST > service to post to, they can then do the complicated work of making the MM7 > protocol calls to the service providers. > >

Re: MMS in ColdFusion?

2008-05-16 Thread Greg Morphis
I just spoke with my contact.. and they mention MM7 traffic via a VASP This is all greek to me.. will an SMS Aggregator still work here? Or will I need to go the openwave route? Thanks guys On Fri, May 16, 2008 at 10:44 AM, Greg Morphis <[EMAIL PROTECTED]> wrote: > Apparently they

Re: MMS in ColdFusion?

2008-05-16 Thread Greg Morphis
Apparently they have SOAP set up.. if I just hit the URL I get SOAP Message Router Sorry, I don't speak via HTTP GET- you have to use HTTP POST to talk to me. On Fri, May 16, 2008 at 10:37 AM, Rich <[EMAIL PROTECTED]> wrote: > Robert, > Were you doing a http post to the aggregator, or is there

Re: MMS in ColdFusion?

2008-05-16 Thread Greg Morphis
ree trial with 10-20 message credits for you to play > around with. They will also offer a bunch of different communication methods > so you dont have to use cfhttp if you dont want. > > Robert > > > > From: "Greg Morphis" &

Re: MMS in ColdFusion?

2008-05-16 Thread Greg Morphis
Please do.. send me anything you can. I'll check out openwave MMS SDK On Fri, May 16, 2008 at 9:49 AM, Rich <[EMAIL PROTECTED]> wrote: > Greg, > I just completed a project that involved MMS. I don't know of a really > simple way to send MMS messages from CF without the use of java. > > I used the

MMS in ColdFusion?

2008-05-16 Thread Greg Morphis
I did some google searching last night and found this : http://www.bennadel.com/blog/794-Sending-SMS-Picture-Messages-With-ColdFusion-And-CFMail.htm however when I tried it on my phone (which can send and receive picture messages)... it just came across as plain text.. I couldn't find much else on

Re: easy one! : comma separated list from cfoutput

2008-05-13 Thread Greg Morphis
If that's what you're doing then why not have a user_groupings relational table that holds the user_id and group_id? On Tue, May 13, 2008 at 12:11 PM, Paul Ihrig <[EMAIL PROTECTED]> wrote: > ian, that is exactly what i am doing. > but i am storing a list inside a column to refer to user created

Re: CF redefines math: 5 = 6

2008-05-08 Thread Greg Morphis
secretly (and inconsistently) rounded for me. > > ~Brad > > > > -Original Message- > From: Greg Morphis [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 06, 2008 6:02 PM > To: CF-Talk > Subject: Re: CF redefines math: 5 = 6 > > Doesn't int() just

Re: CF redefines math: 5 = 6

2008-05-06 Thread Greg Morphis
Doesn't int() just string anything after the decimal away? so 5. would be 5? rnd(5.9) would be 6. ceil(5.99) would also be 6. On Tue, May 6, 2008 at 5:40 PM, Brad Wood <[EMAIL PROTECTED]> wrote: > My coworker ran into this today. We were able to reproduce it on CF 6, > 7, and

<    1   2   3   4   5   6   7   8   >