Recent content by johno77

Hello I havent used perl for a long time and am trying to refresh my memory to write a quick script - i have got the general jist of whatim doing but am still having a slight problems. I am trying to open up a file of usernames for reading and then trying to find if the username is presnt...

Hello Has anybody ever built there own sort function before without using the in built sort command. If anyone has would it be possible to get a look at te code for it. many thanks john

Howdy folks am new to php but my boss has asked me to have a quick look at something. At the moment i connect to a mysql db do a select statement and print the result set. My boss has asked me though if it is possible to sort on price with minimum first. I would imagine it is i just dont know...

Could someone please inform me if it is possible to code the following statement so if there is no record with name equal to bni the statement inserts the details as a new record. Many thanks UPDATE tab SET eng="50" seq="30" where name="bni"

Hello I have created the following code to update a paticular mysql record. Could any one inform me of how if the record is not present to add it to the database. Thanks - heres the relevant code try { String query1 = "UPDATE system SET cox='"+first+"'...

Hi I am creating a regex so that the variable telephone is a the value read in from a html form. I want to delete any white space which i think i have done and make sure there are eleven digits - while the script works for checking ranges 0-11 if the user enters fourteen numbers the prompt...

Hello I have created a class below which for the main part sets up a gui. The two bits of the code i am concerned about are below Tcpdump td = new Tcpdump(); try { td.printOutput(text,text1); } catch(IOException e){ System.out.println("tcpdump err");} and the code just below...

Hello I have created a webapp which i have created under the context root c:\jspapp - i am using tomcat 4.17. I want to deploy this to other machines under the same structure namely c:\jspapp. Can i create a war file with the entire directory structure underneath jspapp and transfer it to...

Hello I am not very familiar with mysql but am having to port a table i have created to another machine. I am running the latest mysql. Could someone please inform me how this is possible from the command line. thanks

Hi I have a database with several field including a status field named stat. Could somone please let me know how to change the value of this field i.e. update the stat field to the value approved when say the field called username=john and sex=male. thanks

Hi hopefully someone may be able to help me out on this one. I have created a servlet which access a DB, stores the results in an arraylist and passes this in the session object to a jsp page. At the moment the code below iterates throught the arraylist and prints out all the records. I would...

Hello my work doesnt normally bring me into contact with databases so consequently i do not know an awful lot. What i am trying to do is insert values into a table but some of my fields will be entered at a later date - how do i code this i.e. will the following work insert into programming...

Hello i am still a bit new to these technologies so please bear with me. I have a simple jsp page which i have restricted access to in my web-xml file. I am using form based security so when the user tries to access this resource a login page is displayed. If the user has the rights to enter...

Hello i am trying to search a field in a database to see if a certain substring exists i.e. re in fred or oh in johnny. SELECT * FROM whatever where fieldinquestion='???' Could someone point me in the right direction. many thanks john

Hi i have no real knowledge of databases but am trying to make a simple table but keep getting a syntax error with the following code: mysql> create table enterprise_programming(Submitter VARCHAR(20) , URL VARCHAR(20) , Date submitted VARCHAR(12) , Version INT , Task-ref-no IN T , Page number...