RE: MySQL Conversion

2011-04-20 Thread Zac Wingfield
the MySQL Migration Tool Kit. ive never had much luck with this. I've converted many DBs from MS to My. So many that i bought some third party software to do it for me. takes about 30 seconds. Let me know if i can help out. zac Regards, Zac Wingfield Operations Manager For and on b

RE: Good CF Host in Texas

2011-04-15 Thread Zac Wingfield
yes sorry everyone. i was thinking of gowestwebdesign.com which is the same company. isn't Utah just up the road from Texas? :-) Regards, Zac Wingfield Operations Manager For and on behalf of, Allied Facilities.com Limited 01903 723999 7 Wickham Business Centre Harwood Road Littleha

RE: Good CF Host in Texas

2011-04-15 Thread Zac Wingfield
try gowestweb.com over your way somewhere, not exactly sure where though Regards, Zac Wingfield Operations Manager For and on behalf of, Allied Facilities.com Limited 01903 723999 7 Wickham Business Centre Harwood Road Littlehampton West Sussex BN17 7AU For more information about Allied

Re: CFM Generators

2011-03-30 Thread zac wingfield
Cool, book marked, thanks again zac > > If anyone else knows of similar sites please do post some links. > > Zac, > > Thanks for the kind words. The best place to look for these sorts of > things is Charlie Arehart's brilliant CF411. I see that I haven't >

CFM Generators

2011-03-30 Thread zac wingfield
post some links. thanks zac ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/mess

Re: Open source ColdFusion forums

2011-03-28 Thread zac wingfield
andle everything from resource allocation to billing to auto account creation and even domain registration. fancy biting that one off? :-) zac P.S. lots of individual packages already exisit that could be brought together to make this happen. FileZilla for FTP LightHouse Pro for bug tracking and su

Re: social networking app in CF

2011-03-25 Thread zac wingfield
Hey, thats brilliant! are you sharing it? perhaps post it on riaforge http://www.riaforge.org/index.cfm?event=page.category&id=1 nice work! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-A

Re: who's in charge around here?

2011-03-22 Thread zac wingfield
ok, i'm getting idea about using it as a mailing list. :-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/gro

Re: who's in charge around here?

2011-03-22 Thread zac wingfield
>Perhaps you'd better enjoy the mailing list vs. the web interface? yes good point. i try not to respond directly via email because of my email header/footer. I use my work email address for everything which is unrelated to any web dev work that i do. I work for MI5 so i wouldn’t want people

who's in charge around here?

2011-03-22 Thread zac wingfield
having just recently found H.O.F ive used it a few times. there are some really helpful, knowledgeable guys monitoring these lists and I’ve received some great help from the CF Newbie list. however the web site needs some attention. it's slow to respond and poorly presented. why are all

Re: WYSIWYG inline editor on mac browsers

