Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    16

    Unanswered: I need help with this sql string....('{0}', {1},'{2}', '{3}');", Chr(64 + j)

    I was looking around on the internet and need something like this:
    Dim NumberOfRows As Integer = 10
    Dim NumberOfColumns As Integer = 4
    Dim PlaneID As String = "3434278231"
    Dim SeatType As String
    Dim i As Integer
    Dim j As Integer

    For i = 1 To NumberOfRows
    For j = 1 To NumberOfColumns
    If j = 2 Or j = 4 Then
    'Assuming B & D are Window Seats (j=1 For A, 2 for B and so on)
    SeatType = "Window"
    Else
    SeatType = "Aisle"
    End If
    Qry = String.Format("INSERT INTO TBL_SEAT (SEAT_NUM, SEAT_ROW, SEAT_TYPE, PLANE_ID) VALUES ('{0}', {1},'{2}', '{3}');", Chr(64 + j), i, SeatType, PlaneID)
    MsgBox(Qry)
    Next j
    Next i


    i figured out most of it but need help figureing out how it inserts the seat number and row?

    what does all this do: ('{0}', {1},'{2}', '{3}');", Chr(64 + j)


    thanks for any advice.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking

    Assigns:

    SEAT_NUM Chr(64 + j) to '{0}',
    SEAT_ROW i to {1},
    SEAT_TYPE SeatType to '{2}' and
    PLANE_ID PlaneID to '{3}'.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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