Re: OT: HackerSafe

2007-06-07 Thread robert . rawlins
It's a tough choice on this kind of thing isnt it, When I try selling my services to clients, security is always at the front of their mind and they love to have some form or reasurance, and something familiar like VeriSign SSL and the HackerSafe badge can definatly add that level of assurance to

Re: Error converting data type varchar to int.

2007-06-16 Thread robert . rawlins
- From: Robert Rawlins - Think Blue To: CF-Talk Sent: Fri Jun 15 10:56:00 2007 Subject: RE: Error converting data type varchar to int. Right you are Jochem! Here is the stored proc code: CREATE PROCEDURE Sp_Credential_Create @User_IDINTEGER, @Username VARCHAR

Telnet/SSH From CF?

2007-06-16 Thread Robert Rawlins
Hello Guys, I'm looking to access a remote Telnet/SSH server and run a few differet commands. I know quite some time back I was reading through a scorpio wish list and one of the items listed (and getting a few votes) was cftelnet as a tag. Can anyone confirm is Adobe have put this in to

Re: Error converting data type varchar to int.

2007-06-16 Thread robert . rawlins
. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Robert Rawlins - Think Blue To: CF-Talk Sent: Fri Jun 15 10:56:00 2007 Subject: RE: Error converting data type

Re: Telnet/SSH From CF?

