Re: Error: attempted to dereference a scalar variable

2008-05-09 Thread Matt Quackenbush
Assuming that "Q.q4_a_int" is a recordset, try changing it to "Q.q4_a_int[1]". I'm kinda grabbing at straws here, but if your recordset contains more than one record (which I'm guessing it should not), that might result in the error message you are seeing. Typically speaking though, that particul

Re: inSERTurl variables into database using coldfusion

2008-03-13 Thread Matt Quackenbush
URL (get) variables are accessed via the URL scope. URL.foo As opposed to form [post] variables, which are accessed via the FORM scope. FORM.foo ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to

Re: I ma stuck here . In coldfusion query

2008-02-20 Thread Matt Quackenbush
The problem is that your database is not normalized. You need to break your table down and add another many-to-many table. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

Re: OT: CSS Question

2008-02-20 Thread Matt Quackenbush
Heh. The asterisks were placed in by Gmail's editor, to signify bold. I was merely attempting to highlight the "key words". After I sent my reply, I found that other people had already answered the question. For some reason the thread didn't stay together in my Gmail account, so I thought I was

Re: OT: CSS Question

2008-02-20 Thread Matt Quackenbush
Yes. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.c

Re: a sIMPLER url?

2008-02-13 Thread Matt Quackenbush
On Feb 13, 2008 6:27 PM, Charlie Griefer wrote: > On Feb 13, 2008 4:24 PM, Les Mizzell wrote: > > > Remember, you have to make sure that you've got the ISAPI_rewrite > module > > > available to you. Your host can tell you if it's installed. > > > > Heh - the IT guys running the server (Law Firm) d

Re: Passing method/function name to CFC

2008-02-10 Thread Matt Quackenbush
In this scenario, you need to use to do the job for you. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: htt

Re: ColdFusion: Some People Just Don't Know Any Better

2008-02-07 Thread Matt Quackenbush
On Feb 7, 2008 3:26 PM, Dave Watts wrote: > > So, what is Adobe doing so the freelance developers like me > > have MORE customers that ask Coldfusion by name? > > It isn't Adobe's job to make you successful at your business. That's your > job. > > Personally, I would love to see Adobe doing all so

Re: Coldfusion Authority, Purchase Volumes

2008-02-04 Thread Matt Quackenbush
On Feb 4, 2008 11:52 AM, Paul Vernon wrote: > The other point here is security and protection... It is just so much more > secure to use a Credit card than a debit card or cash... Callbacks just > don't happen unless you have a credit card or a special "visa" backed debit > card which is a rare th

Re: intermedia.net

2008-01-31 Thread Matt Quackenbush
On Jan 31, 2008 1:12 PM, Brian Peddle wrote: > I currently have 10+ boxes at HostMySite but we are looking to have a > small footprint at another facility in case of a major issue there. > Does anyone have any feedback on intermedia.net? > > Thanks > I hosted with Intermedia.net for about 7 or 8

Re: Exception Handling

2008-01-23 Thread Matt Quackenbush
On Jan 23, 2008 7:59 PM, Charlie Griefer wrote: > the security hole is that you can arbitrarily manipulate the URL > variable and potentially see information that belongs to another > person. > Right. In which case you should also have code in place that (a) verifies that the ID they've request

Re: Personalized URLs (purls)

2008-01-23 Thread Matt Quackenbush
I've not tried it with spaces, but it most certainly has no problems with hyphens ( - ) or underscores ( _ ) in the names. It seems to be a pretty common practice to either store an alternate "url name" in the database, which will have the underscore or hyphen in it, and use that when building lin

Re: Personalized URLs (purls)

2008-01-23 Thread Matt Quackenbush
On Jan 23, 2008 8:28 PM, Jeff Small wrote: > Does anyone have any experience with these? Apparently they're "all the > rage" and I've seen some SEO url topics about taking pages that might > typically be formed: > http://www.mysite.com/index.cfm?name="MyName"; > > and re-form them as: > http://www

Re: livedocs.adobe.com

2008-01-23 Thread Matt Quackenbush
On Jan 23, 2008 3:33 PM, Chad Gray wrote: > Is it me, or does the livedocs for CF8 take FOREVER to load? Im in > dreamweaver and hit F1 and it pops a new IE window. Then the pages > refresh like 3 or 4 times and after about 10 seconds I can find what I need. When did the LiveDocs ever load

