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.
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?
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
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.
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.
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.
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.
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 :)
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.
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 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 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??
Ive seen tutorials after tutorials but i still dont get how to connect a database to my xcode.. i already put it in my reference, put the sqlite framework but still it doesnt work.. i even tried copying the whole code the tutorial offers but still my iphone simulator turns up blank.. can you please help me understand why?
I am looking for a publicly available SQL database with free access, where one can run some SELECT queries for free on some meaningful data (not item1, item2, item3). Have you seen any? Even better if it came together with some tutorial.
Vendor is not that relevant, as long as one can connect using a generic JDBC client.
Other than MongoDB and Memcached, what key-value stores run on Windows? Most of the ones I've seen seem to only run on Linux (Hypertable, Redis, Lightcloud).
Related links:
http://stackoverflow.com/questions/639545/is-there-a-business-proven-cloud-store-keyvalue-database-open-source
http://www.metabrew.com/article/anti-rdbms-a-list-of-distributed-key-value-stores/
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)
I'd like the field to save as a 1 or 0 instead of 'True' or 'False' in the database and i cannot figure out how to do it without manually setting every property when the record is saved. I have to use this a lot in this project and a bit field is not an option. I would like to solve this issue by extending the CheckBox control if possible but i don't know how to change the binding fields value. Any help would be greatly appreciated!
When I am trying to install the IFD tool on an on-premise CRM installation it is not updating the registry and the database.
Should the user doing the installation have some special permissions.
when i am using sequel pro to connect to a remote database, the server says access denied. I am 100% percent sure that the username and password are correct. I also try to use phpmyadmin to connect to the server, it works. I don't know what happened when I am using sequel pro to connect to the server.
I'm storing my files in the database and need to download a file when button clicked.
i can get the File content (Binary) in the action method. But how to return it as a file to the user?
I have downloaded ip-to-country.csv that has ip ranges that are mapped to countries. How should I store this data to database and how can I query in what range Ip address is to know where Ip address is coming from?
In MSAcess Database
Insert query to insert the character------ N'tetarnyl
i have a insert query
OleDbCommand cmd = new OleDbCommand("insert into checking values('" + dsGetData.Tables[0].Rows[i][0].ToString() + "','" + dsGetData.Tables[0].Rows[i][1].ToString()+ "')", con);
but it is showing me error...
syntax error (missing operator) in query expression
any idea??? how to write insert query to insert the N'tetarnyl (including apostrophe)