Recent content by LCD

bump

sorry - should mention that the UniqueID is numbers and letters. I have no control over this since I do not create the source CSV.

I need to write something that will check to see if a records UniqueID allready exsists and update that record or add it as a new record. The source table is a CSV that is generated daily with a complete list of records. And they need to be updated in the SQL DB. What I'm looking for is a...

I wasn't have trouble with the expression, just thought I'd thank the guy for pointing out CAST since I've never used it before. Thank you for your help too.

---Quote if you use the cast function (CAST(Your.Field to VARCHAR(249))) on your memo field to a varchar ---/Quote I ended up modifying the view I was using and added CAST(My.Field AS VarChar(30)) AS NewFieldName to it. Thanks for the idea, this SQL n00b wasn't familiar w/ CAST.

I've considered doing that as a last option, but I believe it's the only way to solve the problem now. Just working with another companies data and didn't want to change anything in the DB. But it looks to be the only option, so it will be done. Thank you.

thank you. Guess I'm just going to have to get 10 and see what happens.

I've gathered from searching the forum that this isn't doable in 8.5 (what I currently have) since the field I'm working with is 1024 chars. Can anyone tell me if this is an available option in 9 or 10? Thanks, Andrew

here is a example of my problem. Select ID, FileName From Table Order By FileName Returns ID | FileName 1 | A0-01-Layout1 (2002.10.30.1.21.33.235).TIF 2 | A1-03-Layout1 (2002.10.30.1.21.38.131).TIF 3 | A1-2-Layout1 (2002.10.30.1.21.34.197).TIF 7 | A3-1-Layout1 (2002.10.30.1.21.42.127).TIF...

thank you

I just want to make sure I'm doing this correct, or if there is a better method for doing this. I'm hosting a website on a 2000 server. I'm using host headers to get different pages to load when different prefixes (right termonology?) are used. www.mydomain.com (HH = www.mydomain.com &...

I should also mention the same server is running SQL 2000, and some of the ASP pages do interact with it. But when the server stops displaying ASP, all pages will not load, even ones w/ just a hello world in them.

I'm running IIS 5.0 hosting about a dozen low trafic websites. Half of those use ASP. On occasion ASP pages will fail to load, but HTML pages will still load fine. Trying to stop the WWW service doesn't work. And I can't seem to find anything in Event Viewer pointing to whats causing this. I...

'I ended up using Function leadDigit(val) If val < 10 Then val = &quot;0&quot; & val End If leadDigit = val End Function strDOB = Year(now) & leadDigit(month(now)) & leadDigit(day(now)) & _ leadDigit(hour(now)) & leadDigit(minute(now)) &...

I'm trying to format the Date/Time so it shows mmddhhmmss with each taking up to 2 chars. (so it'd look like 0708065822 instead of 7865822) strDOB = month(date()) & day(date()) & hour(now()) & minute(now()) & second(now()) is what I'm currently using. Any suggestions? All I can think of is a...