2,570 Topics
 | |
| | Hello,... i usually used win7 x32 bit and i use sql server 2008 r2 enterprice in it and there is no problem , but i change my windos and installed win7 x64 on my labtop after that i try install the same sql server which i used in this system … |
| | I've been doing some research about multilingual and recursive database design for few days. I found interesting the following article: http://www.gsdesign.ro/blog/multilanguage-database-design-approach/ and liked the 4th solution Coupled Translation Table Approach. But I'm seriously confused since I don't understand the case; I see there is only one column id on pages …  |
| | I am developing an sql query to use to grab information from a postgres db. The scenario is as follows: the database I am grabbing information is the backend postgres database of an application (Tableau). My objective is to pull all of the workbooks, views, and datasources (considered objects) that … |
 | i am having real issues trying to build a sql string Dim SelectQry = "SELECT * FROM TblSupplierQuotes where TenderNo='" & Me.txtTenderRef.Text & "' AND KMBPartNo=" & " " & Me.lbKMBPartNo.Text & " " in SQL the TenderNo is varchar(50) = L003141T75-2012JANTEN KMBPartNO is text = 442 019 115 1 …  |
| | I am doing system using window phone 7 and sql server as database. I am using below coding to get shopping cart list at listbox. public List<Order> FindOrder(string custemail, string orderstatus) { var findorder = from r in order.Orders where (r.CustEmail == custemail && r.OrderStatus == orderstatus ) select r; … |
| | hi i need to show the last post thumbnail only i had the code but im now looking for code to get image i need to place the image on the top <ul> <?php $recent = new WP_Query("cat=1&showposts=10"); while($recent->have_posts()) : $recent->the_post();?> <li><a href="<?php the_permalink() ?>" rel="bookmark"> <?php the_title(); ?> </a></li> … |
| | Hi all, I am updating the position og pages, which I get dynimacally from the DB. It is d possible via the backend, for the admin of the site, to decide which position a page should have, when updating or creating a new page for the site. I let the … |
| | Hi everyone, In a nutshell...I have developed a site in ASP.Net and VB.Net which allows a user to create an order and submit it to a SQL Server backend database. When the order is placed...an xml file is also produced, showing the items that have been ordered...which is then loaded … |
| | Good day to you all, am currently working on a windows application. I used sql compact edition for the database. But the first problem i got was that it kept giving me errors i copied and pasted to error code on google and I got an article that says I … |
| | Hi, I have a problem in making a query.I have two tables patient and encounter. Patient has one to many relation with the encounter table. The encounter table has a field encounter_date. I want to make a search query in which I enter the date ranges and the query fetches … |
| | Im having a issue with comparing dates below is the code. it shows all rows even dates that have passed todays date. The Date field is set as date in sql. <?php $con = mysql_connect("localhost","myusername","mypassword"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("mydatabase", $con); $todays_date = date("Y-m-d"); … |
| | I'm trying to make a search by different option say A, B . what i need is if user provide value of A only then it does the searching using parameter A only , if user provide A and B then it needs to do searching using condition A=value1 AND … |
| | I'm extending a website built in ASP.NET to display Spiceworks reports - basic SQL queries. The easist way (with my knowledge) is to connect to the Spiceworks db through both Management Studio and Visual Studio. I have therefore followed this '[how to](http://community.spiceworks.com/how_to/show/2271http://www.)' in this forum, plus a few others, to … |
| | I have looked through a few SQL hierarchy tutorials, but none of them made much sense for my application. Perhaps I am just not understanding them correctly. I'm writing a C# ASP.NET application and I would like to create a tree view hierarchy from SQL data. This is how the …  |
| | "UPDATE P SET Stock = T.Stock FROM prices P INNER JOIN #prices " + "T ON P.Avg = T.Avg AND P.Colour = T.Colour;" + " " + "INSERT INTO prices(Avg, Colour, Stock) SELECT T.Avg, T.Colour, T.Stock FROM #prices T " + "WHERE NOT EXISTS (SELECT 1 FROM prices P WHERE …  |
| | Hi, All, Sample Table Job_ID Job_Name Status 1 TEST00001 FOR KE 2 TEST00002 FOR KE 3 TEST00003 FOR KE 4 TEST00004 FOR KE 5 TEST00005 FOR KE I have sql query that will get a jobname where status is equal to 'FOR KE' and I have multiple users that will … |
| | Hi, Im trying to insert to a table in sql that is related to another by a foreign key. The first table has an ID, a suppliers id and a date; and the other table has an ID (that for some records should have the same id from the other … |
| | 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 … |
| | I have two tables namely student and subject joined by a table called student_subject. With the following structure student: +----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+----------------+ | student_ID | int(11) | NO | PRI | NULL | auto_increment | | studentCode | … |
| | Hi, I have a php file that contains the queries as strings. I have wrote the following query: SELECT message_no, sender, destination, time_received, type, reference_no, message FROM messages WHERE message LIKE '%:substring%'; :substring is then assigned a value from $substring. The query works when i run it directly in cmd …  |
| | 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 …  |
The End.