Re: Confirmed: at least one more CF8 Release Candidate

2007-07-09 Thread Greg Morphis
Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Monday, July 09, 2007 11:29 AM To: CF-Talk Subject: Re: Confirmed: at least one more CF8 Release Candidate I've noticed that some of the cfajax stuff doesnt work with IE6.0.. and I know why.. IE6.0 doesnt follow standards but I

Dreamweaver extensions for CF8

2007-07-06 Thread Greg Morphis
There's a few people here that havent switched to CFEclipse and are still using Dreamweaver. Does anyone know if Adobe is planning on releasing CF8 extensions for Dreamweaver? Thanks ~| Create robust enterprise, web RIAs.

Re: Time Question

2007-07-03 Thread Greg Morphis
130/60 = 2.167 there's your 2 minutes, then take the remainder (using the modulus function) the .17 * 60 and round the result? On 7/3/07, Jim H [EMAIL PROTECTED] wrote: which returns 10:24. I need to get the 1:36 now. First off - forget the format. Format means nothing.

Re: CFEclipse not compatible w/ Eclipse 3.3

2007-06-29 Thread Greg Morphis
Uh I believe Mark was showing CFEclipse 1.3 on Eclipse 3.3 during his presentation at CFUnited this afternoon. Awesome job with that Mark.. great session! On 6/29/07, Andrew Scott [EMAIL PROTECTED] wrote: No 3.3 changes the rules, and I am sure Mark will go into more details as to why. btw

Re: cf why.

2007-06-18 Thread Greg Morphis
no, because you're rounding it to tens.. if you wanted 33.33, then you'd need numberformat('33.334','99.99') On 6/18/07, Tony [EMAIL PROTECTED] wrote: shouldnt numberformat('33.334','99') return 33.33? tony On 6/18/07, Mark Mandel [EMAIL PROTECTED] wrote: They all do similar, but quite

Re: converting a string to a date - most efficient way?

2007-06-15 Thread Greg Morphis
CreateDate is year,month,day.. CreateDate(year,month,day) Thats why it's throwing an error On 6/15/07, Claude Schneegans [EMAIL PROTECTED] wrote: I've got a few ideas, but they all basically suck. Any takers? You can try this free custom tag:

Re: Can anybody see why the first SQL statement works but the second throws an error.

2007-06-13 Thread Greg Morphis
you're sure the second one is bombing? Can you try the page with JUST that one? Exclude the 1st one. Also vice versa, try the other one the same way. On 6/13/07, Ian Skinner [EMAIL PROTECTED] wrote: UPDATE INTRANET.TRAK_CMP SET LOC_CODE = 'ROSE', CMP_CD = '018251', SCAN_DATE = {ts

Re: 16 character limit on SQL pass

2007-06-12 Thread Greg Morphis
To stop people from sitting on their keyboards? On 6/12/07, Brad Wood [EMAIL PROTECTED] wrote: Nobody, huh? Does anyone know why ColdFusion datasources have a 16 character limit on passwords? My DBA just created a monster 38 character password which looked like someone sat on his keyboard

Re: SQL Help

2007-04-03 Thread Greg Morphis
You need a group by in your query.. SELECT count(DISTINCT rate) as rateCount, rate FROMmyrates WHERE my_code = 385 and year = 2005 GROUP BY rate ORDER BY rate On 4/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Why do the first two queries work and the last one fail? The only

Re: SQL Help - Answered

2007-04-03 Thread Greg Morphis
No problem, if you want to know why take a look at aggregate functions, which is what count is, as well as others.. On 4/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Thank you Greg Morphis wrote: You need a group by in your query.. SELECT count(DISTINCT rate) as rateCount, rate

Re: SQL Help - Answered

2007-04-03 Thread Greg Morphis
. Greg Morphis wrote: No problem, if you want to know why take a look at aggregate functions, which is what count is, as well as others.. On 4/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Thank you Greg Morphis wrote: You need a group by in your query.. SELECT count

Re: Query that should run but won't (but does run)

2007-03-20 Thread Greg Morphis
just to be sure.. you might want to wrap your query in a savecontent variable and dump the results into TOAD... maybe there's something up with the variable? On 3/20/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Are you trying to cache the query? This e-mail is from Reed

Re: Need some SQL help!

