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: *

  1. Zeroanarchy

    multidimensional array, Sort column

    Okay I have tried numerous functional examples and have been at it for two days now. I seem to be having an issue sorting a column. Here is the output via print_r ------------------------------------------------------ Array ( [0] => A0034 [1] => 4 [2] => 1 ) Array ( [0] => A0035 [1] => 18 , 9 ...
  2. Zeroanarchy

    Convert Apache Regular Expression to Perl Regular Expression

    Hi I am a bit stuck and was wondering if someone might be able to help. I would normally work with apache but in this case I am working with IIS Ionic. The issue is the software I am using only excepts Perl Regular Expression and I can not understand why the following regular expression will...
  3. Zeroanarchy

    MySQL -- Cobol

    Has anyone worked on developing a method of talking between Cobol and MySQL. I am currently working at a site that has a Cobol back end and the concept is to access this information via PHP for web purpose. I am gathering that services will have to be developed to ensure both sources of...
  4. Zeroanarchy

    htaccess help divert subdomain file to domain

    I hope this is the right forum, I am having real problems trying to divert one page to another in the htacess file. I am unable to make the divert happen on the page as it is part of a forum. I have tried a few different combinations but I can not seem to get it to work. I want to permanently...
  5. Zeroanarchy

    htaccess help

    I hope this is the right forum, I am having real problems trying to divert one page to another in the htacess file. I am unable to make the divert happen on the page as it is part of a forum. I have tried a few different combinations but I can not seem to get it to work. I want to permanently...
  6. Zeroanarchy

    remove <img ???

    Hi was wondering if someone might be able to help, I have the following code $content = "<table><tr><td>This is a general description or some usual text that I want to display.</td><td><img src='http://www.test.com.au//images/logos/client_1100_200.gif' alt='Logo' width='50' height='50'...
  7. Zeroanarchy

    Web site structure best practice

    Hi I was wondering if someone might be able to supply some advice. I have noticed over recent years that website structure has changed a bit. Years ago the technical layer and the presentation layer where the same layer. These days websites are presented in the following format. Database -->...
  8. Zeroanarchy

    Find Field in Functions

    Hi all, I am currently using the following method to determine if a table in being used in a list of functions. select referenced_owner, referenced_name, type, owner, name from all_dependencies where referenced_owner in ('Database1') and referenced_name in ('PRODUCT') order by name Does...
  9. Zeroanarchy

    tracking functions

    Hi, Wondering if there is any method available code or program to track the use of a oracle function. I currently have over 150 functions but can not work out (without a lot of manually checking) which ones are in use, the last time they where used and how often they get used. has anyone...
  10. Zeroanarchy

    Between Using Sysdate

    Hi, Having problems trying to return any values using the following method, can anyone make any suggestions? The field value is set to date and the date is as follows "dd/mm/yyyy" SELECT T_RATES.TO_DATE FROM PRODUCTDB.T_RATES WHERE T_RATES.TO_DATE BETWEEN TO_CHAR(SYSDATE,'DD/MM/YYYY')...
  11. Zeroanarchy

    Email address validation

    Hi, I have been searching Tek-tips for a method to validate an email address that contains only numeric values before the @ symbol and after the @ symbol in a select query. I was hoping that a method existed where by if only numeric values appeared before or after the @ symbol I could remove...
  12. Zeroanarchy

    If Like then ElseIf

    Hey just a little stuck, Can anyone help with this: If pcktype Like "*Ambulance*" Then XV = "Ambulance" ElseIf pcktype Like "*Car*" Then XV = "Car" ElseIf ...... I am unable to get this to work due to Access not reconising the first If, I keep getting "ElseIf without If" Error. Cheers...
  13. Zeroanarchy

    Strip Text to Right and left of words

    Hi, I have a table with a memo field in it. The memo field contains a lot of data with squares between set values. I am interested to know If there is a method of stripping data to the left of a word and to the right of a word. Example. (1) Your Cover Option: Package Cover: Plan 1 Membership...
  14. Zeroanarchy

    limitations to VBA

    Hey, I seem to be having some problems with Access 2003, " Sorry for the inconvenience". I have been hunting the web for answers and tried everyone. My question is what’s the limitation to an array in Access. Is there one? I have limited the problem down to a section of code that runs an array...
  15. Zeroanarchy

    Case Question

    Hi thanks for taking the time to look at this. I am interested to know if this is possible in a Oracle query. What I am trying to do is create two columns and the second column is based on the first columns value. So in the select query I have hte following. The issue is that Oracle tells me...
  16. Zeroanarchy

    Convert IIF to DECODE

    Hi is there a way of converting the following IIF statement from access into a Decode statement in Oracle? Payable: IIf([AMOUNT]=0,[AMOUNTDESCRIPTION],IIf([ORDER]=31,Null,FormatCurrency([AMOUNT]))) Thanks [afro]ZeroAnarchy Experience is a wonderful thing. It enables you to recognize a...
  17. Zeroanarchy

    Display table name in query

    Is there a way of displaying the table name in a query column. I am looking to do a union query whereby I can see which table the record came out of. Is this possible. Cheers [afro]ZeroAnarchy Experience is a wonderful thing. It enables you to recognize a mistake when you make it again.
  18. Zeroanarchy

    Session timeout issue with IE 6

    Hi, I don't know how unique this problem is but I am hopeful that someone might have an answer or be able to point me in the correct direction. Currently using weblogic8 and during sessions members are being kicked out of the members section without requesting it. The timing varies from 2-4...
  19. Zeroanarchy

    Crosstab values remain null

    Hi, was wondering if someone can see what I am doing wrong. For some reason the values in the fields remain blank even when they are told to change to No TRANSFORM First(IIf(IsNull([LPRODUCTNAME])=True,"NO","YES")) [afro]ZeroAnarchy Experience is a wonderful thing. It enables you to...
  20. Zeroanarchy

    Highlight specific record in a continuous form

    Hi I am refering to thread702-693007, does anyone know how one would make this work in Access 2002. Instead of highlighting the row with a solid line it hightlights it with =IIf([SelTop]=[ctlCurrentLine],"ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ",Null)...

Part and Inventory Search

Back
Top