Platform/Vendors Survey and ColdFusion Features Survey

2008-01-16 Thread Manju Kiran P Pacchhipulusu
Hi, As part of the research for Centaur (next major version of ColdFusion aka ColdFusion 9), we need your feedback on ColdFusion 8 features, what enhancements do you need in them, what new features you want in the new release etc. http://www.surveymonkey.com/s.aspx?sm=yLcENFTqjkIn6gqoFpRiUQ_3d_3d

Re: exporting from a CF Application to MYOB

2008-01-16 Thread Mike Kear
There is a connector you can get to allow direct ODBC connection between MYOB and a SQLServer (and other ) database. I'm currently building an application where there is going to be nightly transfers of data between a web site (customer supplied info going into MYOB) and MYOB (updated credit limit

Re: CFLdap

2008-01-16 Thread Joey Daly
Forgot to include the code, here ya go: > Thanks in advance... > > Trying to use CFLdap with AD to modify a users distribution group, > basically have the ability to move someone in and out of different > groups, getting this error: > > coldfusion.tagext.net.LdapTagException: An

CFLdap

2008-01-16 Thread Joey Daly
Thanks in advance... Trying to use CFLdap with AD to modify a users distribution group, basically have the ability to move someone in and out of different groups, getting this error: coldfusion.tagext.net.LdapTagException: An error has occured while trying to execute modify :[LDAP: error code

Re: CRUD Creation

2008-01-16 Thread s. isaac dealey
> I used to think that people do not care to see the primary key so in > my last big application I did not display them(unique numeric IDs) in > most places. After about 6-8 months it was found that the users want > to see those keys and that they use them to reference things. For > example they r

Re: CRUD Creation

2008-01-16 Thread Dominic Watson
> > But if you had 10 records and then deleted the 10th and then created a new > record, > you had a much greater risk of that record being contaminated with > information from the previous record that had been there .. Excellent point :) I used to think it odd how dbs don't fill in the gaps

Re: CRUD Creation

2008-01-16 Thread s. isaac dealey
> I think reading the article will make your mind up either way about > the wisdom of not using 'auto increments' / surrogate pks (I realise > they are not the same thing). This in particular === 2) The definite possibility of historical data contamination. If you leave your company, and som

Re: CRUD Creation

2008-01-16 Thread Aaron Rouse
I used to think that people do not care to see the primary key so in my last big application I did not display them(unique numeric IDs) in most places. After about 6-8 months it was found that the users want to see those keys and that they use them to reference things. For example they rather say

Re: CRUD Creation

2008-01-16 Thread Dominic Watson
> > Heh... read the article... Had never heard anyone complain before about > arbitrary primary keys... and honestly, it strikes me as being rather > odd... I've only ever heard people complain about meaningful keys > actually. But it just seems really odd to complain that "hey, it's a > challenge

Re: CRUD Creation

2008-01-16 Thread s. isaac dealey
> > > ACK i was missing my # signs!!! new wife must have stolen them! > > > > I hear that's a common problem with newlyweds. :) > > hmmm... you think she only married him for his # signs? :) Yeah, gotta be careful. She might be a # digger. :) -- s. isaac dealey ^ new epoch isn't it time fo

Re: CRUD Creation

2008-01-16 Thread s. isaac dealey
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6136&whichpage=1 Heh... read the article... Had never heard anyone complain before about arbitrary primary keys... and honestly, it strikes me as being rather odd... I've only ever heard people complain about meaningful keys actually. But it just

Re: CRUD Creation

2008-01-16 Thread Charlie Griefer
On Jan 16, 2008 6:52 PM, s. isaac dealey <[EMAIL PROTECTED]> wrote: > > ACK i was missing my # signs!!! new wife must have stolen them! > > I hear that's a common problem with newlyweds. :) hmmm... you think she only married him for his # signs? :) -- "Scientists tell us that the fastest animal

Re: CRUD Creation

