Timestamps from SQL server - Aggh
Anyone help me please ? This is on an MX6.1 (with updater) server and
SQL 2000.
Up until now, I've been using a bit of code to convert SQL server binary
timestamps to text, storing them as a form field and then converting
them back to binary data when updating the record. I'd then catch any
errors in a stored procedure, in particular different timestamps to
ensure the record hadn't been updated since we checked it out.
Now, the code has started giving me an error saying that my hexadecimal
value is invalid.. I use some modified code from CFLib:-
Original stored proc results:
Binary data: 180-99-98
Convert using udf:
TimeStampToHex(myQuery.TimeStamp)
-
function TimeStampToHex(timestamp)
{
// Take a timestamp and convert it to a string, then to a hex
representation
// of itself ready for injecting back into a stored procedure as
a CF_SQL_BLOB
BinaryString = toString(timestamp);
myHex = ;
for(i = 1; i le 8; i = incrementvalue(i))
{
myValue = asc(mid(BinaryString, i, 1));
myHex = myHex right(00
DecToHex(myValue),2);
}
return myHex;
}
// Convert decimal to HEX value
function DecToHex(str){
return Ucase(FormatBaseN(str, 16));
}
-
Converted value:
input type=hidden name=timestamp value=01509D9E
Written back to DB using:
cfprocparam type = IN cfsqltype=CF_SQL_BLOB
value=#Attributes.TimeStamp#/
Now, I know there's an option for returning timestamps as string when
setting up a datasource but this doesn't seems to be available for SQL
Server, only Access. I'm sure I'd seen it on SQL server previously but
don't have an MX6.0 or v5 server to refer to.
So, does anyone have a reliable way to convert t/s to string and back or
is there a hack to make it work. I've tried altering neoquery.xml but
with no luck. I've also tried Macromedia's article
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18324
Thx in advance
Martin Parry
Macromedia Certified Developer
http://www.BeetrootStreet.co.uk
~|
Purchase Studio MX with Flash Pro from House of Fusion, a Macromedia Authorized
Affiliate and support the CF community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=51
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190618
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: multiple Inner Joins
Jochem. tried your code, but got the following error. Server Msg: -3010, State: 07002, [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. with this code you supplied. SELECT * FROM auction_item_categories_sub5 s5 INNER JOIN auction_item_categories_sub4 s4 ON s5.category_id = s4.id) INNER JOIN auction_item_categories_sub3 s3 ON s4.categoryy_id = s3.id) INNER JOIN auction_item_categories_sub2 s2 ON s3.category_id = s2.id) INNER JOIN auction_item_categories_sub s ON s2.category_id = s.id) INNER JOIN auction_item_categories c ON s.category_id = c.id WHERE auction_item_categories.id = 1 Protoculture Breetai wrote: SELECT id, category_id, name FROM auction_item_categories_sub5 s5 INNER JOIN auction_item_categories_sub4 s4 ON s5.category_id = s4.id) INNER JOIN auction_item_categories_sub3 s3 ON s4.categoryy_id = s3.id) INNER JOIN auction_item_categories_sub2 s2 ON s3.category_id = s2.id) INNER JOIN auction_item_categories_sub s ON s2.category_id = s.id) INNER JOIN auction_item_categories c ON s.category_id = c.id WHERE auction_item_categories.id = 1 Jochem ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190619 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Migrating from MySQL to SQL
Hello, I've used both, and migrated most of my db's from MySQL to SQL Server. It's pretty simple I think. What I did was purchase the developer edition of SQL Server. It's only $50, and it comes full blown! http://www.microsoft.com/sql/howtobuy/development.asp Other than storied procedures and views, the main difference to me is security, permissions, etc. I currently use CrystalTech.com. They're ok with mySQL, but SQL Server kinda sucks because when you connect, it has to download ALLL the db info from the SQL Server you're logging into. That's hundreds of db's! I'm on DSL Lite so it takes about 15 minutes. ICK!! The way I see it though is we live in an imperfect world, so no big whoop to me. ANY host is going to have problems SOMEwhere st SOME point. HTH, Will ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190620 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Database RAID Config w/Client Variables
Matt Wisdom wrote: 10 drive raid Which controller? Chipset? Battery backup? RAM? What RAID config would you use for the databases? Depends on what RAID controller you have. If it is IOP321 based, 10 disks in a RAID 6 or 9 disks in a RAID 5 and a hotspare. How important is (battery backed) write cache for the raid? It is the single most important way to improve performance on the hardware side. With a RAID system, every write command requires at least 2 physical writes: every bit has to be stored on at least 2 disks. Even if the write heads are perfectly positioned for the write operation, a disk rotating at 1 rpm will take on average 3 ms for the write. With 2 disks, that becomes 4.3 ms, and with a RAID configuration that requires you to write more disks that approaches asymptotically to 6 ms. And that is the theoretical optimum with perfectly positioned heads. Since the ACID Durability requirement mandates that all changes are logged to physical storage, you can not commit more then 160 transactions that require writes per second on such a system. It is physically impossible. A battery backed cache allows you to overcome this limitation because it allows the controller to group writes together in batches, without the database having to wait. Jochem ~| Now there’s a better way to fax. eFax makes it possible to use your existing email account to send and receive faxes. Try eFax free. http://www.houseoffusion.com/banners/view.cfm?bannerid=63 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190621 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: multiple Inner Joins
I'm not sure why you are using parenthesis for your joins since SQL doesn't need them. This may sound horribly simple but I noticed a change in your field naming convention throughout this thread. You have category_id for all your tables except for your alias s4 (auction_item_categories_sub4) where you have a field with an extra 'y' categoryy_id - could this be just a simple typo or was the deviation deliberate? Also, as a note on form, 1. do you really need SELECT * ? - enumerating the fields is always preferred over SELECT * 2. While Access doesn't support stored procs, you should consider using cfqueryparam instead of the hardcoded value to get the benefit of turning this call into a prepared statement, especially with this many joins involved. Subsequent calls can then take advantage of a cached execution plan. Try: SELECT * FROM auction_item_categories_sub5 s5 INNER JOIN auction_item_categories_sub4 s4 ON s5.category_id = s4.id INNER JOIN auction_item_categories_sub3 s3 ON s4.categoryy_id = s3.id INNER JOIN auction_item_categories_sub2 s2 ON s3.category_id = s2.id INNER JOIN auction_item_categories_sub s ON s2.category_id = s.id INNER JOIN auction_item_categories c ON s.category_id = c.id WHERE auction_item_categories.id = 1 Regards, Adam Howitt Protoculture wrote: Jochem. tried your code, but got the following error. Server Msg: -3010, State: 07002, [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. with this code you supplied. SELECT * FROM auction_item_categories_sub5 s5 INNER JOIN auction_item_categories_sub4 s4 ON s5.category_id = s4.id) INNER JOIN auction_item_categories_sub3 s3 ON s4.categoryy_id = s3.id) INNER JOIN auction_item_categories_sub2 s2 ON s3.category_id = s2.id) INNER JOIN auction_item_categories_sub s ON s2.category_id = s.id) INNER JOIN auction_item_categories c ON s.category_id = c.id WHERE auction_item_categories.id = 1 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190622 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: multiple Inner Joins
Adam Howitt wrote: I'm not sure why you are using parenthesis for your joins since SQL doesn't need them. Access ... This may sound horribly simple but I noticed a change in your field naming convention throughout this thread. You have category_id for all your tables except for your alias s4 (auction_item_categories_sub4) where you have a field with an extra 'y' categoryy_id So that is one error, and the other one is the missing alias in the predicate: SELECT * FROM auction_item_categories_sub5 s5 INNER JOIN auction_item_categories_sub4 s4 ON s5.category_id = s4.id) INNER JOIN auction_item_categories_sub3 s3 ON s4.category_id = s3.id) INNER JOIN auction_item_categories_sub2 s2 ON s3.category_id = s2.id) INNER JOIN auction_item_categories_sub s ON s2.category_id = s.id) INNER JOIN auction_item_categories c ON s.category_id = c.id WHERE c.id = 1 Jochem ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190623 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Checking active session
I have an application that sets a session variable. That session variable is also stored in the database. Is it possible to determine if a specific variable belongs to any active sessions? For example, I want to know if there are any active sessions containing the session variable named FOO with the value of 1. - Rick ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190624 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: multiple Inner Joins
Jochem van Dieten wrote: I'm not sure why you are using parenthesis for your joins since SQL doesn't need them. Access ... I know it's not really relevant to THIS discussion, but some database servers DO require parentheses around multiple joins our DB2 mainframe does. So I tend to use them in all situations. ie... SELECT ... FROM (( table1 inner join table 2 on ...) inner join table 3 on ...) inner join table 4 on ... WHERE ... ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190625 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Checking active session
Yes, if you have a look at this http://tech.badpen.com/index.cfm?mode=entryentry=3 article by Tim Blair you should be able to figure out how to get a loop going over the highest level, drop in to session then check if your var is in the struct. Ian On Sun, 16 Jan 2005 12:12:10 -0500, Rick Root [EMAIL PROTECTED] wrote: I have an application that sets a session variable. That session variable is also stored in the database. Is it possible to determine if a specific variable belongs to any active sessions? For example, I want to know if there are any active sessions containing the session variable named FOO with the value of 1. - Rick ~| Protect Your PC from viruses, hackers, spam and more. Buy PC-cillin with Easy Installation Support http://www.houseoffusion.com/banners/view.cfm?bannerid=61 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190626 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFLib Downtime
CFLib may be down for a little bit today. I'm switching servers. (And btw, I'm switching to CFXHosting - who have been _extremely_ helpful!) -- ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190627 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dynamic CF PDFs - help request
Jared, Thanks to you and Doug James for checking into this issue. I just hit your test page, and the PDF form came up, the contents of the FDF came up... same as Doug. But when I clicked on the link to the FDF, I got the Reader splash screen, and then nothing. Blank screen. No content at all. No errors either... but I'm not sure that's a good thing. I used the FireFox Page Info dialogue to save the FDF to my desktop and when I opened it in Reader, nothing at all came up there either, just a blank, gray, empty Reader screen. It seems that Firefox has some known issues when trying to display a PDF via a FDF (content of type Application/vnd.fdf). I should have made it clearer that what we're trying to reproduce are errors when opening the form with _Internet Explorer_. That link again is: http://www.hopeaviation.com/pilotform/test/index.cfm If anyone else could test this with IE and report whether it succeeds or how it fails, I'd appreciate it. The system is oriented toward delivering content from a base64 encoded DB text table, but the example uses a PDF which is streamed back to the browser in a CFM page with cfcontent and cfheader making Acrobat think it's a PDF file... source code is downloadable from the link provided. This is basically what we're doing, too, except that we're trying to make the browser think that it's a FDF file (mime type would be Application/vnd.fdf). Here's another example for comparison at planetpdf.com (FWIW, this is the same situation but using ASP instead of CF. I have the same problems with Firefox and this example): http://www.planetpdf.com/planetpdf/inetpub/demo2.html Thanks again, Stephen ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190628 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFLib Downtime
Who were you with prior to today's move? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Sunday, January 16, 2005 1:36 PM To: CF-Talk Subject: CFLib Downtime CFLib may be down for a little bit today. I'm switching servers. (And btw, I'm switching to CFXHosting - who have been _extremely_ helpful!) -- ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190629 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: multiple Inner Joins
Adam, the code you gave didn't seem to work. same goes with Jochem. Although I think we are getting closer with the last bit of code Jochem posted. Error: Server Msg: -3010, State: 07002, [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. SQL: SELECT * FROM auction_item_categories_sub5 AS s5 INNER JOIN auction_item_categories_sub4 AS s4 ON s5.category_id = s4.id ) INNER JOIN auction_item_categories_sub3 AS s3 ON s4.category_id = s3.id ) INNER JOIN auction_item_categories_sub2 AS s2 ON s3.category_id = s2.id ) INNER JOIN auction_item_categories_sub AS s ON s2.category_id= s.id ) INNER JOIN auction_item_categories AS c ON s.category_id = c.id WHERE auction_item_categories.id = 1 Adam Howitt wrote: I'm not sure why you are using parenthesis for your joins since SQL doesn't need them. Access ... This may sound horribly simple but I noticed a change in your field naming convention throughout this thread. You have category_id for all your tables except for your alias s4 (auction_item_categories_sub4) where you have a field with an extra 'y' categoryy_id So that is one error, and the other one is the missing alias in the predicate: SELECT * FROM auction_item_categories_sub5 s5 INNER JOIN auction_item_categories_sub4 s4 ON s5.category_id = s4.id) INNER JOIN auction_item_categories_sub3 s3 ON s4.category_id = s3.id) INNER JOIN auction_item_categories_sub2 s2 ON s3.category_id = s2.id) INNER JOIN auction_item_categories_sub s ON s2.category_id = s.id) INNER JOIN auction_item_categories c ON s.category_id = c.id WHERE c.id = 1 Jochem ~| Find out how to get a fax number that sends and receives faxes using your current email address http://www.houseoffusion.com/banners/view.cfm?bannerid=64 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190630 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: multiple Inner Joins
SQL: SELECT * FROM auction_item_categories_sub5 AS s5 INNER JOIN auction_item_categories_sub4 AS s4 ON s5.category_id = s4.id ) INNER JOIN auction_item_categories_sub3 AS s3 ON s4.category_id = s3.id ) INNER JOIN auction_item_categories_sub2 AS s2 ON s3.category_id = s2.id ) INNER JOIN auction_item_categories_sub AS s ON s2.category_id= s.id ) INNER JOIN auction_item_categories AS c ON s.category_id = c.id WHERE auction_item_categories.id = 1 You are sill missing the alias in the SELECT. First off, selecting * is not a good idea at all since my guess is that you don't need all the columns. So, change that SELECT * to something else depening upon which table you need the values from. SELECT s.*, s2.*, s3.*, s4.*, s5.* Get rid of the * above and list the columns you want. Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190631 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: multiple Inner Joins
Protoculture wrote: Although I think we are getting closer with the last bit of code Jochem posted. Error: Server Msg: -3010, State: 07002, [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. SQL: SELECT * FROM auction_item_categories_sub5 AS s5 INNER JOIN auction_item_categories_sub4 AS s4 ON s5.category_id = s4.id ) INNER JOIN auction_item_categories_sub3 AS s3 ON s4.category_id = s3.id ) INNER JOIN auction_item_categories_sub2 AS s2 ON s3.category_id = s2.id ) INNER JOIN auction_item_categories_sub AS s ON s2.category_id= s.id ) INNER JOIN auction_item_categories AS c ON s.category_id = c.id WHERE auction_item_categories.id = 1 This is not my last code, my last code had: WHERE c.id = 1 Jochem ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190632 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: regex help (Almost)
The regex works for most cases... but it's not stopping at the next ending tag... For example, the quote replac regex... I have [quote]heres a quote[/quote] Here's some text [quote]here's another quote[/quote] The expression replaces quote tags with blockquote tags unless it false between [code][/code] tags (which it doesntin this case) The result is blockquoteheres a quote[/quote] Heres some text [quote]here's another quote/blockquote Which of course should be blockquoteHeres a quote/blockquote Heres some text blockquotehere's another quote/blockquote This is the regex thats causing this... str = rereplace(str, (\[quote\](.*)\[/quote\])(?!((?!\[code\]).)*?\[/code\]), blockquote\2/blockquote, ALL); How can I change it to stop at the first [/quote] tag? -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.12 - Release Date: 1/14/2005 ~| Purchase Dreamweaver with Homesite Plus from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=54 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190633 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: regex help (Almost)
Are you using CFMX? If so you can specify minimal matching, which I think is probably the only way you can do this using a single regex. I think you replace .* with .*? -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Monday, 17 January 2005 10:01 a.m. To: CF-Talk Subject: RE: regex help (Almost) The regex works for most cases... but it's not stopping at the next ending tag... For example, the quote replac regex... I have [quote]heres a quote[/quote] Here's some text [quote]here's another quote[/quote] The expression replaces quote tags with blockquote tags unless it false between [code][/code] tags (which it doesntin this case) The result is blockquoteheres a quote[/quote] Heres some text [quote]here's another quote/blockquote Which of course should be blockquoteHeres a quote/blockquote Heres some text blockquotehere's another quote/blockquote This is the regex that's causing this... str = rereplace(str, (\[quote\](.*)\[/quote\])(?!((?!\[code\]).)*?\[/code\]), blockquote\2/blockquote, ALL); How can I change it to stop at the first [/quote] tag? -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.12 - Release Date: 1/14/2005 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190634 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: regex help (Almost)
Regular expressions are greedy by default, they match as much as they can. Adding ? to a qualifier makes it non-greedy - this seemed to do the job for me, but I haven't looked too closely at your expression. str = rereplace(str, (\[quote\](.*?)\[/quote\])(?!((?!\[code\]).)*?\[/code\]), blockquote\2/blockquote, ALL) -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Monday, 17 January 2005 10:01 a.m. To: CF-Talk Subject: RE: regex help (Almost) The regex works for most cases... but it's not stopping at the next ending tag... For example, the quote replac regex... I have [quote]heres a quote[/quote] Here's some text [quote]here's another quote[/quote] The expression replaces quote tags with blockquote tags unless it false between [code][/code] tags (which it doesntin this case) The result is blockquoteheres a quote[/quote] Heres some text [quote]here's another quote/blockquote Which of course should be blockquoteHeres a quote/blockquote Heres some text blockquotehere's another quote/blockquote This is the regex that's causing this... str = rereplace(str, (\[quote\](.*)\[/quote\])(?!((?!\[code\]).)*?\[/code\]), blockquote\2/blockquote, ALL); How can I change it to stop at the first [/quote] tag? -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.12 - Release Date: 1/14/2005 ~| Stay Ahead of Hackers - Download ZoneAlarm Pro http://www.houseoffusion.com/banners/view.cfm?bannerid=65 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190635 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: regex help (Almost)
MAN! How simple was that! Uhgg thanks guys -Original Message- From: Mike Nicholls [mailto:[EMAIL PROTECTED] Sent: Sunday, January 16, 2005 4:11 PM To: CF-Talk Subject: RE: regex help (Almost) Regular expressions are greedy by default, they match as much as they can. Adding ? to a qualifier makes it non-greedy - this seemed to do the job for me, but I haven't looked too closely at your expression. str = rereplace(str, (\[quote\](.*?)\[/quote\])(?!((?!\[code\]).)*?\[/code\]), blockquote\2/blockquote, ALL) -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Monday, 17 January 2005 10:01 a.m. To: CF-Talk Subject: RE: regex help (Almost) The regex works for most cases... but it's not stopping at the next ending tag... For example, the quote replac regex... I have [quote]heres a quote[/quote] Here's some text [quote]here's another quote[/quote] The expression replaces quote tags with blockquote tags unless it false between [code][/code] tags (which it doesntin this case) The result is blockquoteheres a quote[/quote] Heres some text [quote]here's another quote/blockquote Which of course should be blockquoteHeres a quote/blockquote Heres some text blockquotehere's another quote/blockquote This is the regex that's causing this... str = rereplace(str, (\[quote\](.*)\[/quote\])(?!((?!\[code\]).)*?\[/code\]), blockquote\2/blockquote, ALL); How can I change it to stop at the first [/quote] tag? -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.12 - Release Date: 1/14/2005 ~| Get help! RoboHelp http://www.houseoffusion.com/banners/view.cfm?bannerid=58 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190636 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
A graphic of the db relationship
Sorry Jochem you were right. Anyway, to get things more concise here, perhaps I'm not even doing the right kind of join... here is my db structure... http://www.webgoblins.net/db.gif The Last Code I tried was Jochems and while it did run succesfully, there were no results returned. Essentially What I'm doing is selecting all related categories from the where all the ( auction_item_categories_sub.category_id = 1 ) and then it should filter down with the appropriate logic. The trouble is, I'm not having a great time finding that logic. [CODE] SELECT * FROM auction_item_categories_sub5 s5 INNER JOIN auction_item_categories_sub4 s4 ON s5.category_id = s4.id) INNER JOIN auction_item_categories_sub3 s3 ON s4.category_id = s3.id) INNER JOIN auction_item_categories_sub2 s2 ON s3.category_id = s2.id) INNER JOIN auction_item_categories_sub s ON s2.category_id = s.id) INNER JOIN auction_item_categories c ON s.category_id = c.id WHERE c.id = 1 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190637 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: another php ?
Why not just use cookies to store login info? I have developed systems that use both ASP and CF. A cookie set using cfcookie can be read by an ASP (or PHP I imagine) page with no problems, as long as it is in the same domain. On Sat, 15 Jan 2005 12:33:19 -0500, Rick Root [EMAIL PROTECTED] wrote: dave wrote: how can u transfer a php login session to cfm or vise versa. say if u have a site that is in cfm but it uses a phpbb and dont want members to have to login twice. I'd love to see an answer to this one =) Bob Guiney's web site (bachelor bob) is a mix of CF and php right now, including phpBB ... I had a need to authenticate users for uploading images, so I actually force them to enter their username and password each time they want to upload an image to the fan photo gallery... and I just use CF to authenticate against the phpbb database. I'd love to not make them do that everytime. - Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.12 - Release Date: 1/14/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190638 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: A graphic of the db relationship
From: Protoculture [mailto:[EMAIL PROTECTED] The Last Code I tried was Jochems and while it did run succesfully, there were no results returned. Essentially What I'm doing is selecting all related categories from the where all the ( auction_item_categories_sub.category_id = 1 ) and then it should filter down with the appropriate logic. The trouble is, I'm not having a great time finding that logic. I would recommend rethinking the DB structure. The fact that you have the category hierarchy broken out into individual tables is not a good approach in my opinion. It looks like you could benefit more from a set or tree structure that would allow you to store the entire hierarchy in one table. Google Joe Celko Nested Set and check it out. The code is out that for selecting hierarchies, inserting a new node and removing nodes. Given your current setup, remember thah the inner join will take care of only filtering out records where there is no ID match (PK/FK). Start with the top level... SELECT A.name FROM auction_item_categories A INNER JOIN auction_item_categories_sub S1 ON (A.id = S1.category_id) INNER JOIN auction_item_categories_sub2 S2 ON (S1.id = S2.category_id) INNER JOIN auction_item_categories_sub3 S3 ON (S2.id = S3.cateogyr_id) INNER JOIN auction_item_categories_sub2 S4 ON (S3.id = S4.category_id) INNER JOIN auction_item_categories_sub2 S5 ON (S4.id = S5.category_id) WHERE A.id = 1 Give the above a try... Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190639 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: A graphic of the db relationship
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] I forgot to change something when copy/pasting. SELECT A.name FROM auction_item_categories A INNER JOIN auction_item_categories_sub S1 ON (A.id = S1.category_id) INNER JOIN auction_item_categories_sub2 S2 ON (S1.id = S2.category_id) INNER JOIN auction_item_categories_sub3 S3 ON (S2.id = S3.cateogyr_id) INNER JOIN auction_item_categories_sub4 S4 ON (S3.id = S4.category_id) INNER JOIN auction_item_categories_sub5 S5 ON (S4.id = S5.category_id) WHERE A.id = 1 Sorry about that.. Mike ~| Flash for programmers - Flash MX Pro http://www.houseoffusion.com/banners/view.cfm?bannerid=56 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190640 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: another php ?
actually i think what i am gunna do is replace the php login with a flash one so that way i can send username and password both to the php script and to the cfm template (via actionscript) maybe not optimal but in theory should work great :) -- Original Message -- From: Scott Stroz [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Sun, 16 Jan 2005 17:00:19 -0500 Why not just use cookies to store login info? I have developed systems that use both ASP and CF. A cookie set using cfcookie can be read by an ASP (or PHP I imagine) page with no problems, as long as it is in the same domain. On Sat, 15 Jan 2005 12:33:19 -0500, Rick Root [EMAIL PROTECTED] wrote: dave wrote: how can u transfer a php login session to cfm or vise versa. say if u have a site that is in cfm but it uses a phpbb and dont want members to have to login twice. I'd love to see an answer to this one =) Bob Guiney's web site (bachelor bob) is a mix of CF and php right now, including phpBB ... I had a need to authenticate users for uploading images, so I actually force them to enter their username and password each time they want to upload an image to the fan photo gallery... and I just use CF to authenticate against the phpbb database. I'd love to not make them do that everytime. - Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.12 - Release Date: 1/14/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190641 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
access DB schema
Does anyone out there know of a tool or utility to unpack the schema of an access database? We are doing a conversion of a fairly large Access db and we are looking to save some leg-work. -mark Mark A. Kruger, CFG, MSCE www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190642 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cflib ATT raymond
did u know u get a big error mesage when u go there with ie? (see below) was pointed out to me by jamie at hostmysite.com (silly boy still uses ie!!) works fine with firefox though Error Occurred While Processing Request Could not find the included template /cflib/includes/udf.cfm. Note: If you wish to use an absolute template path (e.g. TEMPLATE=/mypath/index.cfm) with CFINCLUDE then you must create a mapping for the path using the ColdFusion Administrator. Using relative paths (e.g. TEMPLATE=index.cfm or TEMPLATE=../index.cfm) does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible. The error occurred in D:\websites\cflib.org\wwwroot\Application.cfm: line 53 51 : 52 : !--- Include UDFs --- 53 : CFINCLUDE TEMPLATE=/cflib/includes/udf.cfm 54 : 55 : !--- Include CFCs --- ~| Purchase Homesite Plus with Dreamweaver from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=55 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190643 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Database RAID Config w/Client Variables
10 drive raid Which controller? Chipset? Battery backup? RAM? Looking at an adaptec U320, 256 MB w/battery backup for 72 hours. The rest of the system is a SuperMicro serverworks dual xeon mobo + case. It has 10 drive bays in the 4U case with a backplane and hotswap. 4GB of ram. About $6,000 for the whole thing. What RAID config would you use for the databases? Depends on what RAID controller you have. If it is IOP321 based, 10 disks in a RAID 6 or 9 disks in a RAID 5 and a hotspare. I didn't know what RAID 6 is -- RAID-6. This type is similar to RAID-5 but includes a second parity scheme that is distributed across different drives and thus offers extremely high fault- and drive-failure tolerance. There are few or no commercial examples currently. So you would have only one data volume for the two databases? What about the logs? How important is (battery backed) write cache for the raid? It is the single most important way to improve performance on the hardware side. Sounds like this would be a hard limit on scalability for connections per second because of the cfsessions client vars. Thanks, Matt ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190644 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cflib ATT raymond
From: dave [mailto:[EMAIL PROTECTED] did u know u get a big error mesage when u go there with ie? (see below) was pointed out to me by jamie at hostmysite.com (silly boy still uses ie!!) works fine with firefox though Ray said that he was switching servers today ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190645 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Database RAID Config w/Client Variables
What is the most intense client vars database anyone here has set up? It's a little strange because since the indexing is handled automatically it isn't obvious how optimized the processes are. Has this ever been a bottleneck for scalability? Matt ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190646 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cflib ATT raymond
why would it throw that error with ie though and not any of the good browsers? -- Original Message -- From: Michael T. Tangorre [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Sun, 16 Jan 2005 18:00:39 -0500 From: dave [mailto:[EMAIL PROTECTED] did u know u get a big error mesage when u go there with ie? (see below) was pointed out to me by jamie at hostmysite.com (silly boy still uses ie!!) works fine with firefox though Ray said that he was switching servers today ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190647 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cflib ATT raymond
From: dave [mailto:[EMAIL PROTECTED] why would it throw that error with ie though and not any of the good browsers? Maybe IE is caching the pages... Who knows. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190648 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cflib ATT raymond
Maybe your good browser is/was cached unbeknownst to you :) -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Sunday, January 16, 2005 6:19 PM To: CF-Talk Subject: RE: cflib ATT raymond why would it throw that error with ie though and not any of the good browsers? -- Original Message -- From: Michael T. Tangorre [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Sun, 16 Jan 2005 18:00:39 -0500 From: dave [mailto:[EMAIL PROTECTED] did u know u get a big error mesage when u go there with ie? (see below) was pointed out to me by jamie at hostmysite.com (silly boy still uses ie!!) works fine with firefox though Ray said that he was switching servers today ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190649 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Database RAID Config w/Client Variables
It's a little strange because since the indexing is handled automatically it isn't obvious how optimized the processes are. Has this ever been a bottleneck for scalability? Matt, I've run traced load tests on an isolated client variables database (i.e., separated from the transactional DB) with production-scale data, and the three non-clustered indexes that are created on the CDATA and CGLOBAL tables are about as efficient as can be. Post-test analysis didn't suggest any changes to the indexes in any way. The rows themselves appear to be retrieved as efficiently as possible. The only real bottleneck seems to be deserializing the key-value pairs back into Client variables once the text columns containing them are passed to ColdFusion on each retrieval. I didn't thoroughly read through all the earlier posts in this thread, but are you expiring your Client variables after one day rather than the default 90 days? Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 ~| Purchase Studio MX from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=50 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190650 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Database RAID Config w/Client Variables
Matt Wisdom wrote: 10 drive raid Which controller? Chipset? Battery backup? RAM? Looking at an adaptec U320, 256 MB w/battery backup for 72 hours. Cache size matters. See for instance the following tests with 128 vs 512 MB controller cache: http://www.tweakers.net/benchdb/testcombo/82 http://www.tweakers.net/benchdb/testcombo/197 If you can get more cache, it is probably worth it. What RAID config would you use for the databases? Depends on what RAID controller you have. If it is IOP321 based, 10 disks in a RAID 6 or 9 disks in a RAID 5 and a hotspare. I didn't know what RAID 6 is -- RAID-6. This type is similar to RAID-5 but includes a second parity scheme that is distributed across different drives and thus offers extremely high fault- and drive-failure tolerance. There are few or no commercial examples currently. It is basically RAID 5 with 2 parities. In RAID 5 you can loose one disk without dataloss, in RAID 6 you can loose 2 disks. So you would have only one data volume for the two databases? What about the logs? All on the same volume. But remember the If it is IOP321 based. Adaptec makes its own RAID XOR chips, and it looks like vendors buying their RAID XOR chips from Intel currently hold the performance crown, which is more important with RAID 5: http://www.tweakers.net/benchdb/test/80 How important is (battery backed) write cache for the raid? It is the single most important way to improve performance on the hardware side. Sounds like this would be a hard limit on scalability for connections per second because of the cfsessions client vars. Yes. That is why a battery backed cache is so important. Jochem ~| Protect Your PC from viruses, hackers, spam and more. Buy PC-cillin with Easy Installation Support http://www.houseoffusion.com/banners/view.cfm?bannerid=61 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190651 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dynamic CF PDFs - help request
Stephen... I just hit the URL again using IE 6. I got two messages from Acrobat, one that the page contained no comments with Yes and No buttons. The other one said This action is not permitted. Both of these ocurred while I had Reader open as a standalone app. When I hit the FDF page without Acrobat open, I, once again, got a blank page and no errors. Sorry dude... Laterz, J On Sun, 16 Jan 2005 13:42:30 -0500, Stephen Hait [EMAIL PROTECTED] wrote: Jared, Thanks to you and Doug James for checking into this issue. I just hit your test page, and the PDF form came up, the contents of the FDF came up... same as Doug. But when I clicked on the link to the FDF, I got the Reader splash screen, and then nothing. Blank screen. No content at all. No errors either... but I'm not sure that's a good thing. I used the FireFox Page Info dialogue to save the FDF to my desktop and when I opened it in Reader, nothing at all came up there either, just a blank, gray, empty Reader screen. It seems that Firefox has some known issues when trying to display a PDF via a FDF (content of type Application/vnd.fdf). I should have made it clearer that what we're trying to reproduce are errors when opening the form with _Internet Explorer_. That link again is: http://www.hopeaviation.com/pilotform/test/index.cfm If anyone else could test this with IE and report whether it succeeds or how it fails, I'd appreciate it. The system is oriented toward delivering content from a base64 encoded DB text table, but the example uses a PDF which is streamed back to the browser in a CFM page with cfcontent and cfheader making Acrobat think it's a PDF file... source code is downloadable from the link provided. This is basically what we're doing, too, except that we're trying to make the browser think that it's a FDF file (mime type would be Application/vnd.fdf). Here's another example for comparison at planetpdf.com (FWIW, this is the same situation but using ASP instead of CF. I have the same problems with Firefox and this example): http://www.planetpdf.com/planetpdf/inetpub/demo2.html Thanks again, Stephen -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190652 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: regex help (Almost)
Incase you havent realized regex's arent my forte! This seems to be the last little kink to get out of this thing and it will be set (or I'm going back to the original Jim Davis loop!) str = rereplace(str, (\[hr\])(?!(?!\[code\]).*?\[/code\]), hr, ALL); this regex works perfectly as long as the string doesn't contain [code][\code] blocks and doesn't have any single tags BEFORE the code (like [hr]) if there are code blocks then the above regex will only replace [hr] with hr AFTER the [code][/code] tags and leave any [hr]'s that come before it unchanged it doesn't replace the [hr]'s that fall inside the [code][/code] blocks either but that's what it's supposed to do, so apparently what it equates to is... replace [hr] if its after the last [/code] tag found and it should be... replace [hr] unless its after any [code] tag AND before the NEXT [/code] tag this block ... [hr] [code][b]some code[/b][/code] [hr] [code][b]some code[/b][/code] [hr] Is transformed into... [hr] pre[b]some code[/b]/pre [hr] pre[b]some code[/b]/pre hr The first 2 [hr] tags should be hr everything else works fine. just when I thought that I was actually getting better at regular expressions... sigh That is just the regex for tags without closing tags. The other regex for tags that have open and close works great like [b][/b] str = rereplace(str, (\[b\]([Aa-zZ0-9\s]*)\[/b\])(?!((?!\[code\]).)*?\[/code\]), b\2/b, ALL); cf-talk... Pimp my regex! Sorry... couldnt resist :) -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.13 - Release Date: 1/16/2005 ~| Get help! RoboHelp http://www.houseoffusion.com/banners/view.cfm?bannerid=58 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190653 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: application and path problem 2 environments on one machine
I have found that we had cache web server paths checked in the Server Administrator. Now the different sites are running the correct versions of the code, but they are still sharing the applications vars. I cant find anything in the cf admin that could be making this happen. My application.cfm now sets the app name dynamically: cfif findnocase(dev,cgi.server_name) cfset request.appmapping = intranet_dev cfelse cfset request.appmapping = intranet /cfif Cfparam name=request.appmapping default=intranet cfapplication name=#request.appmapping# sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,0,20,0)# and the request.appmapping is returning the correct info. Then in myGlobals.cfm: !--- only set application variables if not already defined in application scope --- cfif NOT IsDefined(application.datasource) or isdefined(attributes.refreshvars) cflock type=EXCLUSIVE timeout=60 scope=application cfif findnocase(dev,cgi.server_name) cfset application.datasource=MPlus_dev cfset application.dbusername=sa cfset application.dbuserpwd=191nsh cfelse cfset application.datasource=MPlus cfset application.dbusername=sa cfset application.dbuserpwd=191nsh /cfif cfset application.checkip=1 cfset application.nonExclusionList= cfset application.maxRows=20 /cflock /cfif But both applications overwrite the others info when I refreshvars or restart CF services. Please can anyone help me out? I am about to have a breakdown. Duncan On Fri, 14 Jan 2005 14:36:06 +1100, Duncan I Loxton [EMAIL PROTECTED] wrote: 6.1 - I've not heard about this issue. On Fri, 14 Jan 2005 02:49:48 -, Adrian Lynch [EMAIL PROTECTED] wrote: What about the caching paths issue, not sure of it's real name(?). Are you on 6.0 or 6.1? Ade -Original Message- From: Duncan I Loxton [mailto:[EMAIL PROTECTED] Sent: 14 January 2005 02:44 To: CF-Talk Subject: Re: application and path problem 2 environments on one machine Application.cfm Live site: cfapplication name=mars sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,0,20,0)# Application.cfm dev site: cfapplication name=intranetDEV sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,0,20,0)# -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.11 - Release Date: 12/01/2005 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190654 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: application and path problem 2 environments on one machine
Set up multiple CF instances in JRun. The free developer edition (or the soon to be killed DevNet version) let you do this without cost. You'll be running each version of the app in a totally independant environment with no possibility of confusion. We do this in our office with great success. It does require a bit of RAM in the dev server though, since CF isn't a very lightweight app, and you have a complete copy of it for each instance. These phantom problems that you're having (among other things) prompted me to go this route, rather than just running multiple versions on the same instance. It's a little more headache to get everything set up, but it's worth it. cheers, barneyb On Mon, 17 Jan 2005 11:39:20 +1100, Duncan I Loxton [EMAIL PROTECTED] wrote: I have found that we had cache web server paths checked in the Server Administrator. Now the different sites are running the correct versions of the code, but they are still sharing the applications vars. I cant find anything in the cf admin that could be making this happen. My application.cfm now sets the app name dynamically: cfif findnocase(dev,cgi.server_name) cfset request.appmapping = intranet_dev cfelse cfset request.appmapping = intranet /cfif Cfparam name=request.appmapping default=intranet cfapplication name=#request.appmapping# sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,0,20,0)# and the request.appmapping is returning the correct info. Then in myGlobals.cfm: !--- only set application variables if not already defined in application scope --- cfif NOT IsDefined(application.datasource) or isdefined(attributes.refreshvars) cflock type=EXCLUSIVE timeout=60 scope=application cfif findnocase(dev,cgi.server_name) cfset application.datasource=MPlus_dev cfset application.dbusername=sa cfset application.dbuserpwd=191nsh cfelse cfset application.datasource=MPlus cfset application.dbusername=sa cfset application.dbuserpwd=191nsh /cfif cfset application.checkip=1 cfset application.nonExclusionList= cfset application.maxRows=20 /cflock /cfif But both applications overwrite the others info when I refreshvars or restart CF services. Please can anyone help me out? I am about to have a breakdown. Duncan -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 8 invites. ~| Purchase Contribute 3 from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=53 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190655 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dynamic CF PDFs - help request
Jared, Thanks again. I've tried every configuration I can think of I can't get either of the results you reported. Would you mind trying this link at planetpdf.com and letting me know what happens: http://www.planetpdf.com/planetpdf/inetpub/demo2.html This is the same basic idea of serving a FDF data file that points to a corresponding PDF but it's ASP instead of CF. Even though this FDF/PDF solution has worked for us for a couple of years, it's been a real bear trying to troubleshoot the odd, unreproducible problem. There are too many different factors between operating system and patch level, browser version and patch level and plugin configuration, Reader or Acrobat version(s), etc. Since there doesn't seem to be much problem with reading actual PDF files in most browsers, I think I will start looking at a solution that fills and saves a PDF file on the server and then serves that to the requestor. If you have any advice along those lines, please lay it on me. Thanks again for your time, Stephen Stephen... I just hit the URL again using IE 6. I got two messages from Acrobat, one that the page contained no comments with Yes and No buttons. The other one said This action is not permitted. Both of these ocurred while I had Reader open as a standalone app. When I hit the FDF page without Acrobat open, I, once again, got a blank page and no errors. Sorry dude... Laterz, J On Sun, 16 Jan 2005 13:42:30 -0500, Stephen Hait [EMAIL PROTECTED] wrote: Jared, Thanks to you and Doug James for checking into this issue.I just hit your test page, and the PDF form came up, the contents of the FDF came up... same as Doug. But when I clicked on the link to the FDF, I got the Reader splash screen, and then nothing. Blank screen. No content at all. No errors either... but I'm not sure that's a good thing. I used the FireFox Page Info dialogue to save the FDF to my desktop and when I opened it in Reader, nothing at all came up there either, just a blank, gray, empty Reader screen. It seems that Firefox has some known issues when trying to display a PDF via a FDF (content of type Application/vnd.fdf). I should have made it clearer that what we're trying to reproduce are errors when opening the form with _Internet Explorer_. That link again is: http://www.hopeaviation.com/pilotform/test/index.cfm If anyone else could test this with IE and report whether it succeeds or how it fails, I'd appreciate it.The system is oriented toward delivering content from a base64 encoded DB text table, but the example uses a PDF which is streamed back to the browser in a CFM page with cfcontent and cfheader making Acrobat think it's a PDF file... source code is downloadable from the link provided. This is basically what we're doing, too, except that we're trying to make the browser think that it's a FDF file (mime type would be Application/vnd.fdf). Here's another example for comparison at planetpdf.com (FWIW, this is the same situation but using ASP instead of CF. I have the same problems with Firefox and this example): http://www.planetpdf.com/planetpdf/inetpub/demo2.html Thanks again, Stephen -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190656 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: regex help (Almost)
Still fighting that thing, eh? I spent 3 hours this afternoon trying to figure out why a simple INSERT query wouldn't work... finally I wrapped the query text in ## and a cfoutput, then copy/pasted it into Query Analyzer... only to find out that the problem was a new column in the database that was marked not nullable. I hadn't updated the insert to account for the new column. DANG, I hate when that happens. But, my my thought is this... Why not convert every single HR or BR tag to hr, then run rereplace with a regex that finds [\[code\].hr.\[\/code\]] and converts hr back to [HR]. Granted, it may not be the utmost in elegance (which is never pleasing), but it would work. Just a thought... I'll keep thinking on it too. Hard as that whole thinking thing may be. Laterz, J On Sun, 16 Jan 2005 19:11:27 -0500, Ewok [EMAIL PROTECTED] wrote: Incase you haven't realized regex's aren't my forte! This seems to be the last little kink to get out of this thing and it will be set (or I'm going back to the original Jim Davis loop!) str = rereplace(str, (\[hr\])(?!(?!\[code\]).*?\[/code\]), hr, ALL); this regex works perfectly as long as the string doesn't contain [code][\code] blocks and doesn't have any single tags BEFORE the code (like [hr]) if there are code blocks then the above regex will only replace [hr] with hr AFTER the [code][/code] tags and leave any [hr]'s that come before it unchanged it doesn't replace the [hr]'s that fall inside the [code][/code] blocks either but that's what it's supposed to do, so apparently what it equates to is... replace [hr] if its after the last [/code] tag found and it should be... replace [hr] unless its after any [code] tag AND before the NEXT [/code] tag this block ... [hr] [code][b]some code[/b][/code] [hr] [code][b]some code[/b][/code] [hr] Is transformed into... [hr] pre[b]some code[/b]/pre [hr] pre[b]some code[/b]/pre hr The first 2 [hr] tags should be hr everything else works fine. just when I thought that I was actually getting better at regular expressions... sigh That is just the regex for tags without closing tags. The other regex for tags that have open and close works great like [b][/b] str = rereplace(str, (\[b\]([Aa-zZ0-9\s]*)\[/b\])(?!((?!\[code\]).)*?\[/code\]), b\2/b, ALL); cf-talk... Pimp my regex! Sorry... couldn't resist :) -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.13 - Release Date: 1/16/2005 -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190657 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: application and path problem 2 environments on one machine
Thanks Barney, but it seems entirely unpractical that mx cant distinguish application names/variables when they are set on differenct sites. Are you telling me that this is a bug and there is no other way around it except for separate instances of jrun? On Sun, 16 Jan 2005 17:04:54 -0800, Barney Boisvert [EMAIL PROTECTED] wrote: Set up multiple CF instances in JRun. The free developer edition (or the soon to be killed DevNet version) let you do this without cost. You'll be running each version of the app in a totally independant environment with no possibility of confusion. We do this in our office with great success. It does require a bit of RAM in the dev server though, since CF isn't a very lightweight app, and you have a complete copy of it for each instance. These phantom problems that you're having (among other things) prompted me to go this route, rather than just running multiple versions on the same instance. It's a little more headache to get everything set up, but it's worth it. cheers, barneyb On Mon, 17 Jan 2005 11:39:20 +1100, Duncan I Loxton [EMAIL PROTECTED] wrote: I have found that we had cache web server paths checked in the Server Administrator. Now the different sites are running the correct versions of the code, but they are still sharing the applications vars. I cant find anything in the cf admin that could be making this happen. My application.cfm now sets the app name dynamically: cfif findnocase(dev,cgi.server_name) cfset request.appmapping = intranet_dev cfelse cfset request.appmapping = intranet /cfif Cfparam name=request.appmapping default=intranet cfapplication name=#request.appmapping# sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,0,20,0)# and the request.appmapping is returning the correct info. Then in myGlobals.cfm: !--- only set application variables if not already defined in application scope --- cfif NOT IsDefined(application.datasource) or isdefined(attributes.refreshvars) cflock type=EXCLUSIVE timeout=60 scope=application cfif findnocase(dev,cgi.server_name) cfset application.datasource=MPlus_dev cfset application.dbusername=sa cfset application.dbuserpwd=191nsh cfelse cfset application.datasource=MPlus cfset application.dbusername=sa cfset application.dbuserpwd=191nsh /cfif cfset application.checkip=1 cfset application.nonExclusionList= cfset application.maxRows=20 /cflock /cfif But both applications overwrite the others info when I refreshvars or restart CF services. Please can anyone help me out? I am about to have a breakdown. Duncan -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 8 invites. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190658 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: application and path problem 2 environments on one machine
CFMX happily distinguishes different applications with no problem, so that's not the issue. There are a lot of things to deal with in trying to run completely separate instances of the same application inside the same CFMX instance. Enough that I don't think it's practical to try, when there is a simple solution (multiple CFMX instances) that works very well. You'll invariably screw something up, and blame CF when it's a code problem. Believe me. I've done this. You have to have separate application names, separate mappings (for CFCs and CFIMPORT), separate custom tag paths (if you still use any), separate DSNs, separate scheduled tasks, separate web services (if you use them), separate web roots, etc. That's a lot of stuff to try and deal with, especially since it almost always ends up being a bunch of conditionals in the code (i.e. if (dev) dsn = thisDSN else dsn = thatDSN). That makes for messy code, and it usually also mades for forgetting something in the mess. Bottom line, unless you have a very compelling reason to avoid a multi-instance setup, it's the way to go. These probelms aren't CFMX (or CFML) specific, either, you'll run into them with any environment where you're trying to run two copies of the same thing within a container design for just one. cheers, barneyb On Mon, 17 Jan 2005 12:33:16 +1100, Duncan I Loxton [EMAIL PROTECTED] wrote: Thanks Barney, but it seems entirely unpractical that mx cant distinguish application names/variables when they are set on differenct sites. Are you telling me that this is a bug and there is no other way around it except for separate instances of jrun? On Sun, 16 Jan 2005 17:04:54 -0800, Barney Boisvert [EMAIL PROTECTED] wrote: Set up multiple CF instances in JRun. The free developer edition (or the soon to be killed DevNet version) let you do this without cost. You'll be running each version of the app in a totally independant environment with no possibility of confusion. We do this in our office with great success. It does require a bit of RAM in the dev server though, since CF isn't a very lightweight app, and you have a complete copy of it for each instance. These phantom problems that you're having (among other things) prompted me to go this route, rather than just running multiple versions on the same instance. It's a little more headache to get everything set up, but it's worth it. cheers, barneyb -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 8 invites. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190659 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dynamic CF PDFs - help request
Maybe (just a thought here...) it wouldn't be a bad idea to think Blackstone, or get the Macromedia FlashPaper add-on (it's what, $69? $99?) to go direct html-to-pdf without anything extra in the middle. I think, by and large, Acrobat is a great tool for disseminating information to any supported system, and it encapsulates the data in a really awesome static fomation. However, any attempts I've seen to do dynamic PDFs outside of fairly high-end tools just doesn't work very well. Exception: HTMLdoc. Granted, it's limited and imperfect, but when it's capabilities fit the need, it's AWESOME. I'll keep thinking on it... Laterz, J On Sun, 16 Jan 2005 20:21:31 -0500, Stephen Hait [EMAIL PROTECTED] wrote: Jared, Thanks again. I've tried every configuration I can think of I can't get either of the results you reported. Would you mind trying this link at planetpdf.com and letting me know what happens: http://www.planetpdf.com/planetpdf/inetpub/demo2.html This is the same basic idea of serving a FDF data file that points to a corresponding PDF but it's ASP instead of CF. Even though this FDF/PDF solution has worked for us for a couple of years, it's been a real bear trying to troubleshoot the odd, unreproducible problem. There are too many different factors between operating system and patch level, browser version and patch level and plugin configuration, Reader or Acrobat version(s), etc. Since there doesn't seem to be much problem with reading actual PDF files in most browsers, I think I will start looking at a solution that fills and saves a PDF file on the server and then serves that to the requestor. If you have any advice along those lines, please lay it on me. Thanks again for your time, Stephen Stephen... I just hit the URL again using IE 6. I got two messages from Acrobat, one that the page contained no comments with Yes and No buttons. The other one said This action is not permitted. Both of these ocurred while I had Reader open as a standalone app. When I hit the FDF page without Acrobat open, I, once again, got a blank page and no errors. Sorry dude... Laterz, J On Sun, 16 Jan 2005 13:42:30 -0500, Stephen Hait [EMAIL PROTECTED] wrote: Jared, Thanks to you and Doug James for checking into this issue.I just hit your test page, and the PDF form came up, the contents of the FDF came up... same as Doug. But when I clicked on the link to the FDF, I got the Reader splash screen, and then nothing. Blank screen. No content at all. No errors either... but I'm not sure that's a good thing. I used the FireFox Page Info dialogue to save the FDF to my desktop and when I opened it in Reader, nothing at all came up there either, just a blank, gray, empty Reader screen. It seems that Firefox has some known issues when trying to display a PDF via a FDF (content of type Application/vnd.fdf). I should have made it clearer that what we're trying to reproduce are errors when opening the form with _Internet Explorer_. That link again is: http://www.hopeaviation.com/pilotform/test/index.cfm If anyone else could test this with IE and report whether it succeeds or how it fails, I'd appreciate it.The system is oriented toward delivering content from a base64 encoded DB text table, but the example uses a PDF which is streamed back to the browser in a CFM page with cfcontent and cfheader making Acrobat think it's a PDF file... source code is downloadable from the link provided. This is basically what we're doing, too, except that we're trying to make the browser think that it's a FDF file (mime type would be Application/vnd.fdf). Here's another example for comparison at planetpdf.com (FWIW, this is the same situation but using ASP instead of CF. I have the same problems with Firefox and this example): http://www.planetpdf.com/planetpdf/inetpub/demo2.html Thanks again, Stephen -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190660 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dynamic CF PDFs - help request
BTW... that sample site in ASP isn't working for my version of Reader either. I get a file currupted message. I do find that some things just aren't stable with pdfs unless they're generated with Exchange or something, and even then they're twitchy and take tuning to get working sometimes. What's the driver behind needing PDF for this solution, if I may ask? Laterz, J On Sun, 16 Jan 2005 20:18:58 -0600, Jared Rypka-Hauer - CMG, LLC [EMAIL PROTECTED] wrote: Maybe (just a thought here...) it wouldn't be a bad idea to think Blackstone, or get the Macromedia FlashPaper add-on (it's what, $69? $99?) to go direct html-to-pdf without anything extra in the middle. I think, by and large, Acrobat is a great tool for disseminating information to any supported system, and it encapsulates the data in a really awesome static fomation. However, any attempts I've seen to do dynamic PDFs outside of fairly high-end tools just doesn't work very well. Exception: HTMLdoc. Granted, it's limited and imperfect, but when it's capabilities fit the need, it's AWESOME. I'll keep thinking on it... Laterz, J -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190661 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: regex help (Almost)
At least I'm not alone :) I had thought about something to that effect but... I wanted content between [code] and [/code] to stay exactly as the user typed it. So if there are b tags they display as b and if there are [b] tags they display as [b] Jim Davis came up with a loop that extracts code blocks and replaces them with a marker... then you can just do your replaces on everything then replace the markers with the original code blocks and voila! It worked well but my assumption was that a regular expression that can replace an open tag and an end tag and at the same time make the decision on rather or not it's between [code] and [/code] would be much faster. I'm at the point where I'll probably just combine both and move on with my life. Thanks for the thoughts, and watch those non-nullable fields! :) -Original Message- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: Sunday, January 16, 2005 8:24 PM To: CF-Talk Subject: Re: regex help (Almost) Still fighting that thing, eh? I spent 3 hours this afternoon trying to figure out why a simple INSERT query wouldn't work... finally I wrapped the query text in ## and a cfoutput, then copy/pasted it into Query Analyzer... only to find out that the problem was a new column in the database that was marked not nullable. I hadn't updated the insert to account for the new column. DANG, I hate when that happens. But, my my thought is this... Why not convert every single HR or BR tag to hr, then run rereplace with a regex that finds [\[code\].hr.\[\/code\]] and converts hr back to [HR]. Granted, it may not be the utmost in elegance (which is never pleasing), but it would work. Just a thought... I'll keep thinking on it too. Hard as that whole thinking thing may be. Laterz, J -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.13 - Release Date: 1/16/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.13 - Release Date: 1/16/2005 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190662 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: regex help (Almost)
Geeze, I sure hope anyone who read this paragraph: Still fighting that thing, eh? I spent 3 hours this afternoon trying to figure out why a simple INSERT query wouldn't work... finally I wrapped the query text in ## and a cfoutput, then copy/pasted it into Query Analyzer... only to find out that the problem was a new column in the database that was marked not nullable. I hadn't updated the insert to account for the new column. Knew I was speaking in shorthand. It's embarrasing. I mean, I pulled it out of the cfquery tag, wrapped it in a cfoutput instead, and rendered the text as-was to the screen... so I had my query, verbatim, as the cfquery tag would be receiving it. Then I copy/pasted THAT into query analyzer, so I could get the actual SQL Server error that was screwing me up. I haven't always been really good about my error handling, because, I guess, I've always thought that if you make the system so it works well, you don't get errors. And, mostly, it's held true. But, times like today remind me that error handling isn't just for end users... it's more for us than anything, because if we do it right, it'll TELL us what's wrong most of the time. Anyway... good luck with your regexes! Laterz, J On Sun, 16 Jan 2005 22:31:51 -0500, Ewok [EMAIL PROTECTED] wrote: At least I'm not alone :) I had thought about something to that effect but... I wanted content between [code] and [/code] to stay exactly as the user typed it. So if there are b tags they display as b and if there are [b] tags they display as [b] Jim Davis came up with a loop that extracts code blocks and replaces them with a marker... then you can just do your replaces on everything then replace the markers with the original code blocks and voila! It worked well but my assumption was that a regular expression that can replace an open tag and an end tag and at the same time make the decision on rather or not it's between [code] and [/code] would be much faster. I'm at the point where I'll probably just combine both and move on with my life. Thanks for the thoughts, and watch those non-nullable fields! :) -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com ~| Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody. http://www.houseoffusion.com/banners/view.cfm?bannerid=39 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190663 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: regex help (Almost)
Dude, have you considered taking a online Computer related stress test or lowering your caffeine intake? Hah jokes. Believe me... we've all been there... just some more than others. :) -Original Message- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: Sunday, January 16, 2005 10:45 PM To: CF-Talk Subject: Re: regex help (Almost) Geeze, I sure hope anyone who read this paragraph: Still fighting that thing, eh? I spent 3 hours this afternoon trying to figure out why a simple INSERT query wouldn't work... finally I wrapped the query text in ## and a cfoutput, then copy/pasted it into Query Analyzer... only to find out that the problem was a new column in the database that was marked not nullable. I hadn't updated the insert to account for the new column. Knew I was speaking in shorthand. It's embarrasing. I mean, I pulled it out of the cfquery tag, wrapped it in a cfoutput instead, and rendered the text as-was to the screen... so I had my query, verbatim, as the cfquery tag would be receiving it. Then I copy/pasted THAT into query analyzer, so I could get the actual SQL Server error that was screwing me up. I haven't always been really good about my error handling, because, I guess, I've always thought that if you make the system so it works well, you don't get errors. And, mostly, it's held true. But, times like today remind me that error handling isn't just for end users... it's more for us than anything, because if we do it right, it'll TELL us what's wrong most of the time. Anyway... good luck with your regexes! Laterz, J On Sun, 16 Jan 2005 22:31:51 -0500, Ewok [EMAIL PROTECTED] wrote: At least I'm not alone :) I had thought about something to that effect but... I wanted content between [code] and [/code] to stay exactly as the user typed it. So if there are b tags they display as b and if there are [b] tags they display as [b] Jim Davis came up with a loop that extracts code blocks and replaces them with a marker... then you can just do your replaces on everything then replace the markers with the original code blocks and voila! It worked well but my assumption was that a regular expression that can replace an open tag and an end tag and at the same time make the decision on rather or not it's between [code] and [/code] would be much faster. I'm at the point where I'll probably just combine both and move on with my life. Thanks for the thoughts, and watch those non-nullable fields! :) -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190664 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: regex help (Almost)
:P I just read the note I sent and thought Good god, that sucked. Figured if I thought it, someone else probably did too. But then, we're all our own worse critics... And I only got 2 cups of coffee today... every time I went to fill my cup, the pot was empty. Hey, maybe that's the problem... not ENOUGH caffeine. Laterz, J On Sun, 16 Jan 2005 22:56:54 -0500, Ewok [EMAIL PROTECTED] wrote: Dude, have you considered taking a online Computer related stress test or lowering your caffeine intake? Hah jokes. Believe me... we've all been there... just some more than others. :) -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190665 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dynamic CF PDFs - help request
Jared Rypka-Hauer - CMG, LLC wrote: really awesome static fomation. However, any attempts I've seen to do dynamic PDFs outside of fairly high-end tools just doesn't work very opensource iText works a treat, though i don't know what you mean by fairly high-end tools, i wouldn't normally classify it that way. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190666 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Dynamic CF PDFs - help request
We had hassles with iText and multiple pages, but we got FOP working a treat. -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Monday, 17 January 2005 12:38 PM To: CF-Talk Subject: Re: Dynamic CF PDFs - help request Jared Rypka-Hauer - CMG, LLC wrote: really awesome static fomation. However, any attempts I've seen to do dynamic PDFs outside of fairly high-end tools just doesn't work very opensource iText works a treat, though i don't know what you mean by fairly high-end tools, i wouldn't normally classify it that way. ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190667 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dynamic CF PDFs - help request
James Holmes wrote: We had hassles with iText and multiple pages, but we got FOP working a treat. really? never had any issues w/it. nothing a quick email to their list didn't solve. ~| Stay Ahead of Hackers - Download ZoneAlarm Pro http://www.houseoffusion.com/banners/view.cfm?bannerid=65 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190668 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFEclipse Stuido (for lack of a better term)
If you were thinking about trying cfeclpse, but didn't want to mess with the plugin hunt, you can now try it out by just downloading the files from my blog, unzip them, then run the Eclipse executable in the cfeclipse.X directory. There are now packages available for MacOSX, Linux, and the other one - weighing in at about 34MB The packages include: Eclipse3.1M4 - for Mac OSX and Linux - Eclipse 3.0 for the other one cfeclipse 1.1.17.2 PHPEclipse 1.1.2 Quantum244_3 JSEditor 0.0.9 CSSEditor 0.0.4 JDBC drivers for JTDS (MSSQL), Postgres, MySql They support CVS and Subversion version systems. You can download them here http://www.robrohan.com/ on the right under eclipse.X Cheers, and let us know how it goes -- ~Blog~ http://www.robrohan.com ~The cfml plug-in for eclipse~ http://cfeclipse.tigris.org ~open source xslt IDE~ http://treebeard.sourceforge.net ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190669 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Dynamic CF PDFs - help request
I'm sure we could have solved it, but we were in evaluation mode and we really liked the coolness of FOP's XML/XSLT interface so we went with that :-) -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Monday, 17 January 2005 2:05 PM To: CF-Talk Subject: Re: Dynamic CF PDFs - help request James Holmes wrote: We had hassles with iText and multiple pages, but we got FOP working a treat. really? never had any issues w/it. nothing a quick email to their list didn't solve. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190670 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFEclipse Stuido (for lack of a better term)
The Other One lol. I've used quantum with the Oracle thin driver and that also works fine - is adding that to the bundle a violation of Oracle's licence or is it worth considering? -Original Message- From: Rob [mailto:[EMAIL PROTECTED] Sent: Monday, 17 January 2005 2:08 PM To: CF-Talk Subject: CFEclipse Stuido (for lack of a better term) If you were thinking about trying cfeclpse, but didn't want to mess with the plugin hunt, you can now try it out by just downloading the files from my blog, unzip them, then run the Eclipse executable in the cfeclipse.X directory. There are now packages available for MacOSX, Linux, and the other one - weighing in at about 34MB The packages include: Eclipse3.1M4 - for Mac OSX and Linux - Eclipse 3.0 for the other one cfeclipse 1.1.17.2 PHPEclipse 1.1.2 Quantum244_3 JSEditor 0.0.9 CSSEditor 0.0.4 JDBC drivers for JTDS (MSSQL), Postgres, MySql They support CVS and Subversion version systems. You can download them here http://www.robrohan.com/ on the right under eclipse.X Cheers, and let us know how it goes ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190671 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
