Search results for query: *

Thanks tsuji, just the ticket.

Hey Guys, not sure if this is the right forum, but here goes... I'm new to regex patterns, I'm using a simple one to validate a date. dd/mm/yyyy. /^[\d]{2}\/[\d]{2}\/[\d]{4}$/ Can someone help me figure out how to limit the day portion to 01 - 31 and the month portion to 01 - 12. I have...

Hi, I've got a number of components (edit boxes etc.) and the contents are inserted into a sql table on the click of a button. It insert only works if there are less than about 20 characters in one of my tMemo components. It all seems ok to me, it has a maxlength property of 0 etc. Any ideas...

hello all, I'm getting a bcp error "Expected the TEXT token in data stream for bulk copy of text or image data" when importing data. Initially i thought it was something to do with the size of the data in the TEXT field but i'm beginning to doubt this. I'm using the same fmt file for the...

sorted it. it was something stupid. The the SQL needed to be a SELECT AS because it's a function.

All, New to coldfusion so forgive the stupidity. I'm trying to authenticate a user against a SQL Database but cannot use my SQL variable in a CFIF. Code is as below. <cfquery name="PassCheck" dataSource="cfBest"> SELECT PWDCOMPARE ('" & form.Password & "',(SELECT password FROM...

Thanks Guys

Hi, I'm new to delphi and been lumbered with a project for work. I need to pad a number with zero's. ie. 1 becomes 0000001 2 becomes 0000002 etc Similar to the RIGHT function in SQL. I'm sure it's simple, i just can't find it. Thank you.