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.

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:

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

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

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

Hi! I'm a newbee in TSQL, so I've a simple question (I think): I want to make a loop from the first row to the last row in one table. For each row I want to festch two fields @Customer_number and @Phone. Then I'll use those values to update a second table: update samtaler_table set cust_nbr = @custumer_number where (telephone =...

Hello, This is regarding log analysis of a web system, I am finding my backend SQL programming has taken so much of time to process the application due to following quires for a log table having 500 million records, i have already done index tuning , but no use, so I would like to change the following quires into a single stored procedure in...

Hi, Need help to make a script in t-sql for mssql version 2000. I have a table with fields; cusid, txtdes, ordinal Data example : 5001 aaaa null 5001 eeee null 5001 oooo null

How would i go about creating an Alphabetical Sort?

I have a problem. I am developing a website that involves users being able to delete certain rows of their own tables in a MySQL database. Just say there is a table with 10 rows, and a column named 'id' that is auto-increment with numbers 1 to 10. If a user deletes row 4, is there any way to either shift all the data below up so that the end...

Could anyone help with rewriting this query? Result of this query will be inserted into a table. Thanks! SELECT tableA.PK, table1.amt, table2.amt, table3.amt, .... table16.value FROM tableA, (SELECT fk, NVL(value, 0) AS amt

Hello everyone, Please HELP !!!!! I'm facing problem in converting CASE statements into DECODE. As i have PL/SQL 8i, so it does not handle CASE statements. Please send me the solutions . Then basic problem is the CASE has NOT condition i.e. <> ...... and this particularly i'm not able to convert in DECODE. Please send me the solution as...

I am writing a program that will display a small blueprint that i have already drawn. It is a metafile, but the format isnt really an issue..It can be any format if I need to switch it to something else to get this to work. Anyway, the print will display in a picturebox. Overlayed onto it, are several textboxes that the user can type in sizes,...

Hello All, I have been asked to see if I can help out with some reports that we do at work, by no means am I programmer in any type of way. I have part of it done from help that I have already received but I am stuck on something and I have tried to change the SQL myself but have only been successful at messing it up very well. We deal...

Hey Guys !!!! Please help me out....... i have to make a small application using VARRAYS in Oracle 9i.... Can you guys suggest me something good....... Thanks in advance... and hoping for a quick suggestion from all you guys ! :)