2007-06-17 Thread robert . rawlins
mate, I'll let you know how I get on. Rob On 16 Jun 2007, at 12:11, Robert Rawlins wrote: I'm looking to access a remote Telnet/SSH server and run a few differet commands. I know quite some time back I was reading through a scorpio wish list and one of the items listed (and getting a few

Re: Error converting data type varchar to int.

2007-06-17 Thread robert . rawlins
within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Robert Rawlins - Think Blue To: CF-Talk Sent: Fri Jun 15 10:56:00 2007 Subject: RE: Error converting data type varchar to int. Right

Re: Error converting data type varchar to int.

2007-06-17 Thread robert . rawlins
are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Robert Rawlins - Think Blue To: CF-Talk Sent: Fri Jun 15 10:56:00 2007 Subject: RE: Error converting data type varchar to int. Right you are Jochem! Here

Re: Error converting data type varchar to int.

2007-06-17 Thread robert . rawlins
-Original Message- From: Robert Rawlins - Think Blue To: CF-Talk Sent: Fri Jun 15 10:56:00 2007 Subject: RE: Error converting data type varchar to int. Right you are Jochem! Here is the stored proc code: CREATE PROCEDURE Sp_Credential_Create @User_IDINTEGER, @Username

Re: Error converting data type varchar to int.

2007-06-17 Thread robert . rawlins
it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Robert Rawlins - Think Blue To: CF-Talk

Re: Error converting data type varchar to int.

2007-06-17 Thread robert . rawlins
it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Robert Rawlins - Think Blue To: CF-Talk

Re: Error converting data type varchar to int.

2007-06-17 Thread robert . rawlins
Hi Neil, I've just tried an in-line query and that appears to work just fine. I'm unable to try the other elements as my SSMS seems to have decided to forget my connection passoword so I cant get connected untill I'm in the office, doh! Rob

Re: Error converting data type varchar to int.

2007-06-17 Thread robert . rawlins
Hi Neil, I tried the truncate method and that didnt have any effect. I created a new version of the proc as follows. cfquery name=LOCAL.qUpdate datasource=SecurityModel CREATE PROC Proc_Credential_Create @User_ID INTEGER

Re: Error converting data type varchar to int.

2007-06-17 Thread robert . rawlins
'TestUsername' and 'TestPassword' is what i've been using for testing. cfprocparam value=testusername variable=MemberUsername cfsqltype=cf_sql_varchar / cfprocparam value=testpassword variable=MemberPassword cfsqltype=cf_sql_varchar / Rob What are the respective values of @MemberUsername and

Re: Error converting data type varchar to int.

2007-06-17 Thread robert . rawlins
Thanks Neil, It certainly is very odd, I have no idea what its doing, like you say with that explicite string definition it should be fine. I've sent a mail to my SQL guy to see whether he has any suggestions as to what might be causing the issue. Thanks mate, Rob Hmm, so it failed even when

Validating Data

2007-06-17 Thread Robert Rawlins
Hello Guys, I feel like a bit of a putts for asking this, but its the first time I've done any validation code for a while and I'm feeling a little rusty. I have a string which I need to ensure contains no spaces, only letters with NO special chars or numbers. I was hoping to put each of

Re: Validating Data

2007-06-17 Thread robert . rawlins
Sorry, I should probably have mentioned that I'm after CFML server-side validation and not a client side solution. Thanks, Rob Hello Guys, I feel like a bit of a putts for asking this, but its the first time I've done any validation code for a while and I'm feeling a little rusty. I have a

RE: Validating Data

2007-06-17 Thread robert . rawlins
Thank you Bobby, thats a gret help. Rob cfset str = ABC 123 *$%^ / cfoutput Has Spaces: #find( , str)#br / Has Numbers: #refind([0-9], str)#br / Has Special Chars: #refind([^\w], str)# br br Clean it up in one shot: #rereplace(str, [^\w], , all)#

Re: PDF creation/modification

2007-06-18 Thread robert . rawlins
What cf version are you running bobby? I'm crossing my fingers (and so should you) that its 7+. :-D Rob So I finally have to create/modify a PDF from CF after all these years. And wouldn't you know it. it's the biggest scholarship application known to man. The PDF has to look exactly like

Javascript Calendar Deeley

2007-08-06 Thread robert . rawlins
Chaps, I know that CF has this stuff built in, but I'm not running it in production quite yet and need an old school solution. I need a little date selector calendar for my forms, similar to those for the datefield in the flash forms, only a JS/DHTML version which can be used on a standard form.

Multiple Users Per Cookie.

2007-09-01 Thread robert . rawlins
Hello Guys and Girls, I generally haven’t had that much experience with setting custom cookies for my applications using the cfcookie tag so thought I’d come on and get a little advice about the best way to handle this concept. The idea is to have a ‘remember me’ type feature on the login for my

Version Controll with IIS

2007-11-10 Thread robert . rawlins
Hello Chaps, I know many of you are running SubVersion for your version control on your Apache based servers, and to be honest I think its about time I got up and running with some proper source control, the number of Projects I have 'on the go' is growing and I need to tidy up my management a

Debugging Model Glue

2007-02-27 Thread Robert Rawlins
Hello Guys, I'm totaly new to the model glue framework, how do I diable debugging output? I'm sure I've seen a setting in the XML somwhere, but I'll be buggered if i can find it now. Thanks, Rob ~| Create robust enterprise,

MG, CS Controller

2007-02-28 Thread Robert Rawlins
Hey Guys, I'm looking for a few tips on whether I should be using ColdSpring to inject beans into my Controller class, my fear is that if I have a whole bunch of setter methods inside my controller layer, with every call to my controller CS will push in a load of new bean instances and we're

DAO, Gateway Access

2007-02-28 Thread Robert Rawlins
Afternoon/Morning Chaps, Whats the 'correct' way to handle retrieving data from persistance when working in an OOP type methodology? I'll try and explain a little example of what i'm trying to achieve, as i'm not quite sure of how I should be utilizing my DAO's and Gateways. I have a certain

Variable getModelGlue is undefined

2007-03-01 Thread Robert Rawlins
Hello Guys, Having a bit of an issue with obtaining access to ColdSpring and Reactor from my model layout in MG using the getModelGlue().getBean() method. I've been using this in my controller to instantiate a bean and it works perfectly, however when I place it in any of the CFC's in my model

Scheduled Task on CFC

2007-03-02 Thread Robert Rawlins
Hello again guys, I've got a scheduled task that I want to run that invokes a 'remote' method in one of my CFC's, however I'm struggling to get it working. I'm working with model glue, and although the actual functioning element code for the task is in my model layer, the model requires

M$SQL: Treat two columns as one

2007-03-05 Thread Robert Rawlins
Hello Guys, I'm looking to pull a set of records from the database but treat two of the columns as one, I'll also need to GROUP BY on that combined column, so somthing like this. SELECT Col1 Col2 AS ColCombined FROM MyTable WHERE Col1 LIKE '%foo%' GROUP BY ColCombined Does that make sense?

Reactor XML - Throwing Error's

2007-03-05 Thread Robert Rawlins
Hello Guys, First time working with the reactor XML file, and it keeps throwing an error when i try and use it. When using the standard reactor XML without any objects defined it appears to work fine, but when I define my own database objects its throwing the error. The error reads: Bean

Creating HTML Content Wrapper for Email

2007-03-06 Thread Robert Rawlins
Hello Guys, I'm building a general utility component for sending emails from my application, so I can use it for error reporting, contact forms, newsletters, order confirmations and alike. I'm looking for the best method to create an HTML wrapper for the content. At the moment a variable

A Few Design Pattern Questions

2007-03-07 Thread Robert Rawlins
Hello Chaps, I’m new to the world of MVC, and I’m currently using MG to initiate myself into this type of design pattern, and on the most parts I’ve now found my feet, but there are a few of the more simple concepts that I’m still a little fuzzy on. The first element that confuses me

IIRF Rewrite Rules

2007-03-18 Thread Robert Rawlins
Hello Guys, My regex is pretty poor to be honest, and its somthing i REALLY need to start learning, so in addition to any help on this some reccomendations of books or resources on the subject would be greatly appreciated. I've currently got a bunch of urls for model-glue events, and most

Me and My Butter Fingers

2007-03-18 Thread Robert Rawlins
Hello Chaps, Seems I made a bit of a mistake whilst building my database and set one of the fields to VarBinary() instead of VarChar(). It would seem that Reactor has set its heart on using the binary field, and i'm now getting an error since setting it back to a varchar field. Message Error

Java Resources

2007-03-23 Thread Robert Rawlins
Hey guys, Well today has been my first day of getting my head around Java, I'm looking to expand my programming knowledge and Java seemed to be the natural progression, considering i've got a demmand for event gateways comming up soon, I thought it made sense. To be honest I'm finding it

Re: ColdFusion SMS Text Messages to Cell?

2007-04-18 Thread Robert Rawlins
Hello Bud, I went through a conversation about this stuff over on the easycfm boards about a month back along with some of the other developers, you may want to give it a read through. You have plenty of choices on how to distribute the mail. As Sean has suggested one option is to use the

Re: Encyption Problem

2007-06-03 Thread robert . rawlins
are not decrypting an encrypted string... cfset decrypted = Decrypt(myString, myKey, AES) / would need to be cfset decrypted = Decrypt(encrypted, myKey, AES) / or I may just be missing something else at first glance also. J.J. On 6/3/07, Robert Rawlins - Think Blue [EMAIL

Sending File Data Over Webservice

2008-02-27 Thread Robert Rawlins
Hello Guys, I'm after a little advice on refactoring a web service which I have running on one of my applications. The webservice isnt a standard ColdFusion webservice running over SOAP, this is a custom REST service which simply recieves POST data into the FORM scope and then spits back an

RE: cheap CF8 hostings

2008-03-14 Thread Robert Rawlins
Hi Ali, I've got both shared accounts and dedicated servers with www.crystaltech.com. They're very affordable and there technical support is second to none, they come highly recommended, I know quite a few other cf developers use them and I've never heard anything but positive feedback about

RE: GetFileInfo MB or kb - bytes formating?

2008-03-19 Thread Robert Rawlins
cfset mb_format = 1273998 / 100 / cfoutput#mbformat#/cfoutput You could probably use one of the format functions to round it off to the nearest 2 decimals. Hope that helps Paul, Robert -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED] Sent: 19 March 2008 15:37 To:

Avoid multiple form submits.

2008-05-09 Thread Robert Rawlins
Hello Guys, I've got an issue with a form which is sometimes a little slow to process. Seems that some of the users are clicking the submit button a whole bunch of times and we're getting a few problems arise as a result of it. How are you tackling this problem? presumably something with

Re: Avoid multiple form submits.

2008-05-09 Thread Robert Rawlins
Thanks for the suggestions guys, The JS based solution doenst quite work for me, it seems to grey the button out and change the value to 'please wait' but doesnt actualy submit the form :-) I've read about this on a few different occasions and appears to be a problem with IE7 or something like

Re: MMS in ColdFusion?

2008-05-16 Thread Robert Rawlins
Afternoon Greg, I've done my fair share of SMS and MMS messaging in the past from cf applications. You should'nt need any JAVA work arounds however I would definitly stear clear of the cfmail route, people have reported many problems about that in the past, ol' Ben did a good job of pointing

Re: MMS in ColdFusion?

2008-05-16 Thread Robert Rawlins
Hello Guys, When working with it I was simply sending http POST requests to my aggregators web service, it was a very simple REST service. By the looks of things its all grown up in the past year with some people using MM7 which appears to be an iterface built on SOAP, so instead of using a

Database Sessions

2008-08-11 Thread Robert Rawlins
Morning guys, Does anyone know how ColdFusion handles opening and closing a database session? Is it for every cfquery tag set? Or for every cftransaction tag set? Or is it less predictable than that? The reason I ask is that I've been looking at using temporary tables in a procedure, as I

RE: SVN in Production

2008-08-11 Thread Robert Rawlins
This is an interesting conversation, I've been using SVN Export for some time now when looking to deploy changes to production and not really had any beef from it. I understand what you guys are saying here about only wishing to deploy certain changes, that's a very valid use case, but to be

RE: Database Sessions

2008-08-11 Thread Robert Rawlins
it open until the request ends, so that all the queries in a single request use the same connection. So, at the very least, you should be able to use your temporary table for everything in the page. On Mon, Aug 11, 2008 at 5:42 PM, Robert Rawlins [EMAIL PROTECTED] wrote: Morning guys, Does anyone

RE: SVN in Production

2008-08-11 Thread Robert Rawlins
You're an extremely aggressive individual aren't you Andrew? -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: 11 August 2008 12:15 To: CF-Talk Subject: RE: SVN in Production DO NOT ASSUME WHAT I HAVE DONE OR NOT DONE I have not only been there, but that was 10

RE: SQL injection attack on House of Fusion

2008-08-11 Thread Robert Rawlins
Rick, That might be a slightly off angle analogy. If a girl asks to be raped, then she is clearly consenting to the act and therefore it's not technically rape any more, that's the real world equivalent of building a server and publishing open source software for download, then complaining that

cfdocument playing silly buggers on production.

2008-09-09 Thread Robert Rawlins
Guys, Quick buzz for some advice. I've just rolled a copy of my application onto the production server and cfdocument seems to not load any external resources such as images or css. The code works perfectly in development. The only thing that comes to mind for the moment is that the site

RE: cfdocument playing silly buggers on production.

2008-09-09 Thread Robert Rawlins
. Not very elegant, but it worked. bye, marcus Robert Rawlins schrieb: Does anyone know a work around for this? I'm sure it's something some of you have come across in the past. ~| Adobe® ColdFusion® 8 software 8

Temporary Tables

2008-09-22 Thread Robert Rawlins
Guys, I'm looking to run a query which creates a SQL Server temporary table. This has got me a little confused as the SQL requires to have a # in the midst of it to create the table. What's the correct syntax for this? Do I use a double ## or a triple ###? For instance, if I have a

PayPal Integration

2008-12-01 Thread Robert Rawlins
Hello Guys, Looking for the first time in ages to getting up and running with processing credit card payments using PayPal. I have myself a PayPal Payments Pro account setup and paid for, now just looking to get up and running with the API to process the payments from our site. After a

RE: PayPal Integration

2008-12-01 Thread Robert Rawlins
Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: 01 December 2008 15:49 To: cf-talk Subject: RE: PayPal Integration We rolled our own using PayPal's HTTP request/response solution. It was pretty easy to do. Mike -Original Message- From: Robert Rawlins [mailto:[EMAIL

RE: PayPal Integration

2008-12-01 Thread Robert Rawlins
cfhttpparam type=body value=#paramList# /cfhttp Mike -Original Message- From: Robert Rawlins [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2008 9:56 AM To: cf-talk Subject: RE: PayPal Integration Mike, Thanks. Was this website payments pro? And this was using the SOAP web services, correct

Loading data from a webservice call into MSSQL.

2009-01-10 Thread Robert Rawlins
Posted this yesterday but seems to have disappeared and not come to the list :-s Afternoon Guys, I publish a web service which receives statistical data in an array of complex objects from clients. This data then gets processed and inserted into a SQL Server db to be reported from at a

Re: Loading data from a webservice call into MSSQL.

2009-01-10 Thread Robert Rawlins
in one cfquery and see if it makes a difference? Why are you using the temp table for? Explain that a bit more as it might not be the best way or needed at all. Seems awfully complex code for the problem you're describing. Adrian -Original Message- From: Robert Rawlins

Re: Loading data from a webservice call into MSSQL.

2009-01-10 Thread Robert Rawlins
Hi Sam, You should be able to create an in memory query to represent the received data (your temp 'table' is rows and columns, same as a 'query'), and then your other operations would proceed normally with a few minor changes in syntax, change the datasource= to dbtype=) Ok, so you're

