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
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
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
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
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-
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
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,
>
>
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
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
'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
phew
___
* Regards,
Richard Lovelock
Westminster City Council - Web Support
Cap Gemini Ernst & Young
Southbank
95 Wandsworth Road
London
SW8 2HG
( 0870 906 7482
___
yes.
"Lovelock,
Richard J" To
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
memo field??
___
* Regards,
Richard Lovelock
Westminster City Council - Web Support
Cap Gemini Ernst & Young
Southbank
95 Wandsworth Road
London
SW8 2HG
( 0870 906 7482
_
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.
> 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
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');
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
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
(
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
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
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)
> 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
> 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
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;
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
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
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
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
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
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)
>
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
___
> 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
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
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
__
35 matches
Mail list logo