Re: cfimport problem?

2007-12-29 Thread Matt Quackenbush
More than likely you're dealing with a cAsE sEnSiTiViTy issue. Make sure that the path and file name (including extension) are in the correct case. HTH ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic relea

Re: BlogCFC Imports Not Showing

2007-11-14 Thread Matt Quackenbush
Thanks to ScottP, the issue has been resolved. Here is what I did wrong... tblBlogEntries.username = tblUsers.name The correct scenario... tblBlogEntries.username = tblUsers.username Thanks ScottP! Matt On Nov 14, 2007 11:48 AM, Matt Quackenbush <[EMAIL PROTECTED]> wrote: > I

BlogCFC Imports Not Showing

2007-11-14 Thread Matt Quackenbush
I have just done a fresh install of BlogCFC (v 5.9), but I have a ton of "posts" that I am importing from an old database (not a BlogCFC database). I wrote up a little script to pull the data and then insert it into BlogCFC's tblBlogEntries, and have assigned each post to a category by inserting in

Re: Coldfusion hosting recomendation ?

2007-10-21 Thread Matt Quackenbush
I've been using http://www.enterhost.com/ for quite a few years. I strongly recommend them. They're in Dallas, Texas (USA) and are a Windows and ColdFusion shop. On 10/19/07, NUGROHO NOTO wrote: > > Anybody can recommend a VERY GOOD Coldfusion Dedicated Hosting ? > - preferably in Japan (I had

Re: Best Database Engine for ColdFusion (Survey)

2007-10-18 Thread Matt Quackenbush
Of the choices that you've presented, I would undoubtedly go with SQL Server 2005. And don't worry about the comment regarding beta testing it; the product has been out for several years now and is quite mature. :-) I have used all of the following: Access MySQL 3.x, 4.x, 5.x SQL Server 7 SQL S

Re: Best Database Engine for ColdFusion (Survey)

2007-10-18 Thread Matt Quackenbush
On 10/18/07, Brian Kotek wrote: > > I'd make sure to run the database on a separate server from the > CF server. > +1 to that. I meant to mention it, but forgot to. With any sort of traffic, database servers just like to have their own box - not to mention the security benefits (perceived or re

Re: Galleon page

2007-10-16 Thread Matt Quackenbush
+1 on the DNS issue diagnosis. On 10/16/07, Che Vilnonis wrote: > > Ray is having DNS problems. > ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfu

Re: Frameworks: Post vs. Get

2007-10-15 Thread Matt Quackenbush
On 10/15/07, Brian Kotek wrote: > > Back to the original topic, I still wouldn't be referencing the form scope > from within the model. If you want to guarantee that the request was a > POST, > I'd do it in the controller before anything even gets to the model. > Which is precisely what I was ask

Re: Frameworks: Post vs. Get

2007-10-15 Thread Matt Quackenbush
Wowsers! Seems I hit on a hot topic. On 10/15/07, Jochem van Dieten wrote: > > Since the answer to both questions is "No" I will add a third question: > How important is it *really* to know the variable came from a post? > > Jochem > > I don't allow data altering in my apps via a 'get', especia

Re: Frameworks: Post vs. Get

2007-10-14 Thread Matt Quackenbush
I should have clarified my question. I completely realize that the 'form' and 'url' scopes (structs) still exist inside the various frameworks, so I know that I can directly reference them. However, in an "OO world", you're technically not supposed to reference outside scopes. That is what is dr

Frameworks: Post vs. Get

2007-10-14 Thread Matt Quackenbush
Okay, so you pick a framework - just about any framework; Fusebox, ColdBox, mach-ii, Model-Glue. These frameworks fold the form (post) and URL (get) variables into an event object (or attributes in the case of traditional FB apps). But let's say that you want to be sure that the variable came fro

Re: Case Sensitivity

2007-10-05 Thread Matt Quackenbush
A huge AMEN! from Texas. :-) Holy cow, did I just totally agree with Andy Matthews??? ;-) On 10/4/07, Andy Matthews wrote: > > Anyway, I find no use for case-sensitivity. It's only redeeming quality is > that it forces programmers to be consistent in the way their code is > written. > > :) >

