|
Hi,
I'm trying to create an album gallery, which works this way:
First, i have the album photos with description on each album under the photo, with a pager. ( that was done)
Second, when you click on a certain album, you see all photos related to this album only.
I am using ACCESS DB. i just cant figure it out how to connect those data correctly, and how clicking an album will take me to the photos related only to it.
I would appreciate any help or samples for such a thing.
Thanks,
Basil
|
|
|
|
|
That would depend on your schema.
|
|
|
|
|
Hi,
I have a Address field.I want to make a query that returns all records that their addresses contain all words of a address in any order.
Suppose 'John street , No 2' is the address, I want to return all addresses that contains 'John' , 'street', 'No' and '2' in any order.
How can I make this query?
Original string : My name is Mehrdad
Best wishes
|
|
|
|
|
Use and with like
SELECT *
FROM Somehwere
WHERE address1 LIKE '%John%'
AND address1 LIKE '%Street%'
AND address1 LIKE '%No%'
However this is not going to help where you have St instead of Street ,Rd instead of Road and many many more issues that arise from cleaning address data.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You can use SOUNDEX [^]
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
|
|
|
|
|
Hi Guys,
We are newly insurance based company that we are holding most insurance like
*Auto Insurance
*Health Insurance
*Life Insurance
And still we are developing on lot more insurance is there any other insurance quotes that are to be added, Please give us your suggestion about it………………………..
|
|
|
|
|
|
posting in non appropriate forums.
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
|
|
|
|
|
Insurance against insurers denying claims on spurious grounds based on arcane interpretations of small print.
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
The only valid measurement of code quality: WTFs/minute.
|
|
|
|
|
With ado and vb6 classic.
I have sql table with approx 4.500.000 records.
How to copy all sql records into the access table via vb6 code, and with fasted method?
|
|
|
|
|
Could you let me know your target version of MS Access database and do you have any plan to do this by SQL Server DTS services via VB?
Thanks
Md. Marufuzzaman
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
|
|
|
|
|
-access 2003.
-Vb6 classic
I cannot have permission Sql Server, but have only a redaing on the sql table.
If for you is a god way to use DTS in vb code this solution is welcome!
Yes if is possible make all wiyh vb6 classic.
Tks.
|
|
|
|
|
hi,
how can we write CURSOR in Pl/SQL.Plz send me the syntax of it.
Thanks
Richa
|
|
|
|
|
Go to Google, Bing or the search engine of your choice.
Type "pl/sql cursor".
Press Enter.
|
|
|
|
|
richa021 wrote: Plz send me the syntax of it.
You're looking for the Manual[^]?
I are Troll
|
|
|
|
|
Oh My God.
Please please please get a dba to do this for you.
Dave: But I don't wanna be a barbarian!
Fang: You did when you were ten!
Dave: Yes, but I thought it meant a librarian that also cuts hair.
|
|
|
|
|
I am using MS Sql 2005. In my database I have a table "Products" which has following structure and content
ProductName CategoryId AddedDate
Product1 1 04/12/2010
Product2 1 04/12/2010
Product3 2 05/12/2010
Product4 1 06/12/2010
I want to fetch top 2 records order by AddedDate . To do that I can use sql
Select top 2 * From Products Order By AddedDate
This will populate first two records. Both are in CategoryId "1". I want to Select records from distinct categories.
I requirment is to select records order by AddedDate with distinct CategoryId . I can do it with temporary tables. But is there any simple query to do that?
Thanks and regards,
Poppy
modified on Thursday, May 27, 2010 9:33 AM
|
|
|
|
|
SELECT DISTINCT TOP 2 <br />
<br />
p.CategoryId,<br />
(SELECT TOP 1 p2.AddDate<br />
FROM products p2 WHERE p2.CategoryId = p. CategoryId) AS adddate<br />
<br />
FROM<br />
products p<br />
ORDER BY p.CategoryId<br />
Hope this will help you.
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
modified on Thursday, May 27, 2010 10:45 AM
|
|
|
|
|
Please correct me if I am wrong. This will sort the results order by CategoryId not by AddedDate .
But I could learn something from your SQL. Thanks for your help.
Regards,
Poppy
|
|
|
|
|
Let's start out with a basic testscript that other posters can abuse to test on their machines;
DECLARE @Product TABLE (
[Name] NVARCHAR(250)
,[refCategory] BIGINT
,[Added] DATETIME DEFAULT GETDATE()
PRIMARY KEY ([Name])
)
INSERT INTO @Product
SELECT 'Product1', 1, '20101204' UNION
SELECT 'Product2', 1, '20101206' UNION
SELECT 'Product3', 2, '20101205' UNION
SELECT 'Product4', 1, '20101204' UNION
SELECT 'Product5', 1, '20101209' UNION
SELECT 'Product6', 2, '20101206' UNION
SELECT 'Product7', 2, '20101204' UNION
SELECT 'Service1', 3, '20100101' The testset is somewhat larger to make it somewhat easier to interpret what I'm looking at.
popchecker wrote: I want to Select records from distinct categories. I requirment is to select records order by AddedDate with distinct CategoryId.
If I understand correctly, then you want to group the data by category, sort within that group on the date, and take the top 2 records from each group?
Sql Server 2005 supports "Common Table Expressions", which you could use as an alternative to a temporary table, like this;
SELECT [Name], [refCategory], [Added]
FROM(
SELECT [refCategory],
[Added],
[Name],
row_number() OVER (
PARTITION BY [refCategory]
ORDER BY [Added] ASC
) AS [catGroup]
FROM @Product
GROUP BY [refCategory], [Added], [Name]
) AS ProductCTE
WHERE [catGroup] <= 2
ORDER BY [refCategory] ASC, [Added] ASC
I are Troll
|
|
|
|
|
Thanks for the test script.
SELECT p.refCategory, t.Name, t.Added
FROM
(SELECT DISTINCT refCategory
FROM @Product) p
CROSS APPLY
(SELECT TOP 1 Name, Added
FROM @Product
WHERE refCategory = p.refCategory
ORDER BY Added ASC) t
|
|
|
|
|
Hi russell ,
5 from my side.
This will run perfectly...
Reasons are not Important but Results are Important.
http://www.sql4professional.blogspot.com
Swati Tripathi
modified on Friday, May 28, 2010 1:46 AM
|
|
|
|
|
Learn something every day, I'd have gone with the rownumber/partition solution. I've never used cross apply!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Cool! Thanks for updating it
I are Troll
|
|
|
|
|
Hello,
I have written an application that needs to connect to a database that I have hosted online. I can connect perfectly using the MS SQL Management Studio, but when I try to connect using my own code, the connection fails and gives the following reason:
"The user is not associated with a trusted SQL Server connection"
I am using the same login information that I am using with the management studio. This is how the connection string is coded:
SqlConnection Conn = new SqlConnection("server=" + txtServerName.Text + ";user id=" + txtUID.Text + ";password=" + txtPWD.Text + ";Trusted_Connection=True");
I am able to connect perfectly on Localhost using a clone of this exact database.
Can you explain or correct this problem? Thank you, Pat
|
|
|
|