1,694 Topics
| |
Hi I have a MYSQL DB hosted on a Win 2003 server on my LAN and a Mysql DB on a dedicated (linux) server at our ISP. I would like to dump a few tables to a .sql file and ftp it to the server and then import the .sql … | |
Hello all, nice to know this helpfull forum, I'm a totally newbie and I need advice, I want to import a CSV to a table in sql, but the problem is the CSV has very strange format. ================================== Telephone,=,'88213839 Name,=,John Doe Currency,=,USD Date,Information,Source,Total,,Balance '30/04,ATM 28/04 ,'0000,000000000500000.00,DB,1.171892966E7 '30/04,DEBIT 28/04 LAWSON,'0000,000000000092100.00,DB,1.162682966E7 '30/04,DEBIT … | |
| I am trying to insert and retrieve image from sql server into window phone. and the image type would be varbinary. I cant find example for it.. Mostly the related post is about retrieve from url or isolated image.. Any help? Thank you. |
Hi I have a real conumdrum here - I just can't expalin this behaviour!! A colleague has designed a view that contains the following : `CONVERT (nvarchar(4),YEAR(dbo.SYSFinancialYear.FinancialYearStartDate)) + N'/' + RIGHT ('00' + RTRIM(CONVERT (nvarchar(2), dbo.SYSAccountingPeriod.PeriodNumber)), 2) As YearPeriod` When you are in the design view, of the view and … | |
here is my sql data from my search.php page mysql_connect("localhost", "username", "password") or die( mysql_error() ); mysql_select_db("dbname") or die( mysql_error() ); mysql_query("SET NAMES utf8"); $find = strtoupper($find); $find = strip_tags($find); $find = trim ($find); mysql_query("SET NAMES utf8"); $data = mysql_query("SELECT * from database WHERE upper($field) LIKE'%$find%' ORDER BY Catalog ASC"); … | |
I am new to dealing with SQL Express DB tables. I have a Windows application that gives the user a textbox that is bound to a value in my dataset (ds) which reflects my SQL table (Specs) field. The user can change the numeric value of the textbox and I … | |
trying to build a database for user can upload images and stuff. i want to do so that 1-user can upload image 2-name image 3-discribe image 4-how many views that image have 5-how many fav image have 6-list all the messages(comments) 7-number of comments so i could need 9 fields? … | |
I am stuck on a problem, and can't seem to figure out why this isn't working, when I am pretty sure it should be... I am trying to get my code to delete users from the dropdown list after the admin hits the delete button within the page. The form's … | |
I have a datasource on my page, the select query of which creates a pivot table. The complexity is that the columns in the pivot are determined by records in another table (the users table). So I have to use a prepared statement to build and execute the pivot query, … | |
I can't update my database by using select .. i've tried searching for different solutions but those didn't helped me .. any ideas why this doesn't update my DB?? i need to update the row with such conditions: the query/queries i used $records = mysql_query("SELECT * FROM cot_cargovolume WHERE VoyageNo … | |
Hello everyone, im doing a small program where i have a stock table with my Items and the current stock status. How do i substract from that stock status when i insert a new order in my ordertable. My tables are: STOCK: Item_ID Stock status ORDER Item_FK: Qty So i … | |
For the purpose of synchronizing data in sql server, such as: **1. Synchronize data between servers and client 2. When loss of internet, the client can still work based on the data required to run on the client. 3. When have the internet connection, data from workstations to be synchronized … | |
halo guys, I having problem executing the SQL statement in the visual studio but when in the MySQL it work fine. Here are my code. Dim sql As String = "SELECT * FROM (SELECT @row:= @row + 1 AS rowNum, std.* FROM Student std ,(SELECT @row:= 0) r) AS t … | |
Hi all, i have a table for instance, systemid | phonenumber 1 62222222 1 92222222 1 64444444 2 91111111 3 63333333 3 63333333 i want my select query output to be systemid | phonenumber | phonenumber2 | phonenumber3 1 62222222 92222222 64444444 2 91111111 3 63333333 63333333 I tried to … | |
Hi, All, I have a data table that looks like this: USERNAME ICOUNT IAVERAGE DATE_LOGGED LAGX01 1245 1245 05-07-2012 LAGX02 2211 1422 05-07-2012 LAGX03 1698 1112 05-07-2012 LAGX04 4598 1555 05-07-2012 LAGX05 2589 3245 05-07-2012 LAGX06 3321 1155 05-07-2012 LAGX07 3698 3458 05-07-2012 LAGX08 2589 4587 05-07-2012 LAGX09 1598 1142 … | |
I have a problem trying to link my my datagrid view to my sql server stored procedure. The way it should work is that when I select an item in a list from my combo box it returns a set of rows on the datagrid view specific only to that … | |
Hi all! I am looking for some advice on how to best design C++ programs that read, write, and update data in MySQL databases. I have completed a system that successfully does this but I'm not sure if I designed it the right way to take advantage of OOP principles … | |
Hi I populate a drop down menu like this: <select name="mySelect"> <?php $result= mysql_query('SELECT DISTINCT Year FROM MonthlySales'); ?> <?php while($row= mysql_fetch_assoc($result)) { ?> <option value="<?php echo htmlspecialchars($row['Year']);?>"> <?php echo htmlspecialchars($row['Year']); ?> </option> <?php } ?> </select> Then build a HTML table like this: <?php while( $row = mysql_fetch_row($results) ) … | |
I currently have this login form in my python program with a submit button: <input type="text" class="input-small" placeholder="Email"> <input type="password" class="input-small" placeholder="Password"> and I have an sql database that has emails/logins/etc. How do I make it so the after pushing the submit button, the email/password is verified with the database … | |
I need help with the format for single qoutes. I am using dynamic sql in an SSRS for error trapping records inserted with single qoutes during bulk imports but I cannot seem to format the actual select statement properly. SQL Sever 2005 Dev edition. Any help is great. Declare @DB … | |
Hi folks! I got a little problem with my assignment. The idea is to create online bookstore. As far didn't have much troubles with the project, until now. Problem occures when I'm trying to update/delete an entry to mySql. if you take a look at line 93 - there is … | |
Hello, I'm new with Python and running into an error trying to print data I have retrieved from a database. The code works but there are characters being printed with it that are not displayed in the database...here is my current code: con = mysql.connect(host="silo.soic.indiana.edu", port=3306, user="XXXXXXX", passwd="XXXXXX", db="XXXXXXXXX") cursor … | |
Hello Friends, I m Developing an windows form application. i have a winform on which i have datagridview and i am saving the data to Sql Server database from datagridview directly . i m using the following code for connecting & saving data of datagridview to database using button click … | |
am total newbie to programming, apart from knowing SQL, the thing is i have been given a MYSQL database containing various information about kids diseases and a web interface written in php to create reports from the database that can be accessed via the interface. there are almost 25 different … | |
Hi, I am getting the following error and I cannot understand why. SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. Before i try and insert the data into the database I print it out and this is what i get: **09/04/2012 00:00:00** The code below is … | |
Dear All, I am using VB.NET 2010 and SQL Sever CE 3.5 database. I insert some data into my database (SDF file) and I can do any all manipulations with those data. But I cannot see those data in the data table using Data Source or Server Explorer in Visual … | |
Hi, I need to create windows services that will back up MS SQL database. Parameter should be time period when I want to backup database (for example every hours, every 2 hours etc). I haven't any experience with backing up database. Once I made WCF service. How can I do … | |
I have an SQL select statement that I cannot quite get working. Dim SelectStr As String = "SELECT * FROM Appointments WHERE Doctor = '" & ComboBox1.Text & "' AND AptDate = #" & DateTimePicker1.Text & "#" This works perfect ... however I have 2 more WHERE possibilities ... I … | |
Hello, I am working on a C# application where i have to store values of article in sql server as i have 3 products (stone, diamonds, jewellery). Now during the initial process when i enter the product details let say i have to store value for a diamonds i put … | |
Hi, On executing CROSS APPLY Clause using UDF: create function Reg(@pc int,@pp varchar(15)) Returns Table As Return select cr from crt where piod=@pc and cr=@pp Go select distinct a.cr from cdet AS a CROSS APPLY Reg(a.cr,a.piod) AS a where a.piod='208'** Am getting this following errors: Incorrect Syntax near '-'. Thanks. |
The End.