Re: Recursion problem

2007-09-20 Thread Matt Quackenbush
http://tutorial478.easycfm.com/ ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Arc

Re: learncf.com is Coming!

2007-08-27 Thread Matt Quackenbush
Curious. Why would you blanketly refuse tutorials that are script based? That makes zero sense to me, but I'm sure I'm just misunderstanding something? On 8/27/07, Dale Fraser wrote: > > Every tutorial must meet the following requirements > > 5. Must be tag based and not script based > ~

Re: OT: AJAX (Just a little)

2007-07-24 Thread Matt Quackenbush
+1 for jQuery. :) ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http:/

Re: cfc question

2007-07-18 Thread Matt Quackenbush
Chad, is indeed escaping your single quotes. You can get around this in a couple of ways. The first is to use preserveSingleQuotes() in your function, like so: WHERE #preserveSingleQuotes(arguments.criteria)# While that is a very easy "solution", you will be opening yourself up to all sorts o

Re: I love CF but it's not fair

2007-06-13 Thread Matt Quackenbush
Jerry, This is absolutely one of the best replies I've ever read. Cudos for nailing it. :-) Matt On 6/12/07, Jerry Johnson <[EMAIL PROTECTED]> wrote: > > There are also a lot of jobs for McDonalds late shift workers. > > =) > > My current programming job is 95% coldfusion, and the ad was for

Re: Jr. Going to Hendrick

2007-06-13 Thread Matt Quackenbush
A) How more appropriate could it be than for Junior to be the # 3 guy? :-) B) I am more than happy to welcome Junior to our team C) I called this late last summer, when no one even believed that he'd leave DEI. Life is good! On 6/13/07, Scott Stroz <[EMAIL PROTECTED]> wrote: > > I know there

Re: Does CF Framework make life easier? Which one to start?

2007-05-17 Thread Matt Quackenbush
On 5/17/07, James Wolfe <[EMAIL PROTECTED]> wrote: > > I cant speak about Frameworks in general, but I can tell you to avoid > FuseBox like the plague. > > If all you ever coded in was fusebox, then maybe its an OK framework to > work with. > > We hired a new developer who told us that FuseBox was

Re: MySQL Syntax (4.1)