Re: Loading data from a webservice call into MSSQL.

2009-01-10 Thread Robert Rawlins
Hi Sam, Oh, and the relative lifetime of these objects drops significantly as well. the disk table is going to last for LOTS of milliseconds (10ms per I/O at least, times too many to count). here you won't incur ANY I/O unless paging gets involved. so you reduce the elapsed time by

Load testing tools.

2009-01-12 Thread Robert Rawlins
Afternoon guys, Any good recommendations on load testing tools? I’m just looking for something that’ll make HTTP requests to a bunch of given URLS on set intervals for a period of time, monitoring response times etc. I’ve used a couple in the past but forget which, thought I’d get your

RE: Load testing tools.

2009-01-13 Thread Robert Rawlins
Mark, Jamie, Will, Thanks for the suggestions guys :-) I'll take a look into the different ones and see which works best for me JMeter certainly sounds very cool! Cheers all, Rob ~| Adobe® ColdFusion® 8 software 8 is the most

Coldfusion killed my query?

2009-01-19 Thread Robert Rawlins
Morning Guys and Girls, I'm running ColdFusion 8 Standard and SQL Server 2005 Workgroup edition. I'm using The standard SQL Server driver that comes with CF8. I'm having a strange performance issue with a particular query. When running the query from SSMS it returns the dataset in less than a

