6,934 Topics
 | |
| | Hey guys I've got the following code drawn up. But it doesnt work has I wanted it to and can't figure out why. If the user doesn't exist or if that username has been disabled then the query should return -1 otherwise it returns 0. Now that doesn't happen. It … |
 | . Nice forums here, I've been browsing 1/2 the day! My name is Bill Burke, and I'm with a startup company... I've just put the finishing SEO touches to our website. I'd love to hear from anyone who can point me at good people to know re: SQL Server, and …  |
| | Hi All, I want to make a SQL parser in Java which will give the names of view ,column names in select clause,and table names in 3 different arrays. This is the SQL Query which is there in text file. create view NAME1 as select a.col1 as alpha, b.col2 as … |
| | Im having trouble trying to pass a parameter to a SQL query that I am trying to run on a DataTable, that Im using to Dynamically populate a treeview. Im not having any trouble filling the first nodes, but to fill the second nodes, I have to use a query … |
| | Hey guys I was curious to see how ADO.net and SQL server could rank against each other. I have read into it and from what I understand is that SQL server is a medium for retrieving data and ADO.net is for storing data. Am I right in believing this? Does …  |
| | Hi all, I m a newbie to sel server. I want to read transaction logs in SQL Server 2000 for doing some processing on them. I asked many persons reagrding this one told me that it can be doone by creating replication of database. so if anybody having any idea … |
| | |
| | Hi all, I'm struggling to write an SQL query. I'd like to search a database for either a person or an organisation. I have an HTML form on a homepage, and this returns two values: [LIST] [*]a search term [*]a search type, either 'person' or 'organisation' [/LIST] code: [code=php] <form … |
| | Hello Friends, Good day to you all I have been using Access as a base for all my vb projects. I am told SQL is more secure and can handle a wide range of data. I have therefore decided to give it a try, but I don't have any Idea … |
| | Dim strSql As String strSql = " set quoted_identifier off " strSql &= " declare @strSql varchar(150) " strSql &= " set @strSql = ""BackUp database SWAMC to disk = 'D:\SWAMC"" + Convert(varchar, getdate(), 112) + Replace(Convert(varchar, getdate(), 108), "":"", """") + "".dbb' with init,skip""" strSql &= " print @strSql" … |
 | I'm having a strange problem. I have an array of strings that I need to separate into separate data members and insert into a SQL database. It all works fine, except for where I convert a string to a decimal and insert that. It works if the decimal has no … |
