Search results for query: *

Works like a dream - thx tsuji

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

Hi If you are using DSN, then this is one possibility: connectme = &quot;DSN=DBName;UID=U1;PWD=u1&quot; Hope you can use it too. regards Nick

hi I'm not sure if it's possible in your case, but why not leaving the pictures in a separat folder and just putting the reference in the DB. Nick

try this select * from table where GETDATE() between startdate and enddate

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

Hi this should work: WHERE date_sub=cDate(#&quot; & varNow & &quot;#)

Hi This is the script i have already: House = ObjektID (get from other select) sql_command = &quot;SELECT * FROM tblKalender WHERE Datum=cDate(#&quot; & Datum & &quot;#) AND Status = 2 AND Objekt=&quot; & House I need to make following changes, an i'm a little stuck. if Status = 1 then...

P.S. I'll be doing this over a couple of asp-pages. -update page -controll page -update page -controll page etc...

thanks for the help Joli. the second step will be to update (to the now correct Record) paralell tables which are linked with the Customer_ID and then delete all duplicates. Do you think there will be problems making this seperate table, as there are over 1 mio. 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...

Thx terry I was stuck on the innerjoint.

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 &quot;first found record&quot...

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 &quot;first found record&quot;. Then the...