2007-03-20 Thread Greg Morphis
select * from ( SELECT ... FROM tblquestions ) questions, ( SELECT ... FROM tblquestions INNER JOIN tblanswersets USING (answerSetID) INNER JOIN tblanswers USING (answerID) ) answers, ( SELECT A.answerID, COUNT(EAR.answerID) FROM

Re: Query that should run but won't (but does run)

2007-03-20 Thread Greg Morphis
What DB are you using? On 3/20/07, Bryan Stevenson [EMAIL PROTECTED] wrote: WHERE CAST(theField AS Int) = cfqueryparam value=#val(myVar)# cfsqltype=cf_sql_integer I'll try anything at this point...haven't tried the cast() yetbut I have done the val() Thanks Bryan Stevenson

Re: Query that should run but won't (but does run)

2007-03-20 Thread Greg Morphis
We use Oracle here too.. instead of CAST() use to_number() select * from foo where goo = to_number('#MyVar#') On 3/20/07, Bryan Stevenson [EMAIL PROTECTED] wrote: What DB are you using? Oracle9i I beleive Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge

Re: Daylight Savings Time Change (Slightly OT, but relevant)

2007-03-09 Thread Greg Morphis
What? There's people outside the US? heh On 3/9/07, Paul Vernon [EMAIL PROTECTED] wrote: In case you have not heard the dates on which we change to Daylight Savings Time have changed. It used to be we went on Daylight Savings Time the first Sunday in April and off the last Sunday in

Re: querying a date/time field

2007-03-07 Thread Greg Morphis
ew access... try where expiration = cfqueryparam cfsqltype=cf_sql_date value=#fooDate# / On 3/7/07, Orlini, Robert [EMAIL PROTECTED] wrote: I want to compare dates in my Access database. It is setup as a date/time field in Access as expiration. I want to check whether the expiration

Re: querying a date/time field

2007-03-07 Thread Greg Morphis
it might not have anything to do with Access but doesn't mean I have to like Access.. On 3/7/07, Claude_Schnéegans [EMAIL PROTECTED] wrote: ew access... This has nothing to do with Access. The problem is that formated dates should not be used in SQL, only CF date values (which are

Re: Vista - too many files open error message- Dave watts?

2007-03-07 Thread Greg Morphis
I second the Who the hell needs that many files open at one time? On 3/7/07, Jacob Munson [EMAIL PROTECTED] wrote: Maybe Vista replaces her changed file with the original on reboot? I've seen that behavior before in Windows. On 3/7/07, Will Tomlinson [EMAIL PROTECTED] wrote: Dave, She

Re: cfform problem drivin me nuts

2007-02-26 Thread Greg Morphis
I'm using FF and the buttons are enabled? HAve you corrected the problem? On 2/26/07, Will Tomlinson [EMAIL PROTECTED] wrote: I'm having a problem I've never seen before with a cfform. It's just a form with some selects, test inputs, etc. When you view it in FF, you can't click the save or

Re: Not sure how to do this

2007-02-15 Thread Greg Morphis
I'd watch out using JS.. some people have that turned off... just FYI On 2/15/07, Bruce Sorge [EMAIL PROTECTED] wrote: I have a form where the user puts in a time range in a text field (8:00 AM - 12:00 PM). What I need to do is to make sure that they enter at least a 4 hour range. I thought of

what scope type takes precedence?

2007-02-09 Thread Greg Morphis
I'm supporting some CF code and need to check something.. if you have 2 variables session.foo and url.foo and in a query you have select #foo# from table where blah = 1 which scope takes precedence? ~| Upgrade to Adobe

Re: Best resource for learning Flex?

2007-01-26 Thread Greg Morphis
I can attest to the figleaf training, our company went through a 3day training course.. great way to get started! On 1/26/07, Dave Watts [EMAIL PROTECTED] wrote: Any suggestions? Fig Leaf Software offers hands-on Flex training:

Re: Best resource for learning Flex?

2007-01-25 Thread Greg Morphis
flexcoders (yahoo group) is good, I recently bought the Actionscript 3.0 Cookbook, some real nice examples in there... The examples on adobe.com are nice to start too On 1/25/07, Doug Brown [EMAIL PROTECTED] wrote: Any suggestions? Doug B.

Re: Date Problem

2007-01-24 Thread Greg Morphis
you could use an imaginary date and cfparams on the page.. cfparam name=DateElected default=#dateformat('01/01/','mm/dd/')#/ but it looks like your dateformat() and passing null values to it is causing the issue.. this way, you pass an imaginary date to the database.. unless you really

Re: Date Problem

2007-01-24 Thread Greg Morphis
yeah definitely use cfqueryparams when in your query.. cfqueryparam cfsqltype=cf_sql_date value=#form.foodate# null=yes / On 1/24/07, Richard Kroll [EMAIL PROTECTED] wrote: That is what I want, nulls. If no date is selected, then I do not want anything there. I would suggest using the

Re: CF Form Wierdness

2007-01-24 Thread Greg Morphis
try adding getCouncilMemberInfoRet to the variables... #getCouncilMemberInfoRet.fname# #getCouncilMemberInfoRet.lname# On 1/24/07, Bruce Sorge [EMAIL PROTECTED] wrote: OK, this one is strange. I have a CFFOFM that is being populated by a query like so: cfoutput

Re: tallying SQL row entries

2007-01-19 Thread Greg Morphis
can you provide a few rows from your table as an example? and your DBMS? On 1/19/07, Richard Cooper [EMAIL PROTECTED] wrote: Hi all, I have an online poll which allows users to add the answers to the database. I can get the results like this: cfquery name=getData datasource=#ARGUMENTS.DSN#

Re: GoDaddy Hosting Issue

2007-01-09 Thread Greg Morphis
do what Charlie said.. just do something like cfset fooVar = Goo / cfdump var=#fooVar# / If that doesnt work, then it's a problem with Google. On 1/9/07, Bruce Sorge [EMAIL PROTECTED] wrote: So if I comment out the CFDUMP tag, then all works fine. If I put the #Arguments.Exeption# in a

Re: Number to currency words

2007-01-08 Thread Greg Morphis
couldnt you create a list of words one - ninety-nine use the decmial to seperate the currency into 2 values.. dollars and cents. Then use a switch case to determine the length of the dollars to add the hundred or thousand, or ten thousand, etc? use the above list to create the tens and ones

Re: Number to currency words

2007-01-08 Thread Greg Morphis
I made this work... let me know if you still need the code (it's ugly but performs the job) On 1/8/07, Greg Morphis [EMAIL PROTECTED] wrote: couldnt you create a list of words one - ninety-nine use the decmial to seperate the currency into 2 values.. dollars and cents. Then use a switch case

Re: Query of Queries question

2007-01-05 Thread Greg Morphis
not sure what DB you're using.. but with Oracle you can do this in a subquery select * from ( select rownum as rn, n.* From navmenu n ) where rn = 5 and rn = 7 On 1/5/07, Dave Phillips [EMAIL PROTECTED] wrote: Does anyone know if it's possible to extract a 'subset' of records in a query

Re: Getting counts and the sum

2007-01-05 Thread Greg Morphis
what DB are you working with, some, like Oracle have a sum(foo) over (partition by goo).. that you could use in this example On 1/5/07, Matt Williams [EMAIL PROTECTED] wrote: In SQL, is there an easy way to get the counts of something and then also the total of all those counts? For example,

Re: Easy one

2007-01-04 Thread Greg Morphis
= positive feedback / (positive feedback + negative feedback) On 1/4/07, Doug Brown [EMAIL PROTECTED] wrote: My math skills seems to suck!! I have a table where I am holding feedback left for sellers. [feedback] id (int) positive (bit) negative (bit) rating (int) 1-5 I want to get

Re: division by 0 error

2006-12-01 Thread Greg Morphis
We've been seeing a bit of these too. On login to apps and apps where no math is performed. We also have multiple instances.. I haven't seen much around the web as far as answers though On 12/1/06, Bobby Hartsfield [EMAIL PROTECTED] wrote: Sorry. I'm lost in stack traces. Wish I could help more.

Re: How do I get number of birthdays?

2006-11-27 Thread Greg Morphis
Use a date picker and get the full start date and full end date instead of just doing a select box for months and days... It's easier to work with dates instead of what you're doing... On 11/27/06, Andy Matthews [EMAIL PROTECTED] wrote: Why not just add subtract one day from the oldest date,

Re: multiple entries in a database - OT

2006-10-24 Thread Greg Morphis
you need a relational database set up... have a main table called meeting which contains a unique key, date, time, things that are specific to the meeting only. Then create a table for the attendees, have a primary key, the attendee name and a foreign key to the meeting table with the meeting id

Re: one year behind

2006-10-18 Thread Greg Morphis
try using dateadd() it asks for a part, like year, and then the offset, so you could do -1.. Should work for you On 10/18/06, Orlini, Robert [EMAIL PROTECTED] wrote: How can I set this to be one year behind? Right now it displays 2006; I would like it to display 2005 cfset year =

Re: Hash Sha-1

2006-10-02 Thread Greg Morphis
go to the Macromedia (Adobe) exchange and look for SHA-1.. there's already code that hashes strings using the SHA-1 algorithm. I actually utilized it and converted the CF to VB 6 for a project. On 10/2/06, Peter Boughton [EMAIL PROTECTED] wrote: Are you certain that the VB.NET output is SHA-1

Re: Posting variables

2006-09-25 Thread Greg Morphis
Updating one column verses 10 or even 50 wont make much difference PLUS this is done on the DB server, so CF just passes this on (if it's on 2 different servers). You wont see a performance increase from updating only a few columns. If you wanted the colors thingy.. you could use a Confirm page..

Re: CFQUERY of non-swequential primary key ids

2006-08-23 Thread Greg Morphis
You could query the table and get a list of the available IDs. Generate a random number between 1 and listlen() and then using ListGetAt() you can get that random ID and then query the DB again to pull back that record. On 8/23/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: All, I'm doing a

Re: Good script to prevent cross-site scripting sql injection?

2006-08-07 Thread Greg Morphis
look into cfqueryparam, you can't go wrong with it On 8/7/06, Rey Bango [EMAIL PROTECTED] wrote: Hi guys, Any recommendations on a good script to prevent cross-site scripting sql injection? if someone has good code for this, I'd really appreciate it if I could use it. Rey...

Re: Hey, does anyone have any ideas regarding a top 40 voting system?

2006-08-01 Thread Greg Morphis
Have a main songs table with song info, and a scores table with song IDs and a number say 1-10 score. Query the scores table to get an average, arrange query by that average and either use SQL to get the top 40 rows or through the use of CFLOOP output the 40 top scores.. On 8/1/06, Jeff Small

Re: Group By function for MS SQL Server Express 2005?

2006-06-13 Thread Greg Morphis
But it is needed, that query is returning the count of the books per book_genre On 6/13/06, Rick Faircloth [EMAIL PROTECTED] wrote: I finally did get Express to give me the results I wanted... Here's the solution the Query Builder gave: Select Count(*) as Expr2, Book_Genre from Books Group

Re: Group By function for MS SQL Server Express 2005?

2006-06-13 Thread Greg Morphis
What information are you trying to get then? On 6/13/06, Rick Faircloth [EMAIL PROTECTED] wrote: But why does it require that the count be calculated if I don't need that information? -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 13, 2006 1

Re: SQL question

2006-06-12 Thread Greg Morphis
use a subquery update table set status = 'approved' where sku = cfqueryparam value=#url.sku#' and cfsqltype=cf_sql_varchar / and statuswhen = ( select max(statuswhen) from status where ... --include where clauses ) On 6/12/06, Chad Gray [EMAIL PROTECTED] wrote: How would I write the SQL to

Re: MySQL query help

2006-06-03 Thread Greg Morphis
off the top of my head, may have errors.. update contributors c set c.namesort = ( select cs.namesort from contributor_sort cs where c.name = cs.name) On 6/3/06, Jim McAtee [EMAIL PROTECTED] wrote: Using MySQL 5.0.21, I have two tables: contributors - contributor_id name

Re: Anything inherently wrong with this query?

2006-03-31 Thread Greg Morphis
An error that you're getting would also help.. On 3/31/06, Bryan Stevenson [EMAIL PROTECTED] wrote: Yeah...use better aliases than ABCDEF ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell:

Re: Anything inherently wrong with this query?

2006-03-31 Thread Greg Morphis
Make sure you use distinct or in() for those subqueries. If you're returning more than 1 employer_id or family_id then that'll cause an error too. On 3/31/06, Matt Williams [EMAIL PROTECTED] wrote: What error are you getting? Or is it just bad data? If your Client_ID fields are numeric, then

Re: Re-Send: Preventing Cou-pon Generation Fraud.

2006-03-13 Thread Greg Morphis
Yeah, I'd probably have something stored in the database.. customer_login coupon_emails [EMAIL PROTECTED][EMAIL PROTECTED] [EMAIL PROTECTED][EMAIL PROTECTED] [EMAIL PROTECTED][EMAIL PROTECTED] select count(customer_login), coupon-emails from coupons where

Re: burning the midnight oil on my chat room

2006-02-16 Thread Greg Morphis
Hey, a lot of us on the list us CFAJAX.. could you please shed the light on the security issue you discovered? Or blog about it and send out the link. I need to check my apps.. Thanks! On 2/15/06, Rick Root [EMAIL PROTECTED] wrote: Due to a really nasty security risk I've just discovered, my

Re: Session Based Timer?

2006-02-14 Thread Greg Morphis
you could use gettickcount() to get the miliseconds.. it'd be pretty easy to store in a DB for later calculations.. Get a tick count when the start button is pushed, and get another when the end button is pushed. Then subtract the 2.. On 2/14/06, Andy Matthews [EMAIL PROTECTED] wrote: Set a

Re: SQL Update

2006-01-20 Thread Greg Morphis
With Oracle you use the pipe ||.. update foo set fooname = fooname || 'Customer' On 1/20/06, Ken [EMAIL PROTECTED] wrote: Hi. This may be a little elementary, but here it is: I want to update a database field so that all values in it are appended with a given string. Something like this:

Re: phone numbers in database

2006-01-03 Thread Greg Morphis
I'd just store it as a text.. another option would be to store it as a number and use CF to format it correctly On 1/3/06, Brian Coleman [EMAIL PROTECTED] wrote: I have a CF application I'm working on and part of the application has entry of phone numbers. I think this may be related more to

Re: Random Numbers

2005-12-19 Thread Greg Morphis
You could create a table for winners... and use select * from players where playerid not in (select playerid from winners) Let your DB do the work On 12/19/05, Adkins, Randy [EMAIL PROTECTED] wrote: Not sure of what all you are trying to do, but something like this should work (not tested

Re: Need SQL Expert Help!

2005-11-11 Thread Greg Morphis
is it always .doc or . followed by a 3 digit extension? select * from foo where fooid != substr(file, 1, length(file) - 4) That works if so... On 11/11/05, jonese [EMAIL PROTECTED] wrote: we have an upload system that stores an uploadid and then the filename of the file uploaded. the uploadid

Re: Need SQL Expert Help!

2005-11-11 Thread Greg Morphis
select * from foo where fooid != substr(file, 1, position('.' in file) - 1); That works for postgres, if using Oracle use the instr() function instead of the position() function. On 11/11/05, Greg Morphis [EMAIL PROTECTED] wrote: is it always .doc or . followed by a 3 digit extension? select

low resource rdbms

2005-11-06 Thread Greg Morphis
What's the best free low resource RDBMS? I'm currently using Postgres, does MySQL use less? Has anyone installed the Oracle Express DBMS? It's a large install 100+MB, how is it on resources? -- Auxilium meum a Domino ~| Logware

Re: low resource rdbms

2005-11-06 Thread Greg Morphis
Anyone have any suggestions? On 11/6/05, Greg Morphis [EMAIL PROTECTED] wrote: What's the best free low resource RDBMS? I'm currently using Postgres, does MySQL use less? Has anyone installed the Oracle Express DBMS? It's a large install 100+MB, how is it on resources? -- Auxilium meum

Re: SQL join a table to a set of values not in a table.

2005-11-04 Thread Greg Morphis
Our DBA created a days table with days and weekending column from 2002 until 2009 for us... That would have made it a lot simplier, heh. And it's not all that large either. 2922 rows, 2 columns.. not large at all. Then you could have done it all within SQL and not have to rely on CF. On

Re: Need query help please

2005-11-02 Thread Greg Morphis
yeah I agree with Charlie.. just add an extra column called thumbnail with the image name. On 11/2/05, Charlie Griefer [EMAIL PROTECTED] wrote: why not just name the images something like img_large.jpg and img_thumb.jpg this way you can just store img in the database (in one record), and

Re: OT - Complex SQL

2005-10-28 Thread Greg Morphis
AND table_1.table_id IN ('value1','value2','value3') try that On 10/28/05, Jillian Koskie [EMAIL PROTECTED] wrote: Okay, I think it's because it is Friday at 4... can somebody help me out? SELECT table_1.expiry_date, table_3.expiry_date FROMtable_3

Re: Query.ColumnList Sorting?

2005-10-05 Thread Greg Morphis
In Oracle you can do something like this... SELECT t.column_name AS COLUMNS FROM all_tab_columns t WHERE LOWER(t.table_name)= table_name ORDER BY column_id I'm not sure if other DBMS have a similar feature On 10/5/05, Emmet McGovern [EMAIL PROTECTED] wrote: Is there any way to sort a ColumnList

Re: SQL row select?

2005-09-28 Thread Greg Morphis
Select top 50 * from table Where id not in ( select top 199 id from table order by date, alpha) order by date, alpha that works but what if you are paging through a million records as suggested before? wouldnt the inner query select the top 999,999 rows? IE Select top 50 * from

Re: Quick Query Question...[hopefully]

2005-08-26 Thread Greg Morphis
Actually what Mark Kruger said would probably work best in this situation Che, try this, create a table 1 row and the numbers 0 through 23 in them, then do a left join to your group by query :) -Mark What he's saying is create a table called Hours with column row called hour

Re: Building a dynamic menu from a database

2005-08-24 Thread Greg Morphis
If using Oracle you could use the START WITH / CONNECT BY functions to get the ordered list. If it's just for display, you could use LPAD with LEVEL to pad the children. SELECT LABEL, SECTION_ID, TITLE, PARENT_ID, DESCR, TESTPLAN_ID, LPAD(LABEL,LENGTH(LABEL) + LEVEL,' ') AS DALABEL, LEVEL FROM

Re: CFEclipse 1.2

2005-08-15 Thread Greg Morphis
I was having the same problem. I removed the old site and added the new one linked to http://www.cfeclipse.org/update. Then it found the update fine. On 8/15/05, Christian Cantrell [EMAIL PROTECTED] wrote: For some reason, Eclipse isn't seeing that an update is available. I can just install

Re: Query Problem - Brain Cloud

2005-07-28 Thread Greg Morphis
Add a vacant field and check to see if vacant is 0 or 1 0 being not vacant and 1 being vacant? But the where clause would look something like Select * from task t WHERE TO_DATE('#arguments.new_to#','mm/dd/') = t.startDate AND TO_DATE('#arguments.new_from#','mm/dd/') = t.finishDate

Re: Restricting Access

2005-07-25 Thread Greg Morphis
Are you storing the cgi.remotehost variable in a table? If so you could query that table for that IP.. cfquery name=foo datasource=... select * from questionaire where ip = cfqueryparam cfsqltype=cf_sql_varchar value=#cgi.remotehost# / /cfquery then you can check the recordcount of that query..

Re: SHA-1 encoding and least significant bits

2005-07-20 Thread Greg Morphis
This has been solved, thanks On 7/19/05, Greg Morphis [EMAIL PROTECTED] wrote: Okay so I think I know what the problem is.. I downloaded a hash calculator and one of the options is telling it the format of the text entered, hex string or text string. Does anyone know how to accomplish

Re: SHA-1 encoding and least significant bits

2005-07-19 Thread Greg Morphis
function but thats not working either. Any ideas on how to accomplish this? On 7/18/05, Greg Morphis [EMAIL PROTECTED] wrote: I was told that I have to take a 56 bit hex number (MEID) and convert it to a 32 bit hex number (pESN). The end result should look like this.. * The upper 8 bits

SHA-1 encoding and least significant bits

2005-07-18 Thread Greg Morphis
I was told that I have to take a 56 bit hex number (MEID) and convert it to a 32 bit hex number (pESN). The end result should look like this.. * The upper 8 bits of pseudo-ESN shall be set to 0x80. * The lower 24 bits of pseudo-ESN shall be the 24 least significant bits of the SHA-1 digest of the

Re: Join queries

2005-07-15 Thread Greg Morphis
the p and the a are just aliases for the tables.. some people don't mind typing out the table names over and over again however I think most like the shorthand of aliases. On 7/15/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Thanks Deanna. Just a couple of questions (and problems).

cf_fakeurl

2005-07-14 Thread Greg Morphis
I was wondering if there's been any 'fix' for the cf_fakeurl custom tag? I tried to use it at home and on my site and got 404 errors. I dumped the variables and everything seems to parse correctly however I still get the error. I did some searching and found an old thread here which I believe

Re: retrieve ID from db insert

2005-07-11 Thread Greg Morphis
Like Doug suggested, I've found the best way to do this is 2 queries.. First cfquery name=foo datasource=#ds# select game_id.nextval as id from dual /cfquery Then store that value in a session variable or however you want to. Then you can use that to insert into different queries. On

Re: SQL count of rows from a union query

2005-07-07 Thread Greg Morphis
could you put it in a 3rd query? Something like.. SELECT count(*) from ( SELECT * FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) ) On

Re: OT - MySQL to MSSQL

2005-07-01 Thread Greg Morphis
If that doesnt work, Try the mysqldump command line utility. I believe the format is mysqldump -hHOST -pPORT -uUSER -pPASSWORD c:\mysql.sql You may have to tweak the syntax, I'm not sure how close the 2 are. I used it to export and convert a DB to PostgreSQL, those 2 were rather similiar but

Re: OT: count() within a larger query

2005-06-30 Thread Greg Morphis
select p.name, count(*) from products p, category c where c.id = p.id group by p.name On 6/30/05, Damien McKenna [EMAIL PROTECTED] wrote: Back to basics for me. I've got a generic products / category table relationship, products lists the category_id, name, etc, while categories includes

Re: OT: count() within a larger query

2005-06-30 Thread Greg Morphis
You're welcome :) On 6/30/05, Damien McKenna [EMAIL PROTECTED] wrote: select p.name, count(*) from products p, category c where c.id = p.id group by p.name Ah-ha, GROUP BY, that's what I was forgetting. Thanks, Greg! -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu

Re: 5th Most Trafficked Site Switches to BlueDragon

2005-06-28 Thread Greg Morphis
I fall in the 2nd category I guess. I'm married, if 30 is old, I'm close but not there yet. I don't think I've ever heard of them either until recently. On 6/28/05, Roger B. [EMAIL PROTECTED] wrote: Wowmyspace.com must be huge.hm...no waitI've never heard of it?? ;-) Bryan:

Connecting to a Postgres DB

2005-06-28 Thread Greg Morphis
The MM tech note says to download the PostgreSQL JDBC type IV driver and links to the driver download page. I just downloaded the 8.0.3 version but which of those 3 drivers should I download? I imagine it's one of these 3... Version 8.0 Build 311 8.0-311 JDBC 2 8.0-311 JDBC 2EE

Re: Connecting to a Postgres DB

2005-06-28 Thread Greg Morphis
Cool, thanks Jochem! On 6/28/05, Jochem van Dieten [EMAIL PROTECTED] wrote: Greg Morphis wrote: The MM tech note says to download the PostgreSQL JDBC type IV driver and links to the driver download page. I just downloaded the 8.0.3 version but which of those 3 drivers should I download

Re: Using CF Variables Returned from a SQL Query

2005-06-13 Thread Greg Morphis
can you wrap a cfoutput around the ## variable? On 6/13/05, Stewart, Ryan [EMAIL PROTECTED] wrote: I have a column in a SQL table that contains a string of text that includes ColdFusion variables. When I query the text, I'd like the values of the ColdFusion variables to output on the screen.

problem with outputting...

2005-06-10 Thread Greg Morphis
I have a query which returns the follwoing data.. ORIGINATION DT CT ORDERBY ORIGIN_GROUPO1 O23 TOTAL REPORT_GROUP Call to Corporate May-20050 3 2 0 0 0 1 Call to Corporate Jun-20050 3 2

Re: Update Dilemma

2005-06-08 Thread Greg Morphis
what is #update.ID# ? look at the source for the page before submitting and check the value of it. If it's nothing or a string, there's your problem... ~| Logware (www.logware.us): a new and convenient web-based time tracking

Re: Update Dilemma

2005-06-08 Thread Greg Morphis
It would be all of them, you'd have to change them all from = null to is null On 6/8/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Is that the NULL on Line 63? Dan In a message dated 08/06/2005 16:03:25 GMT Daylight Time, [EMAIL PROTECTED] writes: Your cfif switch is trying to

Re: Javascript / Listbox Form Problem

2005-05-17 Thread Greg Morphis
try running it in Firefox and then check the Java Console, you'll see errors if it generated any. On 5/17/05, Paul Henderson [EMAIL PROTECTED] wrote: As far as I know it is running, I do not receive any browser errors I'm not sure how else to tell if it is actually running or not.

Re: Man, this is so OT...

2005-05-13 Thread Greg Morphis
Black On 5/13/05, Charles Heizer [EMAIL PROTECTED] wrote: Black On 5/13/05 12:27 PM, Tony Weeg [EMAIL PROTECTED] wrote: depends. White as an undershirt Black as an outershirt :) tw On 5/13/05, Will Tomlinson [EMAIL PROTECTED] wrote: Don't attack me for posting this

OT: Color Spies

2005-05-05 Thread Greg Morphis
You guys know of any good tools which has a color spy and also shows similar - related colors (colors that go well with the color you spied)? Free would be best.. -- Auxilium meum a Domino ~| Logware (www.logware.us): a new and

Re: OT: Color Spies

2005-05-05 Thread Greg Morphis
Rick Mason On 5/5/05, Greg Morphis [EMAIL PROTECTED] wrote: You guys know of any good tools which has a color spy and also shows similar - related colors (colors that go well with the color you spied)? Free would be best.. -- Auxilium meum a Domino

Re: OT: Color Spies

2005-05-05 Thread Greg Morphis
=10id=271 I think that's what you mean. As for suggesting colors, isn't that a bit subjective? I don't know how it would do that, but that plug in does not suggest anything - I'd like to see a tool that does suggest colors though just to see how it would work. On 5/5/05, Greg Morphis [EMAIL

Re: Color Spies

2005-05-05 Thread Greg Morphis
A lot of people are suggesting that. I think it works great for what I was wanting. Thanks On 5/5/05, Rebecca Wells [EMAIL PROTECTED] wrote: Here's a nice one: http://www.wellstyled.com/tools/colorscheme2/index-en.html ~|

Re: longer than a varchar2

2005-04-29 Thread Greg Morphis
CF_SQL_CLOB http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b20.htm#wp1102474 On 4/29/05, daniel kessler [EMAIL PROTECTED] wrote: CLOB, or course, as the others have said. As a side note, even though I'm _sure_ you're already using cfqueryparam, you have to use it to put data

How to add CLOB to dropdown when using cfqueryparam in Homesite and Dreamweaver Re: (WAS) longer than a varchar2

2005-04-29 Thread Greg Morphis
To add CF_SQL_CLOB to the dropdown in Homesite and Dreamweaver, do the following.. -- I've noticed that CF_SQL_CLOB isnt in the dropdown for sql types in Homesite and Dreamweaver. It's no bother typing in CF_SQL_CLOB for for those who like to have it in the

Re: longer than a varchar2

2005-04-29 Thread Greg Morphis
I didnt see it in the CF 5 LiveDocs but in the ones after that I did. So it's not too new. On 4/29/05, Matt Robertson [EMAIL PROTECTED] wrote: On 4/29/05, daniel kessler [EMAIL PROTECTED] wrote: well that web page lists CF_SQL_CLOB, but when I do edit tag in dreamweaver it doesn't list

Maybe I'm missing something...

2005-04-28 Thread Greg Morphis
This just seems like it would and should be easy.. maybe I'm missing something.. I want my form to submit to a page and apply JS to that page. I want to strip the statusbar, toolbar, and reposition the page. But this has to be done from a window.open() function, right? So how do I pass my query

Re: Maybe I'm missing something...

2005-04-28 Thread Greg Morphis
a window.open and name the window, and then set your form's target to be that same window name? cheers, barneyb On 4/28/05, Greg Morphis [EMAIL PROTECTED] wrote: This just seems like it would and should be easy.. maybe I'm missing something.. I want my form to submit to a page and apply JS

Re: Maybe I'm missing something...

2005-04-28 Thread Greg Morphis
Cool, that actually worked, thanks Barney! On 4/28/05, Greg Morphis [EMAIL PROTECTED] wrote: I don't think that works. Would it get the form values? I mean you're opening a window/url with JS.. I don't think the form variables would get carried over. I'll test in a minute though. Thanks

Re: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Greg Morphis
Of course you could return the whole value and then preform the listGetAt on the column but like Aaron said, we normally use Oracle too for things like that. Pull the data correctly out of the DBMS and no fooling with later On 4/27/05, Aaron Rouse [EMAIL PROTECTED] wrote: I do it in Oracle

Re: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Greg Morphis
What DBMS do you have? Access? I'm sure they have similar functions On 4/27/05, Che Vilnonis [EMAIL PROTECTED] wrote: ugh, I knew this would be hard to do withbasic SQL... -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 9:53 AM To:

<    1   2   3   4   5   6   7   8   >