Recent content by terawebwriter

Thanks for the help, tips, and support. Invaluable.

VI Newbie here, challenged with connecting to a Teradata table, dbc.databases, and returning the results in a Grid DTC. My learning application works fine using <b>MY</b> authentication credential when its embedded in the RecordSet DTC properties. Problem is, I need to learn how to set this...

Thank You. It worked great. This is the actual code: <% Dim T1 T1 = (Total1 / Total2) * 100 T1 = Round(T1, 2) Response.Write (T1) %>

How would you get a Division to return only 2 numbers. For example, if you want to divide 2 totals and than return only 2 numbers instead of (EX)1.32398795094, how would you do that. This is my code: <% Dim T1 T1 = Total1 / Total2 Response.Write (T1) %>% Yes, there is a second...

Is asking me for a End of Statement after the When case week when 1 <===== Expected End of Statement Its not a SQL Database, its a MS Access Database. Does it matter?

I have a database that lists Help Desk tickets. The table consists of Technician Name, Week #, Ticket Count, and Site Name. What I want to do is to list the total # of tickets completed, per technician, per week. Ex: Name Week1 Week2 Week3 John Doe 20...

JuanitaC...... THANK YOU VERY VERY MUCH. It worked. I thank you for your time.

Sorry, but it still did not work. It gave me the same error. Basically I just want to get a list of records from the database (which works fine), list them, and than take the ID of each file and pass it to another page to edit that record (make changes to the record). Any help I would appreciate...

Can someone help me with this one please. Whatever I change the fields to, it wont work. ASP with MS Access Database. ReceivedProductsID is the Autonumber in MS Access Database where I create a link to edit the record #. Error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)...

Could someone tell me what causes this error. Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /AddRecords/AddRecord-catano.asp, line 15 This is what the SQL statment looks like: sqlString =...