Search results for query: *

I think I know what you mean. Each time you create a new widget you assign the new_id to it and you have old_id of the previous widget that is associated with the new widget. Is that correct?

If I understand the question correctly than the answer is: select w.widget, w.widget_id, v.new_id, v.old_id from widgets w, versions v where w.widget_id = 712 and w.widget_id = v.old_id order by w.widget;

Thank for the reply. I may work but I have like 10000 records. I just found an answer. I tried it and it works. DELETE FROM `my_posts` WHERE `post_id`=2 LIMIT 1; Good luck to everyone who has same problem. I found like 5 similar posts on this board but no similar and simple answer. - Webmaster

Hello, I have a problem. I have a table with identical row information. I need to delete duplicates. For exaple I have a table my_posts with data: post_id post 1 first post 2 second post 2 second post 3 third post I need it to be: post_id post 1...

It works like a charm. Thanks a lot guys. Sorry azzazzello I misread your first message a little bit. Thanks again guys. - Andrey

Thanks for reply. I am not sure what maxdate suppose to be. If you are proposing to try: select a.topic_id, a.topic_header, max(messsages.message_date) from topics a left outer join messages(a.topic_id=messages.topic_id) group by a.topic_id <==== missed line order by max(messages.message_date)...

Hello, I have a sort question. I have two table: topics and messages for those topics. Each topic can have multiple messages. I need to select the topic name and the last message posted. topics table topic_id (int) topic_header (varchar 100) topic_text (text) messages table mesage_id (int)...

Hello, I am looking for a code example that does header trailer in Javascript. Meaning when my page is very long and I need to scroll down I need a particular banner/header to be visible all the time. For example if the table data is too long I need to be able to see table heading no matter how...

Coderifous, Thank you very much. I just tried it and it works perferctly. Thanks everyone else who responded.

Thanks for replies guys. I am at home now and will test it tomorrow. Mike I have looked at the docs before posting it, but I managed to make it work for every case, but not for all at the same time. :(

Thanks for reply Mike. As it is shown in examples above I need to find out if number 5 is the in the string. But I need to make sure number 5 is the stand alone number and not part of any other number like 15, 51 or 151. 5,12,121,17 - yes there is 5 12,121,17,5 - yes there is 5...

Hello, I have a pretty simple pattern matching question. I need to match a number in a string. For example I need to see if the number 5 is in the following stringsL 5,12,121,17 - yes 12,121,17,5 - yes 12,121,5,17 - yes 12,121,15,17 - no 12,121,51,17 - no 12,121,151,17...

Thanks for info guys. I have a small form with radio buttons that have to be there (data is stored as value of the radio field). I cannot do any calculations serverside. Whatever I do has to be done in javascript. I am not trying to hide the numbers from experienced programmers and hackers...

Thank you for response. Why would not encryption work? I have seen it done with third party software so I assume that there is a way to do it with perl. All the data is in the database as it is, but the problem is that the results are calculated by javascript depending on what clients chose -...

Hello everyone. I was trying to search this forum for an answer to the question I have and I was not able to do so. Therefore I am asking this question. I need to encrypt my HTML output so other people cannot see the output data because it consist sensitive data (numbers used for caculation.)...

Hello, OK I have looked and I have read a lot of stuff but I still not able to make whatever I need work. Here is the task I need to do: Xml file ################################################## <REQUEST_GROUP VersionID="2"> <REQUESTING_PARTY> <PREFERRED_RESPONSE _Format="TEXT" />...

Thank you very much guys. I will read articles and try example and let you know how it worked out.

Thank you for reply. Well it helps a bit, but not too much. My question is if I have XML file converter into the tree using XML::Parser how do I change some of the data there and how do I write it back into xml file? I hope there is a module for that. And any code samples are appreciated...

Hello, I have never done xml before and now I need to start working with it. I need to read an xml file, modify some data and attributes and write the file out. My questions are: What are the good perl modules to use? Where can I get good examples? I have searched cpan and some other places...

What details would you like to know? I am using a linux server. THe code I am trying to run does work on other server. Here is the connection part: # Create an SSL socket connection my $sock = IO::Socket::SSL->new( PeerAddr => $dataflite_host, PeerPort => $dataflite_port, Proto =>...