Professional Web Applications Themes

Using recordset data with copying a file statement - Dreamweaver AppDev

I'm sure you'll be able to guess what I'm trying to do here: objFSO.CopyFile "\pishon\i-spectra\working\dev\vc\db\VesselConfiguration.mdb" , "\pishon\i-spectra\working\dev\vc\db\(rsVessel.Fields.Item("N ame").Value)_expor ted.mdb" (Use the recordset's value for the database field "Name" as part of the newly created file). It doesn't like the " " around Name, however -- and not being at all ASP minded, I've tried backslashing the "s, using double "s like I'm sure I've read, but neither works. This should be simple to sort, right? :)...

Sponsored Links
  1. #1

    Default Using recordset data with copying a file statement

    I'm sure you'll be able to guess what I'm trying to do here:


    objFSO.CopyFile
    "\\pishon\i-spectra\working\dev\vc\db\VesselConfiguration.mdb" ,
    "\\pishon\i-spectra\working\dev\vc\db\(rsVessel.Fields.Item("N ame").Value)_expor
    ted.mdb"


    (Use the recordset's value for the database field "Name" as part of the newly
    created file).

    It doesn't like the " " around Name, however -- and not being at all ASP
    minded, I've tried backslashing the "s, using double "s like I'm sure I've
    read, but neither works.

    This should be simple to sort, right? :)

    Sponsored Links
    saf_123 Guest

  2. #2

    Default Re: Using recordset data with copying a file statement

    strRSValue = rsVessel.Fields.Item("Name").Value
    strURL = "\\pishon\i-spectra\working\dev\vc\db\" & strRSValue &
    "_exported.mdb"

    --
    __________________________________________________ __________________
    UltraSuite Extension Packages: http://www.ultrasuite.com/
    The *most popular* Suites of DMX 2004 and DMX Server Behaviors
    for ASP, ASP.Net, ColdFusion, JSP, and PHP_MySQL
    __________________________________________________ __________________


    J.S. Guest

  3. #3

    Default Re: Using recordset data with copying a file statement

    :) :D
    saf_123 Guest

Similar Threads

  1. Question Insert from ASP to SQL using recordset data as values in insert statement
    By JasonM in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: June 13th, 05:54 PM
  2. Copying Data using CFLOOP
    By Chiruzo in forum Macromedia ColdFusion
    Replies: 5
    Last Post: July 13th, 02:45 PM
  3. SQL statement For a recordset
    By Tim Mannah in forum Dreamweaver AppDev
    Replies: 2
    Last Post: March 14th, 01:26 AM
  4. copying image data
    By RP in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 7th, 06:09 PM
  5. Replies: 2
    Last Post: July 2nd, 05:33 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