2003-10-08 Thread Zac
On Wednesday, October 8, 2003, at 06:01  PM, Peter Tilbrook wrote: > Perhaps the open source FCK Editor? (http://www.fredck.com/FCKeditor/) From their webpage Requirements Client Side: Internet Explorer 5+ over Windows with _javascript_ enabled (for rich text editing) I think that it only wor

Re: Copying session vars to request scope

2003-10-07 Thread Zac
On Tuesday, October 7, 2003, at 06:02  PM, Dave Watts: > In my experience, this has occasionally caused severe performance > degradation, so you'll want to be very careful when doing this. In > general, > I'd try to avoid doing it at all. Really?  That is quite surprising. So is it the duplicat

Copying session vars to request scope

2003-10-07 Thread Zac Belado
Can anyone see any reason why you wouldn't want to copy session scope variables to a request scope variable if all you want to do is to test the values in them but not set them? It strikes me that this would be more efficient than locking the session scope each time you wanted to test the variable

Re:Access database 401 error

2003-10-07 Thread Zac Belado
>This error isn't related to the database connection.  A 401 means that >your web server has the requested URL protected and the client (in >this case, the ColdFusion scheduler) is being rejected by the web >server.  The ColdFusion scheduler connects to the server as an HTTP >client (so, it loo

Access database 401 error

2003-10-07 Thread Zac Belado
We are running into an unreproducible error when trying to connect to an Access database using CF 5. Our system has a series of scheduled events and in some cases our clients are reporting a 401 Unauthorised error when the scheduled event tries to connect to an Access database. The database conne

Re: mx tag help/insight for studio 5

2003-08-19 Thread zac spitzer
Massimo Foti wrote: >>I have CF Studio 5 and am just starting to code for MX a bit. Is there >>anyway I can get tag insight and help files for the new MX stuff such as >>cfc's? I looked around on the macromedia site a bit but couldn't find >>anything. >> >> > >The files for Homesite+ should

Re: XML Serialisation

2003-08-19 Thread zac spitzer
Neil Middleton wrote: >Guys, > >I'm after a tag or function which can convert a complex cf data type into an >xml packet. I've seen the ones on CFlib that convery queries and structs >but I'm after one which can do combinations of datatypes all in one go and >return a valid xml packet. > >I would

Re: OT: packet sniffer

2003-08-18 Thread zac spitzer
ny alternatives (free if possible). > try mozilla with http://livehttpheaders.mozdev.org .. it really rocks or http://www.proxomitron.info/files/index.shtml which is a filtering proxyserver, which is cool anyway, but it has a log window where you can also see all the http

Re: Mach II 1.0 released

2003-08-14 Thread zac spitzer
zac spitzer wrote: >Mach II has been released > >http://www.mach-ii.com > >with three sample apps, roulette, contactmanager and shopping cart > >redsky required > >being australian, I am thinking this is more of the usual aussie jvm >date problems >as i'm hi

Mach II 1.0 released

2003-08-14 Thread zac spitzer
Mach II has been released http://www.mach-ii.com with three sample apps, roulette, contactmanager and shopping cart redsky required being australian, I am thinking this is more of the usual aussie jvm date problems as i'm hitting a date problem on the parsing of the xml config file.. anyone g

Cold Fusion Studio 5 CFMX tag updater?

2003-08-14 Thread zac spitzer
is there a tag updater for cf studio 5.0 which contains CFMX tags, the only one i find on the MM site is http://www.macromedia.com/software/coldfusionstudio/productinfo/resources/tag_updaters/ and it doesn't contain anything except vtms for cf 5.0 era tags z ~~~

Re: Page Context Bug?

2003-08-01 Thread zac spitzer
Matt Liotta wrote: >>It does make it difficult to write efficient frameworks using CFCs >>tho' so, for example, Mach II will require Red Sky to run efficiently. >> >> >> >I'm glad you finally admitted that. > so matt, you said a while back it was impossible to write mvc frameworks in cfmx, wi

Re: CF tag for highlighting text in a textfield?

2003-08-01 Thread zac spitzer
they r access more by rows and columns zac ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www

Re: MachII Speed (was RE: Mach II)

2003-07-16 Thread zac spitzer
Haggerty, Mike wrote: >1) Speed. Each page took > 700 ms to generate with debugging off. This was >using a slow server: Apache / XP / RedSky / Celeron 733 with 512 MB RAM. >However, FB3 pages doing just about the same amount of work average ~100 ms >on the same server. > coz of the page context bu

Re: cf5 - ColdFusion Graphing Server = JRun??

2003-06-06 Thread Zac Spitzer
n of jrun license wise, you can't use it legally for anything else than generator (or graphing server) z -- zac spitzer - mailto:[EMAIL PROTECTED] http://fraggle.datagear.net/ radio://+61 405 847 168 / fixed://+61 3 9528 6775 ~~~

Re: New to Java and MX

