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 derfloh 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. ibearian

    access denied

    many thanks
  2. ibearian

    access denied

    I have just joined an sec listed company that uses SAP r/3 but does not allow ODBC access (sox 303) to to the DB or the use of report painter or BW. I am an accountant but do loads of VB, SQL coding and crytals reports and i just can't find a way to get data out of sap other than using the excel...
  3. ibearian

    triggers - a shot in the dark ?

    hi again, i have a trigger below that works just great everywhere excet the very last part of the code seems to execute once. By this i mean when our DB posts invoices, it hit the trigger and the following is done line by line, as you would expect. However the last UPDATE is only done once and i...
  4. ibearian

    TRIGGERS - I feel shot away !

    THANKS RORY
  5. ibearian

    TRIGGERS - I feel shot away !

    many thanks, spot on do you have any recomended reading on triggers, thay are so powerfull but i can't seems to find much thats usefull
  6. ibearian

    TRIGGERS - I feel shot away !

    i am not sure .... am I ? this is what i imagine it should look like CREATE TRIGGER test_update1 ON nl_accounts AFTER UPDATE AS IF UPDATE(NCATEGORYCODE3) UPDATE NL_ACCOUNTS SET NCATEGORYCODE2 =(93) WHERE fetchcurrentrow(tpid) = tpid */ where fetchcurrentrow() is my imagined function that...
  7. ibearian

    TRIGGERS - I feel shot away !

    I AM QUITE ACCOMPAISHED AS SOME THINGS, I AM HOWEVER SUFFERING AT TRIGGERS, & THIS PARTICULAR ONE. I HAVE TO UPDATE A FIELD IN THE SAME db AS THE FIELD CAUSING THE TRIGGER TO FIRE, but this field is not being inserted, it is being updated. With my other triggers are at the point of the...
  8. ibearian

    We have just purcahsed a company wh

    i've used both......not so sure why every one thinks the mac is so cool. i just find it a bit more querky and i really miss my other mouse button. find the whole monitor/pc in one is a bad idea as the screens get really bad phos' burn in and so with my PC i would pick up a new monitor with my...
  9. ibearian

    Image Map Question

    its a he, but yes i had in my own opinion decided it was a world>>contenant>>country thing but wasn't picky, its only for a protoype at the moment and you know what customers are like! oh well you don't know where i can download a gif/jpeg/png map of the world and contenants without infridging...
  10. ibearian

    Image Map Question

    no i wanted a map to pick countries from, i could do a drop down but they may have to do the process 10 times so a list may be a pain in the butt and a puicture is easier. I know i can get a map and do hot spots its just time ....... i was going to do exactly what you said and do view source...
  11. ibearian

    Image Map Question

    did you buy this country picker or did you write if from scratch ?? i am looking for the same thing but for every contry ion the world and its a big job ! ibearian. PROJECT H mailto:ibearian@projecth.co.uk
  12. ibearian

    grouping cfoutputs

    sorry, the query is a simple select * from table a kind of affair and should not be effected the list is the full 49 lines when you don't use the group attribute and the additional cfoutput tags. But with it back in it seems to only loop 40 times and dump the other data i just wasn't sure...
  13. ibearian

    grouping cfoutputs

    In the below query is the number of time the group loops limited ????? for some reason mine stops at 40 ! <cfoutput query="modsfaqs" group="modID"> #modName#<br> <cfoutput> #faqquestion#<br> #faqaskedby#<br><br> </cfoutput> </cfoutput> ibearian...
  14. ibearian

    SMS messages

    I have looked at the email text thing but in the uk we don't seem to have had much take up. I guess the mobile companys have cottoned on and want us to pay a per text price. I am not looking at any provider particularly, best price (and severice) gets the job, kind of attitude. Based in UK...
  15. ibearian

    SMS messages

    I have been told 'we want to send x number of customers a smsTEXT to let them know of our deals etc, etc'. So i looked in macromedia's exchanges and found a couple of SMS custom tags but i know nothing of the SMS network and i have some questions you guys may be a able to answer ? 1. is there a...
  16. ibearian

    closing a pop-up and refreshing the opener page

    thanks but what this does is to load the opener in the pop-up window so Index.htm has a link to popup.htm. on popup.htm you do some stuff then you press close. This should refresh the index.htm page and close popup.htm. I can either get the window closing or reloading in the popup. Any ideas...
  17. ibearian

    closing a pop-up and refreshing the opener page

    All i want this to do is when you click on the hyperlink (at the bottom of the code snippet) the window.opener to refresh and then close this.window pop-up but i can't find out how to do this.......any ideas ? I have tried some CF pages but to little sucess the code i have doesn't work it just...
  18. ibearian

    Multi user - win 2003 server

    Sorry i found our error in the microsoft principles of using the same unlock code for each installation. File maker desided we didn't have enough licences so i had to re install all with different licence numbers, now it works ok. Still get the odd error message but few and far between...
  19. ibearian

    Multi user - win 2003 server

    We have just migrated to winxp and server 2003 from MAC and we are having sharing problems with the DB. It says you only have a sigle user licence or the db is single user (we have a five different user licences). We have changed / reinstalled all the FileMmaker Pros with different unlock...
  20. ibearian

    How to setup DNS for redundant Backup web server

    Just browsing......... and this is the very question i wanted to ask! Is there a simpler solution or am i just stuffed to setting ttl to 300 when i want to down a webserver for maintenance ? ibearian. PROJECT H mailto:ibearian@projecth.co.uk

Part and Inventory Search

Back
Top