2007-03-18 Thread Matt Quackenbush
Looks like I found the answer. No support for subqueries pre-4.1. :-( http://www.databasejournal.com/features/mysql/article.php/3434641 Thank you to all who took the time to look at my issue. Thanks, Matt Can anyone confirm whether or not 4.0.27 supports subqueries? > ~~~

Re: MySQL Syntax (4.1)

2007-03-18 Thread Matt Quackenbush
Oooops. I just found out that this particular database is actually 4.0.27, and not 4.1. According to a few articles that I've found, the 1064 error code indicates a "MySQL version mismatch", with specific regard to reserved words. That is making me think that 4.0.27 does not support subqueries.

Re: MySQL Syntax (4.1)

2007-03-18 Thread Matt Quackenbush
Yes Sir, querying the same table. Could be wrong hereIs your second table suppose to be myTb2 and not > myTb1? You may just be querying the same table I suppose. > ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience ti

Re: MySQL Syntax (4.1)

2007-03-18 Thread Matt Quackenbush
Unfortunately, using IN results in the same syntax error (MySQL vendor code: 1064) Thanks, Matt Try WHERE t1.myOtherCol in ( > ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-p

MySQL Syntax (4.1)

2007-03-18 Thread Matt Quackenbush
Hello, I am receiving a syntax error on this query, and I cannot for the life of me figure out why. SELECT t1.myCol FROM myTbl t1 WHERE t1.myOtherCol = ( SELECT t2.myOtherCol FROM myTbl t2 WHERE t2.myCol = '#myVar#' ); According to the MySQL docs (referenced below) it app

Re: Bean Getter/Setter Return Types

2007-03-14 Thread Matt Quackenbush
You'll find people on both sides of this argument. I'm on the side of "type everything possible". So, using your Framework example, I'd probably type it as 'ModelGlue.Unity.Framework'. I say "probably" because there is a possibility that I'd simply type it as 'Framework'. If the method in quest

Re: Uploading and resizing gif files

2007-03-13 Thread Matt Quackenbush
Efflare's imageCR3 is my recommendation. It's an invaluable tool in my box. http://www.efflare.com/products/cfx_imagecr/ Hope that helps, Matt I've been using iEdit.cfc for processing images uploaded by users and > that's been ok for me until now. Until now all i've wanted to do is > receiv

Re: cfimport vs. cfmodule/cf_MyTag for Custom Tag Calls

2007-03-12 Thread Matt Quackenbush
has no problem whatsoever with dynamic template paths. :-) Very true. Also, I know that CFImport cannot have dynamic template path > (ie. No ## in the template attribute). Not sure if CFModule is the same > way (but I guess that it probably is). > > > .. > Ben Nadel > Certif

Re: Obscenity/Bad Words filter udf/cfc?

2007-03-10 Thread Matt Quackenbush
There's also one at CFlib.org. http://www.cflib.org/udf.cfm?ID=1105 ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www

Re: String Function

2007-03-09 Thread Matt Quackenbush
Oooops... my bad. I think I misread the email. Refer back to what Charlie said. :-) Actually, CF totally ignores "empty" list elements. So, if you're using > listToArray(), you'd just use it like normal. > > > > ~| Crea

Re: String Function

2007-03-09 Thread Matt Quackenbush
Actually, CF totally ignores "empty" list elements. So, if you're using listToArray(), you'd just use it like normal. you'd need to do a replace() function on the string first to replace > any instances of the delimiter appearing twice in succession with > something like a space. > > > > >

Re: SOLVED Please put me out of my misery (was How to expire a page?)

2007-03-08 Thread Matt Quackenbush
Wow. Thanks for posting the solution. I had been working with the exact same issue, and had used everything you just posted except for GetHttpTimeString(). Nothing I tried was working either, but your find is working beautifully for me as well. Matt I think I solved the issue by adding serve

Re: SQL Server DSN, text data type, CLOB is required?

2007-03-07 Thread Matt Quackenbush
I'm not an expert, but I've been using 'text' and/or 'ntext' in SQL Server for years and have never done that, so I'm going to say no, that's not true. Matt A co-worker of mine just told me that in order to use the text data > type in SQL Server, you have to enable CLOB and BLOB in the data > s

Re: A neat valueList() trick....

2007-03-05 Thread Matt Quackenbush
Just a cautionary word: that works wonderfully for straight output, but if you were to do say a listFind() on the altered list, CF wouldn't find the item you were searching for unless you prepended it with a space (e.g. listFind(myList, ' myString') ). But for output, it certainly is a whole lot m

Upload CFC While Enforcing Encapsulation

2007-03-03 Thread Matt Quackenbush
Hello, I've searched around for a solid, encapsulated method of doing file uploads within a CFC, and the closest I've found is the following post on Jared's blog: http://www.web-relevant.com/blogs/cfobjective/index.cfm?mode=entry&entry=BD613BAF-BDB9-5320-E7F02F683C0421A1 I'm hoping there's a new

Re: Image manipulation

2007-03-01 Thread Matt Quackenbush
I'll offer a third 'Yea' for imageCR3 from Efflare. When stacked up against the others, well, they just don't compare. Your server will thank you. Matt ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 1

Re: What is the best resource for a begginer CF Programer?

2007-02-28 Thread Matt Quackenbush
Mark, Welcome to the wonderful world that is ColdFusion. I would highly recommend Ben Forta's WACK (Web Application Construction Kit) for *anyone* (beginner or experienced). As a beginner, it is a great teaching tool. For the experienced, it's a great reference. As you get experienced (or if y

Re: cffile is not waiting for cfexecute to finish.

2007-02-18 Thread Matt Quackenbush
This might do the trick for you... http://www.petefreitag.com/item/85.cfm For what it's worth, I would strongly recommend *against* a previous suggestion of using a loop that runs until the file is created; that could be disastrous in the event that the file writing code has an error. I would h

Re: try/catch inside a tag

2007-02-12 Thread Matt Quackenbush
Dave, Thanks for the explanation, but Ben's reply is actually the answer to your dilemma. In the catch () block, change 'Exception' to 'Any', and it'll perform as expected. Matt On 2/12/07, Dave Hatz <[EMAIL PROTECTED]> wrote: > > Matt, > By "not working", I mean the code will throw an error,

Re: Query-of-Query Issue

2007-02-12 Thread Matt Quackenbush
To quote someone else: "Every time you store a comma-delimited list in a database field God kills a kitty." The main problem with your situation is that there shouldn't be a list in a database field. There should be a separate table that creates the one-to-many or many-to-many relationship. By

Re: try/catch inside a tag

2007-02-12 Thread Matt Quackenbush
What exactly do you mean by "not working"? On 2/12/07, Dave Hatz <[EMAIL PROTECTED]> wrote: > > I am trying to figure out why my try/catch is not working inside the > following code example below. Can someone please clue me in on what I am > doing wrong here? > ~

Re: Fusebox Web Site Design Contest Announced

2007-02-12 Thread Matt Quackenbush
Andy, I apologize for replying before thinking about my replies. I was not meaning to get personal, although I can certainly understand that I came across as such. Again, I apologize. You are certainly entitled to your opinion, as am I entitled to mine. What angered me, and I would guess most

Re: Need help searching for files in a directory

2007-02-10 Thread Matt Quackenbush
Well, it's not actually sending to a database in this particular query; it's querying a previous query. But yes, the CF function will process before making the query request, thereby converting the form var to lower case. Then by using the SQL lower() function on the column that you're querying, i

Re: Need help searching for files in a directory

2007-02-10 Thread Matt Quackenbush
No need for that. If you look at my example, you'll see that I used lCase() ColdFusion function to make sure that the form value was in lower case as well. So it covers it all. On 2/10/07, Bob Imperial <[EMAIL PROTECTED]> wrote: > > Thanks Matt...this covers the two possibilities of upper and l

Re: Need help searching for files in a directory

2007-02-10 Thread Matt Quackenbush
QofQ is case sensitive. So if you search for name LIKE '%Alanis%', it is NOT the same as searching for '%alanis%', or '%aLaNiS%'. The force it to be case-INsensitive, use a couple of functions: SELECT * FROM qryResult WHERE lower(name) LIKE '%#lCase(form.findThis)#%' Hope that helps. On 2/10

Re: Fusebox Web Site Design Contest Announced

2007-02-09 Thread Matt Quackenbush
I think what you meant to say was: "The only issue is that my panties are in a wad because I suck at what I do and so I'm going to bitch and moan that these 'contests' aren't rigged to benefit me." On 2/9/07, Claude Schneegans <[EMAIL PROTECTED]> wrote: > > The only issue is about "contests" whe

Re: Fusebox Web Site Design Contest Announced

2007-02-09 Thread Matt Quackenbush
Anyone with *any* business sense at all knows that contests are an *extremely* good marketing/growth tool. Only the completely id10Tic people in this world can even consider the notion that contests are bad. On 2/9/07, Eric Haskins <[EMAIL PROTECTED]> wrote: > > I just hope others that were thin

Re: Fusebox Web Site Design Contest Announced

2007-02-09 Thread Matt Quackenbush
Hell, if I had any design talent (which I unfortunately do not, and have given up trying to acquire it), I'd enter the contest just to make sure my name was published. That way I could be guaranteed that you would never call me for work. ~~

Re: Fusebox Web Site Design Contest Announced

2007-02-09 Thread Matt Quackenbush
Andy and Claude, I strongly urge you both to pursue other careers. More than likely, given your vast understanding of business principles, your are most likely to succeed in life if you move into government, and more specifically, business legislature. After all, in a position like that, you'll

Re: Anyone interested in Railo hosting?

2007-02-06 Thread Matt Quackenbush
At the risk of sounding like a complete [EMAIL PROTECTED]&!, why would >anyone< want to go backwards and use Railo? I mean, it's still not even compatible with CF MX. I'm sure I speak for an extremely high percentage of CFers out there when I say, "Thank God we're not in the pre-MX days anymore!

Re: search for muliple keywords

2007-02-03 Thread Matt Quackenbush
Dan, I just posted a UDF for this over at EasyCFM a couple of days ago. Hope it works well for you as well. http://www.easycfm.com/forums/viewmessages.cfm?forum=10&topic=10867 Matt On 2/3/07, Dan Wiley <[EMAIL PROTECTED]> wrote: > > Can anybody show me an example of how to search multiple ke

Re: PostgreSQL Case Sensitive Data?

2007-01-13 Thread Matt Quackenbush
I was directed to the following link, which appears to have promise, but haven't researched it enough yet to know. http://gborg.postgresql.org/project/citext/projdisplay.php As far as a case-insensitive collation, I've found absolutely nothing that suggests you can do so on an imported database.

Re: PostgreSQL Case Sensitive Data?

2007-01-13 Thread Matt Quackenbush
tions. Jochem, I am responding inline to your other comments... On 1/13/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > > Matt Quackenbush wrote: > > > > Now, I know that the table names and columns are case sensitive, and I > > already took care of all of those i

Re: weirdness with application scope variables

2007-01-12 Thread Matt Quackenbush
To set the struct in your example into the application scope, you'd simply set it to an application-scoped variable when calling the method. Dave already answered your "why not" question, so I'll just say: "yeah, what he said!" :-) HTH Matt On 1/12/07, Kay Smoljak <[EMAIL PROTECTED]> wrote

Re: PostgreSQL Case Sensitive Data?

2007-01-12 Thread Matt Quackenbush
Jon, I wholeheartedly agree that a password should be a case sensitive check, without a doubt. My apps always do that. But that kind of illustrates my point: *my apps handle it*. I believe that case rules should fall on the shoulders of the app, not the database. I have no problem whatsoever

Re: weirdness with application scope variables

2007-01-12 Thread Matt Quackenbush
The variables from within the CFC will NOT go to the application scope. They belong to the CFC itself. Also, I doubt very much that you'll find many that will condone using returnvariable="application" . HTH Matt On 1/12/07, Kay Smoljak <[EMAIL PROTECTED]> wrote: > > I was experimenting with a

PostgreSQL Case Sensitive Data?

2007-01-12 Thread Matt Quackenbush
Hello, After successfully importing my entire MS SQL database and having the Pg server up and flying, I decided to make a copy of my site and test everything out. I went to the login screen, filled in my user name and password and submitted. After several unsuccessful attempts, it dawned on me w

Re: Transferring from MS SQL (2000) to PostgreSQL

2007-01-12 Thread Matt Quackenbush
All- I am very pleased to announce that I have the entire SQL Server database duplicated on PostgreSQL, indexed, PKs, FKs, clustered, etc, and it ROCKS! Not only that, but my 43-line queries all work properly and are lightening fast! Unless I come across something completely unexpected, I feel co

Re: Client asked me: "Why you use coldfusion?"

2007-01-12 Thread Matt Quackenbush
LMAO! Couldn't have said it better myself! On 1/12/07, Emmet McGovern <[EMAIL PROTECTED]> wrote: > > Holy crap. I think everyone is missing the real argument. Just say this. > "For the price I'm quoting, I'll code in whatever the damn hell I please!" > That should be argument enough. > > -e >

Re: Transferring from MS SQL (2000) to PostgreSQL

2007-01-12 Thread Matt Quackenbush
Jon, Your solution worked just fine actually :-) Thanks again! Matt ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adob

