I need to find out which account is running one of my websites application pool.
I need to add the user to a database in SQL Server.
Using IIS Manager, is there a way to check?
I am having database in .dbf (Foxpro) formate.
1) How to retrieve data from Foxpro using Java.
2) If the data can be migrated to MySql, How to do the conversion. Pls help me.
Does Python have a built-in, simple way of encoding/decoding strings using a password?
Something like this:
>>> encode('John Doe', password = 'mypass')
'sjkl28cn2sx0'
>>> decode('sjkl28cn2sx0', password = 'mypass')
'John Doe'
I would like to use these encrypted strings as URL parameters. My goal is obfuscation, not strong security. I realize I could use a database table to store keys and values, but am trying to be minimalist.
I have a table with 3 column's in a table on a MS SQL 2008 Database
ID
ToolID
Count
Can someone toss me a script that will create a stored procedure that accepts the param ToolID and increases its value by 1?
All of my efforts have failed.
Here's a simple relational pair of models.
class Shelf(models.Model):
name = models.CharField(max_length=100)
def has_books(self):
if Book.objects.filter(shelf=self):
return True
else:
return False
class Book(models.Model):
shelf = models.ForeignKey(Shelf)
name = models.CharField(max_length=100)
Is there a better (or alternative) way to write the "has_book" method?
I'm not a fan of the double database hit but I want to do this at the model level.
Hi,
I'm querying an SQL Server database using SQLAlchemy and need to cast a column to varbinary(max). The thing I am struggling with is the "max" part. I can get the cast to work for any actual number (say varbinary(20)), but I cannot find how to get it to work for the "max" size of the varbinary column.
Any pointers? Links? Solutions?
Regards,
Mark
Hi,
I've installed and tested Wordpress configurations on my home server which I use as my test server.
Is it possible to upload everything, including Wordpress, from my home web server to my hosting account so it will work instantly there?
Of course I need to change the database name, password, but that's about it.
thanks!
I'm looking for a CMS just for backend that lets you manage database tables with custom fields.
I found Wordpress Pods similar to what I'm looking for, but I don't want Wordpress to manage my frontend (and Wordpress Pods don't look professional to me...)
Is there something like this out there?
Thank you.
Sergio
Basically, i want to implement Offline/Online XUL application with ability to upload data to server.
Yes, i know there is Mozilla Storage API, but it looks like it is much more easier with Gears to have local database and to upload local changes to server using WorkerPool.
Without Gears, i have no ideas how to upload local changes to remote server.
Any thoughts, friends?
Thanks in advance for any help.
I am working on a form with the possiblity for the user to use illegal/special characters in the string that is to be submitted to the database. I want to escape/negate these characters in the string and have been using htmlspecialchars(). However, I would like to know if there is a better/faster method.
I'm looking for recommendations for an easy to use reporting/business intelligence tool that can interface with an sql server or access database. It can be web-based or a desktop tool.
Ideally it would be freeware or low cost, and easy to use for users who are not that technically savvy (below the level of someone who can generate reports and complicated queries in Access).
Any tools I've seen so far (such as Crystal Reports) are either too expensive or too complicated to use for non-power users.
I want to build a website where you can search by entering the postcode (UK). I know that RoyalMail owns the Database to do this (it's only very expensive, $100K). What are my options?
Hi everyone,
I use MonoDevelop 2.2.2 with Mono 2.6.3 on OpenSuse so the linq to sql feature is implemented. But I have the problem I can create a new connexion to a postgresql database it's ok but when I click in Tool - Generate Data classes and select the connexion I've created before I obtain nothing, no tables appear.
What's the problem ?
I have an application that takes a long time to open odbc connections (like 20 sec) also takes forever using arcmap and arcsde
but when I try the connection on the odbc data source administrator, it tests it really fast
Does anyone have any idea of what my be causing this?
btw the application works fine in another computer with another database
thanks.
I am attempting to link an Excel source to a SQL Server DB on the Go Daddy website. When I execute the sp in SQL Server, it shows it executed successfully, but no data is linked.
This is the main part of my procedure:
EXEC sp_addlinkedserver
@server = 'XLHybrid',
@provider = 'Microsoft.ACE.OLEDB.12.0',
@srvproduct = 'Excel',
@provstr = 'Excel 12.0 Macro',
@datasrc = 'C:\Database\XLHybrid.xlsm'
What's the problem here?
I am creating a calendar in PHP and in the database have a date, let's say 6-10-10.
Sometimes I have repeating events, stored as weekly repeating, so if the date is 6-10-10, and I am repeating an event every two weeks from that day (including that day) what is the best way to find dates for every two weeks from 6-10-10?
For example, let's say the date is 7-8-10, how can I check to see that date meets my criteria?
I've stopped the website in IIS, made a change in Web.config, but the damn thing keeps writting my log events into my database! The only solution I've found is to restart IIS completely. This isn't a very good solution because then all my websites have to stop/restart.
I have database migrations (with sqlalchemy-migrate) working well in my dev environment. However, I'm a little stumped about how to integrate this into my deployment process.
I'm using fabric for deployment but having some trouble scripting the migrations part. The path to the to migrations directory in site-packages is dynamic (due to changing egg version number) and I'd rather not hard code my db password into the fabfile.
Does anyone have a fabfile that plays nicely with sqlalchemy-migrate?
HI Guys,
Here I a wanna know that whether sqlite supports SELECT INTO statement.
Actually I am trying to save the data in my table1 into table2 as a backup of my database before modifying the data.
for that when I am using the SELECT INTO Statement a syntax error was generating as:
My query as:
SELECT * INTO equipments_backup FROM equipments;
"Last Error Message:near "INTO":syntax
error".
Anyone's help will be appreciated.
Thank you,
Monish.
Hi,
I want to convert the mysql database table contents to an Excel(.xls) or comma seperated file(csv) using python script... Is it possible? Any one can help me?
Thanks in advance,
Nimmy
Hi! What would be an appropriate way to do this, since mySQL obviously doesnt enjoy this.
To leave either partitioning or the foreign keys out from the database design would not seem like a good idea to me. I'll guess that there is a workaround for this?
Update 03/24:
http://opendba.blogspot.com/2008/10/mysql-partitioned-tables-with-trigger.html
http://stackoverflow.com/questions/1537219/how-to-handle-foreign-key-while-partitioning
Thanks!
Sorry for the bad title, if you can think of a better one, let me know.
Many-to-many relationship using tables.
Product
ProductCategory
Category
In the ProductCategory table i have boolean column primarycategory
Each product must have a primary category.
I want to find all products in my database which don't have a primarycategory.
Hi,
Can anyone help me regarding update data in the gridview by using AJAX. Once enter the values textboxes and saved into Database, then gridview has to update the new changes. and not by using the ajax updatepanel
How can I serach word with "&" using mysql full text search ?
There are words string, like "Marks & Spencer", "at&t" in my tables , serach "at&t", but can't find it on the database using mysql full text search
Any ways to serach word with "&"?
I'm beginning the design of a medium-sized web application. I usually like to design from the top down, i.e., start at the highest level and design my way down.
I am planning to have the following layers:
Presentation (PHP/Ajax)
Business Logic
Data Access
Database
Now I'd like to start sketching out the major objects in each layer and the interaction between layers. Is there a tool more specific to this purpose than just using a graphics/diagramming tool like Visio?