6,934 Topics
 | |
| | Hi all, I am seeing the following error in my tomcat log file. Please see the attached file for the full error with stack trace. When I first bounce the server all is ok. After running for some time (I haven't yet been able to determine the exact amount of … |
| | I have a table to store the answers of users of our sweepstake. The table that consists of 3 fields: the userid, the questionid and the answervalue. Now I need to find the users with the most identical answers as a certain user. For example I may have values like … |
| | In MSSQL "SQL server enterprise manager"(client side), I run query and application display record list, if I want to set a cell to "<NULL>" value, how can I do that with the hot key? thanks for any answer. |
| | I have a table in MS SQL Server 7.0 Like this: Id Cat_Name Definition Image 101 A1 --------------- ************* 102 B1 ----------- ************* 101 A2 ------------------ ************* 103 C1 ----------------- ************* 101 A3 --------------- ************* 101 A4 ------------------ ************* 102 B2 -------------------- ************* 101 A5 -------------- ************* 101 A6 ----------------- … |
| | Well, I just stumbled over this community in the urgent need of an SQL answer... Name: Christian Zumbrunnen Nickname: zu, zum, zumbi Height: 186cm Weight: 91kg Hair: Brown Eyes: Blue-Green Location: Brugg, Switzerland Age: 41 Hobbies: Skiing, Swimming, Preaching and Teaching (Bible, Web, Marriage) Relationship Status: happily married, 3 Kids … |
| | Hello there all, I need your help..........I have datagrid with its data from SQL server. But i want to update its data to click the ID......That is it........ <a href = "DataUpdate.aspx"> Something here to validate my ID </a> Please help, any idea would be big big help to me......Since … |
| | Hi all, For example i have a database like, Customer A B C ----------- --- --- --- alfa 1 0 0 tango 0 1 1 omega 0 1 0 beta 1 1 1 cobra 0 0 1 and i have 3 checkbox. checkbox1 checkbox2 checkbox3 what i try to is … |
| | Hi, I'm writing some complex queries on a very poorly designed database. We're running on MS SQL Server2000. I was wondering if its possible to do in-line if-else blocks within a query.. i.e. [PHP] SELECT * FROM tablename IF (condition1 = 'a') WHERE condition2 = 'a' ELSE WHERE condition2 = … |
| | Hi Everyone, First of all, thanx Mojio for providing me the right code information on connecting sql server database. As I'm a beginner in ASP.NET, using vb as language. I have created few text boxes on the form as an input to the application. I hav managed to insert the … |
| | I am an old stink who has been a Windows Software developer, Systems Administrator, and now back to developing software again for a major Insurance agency in Oklahoma City, Oklahoma. I am pretty good at most any DBMS, starting with MS ACCESS, SQL SERVER, MySql (My choice of of them … |
| | Hai I m Radha working as a Programmer. I hv done many sites using Access as backend...i wish to try one with SQL Server..so can anyone send the connection Program for ASP with sql server !!  |
 | Hi all. New to the site, and it looks grand. I ran across it searching for suggestions on clearing out the AntiSpyLab parasite/hijacker for a family member. Looks like I'm in the right place. It also seems like the first step is to post a HijackThis log. Here goes: Logfile …  |
| | Hi everyone! SQL newbie here, thought I'd come to get some information :) Appreciate any help I can get! - Lizzy |
| | My ISP has set up only one DB in MySQL, for an electronics store. I want to have a bulletin board for books, but My ISP apparently does not know how to add a second db [i]and[/i]and arrange for separate permissions for each site. Can someone tell me where I …  |
| | Hi there, I keep getting the following error message when i run this script: [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/home/httpd/vhosts/tellproperties.com/httpdocs/testing/register.php[/B] on line [B]42[/B] [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/home/httpd/vhosts/tellproperties.com/httpdocs/testing/register.php[/B] on line [B]43[/B] No Database Selected [CODE] … |
| | Hi, I have an error, during accessing a datbase using jsp:useBean from jsp.Urgent i need this one my source code ispackage SQLBean; DbBean.java import java.sql.*; import java.io.*; public class DbBean implements java.io.Serializable{ private String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; private Connection dbCon; public DbBean(){ super(); } public boolean connect() throws ClassNotFoundException,SQLException{ Class.forName(dbDriver); … |
| | Hi All! I've been working on a simple MVC style / struts web application which will allow a user to view a product database and have the option to update a record. The initial index.jsp page works and forwards to the right locations, the update page displays but is producing … |
| | Hii All :) I am presently working on a project that has A website and All clients are having their own Windows Applications ... I want to manupilate the data in the website and Clients application using a Web Service. So My Web Service Should Get the data From Website(SQL … |
| | I ran the SP3a installation and it didn't return any errors along the way. However, when I ran the query to look at the current version of SQL it still has the service pack at version 1. Any idea why? P.S. I think the installation process is asinine. |
| | Hi there, i got a question on asp recordset.. i got a page whereby i will display records from a particular table. first i will go & do a select sql command to retrieve records from database, then i check if the recordset is eof and bof then i will … |
| | what I use is SQL SERVER 2000,the system is WINXP SP-2 I set the classpath:C:\Borland\JBuilder2005\jdk1.4\lib;.;C:\Program Files\Tomcat 5.0\common\lib;.; I use the JDBC-ODBC to connect the database,the original code is package hospital.db; import java.sql.*; import hospital.db.*; public abstract class DBConnection { private static Connection conn = null; public static Connection getConnection() { … |
| | Hi, can someone help me to code this ? I have a dynamic datagrid and I want to insert only one column from selected [checkbox] rows in the datagrid into a SQL-Server table. I've a working code where I call Add_to_DB function within the loop of Datagrid items, which works, … |
| | Hi! Since there is no problem (any longer) to update database via simple datatable binded to a datagridview I would like to go to a second level. Binding related tables and queries in order they are able to update data in my database. I don't find that as a problem … |
 | I've recnetly finished building my CSS based website based on Alcohol, whereby I've links like Beer, Wine, Whisky and Spirit. I now wish to have "Cocktail" link in it, however, in this particular page, I wish to make a use of MySQL along with PHP. Although, I've basic knowledge of … |
 | Hello All, I'm sure this is an easy one for you all, but pardon...I'm kinda new at this. What I'm trying to do is store a URL in a SQL table using a text field. This is working successfully and as planned. The heart of the issue: I have 200 … |
| | Again, thank you for taking the time. I seem to have fallen into someone else's thread, but am so glad i did. this is the 1st place I have got any real help, & haven't even comunicated with any body yet! I came in looking for help on the FakeMSNBeta, … |
| | Hye, im new here. Need some help on Vb6 coding. I've look up some of the treads on timing in this site but i have problem implementing it. [CODE]Public CHours As Variant Public CMins As Variant Public CSecs As Variant Public CMSecs As Variant Dim StrNested(4) As String ------------------------------------------------------------ Private … |
| | [COLOR=#000000]Hi every one[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]I have 3 tables[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]department department_id, name, description[/COLOR] [COLOR=#000000]category category_id, name, description[/COLOR] [COLOR=#000000]product product_id, name, description[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]category belong to more then one department[/COLOR] [COLOR=#000000]product belong to more then one category also more then one department[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]I managed to show … |
| | Hi, I've got a module where i search for a candidate with his Id and display his name, age..etc.. I've put the details like name , age etc.. in the datagrid. The search module is working fine.. when a valid candidate Id is entered. But when an invalid ID is … |
| | Over the last several weeks my Internet Browsing has slowed to a crawl. Please help me find out why... Logfile of HijackThis v1.99.1 Scan saved at 09:14:00 PM, on 04/26/2006 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe …  |
| | Hi, I need to use function: SPI_modifytuple HeapTuple SPI_modifytuple(Relation rel, HeapTuple row, ncols, colnum, Datum * values, const char * nulls) How can I get object Relation? If I insert NULL as relation function does not modify tuples. I have found an example, when the function was called by trigger. …  |
| | Dear Colleague: In vb I could retrieve a data sored in SQL 2000 server, using grid object placed on the form object. But when I tried to do it using code, meaning with out placing ADODC object in the form object, I couldn't go any longer. Is there any one … |
 | Hi there, I was trying to get a [B]Scheduled Job[/B] (in SQL Server 2000) to [B]run every second[/B] or two. I had three T-Sql blocks I needed to execute every two seconds, and you know you can just schedule recurring times to every minute. I started out by introducing multiple … |
| | Hi, How can i get this on screen ? sql= new sqlcommand("select count(*) from datas", database123) ... ... persons=sql.executereader() ... ... label1.text= [B]????[/B] [B]Thanks[/B] |
| | Hi, I have column with alphanumberic fields like: trader1.dbpt 1234.mcxl abc243.cexl 234-lab.cxcl There are following characteristics of this data: -fifth last place is always decimal -always four characters after the decimal What I want: -only those rows which have ".mcxl" at the end -rows should NOT have numbers in them … |
| | help please........... i need u're recomendation of site to visit i need to learn (freely) the query (SQL SERVER 2000) thank's:confused: |
| | Hi I have 3 tables that I need to display in a report TableA idxA valueA 1, a 2, b 3, c TableB idxB bidxA valueB 1, 1, aa 2, 1, bb 3, 1, cc 4, 2, aa 5, 2, cc TableC idxC bidcA valueC 1, 1, dd 2, 1, … |
| | hi i have to retrieve a webpage from database given i have the id which is passed to that page as q querystring. here is my code ave 2 pages the one where u clik on hyperlink <<A href="mailto:%@LANGUAGE="VBSCRIPT">%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% dim objConn, objRS Set objConn=Server.CreateObject("ADODB.Connection") objConn.open="Provider=Microsoft.Jet.OLEDB.4.0; Data Source= D:\Datastores\greeting.mdb" … |
| | Hi everyone, i am building a voting system and i am trying to count the number of votes for each candidate to be stored in a candidates table in the field voteresult, i have stored the results in a bean, and written the sql query statement in a jsp page. … |
| | Hi, I have a composite in a Microsoft Access Database that is not populating, when I add data to the two tables connected to it you would expect the Composite Key to populate as well wouldn't you? But this is not happening, can anyone expalain why and how this problem … |
| | How can I create a Formula to figure out a Golf Handicap IN MS SQL Step 1 (Score - Course Rating) x 113 / Slope Rating For example, let's say the score is 85, the course rating 72.2, the slope 131 The formula would be (85 - 72.2) x 113 … |
| | I have this red/green popup that says my computer is infected. and upon clicking on it (my stepfather insists) I get this site [URL="http://www.spywarequake.com/?aff=247"]http://www.spywarequake.com/?aff=247[/URL] So i deceided to do a hijackthis and here is the log [I]\start logfile[/I] Logfile of HijackThis v1.99.1 Scan saved at 11:00:00, on 22.4.2006 Platform: Windows …  |
| | please help i need to learn abt query with transact-sql server 2000 a free module please............... thanks:) |
| | Hi Again, I am choosing a server and its operating system for my office. I have two choices for hardware and another two for software. I have offers for HP Pavilion and HP Proliont; As far as I know HP Pavilion is for home use but the difference in price … |
| | Hi All, Well where I work they are having a problem and I had a solution. Well I was reading on this [URL]http://www.c-sharpcorner.com/UploadFile/mgold/HowtoOepnandReadanExcelSpreadsheetinaListViewin.NET11282005034134AM/HowtoOepnandReadanExcelSpreadsheetinaListViewin.NET.aspx?ArticleID=45ca62cf-fb3e-4f0b-b9a4-031b641aae3c[/URL] Well what it does is pull a named range, sticks the data in an array, my software does it's thing, then puts the changed data back into … |
| | Good Evening, I currently have an issue regarding a query I wish to perform against a particular table in my database, any help would be much apprieciated Background: I am designing a website service which operates with the use of credits, if they pay a fee they are given a … |
| | I want to write a PL/SQL Stored Procedure. A Project is created in database. Please help me in applying the following logic in stored procedure. " Project start date and end date are stored in project_date table. Whenever the project start date and end date are amended from oracle forms … |
| | hi there! Can anyone help me on this... I am currently working in a webbased application using CF 4.5 and SQL Server 2000 as backend. Im having problems with Session variables. The users are complaining for being kicked out while editing few items from quotation detail screen. the timeout actually … |
 | [B]Hi all I am here again ,and this time i returned back and with my hand a problem in SQL server not in asp.net . The problem is the following : [list]I am in a project that contains a table of users[COLOR=Green](user_tbl)[/COLOR] and another table of groups[COLOR=Green](Group_tbl)[/COLOR] . and each …  |
| | hey all i need help i am developing web project with ms sql db. i want to know how i can insert a text in db after i changed its font or color or align, i have html editor in one of the web pages, ex: [B]xxxx[/B] the insert statement … |
The End.