Re: Transferring from MS SQL (2000) to PostgreSQL

2007-01-12 Thread Matt Quackenbush
x27;t have to provide the sequence name. > > HTH, > Jon > > On Jan 12, 2007, at 2:41 PM, Matt Quackenbush wrote: > > > I don't know why i wrote the '+1' in there when I wrote the email. > > I'm not > > using it in the actual statement. The

Re: Transferring from MS SQL (2000) to PostgreSQL

2007-01-12 Thread Matt Quackenbush
I don't know why i wrote the '+1' in there when I wrote the email. I'm not using it in the actual statement. The specific syntax error is that the ( is invalid. On 1/12/07, Matt Quackenbush <[EMAIL PROTECTED]> wrote: > > Okay, so far I'm *really* liking Pg.

Re: Transferring from MS SQL (2000) to PostgreSQL

2007-01-12 Thread Matt Quackenbush
Okay, so far I'm *really* liking Pg. I have successfully imported all of my tables and data, and have everything fixed with one exception: updating the currval() of the sequence for the 'auto_number' fields. I can go through each sequence one at a time with the GUI and update it, but I'd obviousl

Re: Transferring from MS SQL (2000) to PostgreSQL

2007-01-11 Thread Matt Quackenbush
Jochem, Thank you. That was the problem. I didn't realize that it was needed. Remote connection up and running; time to play! :-) Matt On 1/11/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > > How did you write your IP address? Did you add the /32 to use > *CIDR-address* notation? > > Jo

Re: Transferring from MS SQL (2000) to PostgreSQL

2007-01-11 Thread Matt Quackenbush
On 1/11/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > > > LOG: invalid IP mask "password" in file "C:/Program > > Files/PostgreSQL/8.2/data/pg_hba.conf" line 72: Unknown host > > You are missing a column in your pg_hba.conf. Do you have the real one > somewhere? > > Jochem Which column am

Re: Transferring from MS SQL (2000) to PostgreSQL

2007-01-11 Thread Matt Quackenbush
Jochem, This is a bad combination because they result in a cleartext communication > and even a cleartext password. Best would be to install a certificate and > use hostssl instead of host, but at least you should use md5 instead of > psssword. Thank you for the tip on the ssl/md5/password issue

GoDaddy Dedicated Servers

2007-01-11 Thread Matt Quackenbush
Hello, I was looking at GoDaddy's dedicated server pricing, and it's cheap as... well, it's cheap. Typically speaking, when cheap and hosting are used in the same sentence I run the other direction. However, GoDaddy is generally known as a reputable company, with good uptime, etc on their networ

Re: A few Eclipse/CFEclipse questions...

2007-01-11 Thread Matt Quackenbush
SWEET! I knew you guys would know more about it than me! :-) Thank you Jacob! On 1/11/07, Jacob Munson <[EMAIL PROTECTED]> wrote: > > > > > In DW, it has a really cool option that allows you to find/replace text > in > > every file throughout the site/project - whether the file is currently >

