- see footer for list info -<
That is definitely an error with the text or varchar field not being big enough for the data you are inserting. If it only errors in Firefox then it must be adding white space. Try doing a len() on all your fields
On 12/12/06, Paul Swingewood <[EMAIL PROTECTED]> wrote:
>- see footer for list info -< It all works in IE ok. So I don't think its the column widths. The database is MS SQL2K Regards - Paul >From: "Jatin Nanda" <[EMAIL PROTECTED]> >Reply-To: Coldfusion Development <[email protected]> >To: "Coldfusion Development" <[email protected]> >Subject: Re: [CF-Dev] OT - Firefox >Date: Tue, 12 Dec 2006 11:04:12 +0000 > >>- see footer for list info -< >HI Paul, what DB are u using? Also what are the column widths for >tblPropertyDetails? >A truncation error suggests that a field in that table may not be large >enough. > >Thx > >J > >On 12/12/06, Paul Swingewood <[EMAIL PROTECTED]> wrote: >> >> >- see footer for list info -< >>I have a form submitting some stuff for an estate agents website. I had >>aproblem initially with an IE update which caused teh SSl login to stop >>working. The client hasnow switched to firefox andall seemed well until >>they >>try to upload property details. This system worked fine and I haven't >>changed any code. >> >>When they fill in the form and submit I get an error saying data wouldbe >>truncated .... with this error >> >>INSERT INTO tblPropertyDetails (NoBedroomsIDFK, PropertyTypeIDFK, >>PropertyLocationIDFK, RoadName, Picture, Description1, Description2, >>Description3, Description4, Description5, Description6, PostCode, >>PDFDetails) VALUES ('1', '2', '11', 'test road', >> >>'C:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\neotmp1621.tmp', >>'test', 'test', 'test', 'test', 'test', 'test', 'b43 7pq', 'BETT Floor >>Plan.pdf') SELECT @@IDENTITY AS NewID >> >>I have no idea what this is doing here >> >>'C:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\neotmp1621.tmp' >> >>Can anyone tell me whats going on please ... >> >>Regards - Paul >> >> >>_______________________________________________ >> >>For details on ALL mailing lists and for joining or leaving lists, go to >>http://list.cfdeveloper.co.uk/mailman/listinfo >> >>-- >>CFDeveloper Sponsors:- >> >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >> >- Lists hosted by www.Gradwell.com -< >> >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >>-< >> >_______________________________________________ > >For details on ALL mailing lists and for joining or leaving lists, go to >http://list.cfdeveloper.co.uk/mailman/listinfo > >-- >CFDeveloper Sponsors:- >>- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >>- Lists hosted by www.Gradwell.com -< >>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
-- Simon Baynes www.simonbaynes.com _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:-
- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< - Lists hosted by www.Gradwell.com -< - CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
