Error: no property 'select' for type 'ddbc.core.Statement'

Vadim Lopatin via Digitalmars-d-learn digitalmars-d-learn at puremagic.com
Wed Sep 21 04:49:49 PDT 2016


On Sunday, 31 January 2016 at 09:15:04 UTC, Suliman wrote:
> I hope that here I will get answer faster then on 
> https://github.com/buggins/ddbc/issues/18
>
> I am using ddbc diver for access to mysql. I need to return 
> result of request to struct. My code is next:
>
> import std.stdio;
> import ddbc.all;
> import std.stdio;
> import std.conv;
>
> void main()
> {
> 	string[string] params;
> 	MySQLDriver driver = new MySQLDriver();
>     string url = MySQLDriver.generateUrl("localhost", 3306, 
> "test");
>     params = MySQLDriver.setUserAndPassword("root", "pass");
> 	DataSource ds = new ConnectionPoolDataSourceImpl(driver, url, 
> params);
>
> 	// creating Connection
> 	auto conn = ds.getConnection();
> 	scope(exit) conn.close();
>
> 	// creating Statement
> 	auto stmt = conn.createStatement();
> 	scope(exit) stmt.close();
> 	
> 	string sql = "select * from test.imgs";
> 	auto images = stmt.executeQuery(sql);
> 	
> 	struct myData
> 	{
> 	 int id;
> 	 string date;
> 	}
> 	
> 	foreach(ref e; stmt.select!myData)
> 	{
> 	
> 	}
> 	
> 	/* this code is work
> 	while(images.next())
> 	{
> 		string mydata = images.getString(4);
> 		writeln(mydata);
> 		readln;
> 	}
> 	*/
> 	
> }
>
> I am getting error: Error: no property 'select' for type 
> 'ddbc.core.Statement'
>
> What I am doing wrong?

You forgot to add "import ddbc.pods;"
Sorry for late answer :)
Closing issue.




More information about the Digitalmars-d-learn mailing list