1,694 Topics
|
|
Hi, I need to exclude any rows where the ASX_Prices.Date is a weekend. The date format is yyyy/mm/dd 2013/03/17. Ideally I would like to add another WHERE clause. WHERE ASX_Prices.Date !=weekend date????? $sql="SELECT Distinct ASX_Prices.ASX_Code, ASX_Prices.ASX_Price, ASX_Prices.Date, Company_Information.Company_Name FROM ASX_Prices, Company_Information WHERE ASX_Prices.ASX_Code = Company_Information.ASX_Code AND DateDiff(now(), ASX_Prices.Date)<=7 ORDER BY … |
|
I need this program to record bugs into a MYSQL database. I need to create the database if it is not found. I have my html set up. I am posting pictures below of what I have, and what functionality I need the program to have. I have the html … |
|
Hello guys i have a question i have these codes Imports System.Data Imports System.Data.SqlClient Module Connect Public Conn As SqlConnection Public Function GetConnect() Conn = New SqlConnection("Server = SQL Server;" & "initial Catalog = BloodBank;" & " Trusted_Connection=yes") Return Conn End Function End Module Public Class BloodDonor Private Sub TextBox5_TextChanged(ByVal … |
|
**have used the following code for displaying names of my sql db tables in combobox...now i want dat when i click on any of these table names from combo box..my dgv populates with that table's contents...i have gor three tables in my db..lol,datejoin and tble ** private void Form1_Load(object sender, … |
|
How to generate Dynamic where condition for single stored procedure and pass from code behind asp.net.... |
|
How to Get Difference between frommonth with fromyear compared to tomonth with toyear.... For instance one has work experience with frommonth March and fromyear 2006 and tomonth June and fromyear 2007 duration should be 1 year and 3 months...Also there would be multiple work experience with various durations as mentioned... … |
|
SELECT * FROM `users` WHERE `birth_date` between '%-02-02' AND '%-05-06' |
|
Hey guys im populating a combo box from my database i was just wondering how do i prevent the combo box from displaying different instances of the same value. e.g three B&Bs all from ennis. ennis is in the combobox but its displayed three times. how do i stop this … |
|
Hi guys, I'm hoping you can help me find a more elegant solution to my query inside a foreach loop. Here is the loop in question: foreach (DataRow row in dt_blah.Rows) { SqlCommand sc = con.CreateCommand(); sc.CommandType = CommandType.Text; sc.CommandText = "select blah blah blah .. where S = @s1 … |
|
I have the following code which is in a class called customerModel. How do I call this method to another method inside another class called customerController? I am abit new to this and have been trying for ages but have had no luck. Please help thank you. public class customerModel{ … |
|
My database with the following table: ITDetail Table: [Click Here](http://i.imgur.com/WcwRI.jpg) InvTrans Table: [Click Here](http://i.imgur.com/hPnlz.jpg) Currency Table: [Click Here](http://i.imgur.com/YUNxC.jpg) Database Relationship: [Click Here](http://i.imgur.com/CTCdo.jpg) I need to build a report with the time parameter (use the procedure; [Click Here](http://i.imgur.com/PwVYX.jpg)) with the following requirements: 1. MaterialID, Art, Color, Width is taken from the … |
|
UPDATE members a INNER JOIN members b on a.Recommended_By = b.ID set a.Node = CONCAT_WS('(',b.ID,')',b.Node) this statement to update node column from same table, but the problem is i have to execute many times to get the correct: example : ID Recommended_by Node 1 2 1 1 3 2 2 … |
|
Remove the last word while using left in sql query...I weant to avoid broken words while doing so... My query as follows: select top 2 tempJobTitle.id,tempJobTitle.JobRefId,tempJobTitle.JobTitle,LEFT (jobmaster.JobDescription2, 330)+'....' as JobDescription,jobmaster.PostedDate from tempJobTitle inner join jobmaster on jobmaster.JobRefId=tempJobTitle.JobRefId where tempJobTitle.Status='Approved' and jobmaster.ClosingDate >= '2013-03-01' order by tempJobTitle.DateofEntry desc |
|
Good morning Guys, I've got this code currently running: private void button1_Click(object sender, EventArgs e) { SqlDataSourceEnumerator sdse = SqlDataSourceEnumerator.Instance; DataTable table = sdse.GetDataSources(); foreach (DataRow row in table.Rows) { instanceCombobox.Items.Add(row["ServerName"].ToString() + "\\" + row["InstanceName"].ToString()); } Which gives me the Instance and Name of the SQL Server over the Network. … |
|
Hi, I have a problem with a code harness given to me by my tutor. Every time i enter values into a form, I get the following message: > Warning: mssql_query(): message: Invalid column name 'N56DSRT'. (severity 16) in /web/users/l1099341/SDD/insertCarController.php on line 27 Warning: mssql_query(): General SQL Server error: Check … |
|
**I am building a hospital managment system as a practice in visual basic. I am having some problem I want to write or read data from particular row or column with visual basics How do I o it? Thanks in Advance -Hassaan bin Jalil** |
|
Good day, I am having trouble with the computation in SQL. i want to subtract the intStock and the intTotal_OutBound_items to just to get the items available. here is my SP.. INSERT INTO CO09_Report ( intMaterial ,txtDescription ,txtMaterial_Type ,txtATP_check ,intDelivering_Plant ,intOrder_Quantity ,isHeld_by_Finance ,isRejected_OOS ,isRejected_Others ,intOpen_Order_Quantity ,intOrder_Quantity_NKA ,intOrder_Quantity_RKA ,intOrder_Quantity_Others ,intStock ,intDSD_Delivery … |
|
Hi, I'm using this SQL statement to retrieve Value and Date which will then be plotted on a graph: SELECT DISTINCT assets.SEDOL,assets.Quantity,stock_names.value,stock_names.Fileid,date_header.dateid FROM assets,stock_names,date_header WHERE assets.Client_ref = '$clientref' AND stock_names.SEDOL = assets.SEDOL AND date_header.fileid = stock_names.fileid I'm also selecting Quantity. Instead of having to multiply out the arrays, how can … |
|
Hi All, i am not sure if this is the right forum, but i couldnt find a SQL section. I am writing an application to log data from our PLC system to a SQL database. I would like to write a record every second. I have it all working fine, … |
|
Hi I am trying to make a bike shop for my project and i need to pull out a product details with image from sql databse. I have made a table with products and i have stored the images url but i have no idea how to pull it out … |
|
How would it be possible using T-SQL to find the raw amount of time that has passed between when the job started and when the job ended? i have used this function datediff(ss,grn_date,GETDATE()) . this function gets the jobs done how ever if the diffrence btw the dates is huge … |
|
I'm using this PDO query to fetch all the data I need from Value and dateid: $pdo = new PDO('mysql:host=localhost;dbname=contisec_portal', 'root', ''); $date = date("o-m-d"); $stmt = $pdo->query("SELECT stock_names.Value,stock_names.Fileid,date_header.dateid FROM stock_names,date_header WHERE SEDOL = '$stocksel' AND date_header.fileid = stock_names.FileID"); Does anybody know how I can sort the two columns into … |
|
how i can make the relation ship in MS SQL ? |
|
Hello guys, I'm in need of some thinking help. I want to build an auto-complete text input to find cars, but I want it to search for Car Models and Car Manufactor too. In example, if the user type 'For', the suggestions would be 'Ford - Car 1' 'Ford - … |
|
A lot of questions in the VB.NET forum are database related. Most of the code that gets posted result in one or more comments like "use parameterized queries to avoid SQL injection attacks". I won't describe the nature of a SQL injection because it is easily looked up via google. … |
|
Hi guys, This is my first time using SQL. So, go easy on me :) I'm executing these queries on some websites online where there is an already made database with Country name,Area,Population,etc What I would like to do is, to get the names of all the countries in Asia … |
|
Hello all, I'm fairly new to using PHP, and for my assignment I've coded it all but I'm trying to go the extra step, and code something that if the item amount = 0 it doesn't print it out on the order form The items are $LAPTOP $MONITOR $KEYBOARD $PRINTER … |
|
Hello everyone, As a freelance i am working on my own project name myOnlineDesk. I want to make a module in admin section where i can create a database backup file and save to the system. The thing that i want is ".SQL" file. When i click on a Backup … |
|
I'm planning to develop a system that can connect through online sql database and a website connected on the same sql database.. Can anyone help me.. Please response.. |
The End.