If I select a db db1 with mysql_select_db() is it possible to access another db db2 in a query? I am looking for something like SELECT * FROMdb2.sometableWHERE 1
Hi,
I have a database that has primary key fields in its tables, but the FK mappings are not in place.
What are the ramifications of this when using linq-to-sql?
I have a folder with more than 2000 files and I need to index their file names on a database(MySQL) using Java, but how could I do this?
PS: The MySQL connection part I already know.
Does anyone know of a Reporting Engine for WPF? Most of the ones I could find are still for WinForms.
I'm happy enough using a WinForms one in WPF with a WinForms host so long as the tool has a UserControl that can be embedded in a window.
Also, I'm not using a database and all my data is in XML so the Reporting Engine needs to be able to handle that.
Any suggestions?
Hello,
I am going to develop a new website with asp.net 3.5 and LinqToSQL. For maintainability purposes, how can I modify a Linq class if an attribute is added to a table in the database ?
Thank you.
Hello,,
I have 3 entities that are not related to each other and I want to get all these entities in one trip to the database how can I do this ??
Thanks
Yo.
I'm trying to find a way to insert a whole database structure into MySQL with PHP. Now, my main question is if there's any way to do this beyond just inserting the whole bloody thing line by line?
Thanks.
I had applied the following code as said by you :
byte[] b = YourByteArrayFromDb;
File.WriteAllBytes(MyFilePath, b);
But I am receiving an exception "Access to the path is denied". How do I solve this using ASP.Net with C# ? And is there any format to set the path as string ?
Hello,
I'm running into a scenario where at random times I am getting "Access Denied" when executing javascript. It is not repeatable and occurs in random places of my application. There is not indication of what is causing it in the logs and I'm really at a loss on this. It seems to be UI problem only. However, there is no reason it should appear as I do not have any such permission checking to could be getting triggered.
Thanks in advance
I got a bunch of Pictures and Videos in a directory and needs to be displayed in the WPF application, I am thinking about displaying the Win7 Large Icon itself as the preview image. Because that will save me the work of grabbing an appropriate frame from the video file since Windows is doing that job pretty well already.
Any code snippet to access this Shell Icon image data?
I get multiple text files daily to update my database from my client side and i am not a DBA expert. Everyday i do update it manually. Is there any method using which i can ease my task. I think there is a way to automate it but exactly i don't know what to do.
I am using <%# MyFormatClass(Eval("fieldname")) % to display data in a grid view on my page. MyFormatClass works fine, but now I want to move it to a central location that can be used by many pages. When I try to access the class <%# Utils.MyFormatClass(Eval("fieldname")) % it no longer works. Is this something we are allowed to do?
I have an element for my side bar navigation being called from my layouts/default.ctp file, I need to access some data about categories from my Photos controller. How would I go about doing this?
Hey,
I am trying to find some source code on how to access and store variables from a database to my program via obj-c(iPhone). I have look for many hours now and no one has provided a sure fire way on how to go about this. If you have any advice or recommendations please post some source code or a link to it.
Thanks for the help.
Currently im working on a research paper about sql-injection with RFID tags and Im curious if it is possible to create a database trigger with an sql injections if stacked queries are disabled. If stacked queries are enabled, of course it is easy (assuming you know the table layout), but what if they're disabled for security reasons.
I pull a data from other website by using curl but how to store in my local database.
$url = 'http://sample.com/'; $ch =
curl_init(); curl_setopt($ch,
CURLOPT_URL, $url); curl_setopt ($ch,
CURLOPT_RETURNTRANSFER, 1); $data =
curl_exec ($ch); curl_close ($ch);
echo $data;
I just want post some categories and sample of data.
I am looking here to create a Facebook App on Hadeeth.
My first question is for muslim programmers here because other might not be having clue. Is it possible to find hadeeth in csv / sql (at least the popular ones like bukhari, muslim, tirmidhi)
otherwise
Do we have any tools or is it possible to convert CHM files into CSV or SQL ? This way I can create my own database.
Thanks for the help as always :)
I have a WCF service which I would like to access using ASP.NET. The binding used in the WCF service is basicHttpBinding. How may I do it? Any examples will be really appreciated.
We are using Mysql.exe to restore database by the following query
string cmd ="-h" + ViewState["host"].ToString() + " " + "-u" +
ViewState["user"].ToString() + " " + "-p" + ViewState["password"].ToString() +
" " + ViewState["dbName"].ToString() + "<" + " " +
Server.MapPath("BackupFiles/") + path;
The same query is executing in MySql command prompt but we are not able to restore using the above query in VisualStudio .Net, we have tried MysqlImport.exe to do the restore but it was no use. we are newbie to MySql if any help would be appreciated.
I'm setting up an online ordering system but I'm in Australia and for international customers I'd like to show prices in US dollars or Euros so they don't have to make the mental effort to convert from Australian dollars.
Does anyone know if I can pull up to date exchange rates off the net somewhere in an easy-to-parse format I can access from my PHP script ?
UPDATE: I have now written a PHP class which implements this. You can get the code from my website.
Hai ,
How to set Key and Value in the client registry using javascript. I Just want to keep the user profiles in the registry. When a user visit the page from a particular system , automatically connect to the system preferred database.For that I want to keep the connection string in the windows registry.
Please tell with code snippets , i am new in javascript.
I am trying to read a html file which is a plain page with nothing but and tags in it. I'm using a function to return what is between each tag . . I can echo this to the page fine, but when I try to insert into the database the information is scattered. Any recommendations?
hye all,
i have built a SQLite database and wanna to add into iphone app. already i have add it resource-add-x.sqlite and also add libsqlite3.0.dylib.framework but i don't know what is the showing code. I wanna to show the data in the db when user pressed button.
Can anyone help me to give an example on how the db can be view when button is press??
I'm new to SQL Server, and have been following this tutorial
I carefully followed all the steps, but when I try to connect to the database from the other computer, I get the error "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)"
What steps do I need to take to fix this?
Thanks
(I'm using SQL Server 2008 R2 on both the machines)