|
Hi!
I'm using Sqlite. I'm calling Sqlite from C++.
|
|
|
|
|
Try:
SQLdb.Query("INSERT INTO Current(TeamID) values(' + countryId + ')");
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
Now + countryId + is store in the table.
|
|
|
|
|
Oops - sorry, should have been:
SQLdb.Query("INSERT INTO Current(TeamID) values(" + countryId + ")");
Couldn't you have figured that out on your own?
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
Sorry! I'm a C++ Programmer. I'm new to SQL. That's why I'm troubling you again and again.
This Query is also not working. C++ shows error:
C2110:Can not add two pointers.
modified on Friday, July 30, 2010 7:23 AM
|
|
|
|
|
That's as close as I can get you. I haven't used C++ for years but I'm pretty sure you could create a string object with the id inserted and pass that to the query. You must know how to do that, surely. printf or sprintf , if I recall.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
T.RATHA KRISHNAN wrote: Sorry! I'm a C++ Programmer. I'm new to SQL
Still, you cant destinguish between a string literal and a variable?
|
|
|
|
|
I suggest you tell your boss to hire an SQL specialist.
|
|
|
|
|
below is the stored procedure I’m having problems with. Its purpose is to filter the results within a result set returned by the spGetTicketList stored procedure, which works as expected.
If I remove the entire WHERE cluse section from the stored procedure I get 458545 rows returned, likewise if I include the Ticket Number range filters.
If I then add the Date range filter I get 446726 rows returned and if I include all the range filters I get 415179 rows returned. I am not providing any values for the parameters, other than the default values.
With all the filters in place there is 43,366 rows missing.
Any ideas?
ALTER PROCEDURE [dbo].[spFilterTicketList]
(
@LowTicketNumber VarChar(MAX) = '',
@HighTicketNumber VarChar(MAX) = 'zzzzzzzzzzzzzzzzzzzzz',
@LowDate DateTime = null,
@HighDate DateTime = null,
@AccountNumber varchar(MAX) = '%',
@AcccountName varchar(MAX) = '%',
@ShortName varchar(MAX) = '%',
@StoreId varchar(MAX) = '%',
@RoundId varchar(MAX) = '%'
)
AS
BEGIN
DECLARE @t1 as Table
(
Id bigint,
[Ticket Number] varchar(50),
[Account Number] varchar(50),
[Account Name] varchar(120),
[Short Name] varchar(50),
[Store Id] varchar(50),
[Date] DateTime,
[Round Id] varchar(50),
Source tinyint
);
INSERT @t1 EXEC spGetTicketList;
IF(@LowDate IS NULL)
BEGIN
SET @LowDate = CAST('1753-01-01 00:00:00.000' As DATE);
END
IF(@HighDate IS NULL)
BEGIN
SET @HighDate = CAST('9999-12-31 23:59:59.997' As DATE);
END
SELECT Id,
ISNULL([Ticket Number], '') AS [Ticket Number] ,
ISNULL([Account Number] , ' ') AS [Account Number],
ISNULL([Account Name] , ' ') AS [Account Name],
ISNULL([Short Name] , ' ') AS [Short Name],
ISNULL([Store Id] , ' ') AS [Store Id],
CAST(ISNULL([Date], CAST('1753-01-01 00:00:00.000' As DateTime)) As DateTime) AS [Date],
ISNULL([Round Id] , ' ') AS [Round Id],
[Source]
FROM @t1
WHERE ([Ticket Number] >= @LowTicketNumber)
AND ([Ticket Number] <= @HighTicketNumber)
AND (CAST([Date] AS DateTime) >= @LowDate)
AND (CAST([Date] AS DateTime) <= @HighDate)
AND ([Account Number] LIKE @AccountNumber)
AND ([Account Name] LIKE @AcccountName)
AND ([Short Name] LIKE @ShortName)
AND ([Store Id] LIKE @StoreId)
AND ([Round Id] LIKE @RoundId)
ORDER BY [Date] ASC ;
END
Steve Jowett
-------------------------
Real Programmers don't need comments -- the code is obvious.
|
|
|
|
|
Hi,
i have the table lab_inestigations which has created_by, processed_by and closed_by and all three columns are integer holding a user id (systm_user_id) from a table sysem_users but of course each created_by, processed_by and closed_by will have different systm_user_id value.. How can I make such sql statement to rertive the system_user_name for all three columns from system_users?
Thanks,
Jassim
|
|
|
|
|
You need to make 3 joins to the user table, one for each of your user fields in lab_inestigations , something like
SELECT *
FROM lab_inestigations I
INNER JOIN sysem_users S1 ON SI.UserID = I.CreatedBy
INNER JOIN sysem_users S2 ON S2.UserID = I.ProcessedBy
INNER JOIN sysem_users S3 ON S3.UserID = I.ClosedBy
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I Have Table with columns as 1,2,3,4,5
I need to write query like
SELECT * FROM Table where columnName = 2. How can I specify column header in where clause
|
|
|
|
|
Hope this will help you
SELECT *<br />
FROM information_schema.columns<br />
WHERE COLUMN_NAME='YourColumnName'
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
It gives column details but not data for that column in specified table.
|
|
|
|
|
You don't specify the column in the where clause, you do it in the select clause as:
SELECT <COLUMNNAME>
FROM <TABLE>;
"When did ignorance become a point of view" - Dilbert
|
|
|
|
|
Forgot to say, in SQLServer you can put squarebrackets [] around stupid columnnames as a temporary fix.
"When did ignorance become a point of view" - Dilbert
|
|
|
|
|
Andersson, did u understand what I meant. I have Table like
Srno col1 col2 col3
1 aaaa bbb vvv
2 hjgj yui jhk
3 hkjdf hgjk jkjlk
I need to get data for specified column.
suppose i sent parameter
col2 then bbb,yui,hgjk
col3 then vvv,jhk,jkjlk
|
|
|
|
|
Have you tried SELECT COL2 FROM TABLE ?
You would get the content from that column like:
COL2
bbb
yui
hgjk
If this is not what you need, then you need to elaborate more.
"When did ignorance become a point of view" - Dilbert
|
|
|
|
|
Andersson 'SELECT COL2 FROM TABLE' this is basic select query if i know the column name. In my case I don't the column names in table.
so if table have column name with col2 then return result otherwise nothing.
|
|
|
|
|
Then you need to use dynamic sql as suggested by Estys.
"When did ignorance become a point of view" - Dilbert
|
|
|
|
|
|
Thanks Estys but its dynamic query right. Is there any way to use built in key words like column_Name in where clause
|
|
|
|
|
a WHERE clause determines which rows are being returned.
|
|
|
|
|
Sorry... I couldn't get u?
|
|
|
|
|
The WHERE clause isn't used to specify which columns you want to retrieve, but to limit the amount of records returned. It's a filter
What you want to do can only be done using dynamic SQL. You'll have to know what columns you want to retrieve, or use a wildcard (*) to retrieve them all.
I are Troll
|
|
|
|