Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: chidi
  • Order by date
  1. chidi

    Upper

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

    Upper

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

    Upper

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

    can you help revamp this?

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

    Help with alignment

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

    can you help me debug this, please

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

    can you help me debug this, please

    ...connectionToDatabase.Open &quot;DSN=sTract;UID=sokeh;PWD=sonn1e&quot; recordSet.Open &quot;SELECT * FROM Driver&quot;,connectionToDatabase,1,3 Dim ss_nbr, fname, validate validate=true for each qryItem in Request.Form if Request.Form(qryItem) = &quot;&quot; Then validate = false...
  8. chidi

    help!!!!!

    Perfect! This is what I want!! Thanks a ton jjgraf !!!
  9. chidi

    help!!!!!

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

    help!!!!!

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

    vb newbie

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

    Date Error

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

    run_product error

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

    run_product error

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

    run_product error

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

    Can't change password as root

    i am having prolems changing users password as root it tell me it can't write to the /etc/passwd file and a Permission denied message. i need help fast on this . my users are on my neck.
  17. chidi

    login problem

    I created a login screen to over-write the oracle default login screen. This works fine. This is where I am having problem: The way the application works now is that once the user logs in, he/she will manually enter his internal emp_id which is numeric and then that emp_id populates his/her...
  18. chidi

    help text

    Yes, it is lewisp, thanks
  19. chidi

    help text

    Why is this not working? DECLARE MouseItem VARCHAR2(80) := :system.mouse_item; BEGIN -- if the mouse is held over a button -- item, show the help text for that -- item in the toolbar text item IF get_item_property(MouseItem, ITEM_TYPE) = 'TEXT ITEM'...
  20. chidi

    Ok, I give up

    It is on when-validate-item trigger (block level). thanks, I moved it to post-insert trigger. I think it is ok now. Does the code look ok to you? thanks,

Part and Inventory Search

Back
Top