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!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
JS Show/Hide Div - Filled from DB with ASP
Dont know much of Javascript, so would appreciate if someone could give this a quick lookover and tell me what's wrong. Desired results: <div> is hidden, is visible with onmouseover and hidden again with onmouseout. ASP is calling multiple rows: id=<%=RID%> is ASP-insert of id-number of text...- Nickman
- Thread
- Replies: 3
- Forum: Javascript
-
transfering records from table to table with where
hi I have two tables (TCustomer & TPolice), they are joined by field (partner_nr) I want to get all information out of TCustomer.User_nr and put it into TPolice.FKB_VST_NR where TCustomer.Partner_nr = TPolice.Partner.nr I would prefer doing this without creating a new table. thx in advance Nick- Nickman
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Select AND/OR
Hi This is the script i have already: House = ObjektID (get from other select) sql_command = "SELECT * FROM tblKalender WHERE Datum=cDate(#" & Datum & "#) AND Status = 2 AND Objekt=" & House I need to make following changes, an i'm a little stuck. if Status = 1 then...- Nickman
- Thread
- Replies: 2
- Forum: Microsoft: ASP (Active Server Pages)
-
checking for duplicates and changing the records
Hi Table design is: TCustomer .Cust_ID .Name .Street .Zip .Code What I've already got: SELECT TCustomer.Name, TCustomer.Zip, TCustomer.Cust_ID, Count(TCustomer.Name) AS [Nr.of.Names], Count(TCustomer.Zip) AS [Nr.of.Zips] FROM TCustomer GROUP BY TCustomer.Name, TCustomer.Zip...- Nickman
- Thread
- Replies: 4
- Forum: Microsoft: ASP (Active Server Pages)
-
Find/Change/Delete duplicates
Nickman Hi Table design is: TCustomer TProduct TReport .Cust_ID .Cust_ID .Cust_ID .Name .Zip I have to find duplicates in TCustomer. The first found Record is saved and the TProdut.Cust_ID/TReport.Cust_ID of the duplicates has to be changed to the "first found record"...- Nickman
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Find/Change/Delete duplicates
Hi Table design is: TCustomer TProduct TReport .Cust_ID .Cust_ID .Cust_ID .Name .Zip I have to find duplicates in TCustomer. The first found Record is saved and the TProdut.Cust_ID/TReport.Cust_ID of the duplicates has to be changed to the "first found record". Then the...