2008-01-16 Thread s. isaac dealey
> ACK i was missing my # signs!!! new wife must have stolen them! I hear that's a common problem with newlyweds. :) -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 http://onTap.riaforge.org/blog ~~

Re: Training a new programmer

2008-01-16 Thread Cutter (CFRelated)
We sent a guy (former PHP) to one of Charlie Arehart's bootcamp courses. He's not looking back;) Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Ian Rutherford wrote: > I have an employ

Re: CRUD Creation

2008-01-16 Thread Dominic Watson
Ok, so I did some googling because I wanted to know WHY it was 'best practice' to add a surrogate key to the table and why to rail against the idea of using 'natural keys' as primary keys. I stumbled across perhaps the longest thread I have ever read completely, it starts in November 2001 and the

Re: Barcode Question

2008-01-16 Thread Ryan J. Heldt
Mario- We're working on a project here that creates barcodes embedded in a PDF created with cfdocument. However, you could use cfimage in a similar way. We ended up purchasing a collection of fonts from MyFonts.com (http://www.myfonts.com/info/fontware-code39) but ID Automation has a free Code

Re: CF8 Image function - get size of text written

2008-01-16 Thread C S
You may want to try using TextLayout instead of FontMetrics getStringBounds() for a more accurate measurement. The Font API mentions "The logical bounds does not always enclose all the text. For example, in some languages and in some fonts, accent marks can be positioned above the ascent or be

Re: Barcode Question

2008-01-16 Thread James Holmes
I've used barbecue to generate barcodes in the past: http://www.bifrost.com.au/blog/index.cfm/2006/8/24/Generating-Barcodes-with-Barbecue-and-Coldfusion On Jan 17, 2008 5:34 AM, Ciliotta, Mario <[EMAIL PROTECTED]> wrote: > Hi, > > I was wondering if anyone could assist me with an issue. I am cu

Re: Training a new programmer

2008-01-16 Thread Kay Smoljak
> He has expressed interest in learning more and getting more involved in the > actual programming for the company. > Any suggestions on how best to go about training him? I've got books galore > but I'm not sure how best to introduce him to frameworks, OOP and CF as a > cohesive whole. I've he

Re: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Jochem van Dieten
Mark Kruger wrote: > I tried the DBCC FREEPROCCACHE routine after making a schema change - but it > does not prevent the 'invalid data type" error that sometimes occurs. Any > other useful routines you can think of? No, but I just realized where there is an error in my logic. I was assuming that

Re: The CRUD thread reminds me of something I 'played' around a few years ago...

2008-01-16 Thread Don L
ok, just brought the dead horse back alive now :) some may say user friendly enough, so, it's not for the general public... thanks. > oops, sorry, accesssing my old version cf admin on the same box is a > pain in ??? but hang on... ~~~

RE: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Mark Kruger
Jochem, I tried the DBCC FREEPROCCACHE routine after making a schema change - but it does not prevent the 'invalid data type" error that sometimes occurs. Any other useful routines you can think of? -mark -Original Message- From: Mark Kruger [mailto:[EMAIL PROTECTED] Sent: Wednesday,

Re: CRUD Creation

2008-01-16 Thread Dominic Watson
> > No, it's not sarcasm. Joe Celko is very well known and respected in that > community. Yeh, I see! Just googled "primary keys" "business logic" (cos I'm interested) and his name came up straight away: http://www.codinghorror.com/blog/archives/000817.html Some varying and strong opinions of h

RE: Barcode Question