Re: Coldfusion killed my query?

2009-01-19 Thread Robert Rawlins
Morning Adrian, thanks for getting back to me. This is definitely not caused by the output/dump of the queries, even when all those are removed it takes the same amount of time to return the page. This is not a large query to return, simply a single row containing 2 columns. The query looks as

Re: Coldfusion killed my query?

2009-01-19 Thread Robert Rawlins
Hello Guys, Thank you all for your ideas. After speaking with [Justice] over on the IRC channel I removed the cfqueryparam / and found it ran smooth as silk. Seems that there was some form of datatype mismatch going on, after changing the cf_sql_type on the queryparam we've got it running at

cfchart in cfdocument.

2009-01-19 Thread Robert Rawlins
Guys, I've got a cfchart which sits inside a cfdocument. In development on my local machine this works perfectly, however, when moved to production we just get a red [X] where the chart should be sat. I've had this problem for as long as I can remember but have only got around to tackling it

Re: cfchart in cfdocument.

2009-01-19 Thread Robert Rawlins
you right-click the broken image and pull up the image location? That'll (at least) tell you where that page *thinks* the chart should be... On Mon, Jan 19, 2009 at 8:00 AM, Robert Rawlins robert.rawl...@thinkbluemedia.co.uk wrote

File upload progress bar.

