viaducting wrote:

Gary Wheeler wrote: My wife's grandfather Oscar ... was familiar with handling dynamite. Gary Wheeler wrote: He also removed about half of the office shack Umm....

Reminds me of a character on The Red Green Show :laugh:

Laterness... Doug

I used to use RegClean from M$ to fix registry problems, but when i looked for a download link on their site i found this from KB article 299958... MORE INFORMATION The RegClean utility is no longer supported and has been removed from all Microsoft download sites. Does anyone know of a currently supported utility (from anyone) that scans the registry for errors? ps: when i say i used to use it, i mean i used it up until now :) Laterness... Doug

Str = "ame's account" Qr = "select * from Tab where fld=?" Dim cmd As OdbcCommand = New OdbcCommand(Qr, OdbcConnection1) Dim param1 as OdbcParameter = New OdbcParameter("name", OdbcType.VarChar) param1.Value = Str cmd.Parameters.Add(param1) then execute the command... Dim dr As OdbcDataReader = cmd.ExecuteReader() Laterness... Doug

Shanmukeswara Rao wrote: Str = "ame's account" Qr= "select * from Tab where fld='" & Str & "'" I have had this same problem before. You should use parameters in your query. Combining the strings like this is prone to a SQL injection attack also. The way you use a parameter query depends on if you are using MS SQL or ODBC (MS Access) for your database. If you provide more information or more sample of your code I can show you better. Laterness... Doug

and the question becomes a little less hypothetical :) now that i'm married with pets with a house payment and everything, i would probably voice my displeasure with the situation, and when the boss tells me to do it anyway I would. Then update my resume and start looking for another job. Laterness... Doug

I don't have any links to any Best Practices documents. However I've seen how it was done in Goldmine (sales contact manager). They use a table of custom field definitions where each row defines a custom field. The actual values are put in a separate table with ID fields to link to the FIELDDEFS table and the table the custom field is associated with. As far as storing different datatypes in .NET I would just make all of the actual data fields varchar and store the data using ToString(). Integer.Parse(), DateTime.Parse(), etc can be used when you retrieve the data. I hope this can get you started. I can give you a more detailed description tomorrow when I get to work and look up how exactly it's done. Laterness... Doug

...and three rights make a left :) Laterness... Doug

Yup, me and my wife and our cat Teal'c :) Laterness... Doug

>>No patent in the US is stupid, they are done by the laws existing there. I guess you mean to say, stupid US patent laws true that Laterness... Doug

> I have a standing offer from another boat shop How long is this offer? For me, in this job market, i would not risk being unemployed, I'd take the job and deal with the consequenses on my resume when that time comes. Laterness... Doug

i've never seen such a sexy copper oxide french tart :-D Laterness... Doug

hey now, in my OS/2 days i read os2.h and os2sys.h they weren't no harry potter book though... :) Doug

skywen wrote: If PortalSecurity.IsInRoles("Admins") = False Then Response.Redirect("~/Admin/EditAccessDenied.aspx") End If It represents the root of the web application. Doug If memory serve's me right... - Chairman Kaga

A life size cardboard representation of Xena, Warrior Princess. Doug