Recent content by ibearian

many thanks

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

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

THANKS RORY

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

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

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

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

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

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

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

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

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

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

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