RE: [ cf-dev ] MS SQL Enterprise Manager - Importing Views

2003-11-28 Thread Ross Williams
Hi Sandeep, No joy with that either - I'm beginning to suspect that the original database is corrupt in some way and the only way to move it will be a Backup/Restore. But I do not have access to the restore directory of the new host and don't think that I can get it before Sunday. All in all a b

RE: [ cf-dev ] MS SQL Enterprise Manager - Importing Views

2003-11-28 Thread Sandeep Shetty
I have experienced errors sometimes copying objects using dts ususlly occurs when copying security settings, if its is ok and u want to get just the data and structure across you can try unchecking the use default options checkbox in step 4 of the DTS and click on the options button and uncheck all

RE: [ cf-dev ] MS SQL Enterprise Manager - Importing Views

2003-11-28 Thread Ross Williams
Hi Paul, Thanks for that - but still getting the error with the scripting. I tried it the traditional way (hadn't seen that before) and right at the end, in prick tease manner, it pops up: "1 task(s) failed during execution." The step shown is "Copy SQL Server Objects Task: undefined", with the

Re: [ cf-dev ] MS SQL Enterprise Manager - Importing Views

2003-11-28 Thread [EMAIL PROTECTED]
Ok views should be fairly straight foward with DTS - - how to - with DTS Right click on the database, under All Tasks, click export data. Provide the source and destination database info and then select the option "Copy objects and data between SQL Server databases". In the next window you might

RE: [ cf-dev ] MS SQL Enterprise Manager - Importing Views

2003-11-28 Thread Ross Williams
Hi Steve, Tried that - it scripts them okay, but bums out after about 5% of copying them. Haven't used MS-SQL for years and now remembering why!! :o) R -Original Message- From: Steve Martin [mailto:[EMAIL PROTECTED] Sent: 28 November 2003 16:31 To: [EMAIL PROTECTED] Subject: RE: [ cf-

RE: [ cf-dev ] MS SQL Enterprise Manager - Importing Views

2003-11-28 Thread Ross Williams
Hi Neil, Yup, tried using DTS - both as Import and Export. It basically forces the views to be copied across as tables - once we have specified the from and to databases, it allows us to select the from views but the destination view is actually shown as a table icon, and it ends up within the ta

RE: [ cf-dev ] MS SQL Enterprise Manager - Importing Views

2003-11-28 Thread Steve Martin
Import all entities as objects as opposed to "copy tables" > -Original Message- > From: Ross Williams [mailto:[EMAIL PROTECTED] > Sent: 28 November 2003 16:16 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] MS SQL Enterprise Manager - Importing Views > Importance: High > > > Hey hoo, > >

RE: [ cf-dev ] MS SQL Enterprise Manager - Importing Views

2003-11-28 Thread Robertson-Ravo, Neil (RX)
Hey, Did you use DTS? Did the names of the views match the names of the Tables? Also what version of SQL Server? 7,2000,Yukon,MSDE ? ;-) -Original Message- From: Ross Williams [mailto:[EMAIL PROTECTED] Sent: 28 November 2003 16:16 To: [EMAIL PROTECTED] Subject: [ cf-dev ] MS SQL Enterp

[ cf-dev ] MS SQL Enterprise Manager - Importing Views

2003-11-28 Thread Ross Williams
Hey hoo, Just getting back in with MS SQL Enterprise Manager - have run an import from one live database to another and it's imported all of my Views into the Tables. Has anyone come across this? I can see the Views in the Tables listing when they should be in the Views listing. Does anyone know

[ cf-dev ] Webservices.... ~sigh~

2003-11-28 Thread Stephen Moretti
'lo. Couple of questions. Anyone got some good resources for consuming web services with CFMX?? Google hasn't turned up much, but then I'm probably using the wrong search terms. Other question - how can I send NULL through to a web service?? I've got : enetws = CreateObject("WebServic

RE: [ cf-dev ] Text field too small!

2003-11-28 Thread Lovelock, Richard J
phew ___ * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst & Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 ___

RE: [ cf-dev ] Text field too small!

2003-11-28 Thread duncan . cumming
yes. "Lovelock, Richard J" To

RE: [ cf-dev ] Text field too small!

2003-11-28 Thread Stephen Pope
You'll have to switch to M$ SQL 2000 or MySQL .. .. not really ! Just change it to a 'Memo' field ! then you can have as much as you like (within reason hehe!) Stephen -Original Message- From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] Sent: 28 November 2003 14:28 To: 'cflist' Subjec

RE: [ cf-dev ] Text field too small!

2003-11-28 Thread Lovelock, Richard J
memo field?? ___ * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst & Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 _

[ cf-dev ] Text field too small!

2003-11-28 Thread Lovelock, Richard J
I have done quite a bit of work trying to develop a comments forum area - but the actual comments field on the DB is too small: it is MS Access 2000, format text. It was set at 255 chars but this simply isn't big enough. When I went to increase it - it tells me this is the max size for the field.

RE: [ cf-dev ] CFForm text box

2003-11-28 Thread Paul Johnston
> I think u are after a confirm box: > > confirm(); But I'm not because if the value is false (ie it doesn't match empty) then I don't want any type of response. Confirm() is only needed when you need to confirm that a user wants an action to happen. Paul > At 11:55 28/11/2003, you wrote: > >Y

RE: [ cf-dev ] CFForm text box

2003-11-28 Thread Moin 'Uddeen
I think u are after a confirm box: confirm(); At 11:55 28/11/2003, you wrote: You could try this... Then in the JS: function checkForm(myform) { if(myform.comments.value.match(/^\s*$/)) { // it's empty alert('You must enter a value for comments');

[ cf-dev ] Thanks

2003-11-28 Thread Lovelock, Richard J
I have been involved in web support using fairly basic CF for about a year now but the site I am developing at the moment is my first using any significant amounts of CF/JS/CSS I'd just like to say thanks very much to everyone on the list for their help to date - it really has been invaluable an

RE: [ cf-dev ] CFForm text box

2003-11-28 Thread Lovelock, Richard J
Paul - that's superb - thank very much Colm - thanks for the link - will take look ___ * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst & Young Southbank 95 Wandsworth Road London SW8 2HG (

RE: [ cf-dev ] CFForm text box

2003-11-28 Thread Colm Brazel
You might have a look at http://www.pengoworks.com/qforms/download/ which preloads javascript forms ready built for all sorts of similar requirements Colm -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED] Sent: 28 November 2003 12:15 To: [EMAIL PROTECTED] Subject: RE: [ cf

RE: [ cf-dev ] CFForm text box

2003-11-28 Thread Paul Johnston
This works: function checkForm(myform) { if(myform.comments.value.match(/^\s*$/)) { // it's empty alert('You must enter a value for comments'); return false; } else { return true; } } HTH Paul

RE: [ cf-dev ] CFForm text box

2003-11-28 Thread Lovelock, Richard J
this is strange: I have tried taking out the image and putting in a normal form submit button and I have added the code from Mike to say return true/false but when you ok the alert the form still submits itself. I also tried the onSubmit code in the tag but that didn't work at al (no alert box)

RE: [ cf-dev ] CFForm text box

2003-11-28 Thread Paul Johnston
> You could try this... > > onClick="return(checkForm(this.form));" /> Wood... Trees... Go with this (just with the type="image"...) as it works! Hope you aren't too confused! Paul -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PRO

RE: [ cf-dev ] CFForm text box

2003-11-28 Thread Paul Johnston
> Paul - thanks for that codealmost works but not quite. I > get the alert box and message as requested BUT when I OK the > alert message the form still submits itself??? > > CODE IS: > > function checkForm(myform) { > if(myform.comments.value.match(/^\s*$/)) { > // it's

RE: [ cf-dev ] CFForm text box

2003-11-28 Thread Mike Connolly
You could try this... Then in the JS: function checkForm(myform) { if(myform.comments.value.match(/^\s*$/)) { // it's empty alert('You must enter a value for comments'); return false; } else { return true;

RE: [ cf-dev ] CFForm text box

2003-11-28 Thread Lovelock, Richard J
Thanks Colm - I remember that from my FastTrack course now! however I was hoping to do it client-side... Paul - thanks for that codealmost works but not quite. I get the alert box and message as requested BUT when I OK the alert message the form still submits itself??? CODE IS: function che

RE: [ cf-dev ] CFForm text box

2003-11-28 Thread Colm Brazel
No equiv cfform tag for this. You have to use something like text Colm -Original Message- From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] Sent: 28 November 2003 11:06 To: 'cflist' Subject: [ cf-dev ] CFForm text box I have a form - using cfform - with a multiline text box () I wa

RE: [ cf-dev ] CFForm text box

2003-11-28 Thread Paul Johnston
Something like: Then in the submit button (note it's actually a type="button" not "submit" as that is done in the JS): Then in the JS: function checkForm(myform) { if(myform.comments.value.match(/^\s*$/)) { // it's empty alert('You must enter a value

[ cf-dev ] CFForm text box

2003-11-28 Thread Lovelock, Richard J
I have a form - using cfform - with a multiline text box () I want to use JS validation or cfform validation to make sure this box has an entry before the form gets submitted and alert the user if it is empty however, I can't find the appropriate CFForm tag to do this - I have found and but n

[ cf-dev ] Re: [cfmail] RE: [ cf-dev ] Email Extractor

2003-11-28 Thread Allan Cliff
I am still trying to get it to work. Very busy at mo. Thanks for your help and will let you know Monday. Allan - Original Message - From: Rich Wild To: '[EMAIL PROTECTED]' Sent: Friday, November 28, 2003 10:14 AM Subject: [cfmail] RE: [ cf-dev ] Email Extractor did that

RE: [ cf-dev ] Email Extractor

2003-11-28 Thread Rich Wild
did that work for you Allan? > -Original Message- > From: Rich Wild [mailto:[EMAIL PROTECTED] > Sent: 26 November 2003 10:09 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Email Extractor > > > yea- there were some probs in that - here's the fixed code: > (again, watch > wrap) >

RE: [ cf-dev ] Keeping text formatting

2003-11-28 Thread Lovelock, Richard J
aaahh! thanks Aidan ___ * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst & Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 ___

RE: [ cf-dev ] Keeping text formatting

2003-11-28 Thread Aidan Whitehall
> inidentally what differentiates a line feed from a carriage return? Think of the old fashioned typewriters... starting to type on a new line actually involves two actions -- the typewriter head returning to the start of the line (carriage return) and the roller rotating so it addresses the next

RE: [ cf-dev ] Keeping text formatting

2003-11-28 Thread Lovelock, Richard J
inidentally what differentiates a line feed from a carriage return? ___ * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst & Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 74

RE: [ cf-dev ] Keeping text formatting

2003-11-28 Thread Lovelock, Richard J
ok cheers damian ___ * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst & Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 __