2009-02-06 Thread Robert Rawlins
Chaps, Does anyone have any good solution for displaying a file upload progress bar? I essentially have a form which looks like this: form name=upload action=process.cfm method=post input name=NewName type=text / input name=TheFile type=file / input

Webservice Error

2009-02-28 Thread Robert Rawlins
Chaps, Trying to invoke the NOAA webservice using cfinvoke but getting a pretty useless exception thrown back at me, you'll be able to see the WSDL document in the code so you can examine it, I cant see anything wrong with my request data. cfinvoke method=NDFDgenByDay

RE: Need a new host

2009-03-02 Thread Robert Rawlins
I've been running with Chystaltech.com for a few years, started with a bunch of shared plans with them and have since moved onto Dedicated solutions, I cannot recommend them enough, their service is very efficient and cost effective and in instance when I've needed technical support email replys

Dynamic SubDomain Creation / Domain Pointing

2009-03-12 Thread Robert Rawlins
Hello Chaps, We've been working on some ideas for our new reseller panel and one things which really attracts me at the moment is making the panel they sign-in to brand able. ~| Adobe® ColdFusion® 8 software 8 is the most

Re: Dynamic SubDomain Creation / Domain Pointing

2009-03-12 Thread Robert Rawlins
Hello Chaps, We've been working on some ideas for our new reseller panel and one things which really attracts me at the moment is making the panel they sign-in to brand able. I've started so I'll finish ;-) I had an itchy trigger finger this morning. Now in the most part a brandable

