Search results for query: *

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

Hi all I use the following code below to insert Datas in a sql Database received from a asp Page ------------------------------------------------------------ ' Open Connection to the database Set conn = Server.CreateObject("ADODB.Connection") conn.Open xDb_Conn_Str Select Case a Case "C"...

Hi all i have a MS SQL Customer DB's which includes 3 Relations (created with the help of the Diagram Wizard in the Enterprise Manager) The relations are configured as follow: Field "Pointing" in the table "Kunden" is linked to "ID_point" in the table "Pointings" Field "Subdomain" in the...

Hi all I use a Access 2000 Database which is located on a productive webserver there is a textfile (linkend within the DB) which the DB shoud update but if a open the Link in the Draft Mode the following error appears: D:\....... is not a valid path which means, the access has a problem...

Hi all last few days we encouter the following problems with our Exchange 2000 (SP3) Server ---------------------------------------------------------- The first mount groups(Public and Private Folder) suddendly shutdown and then the error c1041724 appears in the event logs...

Hi all i have a web Based (ASP) MS SQL Customer DB which works fine, now i need the following function: i have a field called "Domainreg" i the DB so if the field is true (1) it shoud opens the browser a go directly to an URL, otherwise if it's false another URL shoud be called see code...

Hi all i have to fields in database (see code below) x_gesperrt = rs("gesperrt") and x_sperrdatum = rs("sperrdatum") now my question is the follwing: if i set the field "x_gesperrt" to true how can automatically update the "x_sperrdatum" which is a datetime field? many thanks in advance...

Hi all Question: how can i made a "a href" Link to the following code below: ------------------------------------------------------------ <% Response.Write x_Domain %><% Response.Write x_TLD %> ---------------------------------------------------------- if i put <a href = "...... %>"></a>...

Hi all i have a problem with the following query ----------------------------------------------------------- UPDATE [data].[dbo].[Kunden] SET [OS]='NT' WHERE [OS] =NULL ----------------------------------------------------------- The SQL Server says me "no rows affected" how can i fill in datas...

Hi all i want to do the following with the expression below -------------------------------------------------- <% If x_gesperrt = True Then %> --------------------------------------------------- if the value above in the database is true there shoud pop up a warning window which says that the...

Hi all I have the following problem with the statement below --------------------------------------------------------- SELECT [ID], [Domain], [TLD], [LoginName], [Passwort], [FK_ID_Server], [Email_best] FROM [data].[dbo].[Kunden] WHERE [FK_ID_SERVER]= select [BS] from [data].[dbo].[Server]...

Hi all i use the code below (with the linkend "PDF and Mail Library from ATTAC Consulting Group) Dim objPDF As PDFClass Dim objMail As MailClass Dim strCurFileName As String Dim strBaseFileLocation As String Dim lngReturn As Long 'Dim rsReports As Recordset '<- DAO recordset 'Comment out...

hi all Question: we use a Access 2000 Frontend to query a MS SQL Customer DB so far so good, all works fine, exect the following (see code below): Private Sub Befehl108_Click() On Error GoTo Err_Befehl108_Click Dim stDocName As String stDocName = "Datenblatt_NT"...

Hi all I have sucessfully created a Access Form, which works fine in Access inside (Search and List Buttons etc) but if a export this form to a html or asp Page the functionality will be gone --> i can't search and the form shows only the empty table why does this occur? how can i easly...

Hi all one question: we use Access for our customer database and now switched to MS SQL for a better performance and security now i have imported the datas from the Access DB, so far so good how can i now access the reports in Access via SQL? the targeting is the following if i open the...

Hi all One of our customer which uses a Access driven Intranet Application receives the following error message: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your...