Recent content by softboy12

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