2008-01-16 Thread Mark Kruger
I'm not sure if this will work for you but I'll mention it. We recently did a project that handled faxes with 2D bar codes. We used a java library from Java4Less to create a 2D "data matrix" code on a fax cover sheet. The idea was that user would fax documents into our fax number (on an Asteisk se

Re: The CRUD thread reminds me of something I 'played' around a few years ago...

2008-01-16 Thread Don L
oops, sorry, accesssing my old version cf admin on the same box is a pain in ??? but hang on... >You tried to access the Developer Edition from a disallowed IP ... >oops got a live server you can toss it on? > >On Jan 16, 2008 3:19 PM, D > >>

RE: CRUD Creation

2008-01-16 Thread Dave Watts
> > Joe Ceiko holds that theory and considering he's so > > influential in the relational db world... > > I assume that's sarcasm; not being a mover in the relational > db world I wouldn't know :P No, it's not sarcasm. Joe Celko is very well known and respected in that community. Dave Watts, C

Re: CRUD Creation

2008-01-16 Thread Dominic Watson
> > Joe Ceiko holds that theory and considering he's so influential in the > relational db world... I assume that's sarcasm; not being a mover in the relational db world I wouldn't know :P I'd opt for the new primary key and unique constraint on the columns everytime. Zero headache. The unique c

Re: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Sonny Savage
The situations I've seen it most is when doing a SELECT * FROM table, and not getting a newly added column in the query result. I've had issues when changing the column order as well. On Jan 16, 2008 3:01 PM, Ben Mueller <[EMAIL PROTECTED]> wrote: > Now that I would *almost* understand and forgi

Re: The CRUD thread reminds me of something I 'played' around a few years ago...

2008-01-16 Thread Richard Dillman
You tried to access the Developer Edition from a disallowed IP ... oops got a live server you can toss it on? On Jan 16, 2008 3:19 PM, Don L <[EMAIL PROTECTED]> wrote: > http://24.254.1.94:8000/snap823/DataMan.cfm > (Have not re-test it thoroughly) > Who could use something like that? > > > > > >

Re: Training a new programmer

2008-01-16 Thread Bruce Sorge
I agree. When one of my employers decided to go from CF to .NET, I was given 90 days to get up to speed to beginner/intermediate level. So they told me to pick some light-weight apps that I did in CF then convert them to .NET. It worked. In about four months I was doing some high level .NET stu

Re: Training a new programmer

2008-01-16 Thread Ben Doom
I'd pick something non-time-critical and non-mission-critical and, as it were, throw him in the shallow end. Give him all the help he asks for. Do a code review. Pick something more important, wash, rinse, repeat. --Ben Doom Ian Rutherford wrote: > I have an employee who has tinkered around

Re: CF8 Image function - get size of text written

2008-01-16 Thread Raymond Camden
Interesting stuff. I've been wanting to do something like this for a while now, but a bit different. Given the string X, and an image Canvas, put X so that is centered horiz and vert. If you had the W/H of a set of text, it would be trivial. On Jan 16, 2008 10:46 AM, Ben Nadel <[EMAIL PROTECTED]>

Barcode Question

2008-01-16 Thread Ciliotta, Mario
Hi, I was wondering if anyone could assist me with an issue. I am currently using the custom tag barcode39.cfm to produce 3 of 9 barcodes from a CF page. I am have a few issues with the fact that the tag and/or the 3 of 9 barcode specification does not support certain characters like the " , "

The CRUD thread reminds me of something I 'played' around a few years ago...

2008-01-16 Thread Don L
http://24.254.1.94:8000/snap823/DataMan.cfm (Have not re-test it thoroughly) Who could use something like that? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://a

Training a new programmer

2008-01-16 Thread Ian Rutherford
I have an employee who has tinkered around with CF and Javascript and is familiar with HTML basics. He has expressed interest in learning more and getting more involved in the actual programming for the company. Any suggestions on how best to go about training him? I've got books galore but I

Re: CRUD Creation

2008-01-16 Thread Don L
On "For some reason a former employer drilled it into the team that Auto incrementing PK's were dead weight if you could composite a key with existing data" Joe Ceiko holds that theory and considering he's so influential in the relational db world... ~

Re: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Ben Mueller
Now that I would *almost* understand and forgive. But we seem to have gotten the error when we added a column that was *not* referenced in the query. So, all we did was add a column--we didn't alter the query at all. Of course, I can't recreate on my laptop (running CF8 and SQL2005 locally),

Re: CRUD Creation

2008-01-16 Thread Richard Dillman
ACK i was missing my # signs!!! new wife must have stolen them! IF NOT EXISTS (SELECT ups_id_pk,ups_provider_fk,ups_client_fk,ups_service_fk FROM user_provider_services WHERE ups_provider_fk = AND ups_client_fk = AND ups_

Re: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Jochem van Dieten
Ben Mueller wrote: > > SELECT firstname > FROM user > WHERE email = > > > MS SQL Server caches the execution plan. Then, I add a "lastname" column to > the user table. I don't change the query at all. I re-hit the query while > the execution plan is cached. It breaks? Probably not if

Re: CRUD Creation

2008-01-16 Thread Richard Dillman
Sorry stepped away from the computer a couple days to get married WOOT! now back to work What I've come up with is: IF NOT EXISTS (SELECT ups_id_pk,ups_provider_fk,ups_client_fk,ups_service_fk FROM user_provider_services WHERE ups_provider_fk =

RE: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Mark Kruger
Jochem, So... If I ran the DBCC operation on the SQL server to flush the execution plan cache immediatley after a shema change - I would not have to fiddle with the queries or restarts or other techniques to draw it over to CF? If so - that's a great tip. -Mark -Original Message- From: J

Re: Problems with CFDOCUMENT and load balancing

2008-01-16 Thread Matthew Williams
> Sticky sessions? Yes. J2EE sessions are enabled. It's been working well for the past year or so. > How about CSS and Javascript? Anyplace where we can see the HTML? There's one block of inline CSS, and no javascript. It seems to mostly be the images tanking this. I'm looking to get perm

Re: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Ben Mueller
God, so annoying. So, let me see if I really have this straight. Let's pretend I have a table called "user" that has two columns: firstname and email. I write a query like this (shortened syntax): SELECT firstname FROM user WHERE email = MS SQL Server caches the execution plan. Then,

Re: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Jochem van Dieten
Ben Mueller wrote: > It sounds like the only time this is a problem is under the following > circumstance: alterations to an existing DB table where a related execution > plan is stored in memory. Correct. > I'm mostly annoyed that this doesn't "just work". Maybe that's unrealistic > of me,

SOT:_Adobe?_Dreamweaver?_Developer_Toolbox

2008-01-16 Thread Chad Gray
Has anyone tried this add-on to dreamweaver? Worth the $300? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive

Re: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Ben Mueller
> > Thanks, Jochem, for the reply. I glanced at that call just briefly; > does it clear *all* stored execution plans, or just a specified one? > It seems like the only way it would be useful in this context is if it > cleared them all, since we have no way of knowing which plans are > cached.

Re: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Adam Haskell
Even when we have updated a schema in the past the execution plan is trashed and a new one is prepared and we do not experience any problems. Why would a schema change multiple times in a day, there is agile and there is ridiculous that seems to be treading on ridiculous. I've never experienced an

Re: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Jochem van Dieten
Ben Mueller wrote: > Thanks, Jochem, for the reply. I glanced at that call just briefly; does it > clear *all* stored execution plans, or just a specified one? It seems like > the only way it would be useful in this context is if it cleared them all, > since we have no way of knowing which pla

Re: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Ben Mueller
Thanks, Jochem, for the reply. I glanced at that call just briefly; does it clear *all* stored execution plans, or just a specified one? It seems like the only way it would be useful in this context is if it cleared them all, since we have no way of knowing which plans are cached. A larger qu

Re: Problems with CFDOCUMENT and load balancing

2008-01-16 Thread Jochem van Dieten
Matthew Williams wrote: > The situation stands as such. I have an application hosted in my environment > that uses the cfdocument tag. Our servers are clustered at the JRun level. Sticky sessions? > We also have a hardware load balancer in front of the servers. When calling > the page conta

Problems with CFDOCUMENT and load balancing

2008-01-16 Thread Matthew Williams
The situation stands as such. I have an application hosted in my environment that uses the cfdocument tag. Our servers are clustered at the JRun level. We also have a hardware load balancer in front of the servers. When calling the page containing the cfdocument through the load balanced URL

Re: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Sonny Savage
Hi Ben, In the ColdFusion administration there is an option for caching or keeping the connection open... I can't remember what it's called. If you disable this option and then re-run the query you can re-enable the option. I've seen other query errors caused by ColdFusion caching the data struc

Problem with lyla captcha

2008-01-16 Thread Prasath Govindarajulu
Getting the following error, Element CAPTCHA is undefined in a Java object of type class [Ljava.lang.String; referenced as The error occurred in C:\Program Files\Apache Group\Apache\htdocs\art\students\undergraduate\accomplish\add.cfm: line 499 499 :

RE: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Adrian Lynch
Have a look at this: But, I think the last I left it, it wasn't working. It was timing out if I remember rightly. Also, you might not need to pass in that much data, but instead glean it from the datasource. Just an

Re: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Jochem van Dieten
Ben Mueller wrote: > We hit a problem with morning relating to cfqueryparam. A query using > cfqueryparam referenced a table whose structure had been changed (we added a > column). It appears the execution plan had been cached, and either CF7 or > SQL Server 2000 wasn't smart enough to figure

RE: CF8 Image function - get size of text written

2008-01-16 Thread Ben Nadel
John, I did something that was inspired by Barney Boisvert. An image function that draws text areas rather than just a line of text: http://www.bennadel.com/blog/977-ColdFusion-8-ImageDrawTextArea-Inspired -By-Barney-Boisvert-.htm In order to do this, I had to figure out the dimensions of the t

Re: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Ben Mueller
Tom, Thanks for the reply, but I don't think that would solve the problem. The issue is that the execution plan itself is cached, and so it doesn't know about the underlying database changes. If I run a different query, it won't affect this execution plan. And even if it did, that's still no

fckeditor

2008-01-16 Thread Eric Roberts
Has anyone encountered an issue with fckeditor where it inserts a style property into the divs (style="margin 0pt 0pt 0pt 0pt") that causes the ext within the div to form a tight column on the left instead of the text populating the entire td? I didn't see anything specifically about his on t

RE: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Adrian Lynch
You should be able to do it with code. Using the Admin API you can switch a flag (can't remember which one) off and on again for a given datasource. This should clear the cached plan. I had a function to do it but it's at home. If you wait about 5 hours! :OD I also didn't get around to testing it

Re: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Todd
And, in addition to what Tom is saying, I don't think you have to do this all the time. Just one time? That's what I'm gathering from all the comments on Ray's page. On Jan 16, 2008 11:30 AM, Tom Chiverton <[EMAIL PROTECTED]> wrote: > On Wednesday 16 Jan 2008, Ben Mueller wrote: > > and if we h

Re: cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Tom Chiverton
On Wednesday 16 Jan 2008, Ben Mueller wrote: > and if we have to cycle the CF service on our production servers every time > we make a database change, we'll simply be forced to abandon cfqueryparam > entirely. If all you need to is run a query against the new table, why not just do that from a p

cfqueryparam, cached execution plans, and changing table structure

2008-01-16 Thread Ben Mueller
We hit a problem with morning relating to cfqueryparam. A query using cfqueryparam referenced a table whose structure had been changed (we added a column). It appears the execution plan had been cached, and either CF7 or SQL Server 2000 wasn't smart enough to figure out that the table had chan

Re: Ajax CFgrid in cf8 help

2008-01-16 Thread Cutter (CFRelated)
OK, you have your grid object, 'mygrid', now you can do a bit more before your .reconfigure(). Create your paging Toolbar. First you need to get your grid footer: var gridFoot = mygrid.getView().getFooterPanel(true); After this you create a new PagingToolbar: var paging = new Ext.PagingToolbar

CF7 and Axis 1.4

2008-01-16 Thread Stewart Turnbull
Has anybody upgraded CF7 to Axis 1.3 or even version 1.4? Any pointers greatly received. Stewart ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.ne

Re: IP Address to Country API

2008-01-16 Thread Jim Wright
On 1/15/08, Coldfusion Monkey <[EMAIL PROTECTED]> wrote: > Just wondering if you guys are aware of any negatives in using this service > like updates to db, uptime,speed etc. I've had some issues with coverage and accuracy with hostip...when I was first testing it, I had a friend in New Bern, NC

Ajax CFgrid in cf8 help

2008-01-16 Thread Paul Stewart
Hi, I have been using the CFgrid tag in CF8 (format HTML, bound to a cfc), and i have got it do almost all that i need it do (see below). Except that i don't know how to get access to the TOTALROWCOUNT figure that i can see in the debugger returned from the CFC , and also be able to display th

Re: CGI parameters

2008-01-16 Thread benjamin schwartz
Well before that i had CF8 (developper) installed as a war app above tomcat (apache wasn't involved) and it was already giving me this problem. I read something about a proxy redirecting the requests - i don't think that it's the case. It's very strange. If anyone has something to suggest? :) Ben

Re: CGI parameters

2008-01-16 Thread Tom Chiverton
On Wednesday 16 Jan 2008, benjamin schwartz wrote: > No. :) I thought of that. And it's a normal CF8 install via Apache ? Maybe (on Macs) CF sees this as Apache requesting the files, not the end user ? -- Tom Chiverton Helping to elementarily promote low-risk platforms on: http://thefalken.live

Re: CGI parameters

2008-01-16 Thread benjamin schwartz
No. :) I thought of that. On Jan 16, 2008 7:29 AM, Tom Chiverton <[EMAIL PROTECTED]> wrote: > On Wednesday 16 Jan 2008, Ben S wrote: > > Here is the problem when i try to get a client IP address using > > #cgi.REMOTE_ADDR# i get the ip address of the server. > > Are you running the web browser

Re: CGI parameters

2008-01-16 Thread Tom Chiverton
On Wednesday 16 Jan 2008, Ben S wrote: > Here is the problem when i try to get a client IP address using > #cgi.REMOTE_ADDR# i get the ip address of the server. Are you running the web browser on the same host as the web server ? -- Tom Chiverton Helping to revolutionarily scale dot-com meta-ser

CGI parameters

2008-01-16 Thread Ben S
Hi, I just installed CF 8 Standard (running on os X - with apache serving the files). Here is the problem when i try to get a client IP address using #cgi.REMOTE_ADDR# i get the ip address of the server. I was reading a thread on here about a similar problem and someone suggested using #CGI.

RE: beat a dead horse?

2008-01-16 Thread Will Swain
Glad to be of help. -Original Message- From: Don L [mailto:[EMAIL PROTECTED] Sent: 15 January 2008 16:32 To: CF-Talk Subject: Re: beat a dead horse? Many thanks, Will, this is exactly what caused the problem which initially I did not expect, I wished I checked this thread first 45 min

ColdFusion 8 Report Builder on Vista Home Premium

2008-01-16 Thread Alfredo Dimaunahan
Hi, I would like to know if anyone had encountered this same problem on Vista when using CF 8 Report Builder: - cannot import/export styles. On the Report Styles window, click "Export Report Styles", the save dialog window will be displayed, then enter the filename and click save button. The p

Re: calendar event

2008-01-16 Thread Ravi Shankar
>OK, I feel like an ass now. I'm sorry. From his other thread I see that he >had already put in some up-front work. I guess I'm personally annoyed by >people who don't do any research or attempts before asking for help. Again, >I'm sorry Ravi. > >Sonny. > >P.S. Are you related to the musician w

Re: designing db tables for calendar events

2008-01-16 Thread Ravi Shankar
> >what are you ideas so far? what design have you come up with on your > own? > > > >--- > >Azadi Saryev > >Sabai-dee.com > >http://www.sabai-dee.com > > > > > > > >Ravi Shankar wrote: > >> Ravi > > My approach is following > - > PatternbaseTable > --- > Patt