Re: Transferring from MS SQL (2000) to PostgreSQL

2007-01-11 Thread Matt Quackenbush
Hmmm... I setup PostgreSQL on one of my production (remote to me) servers. It's all working wonderfully from localhost. To prepare it for allowing remote access, I added the following line to the pg_hba.conf file: hostsameuserall (the IP, e.g. 555.555.555.555)password I then add

Re: A few Eclipse/CFEclipse questions...

2007-01-11 Thread Matt Quackenbush
Hmmm... since we're talking about Find/Replace in Eclipse, I have one that I haven't yet found, and thought that maybe some of you might have. In DW, it has a really cool option that allows you to find/replace text in every file throughout the site/project - whether the file is currently opened of

Re: Transferring from MS SQL (2000) to PostgreSQL

2007-01-10 Thread Matt Quackenbush
Sweet (regarding the single interface)! Jon, I was under the impression that varchar() was still a valid datatype in Postgre, and would not require changing to 'character varying'. http://www.postgresql.org/docs/8.2/static/datatype-character.html Am I mis-reading that? Dave, Thanks for the tip

Re: Transferring from MS SQL (2000) to PostgreSQL

2007-01-10 Thread Matt Quackenbush
Am I correctly understanding what I'm reading on their site that Aqua Data Studio supports ALL of the listed databases in the same client? (As opposed to having a different one for each DB?) ~| Create robust enterprise, web RIAs

