Search results for query: *

ok thanks i works fine now

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?

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...

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

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...

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...

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...

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 =...

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...

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?

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"...

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

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

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);"...

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...

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...

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

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...

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

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...