| | Hey guys I was hoping someone could shed some light on some research I'm doing. Basically, I want to know if I can use PHP to read n number of cells from an excel file. Based on each cells color, I want that cell value to be written to a …  |
| | Hey All, I am trying to write a php script and would like to have an autosuggest text box with data from a mysql database. This would be for designating a town in a form. The sql query I would use would be. [CODE]<?php $connection = @mysql_connect($server,$dbusername,$dbpassword) or die(mysql_error()); $db … |
| | the code worked perfect on Friday and when I come back today and try.. the RAM alone works fine in the T-SQL but the Mfg, Make, GraphicsCard and GraphicsVersion do not work atall.. they dont give me any queries atall in the data grid view o/p.. why am i stuck …  |
| | Hi I have a small question. I'm building a website and I would like to make custom message strings that I can later put in a sql database. Is the following idea the correct way to go? File: SystemMessages.vb [CODE]Select Case EventID Case 100 msg = "New user" & username … |
| | Hi, i have a form in VB. iam using SQL Server as Back-end. And connection string and all works properly. the only one thing is i want to retrieve data from database into a combobox. i'am using this code.... [ dim i ] [ for i = 0 to Combo1.ListCount … |
| | Hi I'm looking for a piece of code that can turn a sql string into an array. Here is an example: [icode]sqlStr = "SELECT p.id FROM products p WHERE ((p.name = 'im a name' AND p.name2="another name") OR (p.name='always with')) [/icode] So that i in this array quickly could add …  |
| | Hi I'm about to write a short application but I have a problem: I need to get a recordset (or two) from 2 different SQL servers. I would prefer a single quarry but i don't know if it is possible. And if not, I will have rs_1 and rs_2. How … |
| | hi guys.. i got one big problem rite now..currently i'm handling new project using VB 6 and MS SQL Server as host server. Rite now i'm stuck at store/save data into the server. Previously, i'm using C#.Net and it success but then i'm not sure whether the code from .Net … |
| | Hey Everyone, I have got a jsp "1.jsp" which will insert records in various tables. I'm using sql:transaction tag to group the sql statements together to provide transactional behavior. Some of these sql statements will be used by multiple jsps. So I created a separate jsp "Common.jsp" which contains the … |
| | Hello all: I have been developing a web site using PHP and MySQL. I have generally had sucess but am stuck on this. i have a php page that builds and displays a list of products based on a query on the previous page. the list is generated by a … |
| | Hi, I have developed a complex database in MS Access 2007. The problem is that people from around the country will need to input data into the data base on a regular basis. With the data base being in our head office, I thought the easiest way it to make … |
| | Does anyone know how to change the look of the java files that are listed when you expand the java folder in the tree structure of the database? i have these numbers infront of the class file, but have no clue what they are, they are not there in toad(i … |
 | Hey, this could go one of two ways. I want a rich text editor for my website, the information typed into the text editor will be saved to an sql server database under either char or varchar format that supports up to 8000 characters per field. I want it to … |
| | the code worked perfect on Friday and when I come back today and try.. the RAM alone works fine in the T-SQL but the Mfg, Make, GraphicsCard and GraphicsVersion do not work atall.. they dont give me any queries atall in the data grid view o/p.. why am i stuck … |
| | The code below gives me "Warning: Wrong parameter count for mssql_bind() in" [CODE] $action="L"; $M_ExhibitionID=$_REQUEST[M_ExhibitionID]; $areaid=1; $LngCode="el"; $sproc=mssql_init( "sp_php" ); mssql_bind($sproc,"@action",$action,SQLCHAR,false,false); mssql_bind($sproc,"@M_ExhibitionID",$M_ExhibitionID,SQLINT4,false,false); mssql_bind($sproc,"@areaid",$areaid,SQLINT4,false,false); mssql_bind($sproc,"@lang",$LngCode,SQLVARCHAR,false,false); $GET_EXHIBITS=mssql_bind($sproc); [/CODE] what is my wrong? |
| | I've installed the plugin "WP Security Scan" on a fresh install of Wordpress 2.6 running on a Apache server at hostgator & the plugin says this about my table prefix. Your table prefix should not be wp_. Click here to change it. Change your database table prefix to mitigate zero-day … |
| | I want to connect to a remote SQL server database in C# and the connection string needs USER NAME and PASSWORD,(I think its they`re database`s) Any way How can I create usr and pass for a databaese? I tried it in users part of databse but it wants(user name,login name??,and … |
| | Can you please tell me what's wrong with this statement ? i get no errors but I get no o/p either! [QUOTE] Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click Dim con As OleDbConnection = New OleDb.OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=C:\Documents and Settings\bashkark\Desktop\Copy of USERS.mdb") If (ComboBox6.SelectedItem = 0.5) … |
| | Hi.. I m using vb6. plz tell me how can i access data in sql table by vb coding like.....eg. In sql table i hard code the 20 question i want every time when we click the next button on vb form then display question no-2 & IInd time i … |
| | Hello, I have a table with a field AFM (integer), I want to display all fields of the AFM column that have the same value eg. 1 row has 1111 2 row has 4567 3 row has 1111 4 row has 5678 5 row has 3456 6 row has 3456 … |
| | Hello everybody, i'm a newbie to MSSQL - so excuse the newbie question. i am creating a page wich is hosted like any other page on a web server, i need to somehow connect to a MSSQL server , wich is located on a normal computer and connected to the … |
| | i tried putting in actual values and it works..this code gives results of RAM > 0.500 and less than and equal to 2.000 but how do i make it parametrized ??????????????????? [QUOTE] Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click Dim con As OleDbConnection = New … |
| | Hi, [code] function openingBalance($accountNum) { $sql_OpenBal = " SELECT closing_balance FROM bank_balance WHERE bank_account.account_no = $accountNum "; [COLOR="Red"]$runSql = mysqli_query($mysqli, $sql_OpenBal);[/COLOR]... [/code] Red line generates an error. "Warning: mysqli_query() expects parameter 1 to be mysqli, null given". I call function [inlinecode]echo openingBalance (1500);[/inlinecode] How can i search $accountNum in SQL … |
| | Hi all! Ive created this code to read in data from several tables but i have a problem with SUM. With this code im trying to add together all the null values that have the most recent date but all the SUM commandi have does is multiply the number by … |
| | Hi Guys, I have a text file which looks like this 123456 Amanda Morris and I would like it to look like this "123456","Amanda","Morris" The file has about 2000 lines how would I go about inserting the quotes and the commas. I use textpad to open the textfile and I …  |
| | Hi, I am getting this error "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied." when trying to get some data from SQL Server 2000 database. SQL Server is installed on Windows Server 2003, and i am testing the application from WinXP sp2. Testing from other machines with same settings … |
| | Hi, I am getting this error "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied." when trying to get some data from SQL Server 2000 database. SQL Server is installed on Windows Server 2003, and i am testing the application from WinXP sp2. Testing from other machines with same settings … |
| | Hi, using VB 2008 Express, I have a button on a form which is to use a datareader to loop through all the records in a file. When I try to run it I get a message indicating it could not connect. I assume something is wrong with my connection … |
| | I want to select data from ranges like Column1 Column2 25000 10 50000 20 75000 30 I want records like upto 25000, I get 10 upto 50000, I get 20 upto or more than 75000, I get 30 Can anybody suggest me a simple query for that? Thanks in advance, |
| | I am new to both c#.net and sql server. I am working on a project in which I have to 2-3 users using their application and connecting to common database in lan. I decided to use c# as my programming language. when coming to database i m very confused. microsoft …  |
| | Hi, I m inserting Record in Access using VB6 SQL statement as follows [code]Dim str As String On Error GoTo solve str = "INSERT INTO [compinfo]([cID],[cname],[address],[add2],[city],[Postno],[mob],[phno],[faxno],[email],[workday],[offtime],[saldate],[duedate],[amount],[paytyp],[web],[type],[expdat],[charge]) values (" & "'" & txtcomid.Text & "'" & _ "," & "'" & txtcomnam.Text & "'" & "," & "'" & txtcomadd.Text & …  |
| | I want to get list of top 10 students (based on marks) in class.How can I write SQL query for it? |
| | Hi, I'm struggling to update my table with columns that are identified through variables. For example, I want to update Day3 using the hidden field "NewDay." Eventually, all of my days will be set using hidden field variable. Right now the trouble seems to be the statement [B][U]%s=%s[/U][/B]. Any suggests … |
| | i have 2 comboboxes filled with ram values..both are the same.. i need to choose 0.5 from combobox6 and 2 from combobox7. and when I hit the click button, I want the sql query to get executed. 1. how do i fill the comboboxes with the same values from the … |
| | Hello, I am currently having problems getting Coldfusion and SQL Server 2005 to connect on my home laptop. I have both installed correctly, I just cant seem to get the connection part down I keep getting this error from the Coldfusion Administrator. [I]Connection verification failed for data source: GTOTDsite java.sql.SQLException: … |
| | Folks: I am trying to get all NVIDIA users on the list and I am saying NVIDIA* in my SQL statement since there are different versions of NVIDIA.. if instead of NVIDIA* i said 'NVIDIA Quadro fx 4600' i get a list of queries.. but if I said 'NVIDIA*' i … |
| | hi: I have a db which has RAM field in it. I have set it as text because I need to have the GB or MB along with it. I had 5 modules in my project and this is my last one. i also have decimal values in RAM like … |
| | Sumbody please let me know bout this....  |
| | Hi Everybody, I have problem with unicode data in SQL server. I could not show data that fileds are nvarchar,nchar,ntext properly on front end. [code] $myServer ='servername\SQLEXPRESS,1433'; $myUser = 'odysseous'; $myPass = 'ody1'; $myDB = "eSQL"; // connection to the database $dbhandle = mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to … |
The End.