I am trying to store a username and password to hash against for future offline logging in. What is the best way to do this in objective c?
I will need the password to be stored securely.
Imagine the following use case:
You have a basecamp style application hosting files with S3. Accounts all have their own files, but stored on S3.
How, therefore, would a developer go about securing files so users of account 1, couldn't somehow get to files of account 2?
We're talking Rails if that's a help.
I am told that usage of SP_OACreate , SP_OAMethod in SQL Server 2000 is of a security risk.
I am using Strong Name in the assembly and is stored in GAC on the SQL Server Machine.
What are the security implications/compromise ?
We have stored all media in Sql Filestream, but now we'll need Video and Audio streaming... Will this be possible with Sql Filestream or will I have to take all of the Video and Audio out of the database?
Which technology would you use to enable Video/Audio Streaming?
WebORB
FluorineFX
Wowza (way better I think than the first two)
IIS Media (haven't looked into this yet)
Hi all!
I'm looking into an offline web app solution using HTML5.
The functionality is everything I need BUT the data stored can be directly queried right in the browser and therefore completely unsecure!
Is there anyway to encrypt/hide so that the data is secure?
Thanks,
D.
How do I access this activity log information programmatically with Ruby (this is the Activity Window from Safari)? Can I use Mechanize to spit out all this information (duration, size, address, etc.) in XML, or is this already stored somewhere on my computer?
Hi,
I have to read in a large record set, process it, then write it out to a flat file.
The large result set comes from a Stored Proc in SQL 2000.
I currently have:
var results = session.CreateSQLQuery("exec usp_SalesExtract").List();
I would like to be able to read the result set row by row, to reduce the memory foot print
Thanks
I'm trying to access the post target action in a jquery function.
example:
<form action="/page/users" id="signup" method="post">
I'd like to access the "action" part - "/page/users" in this case.
$('#signup').live("submit", function(event) {
// get this submitted action
}
Seems like I'm missing something very simple. I see the value in the dom but don't know where it's stored in jquery.
Thanks!
I am getting following error on
Cannot create the in-place editor
This is probably because there is no OLE editor registered against the type of file you were trying to open.
Failed to create Ole Client. result = -2147417851
I have MS office 2007,and the excel file is stored as "save as 2003 version".
I realise it is possible to create a crosstab within sqlite, but is it possible to dynamically determine the relevant categories/columns at runtime rather than hardcoding them?
Given the following example, it can get rather tedious ...
SELECT
shop_id,
sum(CASE WHEN product = 'Fiesta' THEN units END) as Fiesta,
sum(CASE WHEN product = 'Focus' THEN units END) as Focus,
sum(CASE WHEN product = 'Puma' THEN units END) as Puma,
sum(units) AS total
FROM sales
GROUP BY shop_id
I managed to do this in SQLServer in a stored proceedure before and wondered if there was anything equivalent.
Hi,
I need a way to store the current user's SID in a variable, I tried a lot of variants of:
setlocal enableextensions
for /f "tokens=*" %%a in (
'"wmic path win32_useraccount where name='%UserName%' get sid"'
) do (
if not "%%a"==""
set myvar=%%a
echo/%%myvar%%=%myvar%
pause
endlocal
None are working
wmic path win32_useraccount where name='%UserName%' get sid
should be returning 3 lines, i need the second one stored in a variabel
Can someone fix my script?
edit
btw; I am using a .cmd file
I want to run scheduled nightly exports of my database code into my SVN source.
It's easy to schedule automated check-in's into svn from a folder, but scheduling the export from SQL in SQL Management Studio is
Right click target database, choose Tasks Generate Scripts.
Follow the wizard and presto you've got scripts in a folder.
Is it possible to extract a single script that the wizard generates, and stuff that into a stored proc which I can run nightly?
Ideas?
Hi,
Are there any utilities available that allow you to bulk extract binary data from a MSSQL table?
For example, I have a number of Word documents stored in a table and I would like to extract all of these documents into files.
I know could do this by writing some .NET code, but I only need to do it once.
hello friends
I am using following query in linq
In product table following type of data are stored
abc-def
bcd=fgh
abc-xyz
var query=from prod in db.Product
join cat in db.category on prod.categoryId=cat.categoryID
where prod.productName.split('-')[0]=="abc"
but in that query it product annoumous problem
Please give some suggestion to split in where caluse
I have some BigDecimal values which should be indexed for searching. Lucene has NumericField but it has setters only for long, double, float and int. I could store it as a String but then I would not benefit from NumericRangeQuery.
How you have stored your BigDecimals? Any best practices to share?
I have script file where a command is stored in a variable
First i got the command (assume "ls -l " command)
cmd= cat /proc/2345/cmdline
now doing
echo $cmd
outputs
ls -l
Now how to use $cmd to actually execute that command. which is ls -l
Hi all,
I am writing an iPad app that downloads a rather large .csv file and parses the file into objects stored in Core Data. The program keeps crashing, and I've run it along with the Allocations performance tool and can see that it's eating up memory.
Nothing is alloc'ed or init'ed in the code, so why am I gobbling up memory?
Code at: http://pastie.org/955960
Thanks!
-Neal
Hi,
How to load a multiple line query in one row using mysql.The data is stored in a text file.
For example:
"GGAGTTGTGGGAGTGGAGGAGGAAGAGGCGGTGGGGAGTACGGGGGCTGGTCCCAGAAGATGGCGGAGGC
GGGGGATTTCTGGTAGGTCCTACTTTAGGACAAGATGTGGTGGTACTGTTGAAGCGTCAGTCTTTGATTC"
Thanks in advance.
Currently my MySQL data stored like below
product | total
------------------------------------------
puma,adidas | 100.00,125.00
puma | 80.00
reebok,adidas,puma | 70.00,100.00,125.00
adidas,umbro | 125.00,56.00
How to combine, explode, merge and total it like this in php?
puma 485.00
adidas 350.00
reebook 70.00
umbro 56.00
Hi all,
I'm building a website at the moment, I've some html fragment that is being stored into the database, I've been reading around that inserting HTML at runtime poses security risks by using the InnerHTML property of any html tag with runat server on it.
So, my question is there any alternative way to safely display the html code and won't pose security risks and is it best to assume any textboxes on any given page is dangerous and process the text in the textboxes with Server.HtmlEncode before I store it to database?
Cheers
I enjoyed the answers and questions about hidden features in sql server
What can you tell us about Oracle?
Hidden tables, inner workings of ..., secret stored procs, package that has good utils...
I just figured out that all code completion for Eclipse is stored in plain files located here (example):
.\eclipse\plugins\org.eclipse.php.core_2.1.1.v20090921-1100\Resources\language
I tried adding global variables like $_POST, $_GET, $_SERVER to the end of basic.php but without any luck (did try to restart Eclipse).
Is there a way to create compatible files for the needs of "smooth integration" of (ie.)CodeIgniter framework by adding or changing files located here and how would it be done?
I would like to turn this query to regular inline sql without using stored procedures
declare @nod hierarchyid
select @nod = DepartmentHierarchyNode
from Organisation
where DepartmentHierarchyNode = 0x6BDA
select *
from Organisation
where @nod.IsDescendantOf(DepartmentHierarchyNode) = 1
Is there a way to do it?
Using the bulkloader.py utility you can download all data from your application's Datastore.
It is not obvious how the data is stored, however. From the looks of it, you get a SQLite file with all data in binary format in a single table:
sqlite> .tables
bulkloader_database_signature result
sqlite> .schema result
CREATE TABLE result (
id BLOB primary key,
value BLOB not null,
sort_key BLOB);
Are there any tools to work with this data?
Is there a way to identify the timestamp when an object(table/view/stored proc...) was modified ?
there's a refdate in sysobjects but it's always the same as crdate atleast in my case and i know that alter view/alter table/alter proc commands have been run many times post creation