2003-03-05 Thread Zac Spitzer
> I've tried this (mind you I am totally lost) > > > > > > > The first two lines seem accepted fine, but when I add the third, it starts throwing > errors. > Any help would be appreciated. what's the errors being thrown? z ~~

Re: Character Encoding - Reward Offered!

2003-02-05 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Eric Hoffman wrote: | The xml got changed this year and it all comes back UTF-8 encoding. Is | this what you are looking for? but then the xml version would need to be 1.1 at the start, otherwise not if it 1.0...i think z -BEGIN PGP SIGNATURE---

Re: sql 2000 vs sql 2000 enterprise

2003-02-05 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tony Weeg wrote: | can someone explain to me, very high level, what the difference is | between | | sql server 2000 Standard Edition | sql server 2000 Enterprise Edition | | we have 2000 ent edition on our servers now, however we are about to | configu

Re: Replication - Mirroring Software for Linux?

2003-02-05 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mike Brunt wrote: | We are about to add a new production environment that will be CFMX on Linux. | Can anyone recommend good replication software for Linux as this will be a | clustered environment. rsync would be a good starting point z -BEGIN P

Re: all records deleted from table

2003-02-05 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jochem van Dieten wrote: | Zac Spitzer wrote: | |>Kay Smoljak wrote: |>| |>| A tip I picked up from somewhere - it might even have been this list |>| - is to not ever actually delete records using code. Instead, I have |>| a dtDeleted

Re: all records deleted from table

2003-02-05 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kay Smoljak wrote: |> A long time ago, I made a really stupid mistake that results in |> deletion of all data from a table... | | | A tip I picked up from somewhere - it might even have been this list | - is to not ever actually delete records using co

faxing from cf

2003-02-03 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 what r people using for online faxing solutions ( need to work in europe ) with only a tcp-ip connection z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+PnEU1lRHdy

Re: Screening files before CFFile upload: Follow-up

2003-01-30 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 webguy wrote: | becuase you can do this | | only when cold fusion is not running under a restricted user acount z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+O

Re: PDF Conversion Tools Question

2003-01-23 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 cflist wrote: | We use AdLib for converting large amounts of uploaded resumes in all | sorts of file formats to PDF. And it works great. | | We were using ActivePDF, and it worked well at converting, but the | application always seemed to hang and spit

Pet Market Benchmarks?

2003-01-23 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 does anyone know of some benchmarks of pet market against the java or .NET versions z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+MDU31lRHdy8ASusRAiNeAJ9eEiy

SQL 2000 sp3

2003-01-21 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 http://www.microsoft.com/sql/downloads/2000/sp3.asp z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+LYPM1lRHdy8ASusRAofVAJ0Zz+wl/Rqa3wOuqXKE4oX+JLxWfACgrT/c xyQnP

Re: Next N" Navigation and query caching theory question

2003-01-17 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | needs to get run again? Should I do something like append the | CFTOKEN for that user's session to the query name so that it is | unique? Or should I store the query output as an array in a session | variable? store them in a session structure key

OT: mac cfmx zdnn et confused!

2003-01-07 Thread Zac Spitzer
http://zdnet.com.com/2001-11-0.html?legacy=zdnn Macromedia heats up ColdFusion MX Adobe touts three new versions of its applications server software that will work with systems running on BEA's WebLogic, IBM's WebSphere and Sun's Sun ONE server software. adobe now makes mx? :-) z ~~

Re: Text images on the fly

