General Forum

The Miscellaneous Discussions forum is for any technology related question, comment, concern, or discussion. However, we encourage you to look at the full list of forums before deciding this is the best place for your thread. For instance, a question about C/C++ technically fits into this forum, but it would be much better in our C/C++ forum. ...

Tell us about the worst experience you have had with a purchase of software or script. There are a lot of horror stories out there, so take the time to share with us yours. All facets of using/buying software - support, installation, bugs, fraud/deception, so and soo.

There is always that one company with a killer product and great all around service that makes us feel good about our purchase. Share a good experience you had with a software company and it's products. Provide name of company, url if available, and the product you purchased and use. Don't forget to tell why they made it into your top list.

We are actively working on the new version of thescripts.com. It's really exciting and coming together really well. Please post suggestions for features and ideas you may have. ~ KUB

Hi, I want to do a select statement in one table. The table has two columns: Citycode, TeamCode The citycodes may have multiple team codes, and the team code may be the same as the citycode or not.

hi, i am begineer in Berkeley DB , i need some examples which can ilustrate how to store objects in berkely DB. if anybody has plz send on the forum or either mail me at kunal.jethwa@gmail.com thx in advance regards kunal :confused:

Hello. I am getting started with PHP 4/5. I am coming from a Delphi background. I find PHP straightforward so far. The books I have are guiding me via MySQL, but my client is running MSSQL. I will be developing a few learning apps along the way. I was asked if MYSQL is stable enought to run a million dollar business on. The app will be the...

Hi, *Sample Data *Company ============= CoId CoName 1 Company1 2 Company2 3 Company3 ** Employee

Hi Every Body I want to round Money Value 100.54895 to 2 decmal place. and result required is 100.54 not 100.546 please suggest which function to use Thanks vijay Soni Mail Me

Hi, I'm trying to write regular expression to find addresses or locations in HTML file (like cities, countries, states). Does anyone have an idea of general format of an address? :confused: Thanks Amit :)

Hi I have created a simple search that allows the user to enter text in a text box, then on search it searches a column in my database to find what ever the user has typed. This works fine, but I want it to search on all the words the user types and display records that have any of those words in. Obviously excluding "and" "or" etc. This is...

Scenario description - We have two Oracle DB's A & B. Both DB's have a table test1 (customerid varchar2(50, val number). The idea is that for every customer id, the counter (stored in val) increases. Whenever we send a file to the customer, we tag/identify it with a counter value. This is for verification on the customer side that they have...

Hello, I am returning a boost::archive::text_oarchive object from a function. But i am getting error " In copy constructor of boost::archive::text_oarchive shared_ptr is private. How can i resolve this problem with the copy constructor of boost. ThanX & Rgds Rajeev

hello. could anyone tell me why my msqsl db is still storing (displaying) 10.0 instead of 10.00 on a float (2), decimal(2), numeric(2) field? Thanks

In and stored procedure, how can I change any null result to empty? In other words, select both: null and empty records when the query includes WHERE Field LIKE '%' (my condition LIKE '%' excludes NULLs)

hi, i have a unique problem running trigger. i have 2 triggers attached to 2 different tables. on insert / update of each row in table-1, a trigger is fired to update value in table-2. Again on update of a row in table-2 trigger is fired to update a value in table-3. The problem is, if i have 'n' number of rows to update, it works only...

Helo All! Got a problem. Is it possible to select fields from a subquery? I have seen different types of subqueries but I don't think i could use them. I can not create views so it is out of question. This is my query and it is supposed to be my subquery: SELECT POROW_AVSTEM.RUNDATE, POROW_AVSTEM.STOCKNO, POROW_AVSTEM.PONO,...

how do i convert a yyyymmdd format to yyyy,mm,dd format. also i want to know how do i get the number of days between two dates which r in the format yyyymmdd. how to convert date into unix time stamp nad back

I'm trying to update an empty field in a table using the update statment. The table has a number of joins and the update statement comes up with an error when I enter the main table to update. should i be including the joins here as well? I get the following error: Server: Msg 208, Level 16, State 1, Line 178 Invalid object name 'TD_EXTRACT'....

Does anyone know how u can add a name to a query please? I want to name a query so I can update an empty field in the query. I need it to act as a table name, so that i can use it in an update statment. I need the syntax please! Thanks

Can you write a MERGE statement omitting one of the WHEN MATCHED and WHE NOT MACTHED statements. In my program I have to update when macthed and not do any thing when not matched. EX: MERGE INTO table1 tb1 USING table2 tb2 WHEN MACTHED THEN UPDATE SET tb1.col1 = tb2.col1 WHEN NOT MACTHED then do nothing

Hi every, I did create the following store procedure , but when I execute I get a timeout error and nothing done even I ran it in local db ----------------------------------------- CREATE PROCEDURE create_mat AS declare @loop_cnt int, @max_cnt int, @cur_month char(6),

May i know the coding for Insert, Update and Delete of MS SQL? Any good websites to search for Codings?

Hi, I am looking for someone who can do "good" shell,plsql programming with knowledge of Oracle DBA (dataguard,cloning, etc). I have requirement of scripts to be created on adhoc basis from time to time. At present, I am looking to pay on per script basis. If you think you are the correct person and want to earn few bucks apart from your...

i have created an email form using JMail ... and after filling the form and sending the email i get a new file in the badmail folder with a message that i need MIME-capable mail program what should i do?

Hello to everybody i am new to this forum and i have an important problem with sql statements in my website. why do i get these error messages , can anybody tell me; --> com.mysql.jdbc.PreparedStatement@1f11507: select news_id,DATE_FORMAT(news_date ,'%d %m %y')as Hmerominia , news_title, news_decr from news sql...