Recent content by chidi

Targol and my other good helpers, I understand what you are saying. I have used upper in sql and have used ucase in asp but the problem I am having is that ucase is not working the way I am using it. I am not using in my where clause. A user enters values of either yes or no but the problem is...

When I remove the UCASE(), my code works. select UCASE(engineName) FROM Engine I keep getting this: SQL Server]'UCASE' is not a recognized function name.

In sql server, you can select UPPER(tablename.fieldname) from your tablename. But how do I make it work within asp? I keep getting error: Item cannot be found in the collection corresponding to the requested name or ordinal. thx

sorry I am too stressed out to find the thread I sent earlier today. Here is what I am trying to do: 1, per my boss, we want to give our users to ability to do a search based on either firstname, lastname, posnumber, jobtitle, jobgrade, hiredate, and training and posNumber in one table must...

Ok, I got the Top Bar aligned to center for you. Hope someone else can help you with the other problem. here it is: just copy and paste!! <td width=&quot;582&quot; valign=&quot;middle&quot; height=&quot;50&quot; colspan=&quot;2&quot; bgcolor=&quot;floralwhite&quot;> <div...

You guys are so good. I love this forum. I just came back to say I found the problem which was exactly what you pasted onpnt. I was inserting an nvarhar into an integer column. It is all fixed now.

Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E21) Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. I have been trying to debug above error to no avail. Please tell me what is causing it. Here is the code...

Perfect! This is what I want!! Thanks a ton jjgraf !!!

thanks for your response but i don't see any quarter date format. that is where the real problem is. i need to able to display data like: 1Q 2Q 3Q 4Q mar apr may; jun jul aug sep oct nov dec jan feb. This way, i could get data for any month and it...

I am trying to write a query that will return data on a quarterly basis. example, select data from table where data is between 1st quarter and 2nd quarter. data could be queried for any month in any quarter. our company's quarter starts in march. first quarter is mar - may, second quarter is...

I have two separate codes that I need to put in on module in access forms using vb. can anyone tell me how to do this, please? example, if x then do you else do x end if if yes then 10* 20 else 0 end if. I need to put these two if statements in one module. thanks for your help.

To all you great coders, please help!! I am having a date problem. I have three fields: Lov_date, deadline_date, and comleted. completed is boolean = Yes/No. What I am trying to accomplish here is that if lov_date is less than deadline_date then completed should be yes else completed is No. The...

I have it working now. Sorry I posted it twice. Tensions, sometimes, forces you to make mistakes.

Hi Everyone! This error is strange to me, strange in the sense that I have used it several times without error until now - same syntax! Here it is followed by the error message: run_product(REPORTS,'Emp',Asynchronous,Runtime,Filesystem,null,null); error: too many declarations of RUN_PRODUCT...

Hi Everyone! This error is strange to me, strange in the sense that I have used it several times without error until now - same syntax! Here it is followed by the error message: run_product(REPORTS,'Emp',Asynchronous,Runtime,Filesystem,null,null); error: too many declarations of RUN_PRODUCT...