Re: Transferring from MS SQL (2000) to PostgreSQL

2007-01-10 Thread Matt Quackenbush
Joshua, Thanks for the pointer and the link. Jim, Are you referring to v6 RC1? That's all I've seen so far on their site. Thanks, Matt On 1/10/07, Jim Wright <[EMAIL PROTECTED]> wrote: > > Joshua Cyr wrote: > > Wasn't Aqua Data Studio free at one point? I swear I didn't buy it... > but >

Re: Transferring from MS SQL (2000) to PostgreSQL

2007-01-10 Thread Matt Quackenbush
I have found this software, but it appears to be brand new. Has anyone had any experience with it? Or with something similar that you would recommend? http://www.download3k.com/Business-Finance/Database-Management/Download-MS-SQL-Server-PostgreSQL-Import-Export-Convert-Software.html ~~

Transferring from MS SQL (2000) to PostgreSQL

2007-01-10 Thread Matt Quackenbush
Hello, I have a heavily used and ever-growing MS SQL database that I would like to transfer over to PostgreSQL. It is currently 143mb (plus about 67mb in log files). The database is relatively basic, in that it does not currently use any stored procedures, and the tables makeup is pretty sql-gen

Re: PostgreSQL vs. MSSQL

2007-01-10 Thread Matt Quackenbush
Sweet! Sorry about that Jochem, I read the one Chapter (7), but didn't follow the referenced links. Obviously, I should have. Thanks, Matt ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with F

