How can I call Access's Compact and Repair Database utility from within C++? I'm already using ADO and ADOX, so a solution using either of those would be handy.
So I'm using the datepicker plugin to make an availability calendar. Here is my javascript:
http://pastebin.com/H7D9PcAg
When dpSetSelected() is called it is also calling dateSelected() which triggers the AJAX call to my PHP script. I need a way to only update the database if the date is clicked on and not pre-loaded. When I pre-load the dates they are sent to the PHP page and subsequently removed.
I would like to create an application from a database schema using seam-gen, unfortunatly informix isn't supported out of the box.
Where can I add another db?
I read some tutorials on how to read data from a database.properties file- which basically stored key-value pairs.
What i want to know is, in which folder should I place this file? Is it in the root (ie "src") or within a package... And how do I access this file, if it is placed in "src"- my code will be within a package (and the package's directory will be under src)- so how do I access the properties file, which is in "src", from a class within a package?
Hi all,
Somebody knows how to change the user account and authentication method sharepoint uses to connect to its content database?
It is now setup to connect using Windows Integrated Authentication but I want to change that to a local user account.
Is it even possible to do this?
Thanks in advance
Transactional Replication on SQL Server 2005 Enterprise x64 (SP3).
I need to add check constraints to a databases that is the target for a replication, but I cannot add the check constraints to the publishing database. The Problem is that the replication process keeps removing my constraints. How do I prevent this?
Hi,
Please help me to achieve the below problem:
I am having one "view" in the Oracle database,I want the output of that view and store that output in the .txt file on some other folder in UNIX box.
The output which is generated from view is a report and I want to save that report in .txt format in one folder on UNIX box.Oracle is present on the UNIX box.
I'm looking for a way to get all rows as insert statements from one specific table within a database using pg_dump in postgres.
eg I have table A and all rows in table a I need as INSERT STATEMENTS, it should also dump those staements to a file
Is this possible?
I want to create a Rails (2.1 and 2.2) model with ActiveRecord validations, but without a database table. What is the most widely used approach? I've found some plugins that claim to offer this functionality, but many of them don't appear to be widely used or maintained. What does the community recommend I do? Right now I am leaning toward coming up with my own solution based on this blog post.
This line:
used_emails = [row.email for row
in db.execute(select([halo4.c.email], halo4.c.email!=''))]
Returns:
['[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]']
I use this to find a match:
if recipient in used_emails:
If it finds a match I need to pull another field (halo4.c.code) from the database in the same row. Any suggestions on how to do this?
I am using SQLite to store school classes. I want to fill in a Spinner with the classes that get stored in the database. How would I grab all the classes in the DB and load them into a spinner?
I am integrating LDAP authentication in my web enterprise application. I would like to show listing of people name and email. Instead of querying the LDAP server for the name and email each time a listing containing several users I thought about caching the data locally in the database.
Do you guys know about caching LDAP data best practices?
Should I cache LDAP user data?
When should I insert and refresh the data?
Hi,
I want to integrate the beast forums in an existing rails app, but
there is a database conflict. I already have a "post" model for the
blog and beast requires it. How do I eliminate the problem?
Regards
I have a database with the following tables:
Employee (EmpID, FirstName, LastName, RegionID)
EmployeeSkills(EmpID, SkillID) [this is a linking table for the M:N relationship between Employees and skills]
Skills(SkillID, Description)
I need to list the name of the skill that most employees have. I tried doing a max(count(skillID)), sqlserver said that you can't do an aggregate function on an aggregate function. Any other ideas?
Thank you in advance!
Hello All,
Please suggest me a query, which retrieves only those record which has the single row in table. For Example
table1.
name age
aaa 20
bbb 10
ccc 20
ddd 30
If I run "select distinct age from table1. result will be
age
20
10
30
But I need a query, which give the result like
name age
bbb 10
ddd 30
Thanks....
hi guys, when i am using 'localhost' as the host for mysql database, sequel pro alert me that i will be using socket, if i am using '127.0.0.1', i am actually using the ip address and port 3306 to locate the server.
is there any difference?
Hi, i would like to create a Rails controller that download a serie of jpg files from the web and directly write them into database as binary
(I am not trying to do an upload form)
Any clue on the way to do that ?
Thank you
Edit :
Here is some code I already wrote using attachment-fu gem :
http = Net::HTTP.new('awebsite', 443)
http.use_ssl = true
http.verify_mode = OpenSSL::SSL::VERIFY_NONE
http.start() { |http|
req = Net::HTTP::Get.new("image.jpg")
req.basic_auth login, password
response = http.request(req)
attachment = Attachment.new(:uploaded_data => response.body)
attachement.save
}
And I get an "undefined method `content_type' for #" error
How would i go about creating an application for my web page that can extract data from my database (i currently get the data in a CSV file). id also like the user to be able to filter the data by certain parameters. can u help
i have a txt file stored in my sql DB, in that .txt file i have certain numbers like
99435
87889
33455
33555
34556
how to get the count of these numbers from the txtfile stored in the database and also to read the file and fetch the number one bye one in a string.
using asp.net (C#)
I am inserting userId.It is displaying correct but inserting 0 in spite of actual userId. mycode-
If(! empty($userIDToCheck) || $userIDToCheck != '' )
{
echo $userIDToCheck;
$sql = "INSERT INTOpnpdb.ruser(userid) VALUES ('$userIDToCheck');";
mysql_query($sql)or die(mysql_error());
echo "Done";
}
Output : pi203713 Done
But is database it is inserting "0"???
I've made 2 apps, App A and App B. App A's sole purpose is to allow users to sign up and App B's purpose is to take select users from App A email them. Since App A & B were created independently & are hosted in 2 separate Heroku instances, how can App B access the users database in App A? Is there a way to push certain relevant rows from App A to App B?