|
Doh.. How??
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
|
The Following number is called an Attribute code
"120080200000"
These are 6 pairs. i want to chance the 5th pair to '10' and not tember with the other pairs. here is the query but it gives me undesirable results.
update property
set attrib_code = substring(attrib_code,1,8)+ substring(attrib_code,9,2)+ '10'
and substring(Attrib_code,11,2) + '00'
where property_id = 15985
Please Help
Vuyiswa
|
|
|
|
|
Vuyiswamb wrote: here is the query but it gives me undesirable results.
You should describe the undesirable results. That way we can concentrate on what is likely to be wrong rather than have to waste time reading the whole thing to figure it out.
If you are normalising your database (which is generally a good idea), the first normal form should split this out in to separate columns. If you need it all joined up you can always create a calculated column for that purpose. If you need it joined up and indexable then a trigger can be created to ensure that happens.
|
|
|
|
|
I understand, mybe you can explain in detail how the substring is working, there are more than 40 000 records, am a junior, i have used this before and it worked, this code i used for something within the organisation. its true am normalasing the table, can you please tell me
how the substring work , i try to google it, but the explanation were not clear, i know there is a starting position and replce position. in this case
xx xx xx xx xx xx i want to change the 5th pair only, but my query temper with the last pair and change the 5th pair please help
Vuyiswa
|
|
|
|
|
Vuyiswamb wrote: mybe you can explain in detail how the substring is working
See the documentation for SUBSTRING[^].
Vuyiswamb wrote: its true am normalasing the table, can you please tell me
I don't know anything else about your table. All I can see is you appear to be modifying only part of a column value. That suggests to me that the column breaks the first normal form. i.e. you should split out all values into separate columns.
SUBSTRING(Value, 1, 8) + ReplacementValue + SUBSTRING(Value, 11, 2) Value is the name of the column, ReplacementValue is the value you want to replace the 5th pair with.
|
|
|
|
|
Thank you it worked, infact we were talking abot the same thing, i did not understand you, but now i do. tell let me ask you something. have you ever modify a large number of records by mistake? if yes what did you do, and how did you feel after that?
Vuyiswa
|
|
|
|
|
Vuyiswamb wrote: have you ever modify a large number of records by mistake?
Yes.
Vuyiswamb wrote: if yes what did you do?
I restored the backup.
Vuyiswamb wrote: how did you feel after that?
Normal. Why?
|
|
|
|
|
what is the maximum number of clients that can connet to a TCP server ( in .net remoting) and what happens if the number of clients reach beyond the max limit?How can we temper the maximum limit?
|
|
|
|
|
hi
I want to make an import from access to mysql on Linux but i have a problem with mysql:the default value of
lower_case_table_names is 0 and i must put the default value of
lower_case_table_names to 1 .
Help please.
thanks
|
|
|
|
|
i inserted the ado data control in my form and went to propertes as usual with the Ado data control, and Build connection string, and choose SQl server a driver and where am supposed to choose my Sql server it gives me an Error.
"Error Enumerating data servers.Enumarator reports 'unspecified error'"
help what would be the problem
Vuyiswa
|
|
|
|
|
how to insert null into datetime field in sql??
can i assign it from asp.net..
pls explain..
thks
|
|
|
|
|
use DBNull.Value
i.e dr["ColDate"] = DBNull.Value
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
How can get the path of a database(.mdb)and name of the tables in that .mdb file?
thanks
|
|
|
|
|
Please help i've many forms inserting to DB SQL
i want to implement a method that reads directly from the Datatable and insert or delete directly to the DB instead of providing the parameters manually.
the update is easy just provide the to the adapter.update()the datatable and it automatically do it
but the insert and delte of the adapter u must provide the paremeters manually.
so did any body though about this before ????
i hope it can works.
|
|
|
|
|
simsem wrote: the insert and delte of the adapter u must provide the paremeters manually.
No you don't. After you create the DataAdapter, you can use an OleDbCommandBuilder or SqlCommandBuilder to create the INSERT, UPDATE and DELETE commands for that adapter. Well, so long as the SELECT is a single table query that is...
Docs on the SqlCommandBuilder are here[^].
|
|
|
|
|
Hi chaps, i have a question.
Is it possible to somehow combine a collection of commands to read out as the same DbReader, and just iterate through the batches in the DbReader object?
Being able to return multiple sets is REALLY useful, and it would be nice if i could construct say 3 commands, to select the contents of multiple tables, execute them all together into one DbReader, and generate the objects for each result set without consecutive db calls.
Are there any options like this? Or would i have to use stored procs?
Cheers
Tris
-------------------------------
Carrier Bags - 21st Century Tumbleweed.
|
|
|
|
|
This is possible, but not with Access. Access doesn't support batch queries like SQL Server does.
It's easy to find examples. All you have to do is Google for "VB.NET SqlDataReader multiple result sets".
|
|
|
|
|
Hi Dave, thanks
I have the multiple result sets, but what i'm looking for is the ability to box up multiple DbCommand objects and send them off all in the same query, and return a DbReader with a result set for each of the supplied commands.
-------------------------------
Carrier Bags - 21st Century Tumbleweed.
|
|
|
|
|
Tristan Rhodes wrote: i'm looking for is the ability to box up multiple DbCommand objects and send them off all in the same query, and return a DbReader with a result set for each of the supplied commands.
There's no way to do that. You can only send off each one by itself and get a seperate dbreader for each result.
|
|
|
|
|
I suppose i have a bit of a brain block with databases.
I always get mixed up over what is physicaly fast / slow and what's worth using when, and in what situations. They are a complex beast and i'm trying to cram in as much experience with them as possible. But i still feel there is a fundamentaly different way of handling things depending on the situation, single site web app, distributed web app, client DT application etc. Then there is concurrency and caching, and the nature of the application.
I've only been using databases for about a year and a half, please tell me it gets easier with time / experience 
Tris
-------------------------------
Carrier Bags - 21st Century Tumbleweed.
|
|
|
|
|
Tristan Rhodes wrote: please tell me it gets easier with time / experience
Yeah, right! 
The point behind solving problems is not to know how to solve the same problem again later. It's learning how to research any problem you encounter. The more you do this, the easier it gets to find an answer to the next problem.
|
|
|
|
|
Hello,
SQL 2005
I have a stored procedure and I am not sure I wrote it correctly to except a parameter of ticketid.
In VS I can see the fields however no data gets passed.
When I select query builder from VS I get an error "unable to parse query text"
I then exceute query and the fields show up with no data.
If I set the Parameter @ticketid to a value it works in SQL Query Analyser.
In the command and editor window in VS-? under parameters I have ticketid value request.querystring ("@ticketid")
Query String Field = @ticketid
here is the stored procedure:
Declare @ticketid as varchar (20)
Declare @Technician as varchar (20)
set @Technician=(SELECT email
FROM dbo.tech INNER JOIN dbo.job_ticket ON tech.client_id = job_ticket.assigned_tech_id WHERE job_ticket.job_ticket_id =Cast (@ticketid as varchar (20)))
SELECT job_ticket.job_ticket_id 'Ticket Number', @Technician 'Technician Assigned',job_ticket.subject 'Issue Description', report_date 'Open Date',tech_note.note_text 'Work Notes'
FROM job_ticket INNER JOIN dbo.tech_note ON tech_note.job_ticket_Id = job_ticket.job_ticket_id WHERE job_ticket.job_ticket_id =Cast (@ticketid as varchar (20))
Am I not passing the varible correctly or is the stored procedure incorrect?
Any help is greatly appreciated; I have been stuck on this for days.
Thanks
Regards,
Hulicat
|
|
|
|
|
okay so it needed to be created as......
question what does this do as oppsoed to how I had it:
CREATE PROCEDURE dbo.sp_dticket
(
@ticketid as varchar(20)
)
AS
CREATE PROCEDURE dbo.sp_dticket
(
@ticketid as varchar(20)
)
AS
Declare @Technician as varchar (20)
set @Technician=(SELECT email
FROM dbo.tech INNER JOIN dbo.job_ticket ON tech.client_id =
job_ticket.assigned_tech_id WHERE job_ticket.job_ticket_id =Cast
(@ticketid as varchar (20)))
SELECT job_ticket.job_ticket_id 'Ticket Number', @Technician
'Technician Assigned',job_ticket.subject 'Issue Description',
report_date 'Open Date',tech_note.note_text 'Work Notes'
FROM job_ticket INNER JOIN dbo.tech_note ON tech_note.job_ticket_Id =
job_ticket.job_ticket_id WHERE job_ticket.job_ticket_id =Cast
(@ticketid as varchar (20))
GO
Regards,
Hulicat
|
|
|
|
|
Dear i it is not necassry to CAST the value if u have int type Value. Query gives the result. if u send me Table structure thean i will solve you clearliry.
Thanks and Have a Nice day
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
