Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: softboy12
  • Order by date
  1. softboy12

    update field with actual modify date

    ok thanks i works fine now
  2. softboy12

    update field with actual modify date

    Hi KarveR (MIS) it works thanks for that but now the date is shown in the english format instead of the german (2004-08-15 19:08:22 instead of 15-08-2004 19:08:22) how can i reverse this or does this depend on the mysql server language?
  3. softboy12

    update field with actual modify date

    hi all i use a php form which writes datas into a mysql db Now i have a field called "sperrdatum" in the db and this field shoud be automatically updated with the actual date and time, if the radio button "x_gesperrt" on the php Form is set to True below is the code...
  4. softboy12

    mysql 4.0.20a for windows

    Hi all Don't ask me why, but now (after i tried and tried) it works thanks anyway for your help
  5. softboy12

    mysql 4.0.20a for windows

    Hi all i installed just a few days ago the new my sql 4.0.20a server on a Windows Machine and heart about that the feature "auto_increment = default value" will work now now i created a new table added some fields and one field shoud be auto_increment and shoud have a default value (which...
  6. softboy12

    SQL and Join and delete

    hi all well if a modified the sql commands in the area below: ----------------------------------------------------------- ' Open Connection to the database Set conn = Server.CreateObject("ADODB.Connection") conn.Open xDb_Conn_Str Select Case a Case "I": ' Display strsql = "SELECT...
  7. softboy12

    SQL and Join and delete

    Hi Twan yes i selected the option "casade delete/update" but it doesn't work after i tried to save the relations the following error occurs "Kunden'-Tabelle wurde gespeichert 'Pointings'-Tabelle - Beziehung 'FK_Pointings_Kunden' kann nicht erstellt werden. ODBC-Fehler: [Microsoft][ODBC SQL...
  8. softboy12

    SQL and Join and delete

    it tried also this (see code below) ---------------------------------------------------------- ' Single delete record key = Request.querystring("key") If key = "" Or IsNull(key) Then key = Request.Form("key") End If If key = "" Or IsNull(key) Then Response.Redirect "Kundenlist.asp" sqlKey =...
  9. softboy12

    SQL and Join and delete

    thanks i tried the second solution (realtionships) and then i made the following relations between the tables: --------------------------------------------------------- ID Field (Primary Key) of the Table "Kunden" is in relation to ID_point (also Primary Key) of the table "Pointings and is...
  10. softboy12

    SQL and Join and delete

    1.) what do you mean, separate SQL Commands to delete the recordsets in the other table 2.) i was study also on this solution, but how can access the stored procedures from within the asp pages?
  11. softboy12

    SQL and Join and delete

    Hi all i use the follwing asp page to delete records from our customer database <%@ codepage = 1250 LCID = 2055 %> <% If Session("project6_status") <> "login" Then Response.Redirect "login.asp" %> <% Response.expires = 0 Response.expiresabsolute = Now() - 1 Response.addHeader "pragma"...
  12. softboy12

    Insert Into

    Hi DreX sorry for my late reply, but i was in holiday last three weeks Well i found now another solution to fill the fields (clientside scripting) if the radio button "Inhaber=Rechnungsadresse" is True Thanks anyway for your help
  13. softboy12

    preventing field update (SQL Update)

    and of course your anwser is also the right, if i exclude all fields which i don't want to update by the sql stamement, it works also
  14. softboy12

    preventing field update (SQL Update)

    ok, thank you, if found the error myself it was the form action tag which means <form onSubmit="return EW_checkMyForm(this);" action="Kundenedit.asp" method="post"> updated the wrong fields in the database and if change the statement above to <form onSubmit="return EW_checkMyForm(this);"...
  15. softboy12

    preventing field update (SQL Update)

    Hi all I use the code below (asp Page) to update records in our customer DB ------------------------------------------------------------ <%@ codepage = 1250 LCID = 2055 %> <% If Session("project6_status") <> "login" Then Response.Redirect "login.asp" %> <% Response.expires = 0...
  16. softboy12

    Fill two form fields with the same content

    Hi all i use a html form with the following fields: Anrede Besteller Firma Besteller Nachname Besteller Vorname Besteller Strasse Besteller Postfach Besteller PLZ Besteller Ort Besteller Telefon Besteller Fax Besteller Land Besteller Email...
  17. softboy12

    Insert Into

    sorry, but what you mean about check your sql statement for field names
  18. softboy12

    Insert Into

    i found that the "SQL Profiler" is a handy tool to determine where eventually the error is located here is the output ----------------------------------------------------------- [Microsoft][ODBC SQL Server Driver][SQL Server]Zeile 1: Falsche Syntax in der Nähe von '='. (Status 42000) (Code...
  19. softboy12

    Insert Into

    you mean your modified sql statement i will test in in the query analyzer and see if there is an error
  20. softboy12

    Insert Into

    Well it work nearby, but the error 500 will occur, if i press the "Hinzufügen" Button, so i think the code error reside in the "update" area, which means, if the asp page tries to insert data in the Database, and i don't know why here is the modified code...

Part and Inventory Search

Back
Top