Re: OT: SQL Server database problem

2002-10-28 Thread Rizal Firmansyah
I think the error message is straight forward, that is you are trying to insert string that's longer than your datatype can handle. For example: Field: MessageTitle (16): You are trying to insert: Some text to throw error which has 24 characters. Try to increase the length of the field in your

Re: OT: SQL Server database problem

2002-10-28 Thread Rizal Firmansyah
Just another taught... Using varchar instead of text as a datatype for this kind of data maybe helpful... Rizal At 10:21 PM 10/28/2002, you wrote: I think the error message is straight forward, that is you are trying to insert string that's longer than your datatype can handle. For example:

Re: Payment Gateway

2003-03-06 Thread Rizal Firmansyah
Payflow link, 2checkout and authorize.net are good, worth to consider... Talking about integration with CF, when i was working with SentraCommerce, i've successfully integrate 2checkout, Payflow Link, Authorize.Net, GoEMerchant, Iongate and other gateways with ColdFusion. As long as the gateway

Re: Session Hijack

2003-06-25 Thread Rizal Firmansyah
I use dynamic cookie to prevent session hijacking. Dynamic on both name and value. Here's the idea: 1. For each session, the system will then create a random cookie name and a random value. 2. Each request, the system should check the existence of cookie generated in point 1. So if someone

Re: Incoming email manager

2003-01-06 Thread Rizal Firmansyah
David, i've made a helpdesk/trouble ticketing system like this based on CF. Basically it scans POP3 account, and check the subject and content of the email. If the system founds specific keywords, then the email will be redirected to agents (cust. support). My app uses cfschedule for mail

RE: Incoming email manager

2003-01-06 Thread Rizal Firmansyah
Okay, first of all, thanks for your offer. I've now setup my CF helpdesk on my prev. company account :) For all of you who want to take a look, here's the info: URL: http://216.218.205.107/helpdesk/backoffice Sysadmin login: username: [EMAIL PROTECTED] pass: helpdesk Feel free to try this app,

Re: cold fusion hosting with full tag support

2003-01-06 Thread Rizal Firmansyah
Paris, have you try www.powersurge.net Afaik they support all CF tags, no restriction. Rizal At 12:56 AM 1/7/2003, you wrote: I have a client who has a project I have created that requires full tag support... for some reason, they want to be cheap on the hosting side... $150-200 a month is too

RE: Incoming email manager

2003-01-06 Thread Rizal Firmansyah
: Rizal Firmansyah [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 12:13 PM To: CF-Talk Subject: RE: Incoming email manager Okay, first of all, thanks for your offer. I've now setup my CF helpdesk on my prev. company account :) For all of you who want to take a look, here's the info: URL

RE: Incoming email manager

2003-01-06 Thread Rizal Firmansyah
Ooppsss, forgot to tell you that this app only works in IE 5++ Sorry for the inconvinience. Rizal At 07:23 AM 1/7/2003, you wrote: Doesn't seem to do anything (in mozilla 1.0) Rob -Original Message- From: Rizal Firmansyah [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 4:12

Re: CF vs. ASP

2002-08-26 Thread Rizal Firmansyah
At 09:14 AM 8/27/2002, you wrote: cfset thefile = d:\cdr\p.jpg cfmail from=#email# to=#email# subject=test cfmailparam file=#thefile# test /cfmail cffile action=delete file=#thefile# Error in the mail.log: Error,scheduler-4,08/27/02,04:03:47,,Sending failed; nested exception is:

Need beta tester (Was:Re: eCommerce - shopping carts - Your Opinion)

2002-09-04 Thread Rizal Firmansyah
Guys, I'm in the middle of developing SentraCommerce v2. Basically SentraCommerce is an e-commerce enabler application. At the core of SentraCommerce is its e-commerce engine with user's friendly and feature-rich web based store-manager. To learn more about SentraCommerce, please browse to:

Re: OT: Naming Convention choice

2002-07-05 Thread Rizal Firmansyah
I use Hungarian style for naming convention, that is using prefix such as: i for integer - iQuantity str for string - strName fl for float - flPrice qry for query - qryProducts etc... and i lower case every tags (thanks to CF studio) Rizal At 09:13 PM 7/5/2002, you wrote: Curious as to which

RE: OT: Naming Convention choice

2002-07-05 Thread Rizal Firmansyah
aaah... nice link :) actually the first time I read this Hungarian notation (or whatever you call it) is in Code Complete book by McConnell - M$ press, if i'm not mistaken. That was 7 years ago... The idea of Hungarian notation is really good, and it's applicable in most programming languages,

RE: CF MX Service Pack Timeline?

2002-07-05 Thread Rizal Firmansyah
Ben, how about bug: 45938? (select, drop, no recordset is returned) I think CFMX final release still contains this bug... I'm using cftrycfcatch as a temporary solution for this... Rizal At 12:35 AM 7/6/2002, you wrote: The COM problems in particular is being looked at. If there is an SP I am

Re: cfusion_verifymail error in CFMX

2002-07-09 Thread Rizal Firmansyah
Brian, i believe this CFusion_VerifyMail undocumented function no longer exist in CFMX. Here's my code to replace it: cfobject action=CREATE type=JAVA class=coldfusion.server.ServiceFactory name=factory cfscript function my_cfusion_verifymail(smtp,port,timeout) { ms =

RE: Unzip?

2002-07-11 Thread Rizal Firmansyah
Dear Jeff, i'm interested to see your CFX Unzip in action. Do you have any demo site? Or maybe you could send me the component? Thanks, Rizal At 01:16 AM 7/12/2002, you wrote: I have a java CFX tag that implements the java.util.zip package. Let me know off the list if you are interested in

RE: Unzip?

2002-07-11 Thread Rizal Firmansyah
Uupppsss... sorry, this mail is suppose to be off list :( Rizal At 07:11 AM 7/12/2002, you wrote: Dear Jeff, i'm interested to see your CFX Unzip in action. Do you have any demo site? Or maybe you could send me the component? Thanks, Rizal At 01:16 AM 7/12/2002, you wrote: I have a java CFX

Re: Hosting

2002-04-25 Thread Rizal Firmansyah
Powersurge - www.powersurge.net I've used them for 3 years, nice support, no CF tag limitation, they're all enabled. Rizal At 02:03 AM 4/26/2002, you wrote: Does anyone know of a good CFML hosting company that has CFFile enabled that I can register a domain through?

RE: CFHTTP Connection Failure (fwd)

2002-05-14 Thread Rizal Firmansyah
Tony, are you sure that this is not https issue? Check this kb: http://www.macromedia.com/v1/handlers/index.cfm?ID=22713Method=FullPageCall=/support/index.cfm http://www.macromedia.com/v1/handlers/index.cfm?ID=1608Method=FullPageCall=/support/index.cfm I found that several https sites require

Re: Recommend a replacement for CFMAIL

2002-05-15 Thread Rizal Firmansyah
I am using ASPMail from ServerObjects. There's a cf custom tag: cf_aspmail to use ASPMail with CF too. HTH, Rizal At 11:19 AM 5/16/2002, you wrote: Can anyone recommend a good replacement for CFMAIL, should able to handle bulk emails (~20k/day) reliably. Should not cost more than US$ 100. I'm

Re: SQL record retrieval problem

2003-10-01 Thread Rizal Firmansyah
What database are you using? If you're using SQL server, you can do this: SELECT emailaddress FROM E1_EmailAdr WHERE right(emailaddress,7)='aol.com' if you're using Oracle,you can use substr function: SELECT emailaddress FROM E1_EmailAdr WHERE

Re: ColdFusion Coding Contest

2004-04-05 Thread Rizal Firmansyah
Kevin, just curious... is this contest still open? And are we allowed to play this in god's mode? You know... solve it by looking at the whole maze, instead of thinking like the mouse inside (which can only go U,D,L,R). And then backtrack the solution to give the right direction (U,D,L,R)?

Re: Primary key preference quick poll

2003-11-10 Thread Rizal Firmansyah
Well, i guess that depends. For me: 1. If the PK will be used as FK in other table - UUID. 2. If this is just a surrogated key, or a simple key in a relation table, which won't be used in other table, then i prefer to use identity Rizal At 09:09 AM 11/11/2003, you wrote: Why do you prefer 1.

Re: Evaluate an Array

2003-11-13 Thread Rizal Firmansyah
You can treat the response string as a delimited list. The delimiter should be ''. And for each element in that list, you have to treat them as a list again, but now using '=' as the delimiter. From the latest list, the first element will be the variable name, and the last element will hold

cfhttp - https - linux

2003-11-28 Thread Rizal Firmansyah
Guys, i've a problem on my client's Linux - CFMX box. I have this script that use cfhttp to connect to a https server on port 15000. Both 'https' and port is specified in cfhttp attributes. The same script works like charm in Win2k machine, but when i put it in the linux box, it always give me

Re: CFTicket

2003-12-07 Thread Rizal Firmansyah
I've a trouble ticket / helpdesk application. You may check the demo: URL: http://216.218.205.107/helpdesk/backoffice Sysadmin login: username: [EMAIL PROTECTED] pass: helpdesk Currently it supports: 1. Unlimited email accounts, smtp servers. Support all types of SMTP and POP3 server. 2.

Re: Application Modeling/Design/Diagramming

2003-12-08 Thread Rizal Firmansyah
Mostly i use PowerDesigner for designing big system. But sometimes i use Visio for medium size application. Rizal At 03:39 AM 12/9/2003, you wrote: Hello everyone, I wanted to get some idea of what everyone uses to layout an application prior to building it. I'm trying to improve my skills and

Re: CF Hosting

2003-12-23 Thread Rizal Firmansyah
Try PowerSurge www.powersurge.net I'm not sure about tape backups and IMAP though... :) Just ask them. Rizal At 11:42 PM 12/23/2003, you wrote: Ok, I know this has been asked multiple times, but I want to see if anyone has a direction for me based on my specific needs... I need to find a

Re: CSV HELL

2004-06-22 Thread Rizal Firmansyah
Rich, i have a custom tag to parse CSV files. Perhaps you can give it a shot: http://www.cftagstore.com/tags/csv2query.cfm Try the example here: http://www.masrizal.com/product/custom%20tag/csv2query/docs%20%26%20examples/csv2query_example.cfm Copy paste your CSV files into the textarea, and see

Re: Best Database Engine for ColdFusion (Survey)

2007-10-18 Thread Rizal Firmansyah
That depends on your requirement and budget... But for enterprise use, i'd say Oracle and SQL Server 2000. Personally i don't think SQL Server 2005 is worth an upgrade :) Rizal At 11:42 PM 10/18/2007, you wrote: Hi to all, i have to create a Database Server to work with ColdFusion. I'd like to