RE: JRun Throwing 503 Errors

2009-03-18 Thread Robert Rawlins
Matt, Hope you're well mate. With regards to this it looks as if requests are timing out whilst sat in the request pool before being processed. My guess would be that this might be related to those scheduled tasks, if they're running and consuming all available requests due to the slow running

RE: JRun Throwing 503 Errors

2009-03-20 Thread Robert Rawlins
Yeah thought that would be the case. So, are they just slow running or was the end server not responding and causing them to stack? Did changing the concurrent requests setting the Admin help at all? Or just prolong the problem? I'd probably recommend using the timeout on cfhttp be set to solve

RE: SQL server - Order totals by month, even without month data

2009-03-25 Thread Robert Rawlins
Hello Will, I'd advise building yourself a calendar table, these are always a useful facility in any application where you're going to be doing report generation, I've attached the SQL script which creates and populates your calendar table, this basically creates a record for each date in a

Re: CFQUERY Timeout for SQL2005 Fails

2009-04-15 Thread Robert Rawlins
This is an interesting thread, I've seen what I believe to be very similar behaviour here on one of my webservices, seemed that one particular query sometimes just hangs indefinitly, however other threads and requests are all just fine. I tried playing around with application request

Formatting HTML as Plain Text.

2009-04-29 Thread Robert Rawlins
Hey Chaps, I've been doing a little work with some RSS feeds of late, and on the most part all is very well, now, the one problem I'm running into is people who publish RSS feeds containing lots of junk HTML (urgh!), like inline links, images, divs and whatnot in the description content of

Secure CFIDE Virtual Directory

2009-05-26 Thread Robert Rawlins
Hello Guys, Looking for your advice on the best way to create a secure IIS virtual directory to /CFIDE. My understanding is that certain folders within that need to web accessible for cfchart,cfform,cfdocument to work, is that correct? However I don't want to expose my /cfide/administrator

RE: cfmail diagnosis

2007-06-07 Thread Robert Rawlins - Think Blue
Have you supplied all the correct credentials to the tag for the mail account? Username, password etc? It might be a case of your ISP tightening down the screws on sending unauthenticated mails, I know I've had similar troubles in the past from memory. Rob -Original Message- From:

RE: Reading/Importing Large Text Files into a Database