Re: PostgreSQL vs. MSSQL

2007-01-10 Thread Matt Quackenbush
I just read through Chapter 7 of the PostgreSQL docs ( http://www.postgresql.org/docs/8.2/static/queries.html) regarding queries, and could find no examples or mention of a sub-query used in the select list. For example: SELECT t1.foo, (SELECT COUNT(t2.id) FROM tblTwo t2 WHERE t2.id = t1.id) AS m

Re: CF and OOP - Controller

2007-01-09 Thread Matt Quackenbush
Rich, Thanks for the kick-ass reply. Somehow it got buried beneath the piles of email, and I just now saw it; sorry about that. Your post is most informative, and very helpful. As of a couple of days ago, being 6+ weeks behind on a project that I was going to run on my new framework has made me

Re: PostgreSQL vs. MSSQL

2007-01-09 Thread Matt Quackenbush
need to be aware of when running on XP Pro along with IIS and CF 7.x in my dev environment? Thanks, Matt On 1/9/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > > Matt Quackenbush wrote: > > Thanks for the reply. I forgot to post his specific gripes about > it. Here >

Re: PostgreSQL vs. MSSQL

2007-01-09 Thread Matt Quackenbush
Jon, Thanks for the clarification. Matt On 1/9/07, Jon Clausen <[EMAIL PROTECTED]> wrote: > > On Jan 9, 2007, at 3:23 AM, Matt Quackenbush wrote: > > > Thanks for the reply. Do you currently run MySQL and/or PostgreSQL on > > Windows boxes? If so, what version(s)

Re: PostgreSQL vs. MSSQL

2007-01-09 Thread Matt Quackenbush
Jon, Thanks for the reply. Do you currently run MySQL and/or PostgreSQL on Windows boxes? If so, what version(s) for both the db server and windows servers? The cost is currently not an issue, although it certainly has the potential to become one in the relatively near future, at the current da

Re: PostgreSQL vs. MSSQL

2007-01-08 Thread Matt Quackenbush
Jordan, Thanks for the reply. I forgot to post his specific gripes about it. Here is a quick summary: - non-standard sql - difficult to backup / migrate - user authenication is weak - difficult to setup - difficult to manage Your post was most informative, for sure. But there's one thing that

PostgreSQL vs. MSSQL

2007-01-08 Thread Matt Quackenbush
Hello, I've always used MSSQL and quite frankly am quite fond of it - except for licensing costs. I've read a few posts here and there where people have talked highly of PostgreSQL, so I'm thinking about giving it a shot on a new server (windows box). I mentioned this to a buddy of mine who is a

Re: CF and OOP - Controller

2006-12-31 Thread Matt Quackenbush
Hmmm... I tried to do that, but when I submit the form, it gives me only a blank page (with just the masthead and sidebar). I tried on 4 different browsers, and got the same result. :-( On 12/31/06, Dan Vega <[EMAIL PROTECTED]> wrote: > > I just picked up a single pdf download for 6.95. This wa

Re: CF and OOP - Controller

2006-12-30 Thread Matt Quackenbush
Nic, Thank you for that. I actually just finished reading a couple of articles on your blog that I thought cleared that up for me, and your reply here verified that your articles actually DID get thru my thick skull. :-) Matt ~~

Re: CF and OOP - Controller

2006-12-30 Thread Matt Quackenbush
On 12/30/06, Dave Merrill <[EMAIL PROTECTED]> wrote: I think of the controller as the orchestrator, the one who examines the > context, calls the models needed to get any data required, then passes > that to > the view for rendering. He's the traffic cop, kinda. Precisely. That's a much better

Re: CF and OOP - Controller

2006-12-30 Thread Matt Quackenbush
Doug, I understand your point that CF is not a "true" OO language, but since it is now possible to quickly and efficiently apply so many great OO principles to CF, I want to learn every bit of it that I can as it relates specifically to CF. There are three main reasons for that: 1) from a progra

<    1   2   3   4   5   6   7   >