Re: Best Database Engine for ColdFusion (Survey)

2007-10-19 Thread Rizal Firmansyah
That depends on your requirement and budget... But for enterprise use, i'd say Oracle and SQL Server 2000. Personally i don't think SQL Server 2005 is worth an upgrade :) Rizal At 11:42 PM 10/18/2007, you wrote: Hi to all, i have to create a Database Server to work with ColdFusion. I'd like to

VPS hosting, anyone?

2007-12-13 Thread Rizal Firmansyah
Hi Guys, i need your input on choosing VPS hosting service. Anyone using it? Any pros and cons on using shared vs vps vs dedicated machine? Thanks, Rizal ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic

Re: VPS hosting, anyone?

2007-12-14 Thread Rizal Firmansyah
Thanks for your input guys. Correct, CFAdmin is one of the feature i very much like with a VPS. I have looked at all your recommendation, and all looks good to me :) Btw, is anyone using triple8 (www.888.net)? I tried their live help system, and the agent looks very knowledgable with CF (at

RE: Does anyone know of a non-idiot CrystalTech support person?

2007-12-17 Thread Rizal Firmansyah
I'm experiencing the same now, duh :( CT support has gone worst since last year :( That's why i'm thinking of having a VPS... Rizal At 10:33 PM 12/17/2007, you wrote: -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Monday, December 17, 2007 6:57 AM To:

Re: Best Multipart File Upload Tool? Recommendation Needed

2006-06-06 Thread Rizal Firmansyah
Hi Jon, ActiveX, Java applet or a Flash will do the job. We have a Flash based upload component (custom tag) that will do this. You might want to check them: 1. For single file upload: http://www.masrizal.com/index.cfm?fuseaction=idea.download_detailProductID=cf_flashupload 2. For multiple

Re: Stored procs (was Top 100 ColdFusion Programmers)

2006-08-27 Thread Rizal Firmansyah
Interesting topic, eh? As long as the SP doesn't get recompiled, the SP should be somewhat faster than plain CF query. SP coded in T-SQL or the powerful PL/SQL can save you lots of time doing the same thing in CF too. But when it goes to deployment, it will take more steps for just to upgrade

RE: Handle lists with delimiters in the data.

2006-08-23 Thread Rizal Firmansyah
Ian, you can try my CSV2Query custom tag: http://www.masrizal.com/index.cfm?fuseaction=idea.download_detailProductID=cf_csv2query Try our live example, copy paste your CSV and see the result... It can handle great deals of CSV problems like text qualifier inside qualifier, or delimiter inside

Re: Cross - Site Scripting

2005-10-18 Thread Rizal Firmansyah
I don't think myspace.com's related problem has anything to do with cfqueryparam... I think this is a bad coding, that's all... Here's piece of the http://www.betanews.com/article/CrossSite_Scripting_Worm_Hits_MySpace/1129232391self-propagating cross-site scripting (XSS)

Re: ColdFusion and Microsoft Excel

2006-11-28 Thread Rizal Firmansyah
Yes indeed. Our CFX_Excel uses Jakarta POI to deal with stuff. But it's significantly faster than other POI implementation according to our customers. We also plan to release CFX_Excel v3 before end of this year. IMHO POI only provides basic way to write/read Excel files. But when it comes to

Re: URL re-write SEO friendly

2008-04-21 Thread Rizal Firmansyah
No, i don't think so. It may be true couple of years back, but now it seems Google treats them same. Try this: http://www.google.com/search?sourceid=navclientie=UTF-8rls=GGLJ,GGLJ:2007-50,GGLJ:enq=cfx%5fexcel What do you see at the top? It's the URL that contains querystring... not the folder

Re: Need some advice on speeding up query...

2008-04-22 Thread Rizal Firmansyah
Hi Rick, index will speed up the query if used correctly. I think you can put index on these tables smlc_acr_photos - photo_mls_number smlc_com_photos - photo_mls_number smlc_lot_photos - photo_mls_number smlc_ren_photos - photo_mls_number smlc_res_photos - photo_mls_number Also if the

Re: Split data over multiple mysql tables or leave in 1 table

2008-05-04 Thread Rizal Firmansyah
Hi Scott, regardless of how many records you have (60,000 is small for DB though), i think it's better if the DB design and logic jobs are separated. Assuming you have a correct index, saving them all in one large table is ok. So, you can keep the current logic the same. If you really care about

Re: Yet another validating email addresses question

2008-06-14 Thread Rizal Firmansyah
isValid only validates the string format, it doesn't check whether the domain, or the email address really exists. To do that, you need to check DNS MX record and perform SMTP check. Or you can also use cfmail without spooling and trap the error to decide whether the email address is ok or

RE: HELP! SQL Injection Attack!

2008-08-07 Thread Rizal Firmansyah
I tried to decipher the SQL injection which hits my websites thousand times for this week. I found this particular code (it's attacking MS SQL): select a.name,b.name from sysobjects a,syscolumns b where a.id=b.id and a.xtype='u' and (b.xtype=... or b.xtype=... or b.xtype=... or b.xtype=...)

RE: HELP! SQL Injection Attack!

2008-08-07 Thread Rizal Firmansyah
Yup, that's correct Justin. Just a warning sign though :) I switch my hosting back in 2003, because the system event though it gives me my own SQL user/pass but it actually can see and queries other DB on the same machine (wrong priv). My current hosting, also allows user to query 3-4 other DB,

Re: Flat File as a Database?

2009-01-26 Thread Rizal Firmansyah
Just an idea: I think you can use MS ODBC to deal with delimited text file as a database or You can do this: 1. Convert the text file as a recordset. This can be done by converting your delimited text file (CSV) to CF Query (recordset) 2. Use QoQ for select operation against the recordset. 3.

Re: Is Coldfusion losing it biggest asset?

2011-01-12 Thread Rizal Firmansyah
Somehow i agree with Irvin :) I've been doing programming since Basica/GWBasic (that's somewhere in early 90 or late 80), and am proficient in coding Java, C++, Delphi, TSQL, PL/SQL and such... What i love most from CF is it's easy to understand and can do things in 3-4 LOC whereas other

Re: Is Coldfusion losing it biggest asset?

2011-01-12 Thread Rizal Firmansyah
Whoa, assembler.. back to the old days when moving to 16bit... All ended with *W :) Yeah, those are for hardcore jobs only... I got several projects though :) Rizal At 09:29 PM 1/12/2011, you wrote: I also have done Pascal, Fortran, Basic, Cobol, Assembler... never got any jobs doing that

RE: Is Coldfusion losing it biggest asset?

2011-01-12 Thread Rizal Firmansyah
Wow, the commodore! International karate, right? So, CF is a bless eh :) Rizal At 09:51 PM 1/12/2011, you wrote: Nah this was 8 bit 6502 assembler Lda#$00 Sta$d020 Sta$d021 Commodore64 fans should know what that does :-) Russ -Original Message- From: Rizal Firmansyah

Re: Consultant's Revenge

2008-02-02 Thread Rizal Firmansyah
I'm running an offshore ColdFusion developer from Jakarta, that is south east Asia. My company's rate is US$40/man/hour, i think it's not that cheap :) Currently we have 0 customers that won't pay us. Infact, we never ask for down payment cause we're 100% sure that our client will benefit from