2,570 Topics
 | |
| | Hi I'm trying to Select Data from an Access DB. I wrote this query to Select all Invoices that were Invoiced between two dates. I get the following error Syntax error (missing operator) in query expression 'Invoiced >=02/01/13 AND <= 05/01/13' "SELECT * FROM invoiced_filter WHERE Invoiced > " & … |
| | My case is Input is "abdknmgbm". BUT The record in database that i want to query out is "abkdnmgmb" The input and database record is quite similar. String length is same, only some arrangement of character are not same. In the above case, dk and kd ; bm and mb. …  |
| | hello! I got this error when I tried to connect to my db in sql server. > Unable to add data connection. Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version = 10.0.0.0, Culture = neutral, PublicKeyToken = 8945dcd8080cc91' or one of its dependencies. The system cannot find the file specified. … |
| | Hi I have an insert statement in my VB code that updates about 20 fields in sql. I pass through todays date and a set of values. This occurs on a button click event. My problem is if the button is clicked more than once the data is duplicated in … |
| | This code is suppose to take the images array and use its value for the name of the table. When I echo the images varaible I get kids, which is what $images[3] is set to equal, but when I put it in the query the $result2 is echoed as resource … |
 | Explore Python's sqlite3 database module, create, write and read a database file. |
| | I am working with sql server using ADO provider. My code uses recordsets and commands to run quries and I fail to understand a basic issue - connections. In my code, they set a connection string (which is being built in the code, not taken from other ADO element) to …  |
 | Hello people, I am new to crystal report. Normally, I would insert columns in the crystal report viewer and then look at the records at the Main Report Viewer. All the rows/records in that particular columns of that table will be shown. And then I found out about this SQL … |
 | hi people.. I was wondering if u experts could help me with this. I have attached a screenshot of my form. This is an invoice system.. I have customers table for customer profiles.. I have Products table I have manufactures table I want to save all invoices so that these …  |
 | Hello im braking my head with a problem, im using netbeans building a web application using java, jsp that handel a database with hebrew fields. String cityTable = "CREATE TABLE IF NOT EXISTS hebrew_test.table (" +"id int(11) NOT NULL AUTO_INCREMENT," +"en varchar(30) NOT NULL," +"he varchar(30) COLLATE utf8_bin NOT NULL," … |
| | Okay what I am trying to do might be hard to understand, but I will give it my best shot. I have created a script which selects data randomly from a table called albumname in a databse called characters. This array is then used again in a mysql_query to select … |
| | I am trying to make an array which has a random selection of database results in it. This is what I have so far, <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("photos", $con); $query="SELECT album FROM albumname ORDER BY RAND() LIMIT 9"; $result= … |
| | Hi Guys....i am facing a small issue with an SQL statement here. Will you be able to help me out? I wanted to grab the page title, page author's name which is in the users table, the no of comments, and the page publish date. "SELECT * FROM pages INNER … |
| | I don't quite understand how to make a Procedure as most of my processing takes place in my scripts. I have a set of 3 Queries that are almost identical that I would like to combine them to return a result set. The queries are: SELECT Date, Location, Sum(SubTotal) FROM …  |
| | # how to validate sql statement 1. hi, is there anyone who can help me in my problem? sql = "SELECT UserID, Status FROM tbl_User WHERE UserID = '" & strUserID & "' and Password = '" & strUserPW & "' " i want to validate my sql statement using … |
| | Hello Daniweb Univere, I am looking for a good program to use to store several dozen text documents, make them searchable, and ideally, allow me to link to specific lines of the document. I imagine there are programs like this, I have just been unable to find them. Any suggestions … |
 | Hi, I have done my vb.net application and ready for deployment, my database is located somewhere in my drive c:, i used this code to get connection string from app.config Public Sub main() constr = System.Configuration.ConfigurationManager.ConnectionStrings("WindowsApplication7.My.MySettings.nameConnectionString").ToString Con = New SqlConnection(constr) Try Con.Open() 'MsgBox("Server Connection is Open ! ") 'frmMain.Connection.Text = …  |
| | I have a table with these columns: stockNumber, storageID, lastPutDate, qtyOnHand Each stockNumber can have multiple storageID's but only one lastPutDate and qtyOnHand for each storageID. Here is an example of what the rows might look like: stockNumber storageID lastPutDate qtyOnHand ----------- --------- ----------- --------- 100505 R010101 2012-10-18 150.00 100505 … |
 | Hi, This has been troubling me for the last hour and I cant think of a way around it. My SQL table looks like this: **Name, Cost** Matt, $5.00 Carl, $4.50 Tom, $6.00 Tom, $7.50 I need to make a query so that it puts anything with the same **Name** … |
| | How can I specify the Server of my database when I make my project executable I have this module I call everytime i modify my database Public Sub main() constr = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:"database file".mdf;" & _ "Integrated Security=True;Connect Timeout=30;User Instance=True" Con = New SqlConnection(constr) Try Con.Open() 'MsgBox("Server Connection is Open … |
 | Hi Does anyone here can show me how to make an application that is like an odbc wizard that could register a sql server type connection? I have found one on the net through searching but it does not accept the UID and password of the sql server. I also … |
| | |
 | i have tblScrutiny , COLUMNS: teamid name userid now confusion is that every team has many members, so how how would i mention them, like e.g i mention 1 member in teamid =1 , then in next row the teamid changes (identity=ON) , so how to mention 2nd member ? |
 | hi i have a table in which m storing some data like in the following: table => uploads string_file and file_name and m trying to select the string_file. the data for this column is like in the following; ab323892,416a75f4, e732ced3 and blah blah. and following is the query that m … |
| | hi i have deattach the database from the SSMS. and a new database i have created in visual studio 2010. and i want to attach it to the SSMS. but my attach process is failed. any body is there to help me to attach the database into SSMS... |
| | Hi I have the two queries below, they run far too slow around the 20 second mark , I have around 18,000 rows on the videos table and 2,000 on the other. Any thoughts? Thanks $query="SELECT videos.VIDEOID, videos.title, (select video_thumb_chosen.thumb from video_thumb_chosen where video_thumb_chosen.videoid = videos.VIDEOID group by video_thumb_chosen.thumb order … |
 | I have a sproc that pulls six years of records for a report. The person who set it up years ago set it up using statically defined years which ended in 2009. I am rewriting this sproc to pull the current year and five years previous. In the process of …  |
| | I am building a new website and migrating all users off a CMS (ExpressionEngine) that uses MYSql. I have all of the users imported into a MS SQL staging table (except passwords). I am trying to create members in asp.net membership by looping through the users in the staging table. … |
| | hi i have a table like this for attendence: table name attendence. id std_rolNum std_fname date std_bkfast std_lunch std_dinner i want to make search on the base of `date`, `std_rolnum`, `std_lunch`, `std_bkfast` and `std_dinner`. so that if on the same date if student have already taken breakfast, lunch or dinner … |
| | hi m getting the following exception: `System.Data.SqlClient.SqlException: Incorrect syntax near '4'.` the following is what i was trying: public void hostel_cpacity(ManageHostelRoomsBE hmr) { string str; string conString = System.Configuration.ConfigurationManager.ConnectionStrings["Hosteluog"].ConnectionString; SqlConnection con = new SqlConnection(conString); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; con.Open(); DataTable dt = new DataTable(); DataTable dt1 … |
The End.