Professional Web Applications Themes

update from select - PERL Beginners

Hi folks, don't know if it's cos of the 17 hours I've just worked (sympath vote please) but I can't get this one worked out I've got table names with nid as name id field and nallowfollow flag. I've got a vehicles table with vowner pointing at nid and a vallowfollow field. How can I update nallowfollow from the appropriate vallowfollow flag? -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000...

  1. #1

    Default update from select

    Hi folks,

    don't know if it's cos of the 17 hours I've just worked (sympath vote please)
    but I can't get this one worked out

    I've got table names with nid as name id field and nallowfollow flag.
    I've got a vehicles table with vowner pointing at nid and a vallowfollow
    field.

    How can I update nallowfollow from the appropriate vallowfollow flag?
    --
    Gary Stainburn

    This email does not contain private or confidential material as it
    may be snooped on by interested government parties for unknown
    and undisclosed purposes - Regulation of Investigatory Powers Act, 2000

    Gary Stainburn Guest

  2. #2

    Default Re: update from select

    On Wednesday 29 Oct 2003 9:11 am, Gary Stainburn wrote:
    > Hi folks,
    >
    > don't know if it's cos of the 17 hours I've just worked (sympath vote
    > please) but I can't get this one worked out
    >
    > I've got table names with nid as name id field and nallowfollow flag.
    > I've got a vehicles table with vowner pointing at nid and a vallowfollow
    > field.
    >
    > How can I update nallowfollow from the appropriate vallowfollow flag?
    Sorry folks, not enough chemical stimulation - posted to wrong list.

    --
    Gary Stainburn

    This email does not contain private or confidential material as it
    may be snooped on by interested government parties for unknown
    and undisclosed purposes - Regulation of Investigatory Powers Act, 2000

    Gary Stainburn Guest

  3. #3

    Default Re: update from select

    [email]gary.stainburnringways.co.uk[/email] (Gary Stainburn) wrote in message news:<200310290911.54453.gary.stainburnringways.c o.uk>...
    > I've got table names with nid as name id field and nallowfollow flag.
    > I've got a vehicles table with vowner pointing at nid and a vallowfollow
    > field.
    >
    > How can I update nallowfollow from the appropriate vallowfollow flag?
    What database are you using? Have you got some code to show us? Is
    this a SQL question, or a Perl question?
    Roy Johnson Guest

Similar Threads

  1. Can't select Acrobat Pro for update 8.1.2
    By Patrick_Tigue@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 3
    Last Post: October 22nd, 05:22 PM
  2. Select-And-Update in one statement?
    By Ignoramus23298 in forum MySQL
    Replies: 1
    Last Post: May 19th, 07:02 PM
  3. Select, Edit, Update Issue
    By Michael D. Murphy in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: January 29th, 09:52 PM
  4. Update from a select
    By Bob Bedford in forum PHP Development
    Replies: 1
    Last Post: January 15th, 10:14 PM
  5. Update and Select Statement
    By hngo01 in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 4th, 01:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139