2002-12-20 Thread zac sitzer
> > >Does anyone have any pointers for creating GIFs on the fly? I would like >to create dynamic headings for one of our portals (such as the "quick >link" header on this page: http://my.georgetown.edu/) > > css2 would work 2 :-) cfx_image, imagemagik, cfx_image_cr from efflare.. the first 2 are

Re: How to do this without the subselect?

2002-12-19 Thread Zac Spitzer
Rick Faircloth wrote: > Hi, all. > > How can I get the same results as this query with using the subselect? > > > > Select UW.UtilityWaiverID > from utilitywaivers UW > where Month(UW.IssueDate) = #Form.Month# > and Year(UW.IssueDate) = #Form.Year# > and UW.

OT: browser stats, mozilla rising

2002-12-19 Thread Zac Spitzer
few interesting stories around the web today about mozilla's market share rising... this is the stats from heise.de a big german news site, where mozilla based browsers now accounting for 19.4% of users http://translate.google.com/translate?u=http://www.heise.de/newsticker/data/anw-18.12.02-000

Re: OT : Mac / IE / OS X

2002-12-18 Thread Zac Spitzer
Robertson-Ravo, Neil (RX) wrote: > I'm running into some of the very problems you mention. > I tried "Decimal" as the field type, but 100.5 gets rounded up to > 101.00...not good. > > I tried Integer, but when, for example, 100.50 gets entered into a > formfield, > then inserted into the db, it ge

Re: Generating PDFs in CF

2002-12-17 Thread Zac Spitzer
Ciliotta, Mario wrote: > Hi, > > I was wondering if anyone has any information on how to create a PDF > on the fly in CF. I have been told to look at Active PDF, but right > now there is no money to purchase that tool, so I was looking of > either a custom tag or maybe an article or two on how to

Re: CFMX: Caching files

2002-12-17 Thread Zac Spitzer
Dave Carabetta wrote: >>Hey all, >> >>I am running into an issue with CFMX apparently not showing the latest >>files that I place on the server. >>If I make a change to a file, say showdetails.cfm on my machine and load >>that page from the webserver, >>it shows me the previous page, not the page I

Re: Compare Two Lists - Keep What Is Similar

2002-12-17 Thread Zac Spitzer
Scott Brady wrote: >> Hi everyone. I am looking for a way to compare 2 different lists of >> information, and after comparing them keep which records are >> exactly the same. > > > I'd probably convert them both to arrays. Then, I'd loop along the > first array and look for each element within t

Working with CF & MMS enabled phones

2002-12-17 Thread Zac Spitzer
anyone got any good pointers on working with these next gen gsm phones, like the nokia 7650 with the built in camera and GPRS? what do i need server side to recieve mms in coldfusion? i see there are two options, email or http(s) z ~~

Re: mySQL & CF (url injection info)

2002-12-16 Thread Zac Spitzer
Cary Gordon wrote: > CFQueryParam gives you an easy way to validate the query params. Some > clever, bored hackers have figured out how to do things like pass a drop > table query through the header. It is an even easier exploit if you are > passing query parameters through the url string. a

Re: Verity vs. SQL Server 2000 Full-Text

2002-12-16 Thread Zac Spitzer
paul smith wrote: > In my experience with storing recordsets in cached structures, subsequent > reading records from the structure was slower than reading the same records > from a cached query. > > Is this expected behavior, or did I screw up? (first time again) probably, show us your code...

Re: Verity vs. SQL Server 2000 Full-Text

2002-12-16 Thread Zac Spitzer
Matt Kornguth wrote: > Would love to hear people's feelings and relative > advantages/disadvantages of each.Need to make a decision and I'm > vacilating between the two. really simple advantage of verity is that it's way more intelligent than sql-2000/full text/index server truy searching on m

Re: CF 5 & PDF - FDF files

2002-12-10 Thread Zac Spitzer
> You really only NEED activePDF (or something similar) if you want the > users to be able to save the generated PDF files with the fields > filled out. If you just want them to print it (without being able to > save the files), you can do it all within CF. (I believe there is a > custom tag whic

Re: Lists vs. Arrays vs. Structures

2002-12-09 Thread Zac Spitzer
Michael Dinowitz wrote: > You can see the code here: > http://www.houseoffusion.com/_library/maketree.txt > Your example will fail as there can be more than one item with the same > 'parent', which is what we're looking for. No matter what, we have to do a > search and the list search functions see

Re: Lists vs. Arrays vs. Structures

2002-12-09 Thread Zac Spitzer
Michael Dinowitz wrote: > I think that a new array search function might be in order here. Something to > look through an array for a value and return its index. > >>I'm not sure what you are really trying to accomplish here. I agree with matt, are you working on the maketree tag in cf? lets tal

Re: Lists vs. Arrays vs. Structures

2002-12-05 Thread Zac Spitzer
Michael Dinowitz wrote: >>isn't structkeyexists better than structfindvalue? as our jedi friend >>says, after not evalutating, cflocking I think that's his next biggest tip > > It's better if you just want to know if the value exists. I need to know where > it exists. > > >>my experience is that

Re: Nested Query Loops

2002-12-04 Thread Zac Spitzer
Jeff D. Chastain wrote: > I am not even making it that far. I am getting an error on query="qry2"> stating that qry2 is not a recordset. If I do a prior to the first loop, qry2 is a recordset with several rows of data. > If I do a loop), then qry2 is null. For some reason the variable is just

Re: Nested Query Loops

2002-12-04 Thread Zac Spitzer
Jeff D. Chastain wrote: > I was referring to the inner query using the full scoped name - > variables.queryName. > > So, why does setting newQueryName = variables.queryName PRIOR to looping > the first query change anything? Both variables are in the variable > scope and are created prior to the

Re: Lists vs. Arrays vs. Structures

2002-12-04 Thread Zac Spitzer
Michael Dinowitz wrote: > I'm rewriting my CFMakeTree tag in order to make it tighter and work in CFMX > better. One of the assumptions I had was that Lists would be problematic in > comparison to Arrays or Structs. My first test was to find a value in one of > these data collections. > For Lists I

Re: CFX_Image - Quality of images not good when rotating

2002-12-03 Thread Zac Spitzer
Craig Dudley wrote: > I'd stick to cfx_image then, it works well, can read and convert many, > many formats. It's fast enough as well, as long as you don't run it on > the front end of your site. just make sure your using the latest version too http://www.kolumbus.fi/jukka.manner/ z ~~~

Re: Checking SESSION variable

2002-12-03 Thread Zac Spitzer
FlashGuy wrote: > Hi, > > I have session variable that contains the directory name > "session.strFileName". I also have another session variable > "session.ShowMe" that contains multiple directory names > (comma-delimited) which i'm setting from my database. Basically, i > need to check if the di

Re: When CFHTTP fails, use WGET

2002-11-26 Thread Zac Spitzer
Craig Dudley wrote: > I use a self written java cfx, took 2 hrs to write (I'm a java n00b) and > is massively faster than cfhttp, granted it's a little more simple but > it works well. Using a w32 utility with cfexecute is likely to be even > slower than cfhttp, I wouldn't go there to be honest. If

Re: Application variables

2002-11-25 Thread Zac Spitzer
Bryan Stevenson wrote: > You have to restart CF to reset APPLICATION vars (timing out the app might > work too). application=strucnew(); z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: ht

Re: How to get a JPEG's width/height (not cf_imgagesize)?

2002-11-21 Thread Zac Spitzer
Bob Haroche wrote: > I need to determine the width and height of JPEG's being uploaded. I've used > the free cf_imagesize but it sometimes returns the wrong dimensions. I'm > told it's just buggy with JPEG's. > > I'm deploying to a shared hosting situation so I can't control what can be > installe

Re: Gif Pipes

2002-11-20 Thread Zac Spitzer
Jochem van Dieten wrote: > Adrian Lynch wrote: > > >>www.depressedpress.com used to have something but the site isn't >>working for some reason. another way to do this that is becoming more common is like this document.write(''); j.cfm then returns javascript which gets added to the body of t

Re: java cfx and administrator woes

2002-11-13 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | Any suggestions on what to try next? do you have the CF 5.0 hotfixes installed? z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE90nMU1lRHdy8ASusRAi9WAJ9ij1hsFR9

Re: Compare code on two pages...

2002-11-12 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Adrian Lynch wrote: | Print out both versions, put them together and hold them up to the light :OD | | | -Original Message- | From: Chris White [mailto:whitec@;earthlink.net] | Sent: 12 November 2002 13:10 | To: CF-Talk | Subject: Compare code

cfqueryparam in MX

2002-11-12 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: | Well, it's good to learn Rick. For further reading on | check out Ben Forta's article: | | http://www.macromedia.com/desdev/articles/ben_forta_faster.html | | Anyway, I would advise anyone working with *any* db to use query

Re: OT: good Meta taggers

2002-11-12 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Carlisle, Eric wrote: | Hi CF-Talkers, | | I'm looking for a good meta tagging mechanism -- something that'll build | good description and keyword meta tags from text content. FYI: meta keywords are dead, google never even read them http://searchengi

w2k optimal directory size?

2002-11-11 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 anyone know what w2k & ntfs5 's optimal file count per directory is? ie I have 1,000,000 files, splitting them in to dirs with 5000 files, or 1000 files per directory... this is for cfcontent returned content, linked to a db with a security check, so

Re: Simple serial interface and CF???

2002-11-08 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kris Pilles wrote: | Can I read data vai SSI into a CF application??? | | We have symbol datawand III and I would like to read the data from the | wand directly into my app... can I do this??? if you can find a commandline tool (ie dos ) you can alway

Re: JSP share with CF 4.5?

2002-11-08 Thread Zac Spitzer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chris Norloff wrote: | I have a request to get JSP's and CFML (CF 4.5) to share data. My first response is to say "Easy - buy CFMX" | | In the meantime, they'd like JSP's and CFML to share data. Can they share jsessionid or something? use your databas

Re: Running custom tag

2002-11-06 Thread Zac Spitzer
FlashGuy wrote: > Hi, > > I downloaded the custom tag . I changed the path of my > custom tags directory to e:\inetpub\customtags and added the custom > tag path via CF Administrator and deleted the default path of > c:\cfusion\customtags. When I run my template with the I > get the following err

Re: Deleting duplicate values in list

2002-11-06 Thread Zac Spitzer
Dowdell, Jason G wrote: > Hi all, > > Does anyone know of an easy way to delete duplicate > values from a list. > > For example: > > List = "Jason, Jeremy, John, Jason, Jack" i think the quickest way is to create a struct, make each list item a key in the struct and then return the structkeyli

Re: Max length of Text Data?

2002-10-24 Thread Zac Spitzer
Matthew Walker wrote: > You can't apply max() to a text datatype. So how about: > > SELECT MAX(LEN(CAST(textdatafield AS nvarchar(4000 > > If the result is < 4000 then it will work. If not, it won't. Or you > could use varchar(8000). and you can only stored 8000 bytes in varchars in a row

Re: How can you get the latest version of a page.

2002-10-18 Thread Zac Spitzer
Adams, Stephen wrote: > Hi all, > > How can I get the latest version of a CF page. I am opening a page in a > popup window and I want the latest version, not the one stored in the > cache, > I'm not sure how to do this can anyone give me any pointers. which sets http headers that tells the

Re: Counting Page Views

2002-10-11 Thread Zac Spitzer
>>I have a spec on a project that has me counting page views in order to >>generate a 'most popular' list of the 10 most commonly >>clicked on links. >> >>Has anybody done anything like this? >> >>Initially I was thinking of a db counter that incremented a >>field in my db >>as people viewed the

Re: Page Expires

2002-10-11 Thread Zac Spitzer
Everett, Al wrote: > This is what I use: > > > > you can also use the confusingly named GetHttpTimeString(date_time_object) function for the same effect z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?

EU internet law resources

2002-10-08 Thread Zac Spitzer
I'm looking for some information regarding EU law and the internet, with regards to user agreements, privacy and what is legal and what isn't, in plain english or better from a developer point of view things in the direction for example that the MS eula is not legal in the eu and what isn't

Re: QofQ weirdness when using QueryNew

2002-10-03 Thread Zac Spitzer
Ryan Kime wrote: > OK, I really need some help on this one. > > I have a query I create on the fly using QueryNew/QueryAddRow/QuerySetCell. > Everything is fine until I try to use a cfquery with dbtype="Query" on the > created query to order the results - it throws a QofQ runtime error. If I > c

Cumulative Patch for SQL Server (Q316333) Crtical for 2000

2002-10-03 Thread Zac Spitzer
Microsoft Security Bulletin MS02-056 have fun, yet another crappy m$ patch from with no installer and 2 pages of instructions and it's rated critical for all internet instances z ~~~

Re: CFM Files are "Locked"?

2002-10-02 Thread Zac Spitzer
[EMAIL PROTECTED] wrote: > IIS likes to lock files for a little while if they have been recently accessed from >the web. If you wait about 30 mins, they'll be freed. Annoying. rename then delete then write a new file always seems to work for me in w2k z

Re: opinions about XSL

2002-10-01 Thread Zac Spitzer
Tony Weeg wrote: > zac. > > can u explain in brief, or give a brief example > of taking an xml node(s) and sending that to a structure? using an xml parser in cf 5 or native in MX, you can convert an xml document into a dom object... like a tree of objects or structures of structu

Re: opinions about XSL

2002-10-01 Thread Zac Spitzer
Alex wrote: > What other option is there to transform xml docs? convert the xml to dom, do your mods and then back to xml, as a CF developer, it much easier to work IMHO with the xml dom as structures etc than messing around with... apparently one of the problems with XSL as an approach perfor

opinions about XSL

2002-10-01 Thread Zac Spitzer
is found this article talking about why xsl is bad http://www.xml.com/pub/a/1999/05/xsl/xslconsidered_1.html any comments? I haven't personally looked into xsl, the syntax always looked like RTF :-) through babelfish and it looks like doing client side work on the server ( ie browser stuff )

Re: Using the Verity Engine on non-cf apps

2002-09-30 Thread Zac Spitzer
Bruce Sorge wrote: > If you have CFMX and .net apps running on the same server, is it possible to use the >K2 Verity engine on the .net apps, or does this require one to purchase and install the K2 product? sounds like you coud expose it via a web service :-) that would be the license complia

Textarea manipluation with JS ( IE & Moz)

2002-09-24 Thread Zac Spitzer
the following link show how to create controllable textarea's for editing, ie get selection, insert at selection with both mozilla and IE 456 ( diff methods, but same results ) hope it saves someone some time :-) http://www.faqts.com/knowledge_base/view.phtml/aid/1052/fid/130 http://bugzilla.m

Re: QueryNew() Filtering Problems

2002-09-24 Thread Zac Spitzer
Raymond Camden wrote: > Can we see your code? I had no issues with this on either CF5 or MX. > Here is the code I used: > > > > price name > 6000 foo > 1 goo > 2 moo > > > > > select price > fromfoo > where price > 7000 > > > order by in CF 5.0 doesn't work w

Re: IIS Security

2002-09-24 Thread Zac Spitzer
Robertson-Ravo, Neil (REC) wrote: > I am pretty sure that there are Netscape issues with IIS/NT security based > systems. only with NTLM/kerbos auth, use basic security... NTLM is not secure anyway coz it's flawed (crackable) ... if you are worried about passwords in clear text then use ssl z

Re: IIS Security

2002-09-24 Thread Zac Spitzer
Candace Cottrell wrote: > What is the disadvantage of using the native IIS directory security > functionality over using a cf-based login? you don't have so much control over the interface ( ie browser login dialogs ) and it generally more flexible via cf logins with error handling.. ie you con

Re: NSLookup

2002-09-24 Thread Zac Spitzer
James Smith wrote: > The reason for attempting direct interaction is that the page I have here > has about 200+ domains on it and it is growing every day and every custom > tag I have tried can't cope with the volume. like always, cache your results, if it's possible, most likely the results you

Re: NSLookup

2002-09-24 Thread Zac Spitzer
James Smith wrote: > Hi all. > > Here is a problem I have been pulling my hair out over. I want to do an > NSLookup directly (ie: no custom tags if it can be avoided) and have tried > both w3sockets and TCPClient to open the socket but not for love nor money > can I find the appropriate commands

Re: Returning columns with null values when specific columns are unknown at runtime

2002-09-19 Thread Zac Spitzer
null values are not indexed btw. (maybe thigs have changed in the last few years but) using a value like 0 as a quasi null means that select user_id from users where b_sysadmin is null versus select user_id from users where b_sysadmin = 0 do an explain plan in oracle or execution plan in sql

Re: UUID's ( maybe OT)

2002-09-18 Thread Zac Spitzer
Bryan Love wrote: > Not really true. The word "terrible" is a vast overstatement. > > Assuming you use char (or varchar) for the UUID (char is better since the > size is constant)... > The difference btwn string keys and numeric keys (performance-wise) is > pretty much null until you get up into

UUID's ( maybe OT)

2002-09-18 Thread Zac Spitzer
I am probably OT here, but I see so many people using UUID's when simpler normal numeric keys are better... a classic example for me is article id's... look at cfcomet for example... the article ids aren't user friendly, it reminds me of good old lotus notes and we all know how short urls are b

Re: more issues -- ARGH!!

2002-09-18 Thread Zac Spitzer
S. Isaac Dealey wrote: > Yea, it turned out to be the cf_sql_date that was causing the "wrong number > of parameters" error message... so changing that to cf_sql_timestamp solved > the problem... Better support for cfstoredproc ( naming and better error > handling in particular. ) would be _great_

Re: FW: Jsp Vs Cfm (CFMX) -- Test Code

2002-09-17 Thread Zac Spitzer
and writeoutput in cf 5.0 is slower than cfoutput, did you try the same test with cfml and not cfscript ? z __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http

Re: FW: Jsp Vs Cfm (CFMX) -- Test Code

2002-09-17 Thread Zac Spitzer
> Anyone else have any ideas? try scoping your variables z __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/f

Re: Recursion

2002-09-13 Thread Zac Spitzer
S. Isaac Dealey wrote: > Before you give up... There's a couple of things you can do for the > recursion in the db... One is to create a cross-reference table which shows > the parent-child relationship between all records in the table... > Alternatively, you could try this: > > > > > > > >

Re: Saving a static version of a website

2002-09-08 Thread Zac Spitzer
Jason Miller wrote: > I have been unsuccesful as well with some of the download utitilies. > This would be great if UltraDev did indeed have this. Just wanted to > post my interest if this is found - I would appreciate a note to the list. > > I will do the same if I should happen to solve the i

Re: upload multiple image files

2002-09-06 Thread Zac Spitzer
Chris Edwards wrote: > how do I access a file's information after uploading multiple images in a > single form? > > the default is FILE.stuff. or CFFILE.stuff.. i think u need the duplicate because otherwise as cffile is a struct, when cffile changes this_files_info would change as it's only

Re: html2jpg

2002-08-30 Thread Zac Spitzer
James Smith wrote: > Some time ago there was a thread about HTML2JPG (http://www.html2jpg.com/) > and using it to create screen shots of web sites. > > Has anyone got it to work with the cfexecute tag? > > It works just fine when I execute it directly or with a batch file from > windows, but eit

Re: Programmatically Control IIS with CF.

2002-08-29 Thread Zac Spitzer
Bryan F. Hogan wrote: > I'm faced with a task of creating an app for our company where a sales > person can input a new client and have it create the needed information > within IIS. > > I have been able to do this with my registrar for domain names and have it > programmatically create the neede

  1   2   3   4   5   >