2007-06-07 Thread Robert Rawlins - Think Blue
Rick, Just out of interest, could one use that cfsetting option within a CFC that publishes a web service? I'm glad we're on the same page about dropping that loop though, ikky stuff. Rob -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: 07 June 2007 13:54 To:

RE: Reading/Importing Large Text Files into a Database

2007-06-07 Thread Robert Rawlins - Think Blue
So trying to access the file via SQL Server 2000 probably isn't possible. Unfortunately that probably cuts out your best route, I import a fairly substantial amount of log data into my application from CSV files and I used a query/stored proc and the BULK INSERT function from SQL, it's very good

RE: XSS patch Global Script Protect

2007-06-07 Thread Robert Rawlins - Think Blue
I'm not sure Chris, It might be worth noting that scriptProtect does have a few holes in I think so don't rely on it too much, put your own validation in place as well. Rob -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED] Sent: 07 June 2007 15:33 To: CF-Talk Subject:

RE: Instant Credit Check

2007-06-11 Thread Robert Rawlins - Think Blue
Hi Robert, I've not had any experience with this kind of thing myself but I think you will probably be better off looking for an API rather than a plug-in per se. The API would probably come as a web service which you can publish your clients data too in XML format and it will then return the

RE: Odd session behavior

2007-06-12 Thread Robert Rawlins - Think Blue
James, I've just played around and everything seemed to work a real charm, changed quantities, deleted items, added new ones and everything works great for me, nice site *:o) I'm running IE7, Rob -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 12 June 2007

RE: Large CSV File

2007-06-12 Thread Robert Rawlins - Think Blue
Eek! A file of that size and complexity needs to be handled by the database, putting it into an array would be a nightmare. It would be fine for smaller files, but something that size would probably push the server over. Les, what database are you using? *Crosses fingers he says something

Make Number Negative

2007-06-13 Thread Robert Rawlins - Think Blue
Chaps, I'm looking for the best way to make a positive number into a negative one, so if I have '10' I'm looking to convert that to '-10' what's the best way to achieve this? Thanks, Rob ~| ColdFusion MX7 and Flex 2

RE: Jr. Going to Hendrick

2007-06-13 Thread Robert Rawlins - Think Blue
!--- NASCAR Expressed In CFML --- cfloop condition=true cfset Exciting = False / /cfloop :-D -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: 13 June 2007 16:39 To: CF-Talk Subject: RE: Jr. Going to Hendrick Haha! ...:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.

Securing Datasources

2007-06-14 Thread Robert Rawlins - Think Blue
Hello Guys, I'm looking to get some advice on securing my datasource as much as possible. I'm looking for some advice on the data source, I'm changing the allowed functions of the datasource to SELECT, UPDATE and INSERT only to stop things being dropped, however, how do I have it so the

RE: Securing Datasources

