Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL insert to a logical field
Message
 
 
À
16/08/2002 13:55:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Applications Internet
Divers
Thread ID:
00690459
Message ID:
00690987
Vues:
17
You can send either 1 or .T. as value of True. Don't enclose it in quotes.
   Conn.Execute "insert into PROFILES (dbhlink, responsibi, instruc, subject,
      emailsub, Panumber) values ('" & _
   dbhlink & "', '" & responsibi & "', '" & instruc & "', '" & subject & "'," &_
     emailsub & ",'" &	PAnumber & "');"
>Hello,
>
>I'm attempting to insert into a logical field in a foxpro database from an asp page. I have set the values of the dropdown to 0/1, .t./.f., t/f and nothing has worked. It inserts everything into the database as "F", even when it should be "T".
>
>Some background.....
>SQL insert:
>   Conn.Execute "insert into PROFILES (dbhlink, responsibi, instruc, subject,
>      emailsub, Panumber) values ('" & _
>   dbhlink & "', '" & responsibi & "', '" & instruc & "', '" & subject & "',
>     emailsub, '" &	PAnumber & "');"
>
>where emailsub is the logical field.  The HTML looks like this:
>          <option value = "t" selected>Yes</option>
>          <option value = "f">No</option>
>
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform