Search results for query: *

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

...AFTER UPDATE AS declare @DET_PRIM varchar (20) declare @HEAD_PRIM varchar (20) declare @newfield varchar (20) IF @@ROWCOUNT =0 RETURN BEGIN /* DETAIL-DIM3 THIS CHECKS FOR THE LAST NUMBER AND SET IT TO @DET_PRIM*/ SELECT @DET_PRIM=MAX(det_primary) FROM sl_pl_nl_detail m /* DETAIL-DIM3...

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

...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 returns a field from the row where the trigger was fired from /* does this make any sense sorry...

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

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

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

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

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

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