| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> ...anyone?
<1> hmm
<1> what permission to give to a user to be able to write registry
<2> heh
<2> Quant: every key has an acl
<2> its the same system as with folders
<1> upb: eventlog keys
<3> morning
<3> my mysql friends
<4> php programmer /
<5> Hmm, I wonder if it's normal for Access to crash when I try to execute an
<5> INSERT statement that contains a subquery..
<3> thats normal
<5> Maybe if I replace it with a DLookup it might like it better.
<4> maybe you should replace the dbms :D
<5> mod_tom: Got any suggestions? Something that can run on Windows NT, be easy
<5> to setup, maintain, and will play nice with Access frontend? :)
<5> I would try getting the MS SQL Server 2005 Express thing, but apparently
<5> they don't support WinNT anymore and I doubt my company would let me upgrade to 2000.
<6> guys, some advice on how (roughly) you would go about solving this....
<6> on sqlserver I have a table with fields ID and ParentID
<6> The table is linear but the actual data will form a nested set of form elements
<6> with ParentID matching to the relevant ID of the parent
<6> how would you go about picking up all the related items from one parent (given by ID)?
<6> there could be up to 4 levels of hierarchy
<6> a recurrsive function using a cursor has been one of the suggestions put forward
<6> but the db we have can't run functions
<6> just not sure "how to attack" the problem
<7> try storing in a temporary tables and querying that then
<6> _Kal-EL, looking up temporary tables details just now.
<6> It's the fact that it can be more than 2 levels meaning having to recurse several layers of results
<7> yes so you would manually construct a temporary table with the resultset you want and query that
<6> http://www.sqlteam.com/item.asp?ItemID=2029
<6> http://www.sqlteam.com/item.asp?ItemID=436
<6> are the two docs I am reading just now
<7> i think its more than sufficient to get you running and tackle your problem
<7> reboot
<7> brb
<8> hello everyone. I have a form asking for my clients first and last name. Alot of the times my clients dont use proper punctuation. Is there a way to make my MySQL server capitalize the first letter of the first and last name at insert?
<7> you can do this easily in the front end of your application as you retrieve the data
<7> shouldnt matter to your db in what case its stored :p
<3> windblows: topic
<3> mysql does not support lower and uppercase
<8> topic? did I do something i shouldn't have?
<8> oh okay
<3> since one byte only has 6 bits in mysql
<7> windblows, is this a web application ?
<7> the front end to your database that is
<8> yes. Written in CF
<3> compact flash?
<3> how much GB?
<8> GB?
<7> well, use css to upper case the first letter
<3> gigabyte!
<8> oh?
<8> I didnt know css could capitalize first individual characters
<8> will look into that
<3> css, crazy style stuff
<3> or use a trigger
<3> if mysql supports trioggers
<8> will it be supported by ie6
<8> ?
<7> text-transform:uppercase; <-- this will make the first letter of each word upper case
<3> ie6 is incompatible wirh mysql
<7> its so simple really :p
<3> i would use text-transform:capitalize
<7> sorry, this : text-transform:capitalize;
<7> hehe
<7> the first will capitalize the entire word :-)
<8> so this will capitalize the first word only?
<8> text-transform:capitalize;
<7> yeah
<7> the first letter of every word it finds to the element you applied that style
<7> Hi, My Name Is Windblows
<7> like this
<6> <div id="foo">hello</div> ... #foo:first-letter {{ text-transform: uppercase }
<6> oops, multiple {{ there, just the one needed
<6> it's a css pseodo selector
<3> is css good or evil? i dont know it!
<6> lovely thing
<6> as we all want (on the client) a separation from markup/design/content/script
<6> css allows us to remove the markup/design apart
<4> anyone know how to do a count() operation on firebird ?
<6> see with mssql, and the IN statement, used like this... select * from tableName where foo IN (1,20,30)
<6> is there any way to get a parameter p***ed to be the set? like so.. select * from tableName where foo IN @myp***edParameter
<9> There is no ANSI way to do that. If MySQL has some crazy feature of their own you'll have to ask #mysql.
<6> this is MS, not My
<9> oh, sorry, then the answer is no
<6> np, and thanks
<10> ric, which version
<6> not entirely sure, think its 2000
<6> in fact pretty sure of it
<10> you need to create a udf that returns a table variable
<11> Yeah, sets as parameters is just weird. Its really annoying.
<10> i'll paste one you can modify as required
<10> hold
<9> The tricks of the trade usually involve making a tabular UDF to take a CSV or similar, or XML.
<6> yeh, I have a script that shows how to do recusive functions with a cursort
<6> -t
<6> but the db we are working with doesn't support udfs
<10> eh?
<9> That would be SQL Server 7.0
<10> nm, then
<6> yeh, what I am using here and what the client's db is one ;)
<6> *db is on
<9> Probably could do it in a sproc, but it's more code.
<9> Create a temp table, EXEC sproc INTO #table, join to that
<6> I think temp tables is the way to go
<6> the problem is I have a linear table with rows, with fields called id and parentID
<6> it's for "nested" form elements, so the parentID of one row will match the id of another item
<6> and that could be up to 4 levels deep
<6> can't use UDF
<6> and I am not "good" enough with sql to work out some procedure/temp table/cursor malarkey
<11> Malarkey? Haven't seen that term in ages. how old are you? ;)
<10> knock him on his keester, saw him checking out my dame
<12> 65 i'm guessing
<6> 35 :(
<6> malarkey is a cracking word
<10> i'll be 40 in four days
<6> as is "inconsequential bollocks"
<6> although that's two words
<13> hey all, I have a MSSQL db that I'm trying to delete a row from a table of. this table has no relationships, no required fields, no primary keys and yet there is 2 identical rows that I cannot delete or change either of them. Any ideas on what might be the issue?
<9> From EM?
<3> sounds like we got a PBKAC
<13> yea Halo
<9> EM won't let you edit or delete from a table with no PK.
<13> I can delete other records
<13> just not those 2
<9> Probably because it can't delete just one of them
<9> Do it in SQL
<13> ah you're right...thats wierd though..anyways thanks :)
<14> hi
<3> hi daniela-
<15> SQL Server 7/2000 - In a SProc I have a variable @IDList varchar that conains a list of IDs (like '1,8,15,29'). In a SELECT I want to do WHERE IDField IN (@IDList) but I get an error: Syntax error converting the varchar value '1,8,15,29' to a column of data type int. How can I do this?
<10> jesus
<3> where '%,' + IDField ',%' like ',' + @IDList + ','
<3> ghaharz
<10> no
<10> in sql2k you can use a udf to parse the 'list' into a table var
<10> the you SELECT * FROM dbo.theUDF(@IDList) and get the same effect as an IN
<15> dfworking: SQL Server 7 doesn't have UDFs.
<10> no ****
<10> which is why i prefaced my comment with 'in sql2k...'
<15> So why are you giving me a solution that won't work on all the platforms I mentioned? :)
<10> the only other way to do it is to dynamically exec the prepared sql
<10> so, if that doesn't bug you, just build up a @sqlToExecute var and then EXEC() it
<10> in the proc
<15> Would that be more effecient than ztod's suggestion?
<10> sure, since what i'm suggesting would actually work
<10> you cannot cast a string 'list' to a comma delimited list of integers
<10> pretty sure this summed up the other suggestion: <3> ghaharz
Return to
#sql
or
Go to some related
logs:
#politics
#politics
#beginner
define:كس
#winvista
#politics
#linuxhelp
cynosual
#nhl
C# how do I clear byte[] array
|
|