2007-06-14 Thread Robert Rawlins - Think Blue
. Thanks again guys, Rob -Original Message- From: Casey Dougall [mailto:[EMAIL PROTECTED] Sent: 14 June 2007 12:02 To: CF-Talk Subject: Re: Securing Datasources On 6/14/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Hello Guys, however, how do I have it so the username

RE: Securing Datasources

2007-06-14 Thread Robert Rawlins - Think Blue
Morning Dave, Thanks for that mate, I know there are bigger security fish to fry when working on the same box but unfortunately this setup works better for my budget at the moment, give it 6 months and I'll have grown out of it. I've just created a user in the database with reader/writer

RE: Securing Datasources

2007-06-14 Thread Robert Rawlins - Think Blue
like rearranging deck chairs on the Titanic Lol, Hilarious analogy, is it really -THAT- bad having them on the same box? Thanks for the tips and link on the stored proc stuff, I'll give that a thorough run through this afternoon and see what I can get working. I also like Gert Franz's concepts

RE: Securing Datasources

2007-06-14 Thread Robert Rawlins - Think Blue
Ok well that's well worth know Dave, thanks. How can I best protect my shell? The server has a pretty tidy firewall on it, albeit a shared one, the server also isn’t used for anything other than the db and serving my ColdFusion apps and email. Thanks, Rob -Original Message- From:

Error converting data type varchar to int.

2007-06-14 Thread Robert Rawlins - Think Blue
Hello guys, I've got a stored proc that enters information into a table on my SQL Server database, and I'm getting the following error message when trying to run it. [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type varchar to int. This is a snippet of the query

RE: Error converting data type varchar to int.

2007-06-15 Thread Robert Rawlins - Think Blue
what's causing this. Thanks, Rob -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 14 June 2007 18:21 To: CF-Talk Subject: Re: Error converting data type varchar to int. Robert Rawlins - Think Blue wrote: [Macromedia][SQLServer JDBC Driver][SQLServer]Error

RE: Error converting data type varchar to int.

2007-06-15 Thread Robert Rawlins - Think Blue
:[EMAIL PROTECTED] Sent: 15 June 2007 13:52 To: CF-Talk Subject: Re: Error converting data type varchar to int. On 6/15/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: cfset VARIABLES.DAO.create(1, 'TestUser, 'TestPassword') / Rob, I don't know if this was just your typing

RE: Error converting data type varchar to int.

2007-06-15 Thread Robert Rawlins - Think Blue
-Original Message- From: Dean Lawrence [mailto:[EMAIL PROTECTED] Sent: 15 June 2007 17:29 To: CF-Talk Subject: Re: Error converting data type varchar to int. On 6/15/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Thanks Dean, That was just a typo on my part, the actual code I've

RE: Error converting data type varchar to int.

2007-06-16 Thread Robert Rawlins - Think Blue
Thanks Dean, This is confusing the hell out of me. I've checked all the data types in both the stored proc and the database columns, they are as they should be, into and two varchars, I even tried changing the column names to make sure they weren’t reserved words or something, but still the

RE: Error converting data type varchar to int.

2007-06-16 Thread Robert Rawlins - Think Blue
. In the cfstoredproc call, for your int type you still have a maxlength defined, which is only useful for strings: cfprocparam value=#ARGUMENTS.UserID# variable=User_ID cfsqltype=cf_sql_integer maxlength=128 / Perhaps it's messing up the assignment to the int - try removing it. On 6/16/07, Robert Rawlins

RE: Error converting data type varchar to int.

2007-06-19 Thread Robert Rawlins - Think Blue
Thanks for your help on this Neil, It now works an absolute charm. I owe you a pint. Rob -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 19 June 2007 09:37 To: CF-Talk Subject: RE: Error converting data type varchar to int. I spoke with Rob, the fix

REGEX File Extention

2007-06-19 Thread Robert Rawlins - Think Blue
Hello Guys, My REGEX skills are pretty horrible. I'm looking for a way to get the file extension from a string, examples of the strings are: Somthing.gif Thisone.jpg Ooh.mp3 Nice.fla What's the best way to achieve this? Effectively I want everything to the right of the dot.

RE: REGEX File Extention

2007-06-19 Thread Robert Rawlins - Think Blue
://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ Robert Rawlins - Think Blue schrieb: Hello Guys, My REGEX skills are pretty horrible. I'm looking for a way to get the file extension from a string, examples of the strings are: Somthing.gif Thisone.jpg Ooh.mp3

RE: Telnet/SSH From CF?

2007-06-19 Thread Robert Rawlins - Think Blue
Thanks James, That's some very useful tips, I'll only be using SSH to connect and run bash commands, file transfer isn't a concern at the moment so cfexecute and .bat file seems like the way to go, jeez, I must have been about 13 when I last wrote a .bat file, this will be a rather nostalgic

DAO Implementation

2007-06-19 Thread Robert Rawlins - Think Blue
Hello Guys, I've been working with OO for some time now but there are still a few little things that escape me, so I'm looking for a definitive answer. When dealing with data access objects how should I be moving the data retrieved by them into the actually bean style object? As I see it

  1   2   3   4   5   >