correct the expression of the textbox field - Database Discussion Boards

Re: save / read image in mysql

Eddy Vluggen17-Nov-10 0:18

Eddy Vluggen

17-Nov-10 0:18

jrahma wrote:
I am looking for the steps on how to save and how to read images from/to mysql using C#?

Would a CodeProject article[^] on the subject help?

I are Troll Suspicious | :suss:

SQL Server - Transaction Log - auto shrink?

devvvy16-Nov-10 20:35

devvvy

16-Nov-10 20:35

hello - how can you configure auto shrink for SQL server Trasnaction log?

Thanks

dev

Re: SQL Server - Transaction Log - auto shrink?

Goutam Patra16-Nov-10 21:18

Goutam Patra

16-Nov-10 21:18

EXEC SP_DBOPTION 'MYDBNAME', 'trunc. log. on chkpt', true

modified on Wednesday, November 17, 2010 3:29 AM

simple recovery model

David Mujica17-Nov-10 3:14

David Mujica

17-Nov-10 3:14

Before you shrink/truncate your transaction log, make sure you have a proper backup so that you can recover the data. You may want to investigate the Simple Recovery Model for your backups.

Read this article http://databases.about.com/od/sqlserver/a/recoverymodels.htm[^]

SSIS and stored procedures

tim_gunning16-Nov-10 10:15

tim_gunning

16-Nov-10 10:15

hi all

I was wondering if anyone could help, I need to pass 2 variables to a stored procedure that in turn fires off an SSIS job that calls a stored procedure.... (dont ask!). I can get the variables into the stored procedure no problem, but getting them through to the job is proving harder than I would expect. I can set static params through the Set Values option but cannot see a way of making them dynamic ?> any thought greatly appreciated

ta

Re: SSIS and stored procedures

Manfred Rudolf Bihy16-Nov-10 12:01

Manfred Rudolf Bihy

16-Nov-10 12:01

Can you post some code from the stored procedure where you "fire off" the SSIS job?

Greetings

Manfred

Re: SSIS and stored procedures

robertford16-Nov-10 14:25

robertford

16-Nov-10 14:25

ta,

I am sure that there is a way to pass those values though another option that I have used before is to update a parm table with the values from the stored procedure and then kick off the SSIS package which reads the parm table.

I hope that this helps

Robert Ford

correct the expression of the textbox field

vinu.111115-Nov-10 23:36

vinu.1111

15-Nov-10 23:36

hi... to all..

i've written the code in expression field...

=format(sum(fields!salary.value),"##\,##\,##\,##\,##\,##\,##0.00")

the code is for printing the number in this format(12,23,23,34,123.00)

now i got an problem i.e if i give 5 digit the it will print ,,,,,12,123.00 the remaining commas

are printed.. i dont want to print the extra commas.. how the word length is there that much it

should take..i.e( for 5 digit 12,123.00 and for 9 digit 12,23,23,123.00)...

i've tried by removing some of the #'s but it is for fixed number..

please help me...

Re: correct the expression of the textbox field

Geoff Williams16-Nov-10 1:07

Geoff Williams

16-Nov-10 1:07

It is customary to group 3 digits at a time. To achieve that you simply need to use "#,##0.00" as your number format - the result will contain as many ',' characters as necessary e.g.

Format(123.45, "#,##0.00") -> 123.45
Format(1234.56, "#,##0.00") -> 1,234.56
Format(12345.67, "#,##0.00") -> 12,345.67
Format(123456.78, "#,##0.00") -> 123,456.78
Format(1234567.89, "#,##0.00") -> 1,234,567.89

Re: correct the expression of the textbox field

vinu.111116-Nov-10 1:08

vinu.1111

16-Nov-10 1:08

thanku.. for reply
i have just change the language setting..

need help to code in c# to update image

chandru22215-Nov-10 22:23

chandru222

15-Nov-10 22:23

please help to update image using c# i'm new to .net
i have successfully inserted image in database but i couldn't update it,using c# if any one finds the answer please let me know it

advance thanks Laugh | :laugh:

Re: need help to code in c# to update image

Eddy Vluggen16-Nov-10 0:02

Eddy Vluggen

16-Nov-10 0:02

chandru222 wrote:
i have successfully inserted image in database but i couldn't update it

Why not? Did you get an error? What did it say?

I are Troll Suspicious | :suss:

Retrive data from Access table

vijay248215-Nov-10 2:17

vijay2482

15-Nov-10 2:17

Hi all,

Re: Retrive data from Access table

Eddy Vluggen15-Nov-10 4:45

Eddy Vluggen

15-Nov-10 4:45

vijay2482 wrote:
I would like to know how to retrive data from Access table to a excel spread sheet with a click of a button in the excel spreadsheet.

Using VBA. I don't have the exact code - you'll have to search a bit Smile | :)

I are Troll Suspicious | :suss:

Re: Retrive data from Access table

Blue_Boy15-Nov-10 9:51

Blue_Boy

15-Nov-10 9:51

Better start to learn C# or any another programming language.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

Re: Retrive data from Access table

jschell16-Nov-10 9:00

jschell

16-Nov-10 9:00

Blue_Boy wrote:
Better start to learn C# or any another programming language.

You can use C# as a macro language in Excel?

Re: Retrive data from Access table

Eddy Vluggen16-Nov-10 9:15

Eddy Vluggen

16-Nov-10 9:15

Like this[^] Poke tongue | ;-P

I are Troll Suspicious | :suss:

Adding mysql data to postgresql

franrtorres7714-Nov-10 1:51

franrtorres77

14-Nov-10 1:51

Hi there

I need to add periodically some data from a remote mysql database into our postgresql database. So, does anyone know how to do it having in mind that it must be runned every minute or so for adding new records to the postresql?

Best regards

Re: Adding mysql data to postgresql

Eddy Vluggen16-Nov-10 0:11

Eddy Vluggen

16-Nov-10 0:11

franrtorres77 wrote:
So, does anyone know how to do it having in mind that it must be runned every minute or so for adding new records to the postresql?

Perhaps the Sync Framework[^]? I'm not sure on the performance though.

I are Troll Suspicious | :suss:

Re: Adding mysql data to postgresql

RaviRanjanKr17-Dec-10 18:36

RaviRanjanKr

17-Dec-10 18:36

Addy already given you a perfect Link, you can also try the given link
Exporting MySQL and PostgreSQL Database Contents[^]

Hope it will work for you.

MySQL Select help required

djhankypark12-Nov-10 12:11

djhankypark

12-Nov-10 12:11

Could someone pont me in the right direction here cos I am pulling my hair out and I have little to start with lol

I am working with 3 tables

User Table:
Auto_ID
User_Name

Profile Table:
Auto_ID
User_ID (This is taken from the Auto_ID in the User Table e.g. 20)
Prof_Img

Comments Table:
Auto_ID
Message_To (This is taken from the Auto_ID in the User Table e.g. 41)
Message_From (This is taken from the Auto_ID in the User Table e.g. 20)
Message

I need to be able to display the Prof_Img for who the message was _to and _from I just can't figure how to get the individual picture references from the same table in the same query. I can get one of the pictures but not both, am probably not thinking about it correctly, well obviously I am or it would work lol

Oh and I need the User_Name to go with each relevant picture

If someone could give me a little guidance please it would save my hair line lol

Many thanks in advance

Regards

Ray

Re: MySQL Select help required

Luc Pattyn12-Nov-10 12:55

Luc Pattyn

12-Nov-10 12:55

OK, you need two joins to the same tables (once for from, once for to; and both once for name, once for image); this will only work when you use aliases to discriminate the identical tables.

This will not be correct, but indicates the technique; try something like this:

SELECT FU.Name, TU.Name FROM Comments
JOIN User as FU ON Comments.Message_From=FU.Auto_ID
JOIN User as TU ON Comments.Message_To=TU.Auto_ID
WHERE Comments.Auto_ID=MessageID

which, once correct, you can extend to also handle the images.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Re: MySQL Select help required

djhankypark23-Nov-10 7:29

djhankypark

23-Nov-10 7:29

I finally got to sit and try your suggestion and this was wonderful help thank you so much.

I do have another question about this which I will post a new messgae for shortly.

Again thank you very much for your help

Regards

Ray

Re: MySQL Select help required

Luc Pattyn23-Nov-10 7:43

Luc Pattyn

23-Nov-10 7:43

You're welcome.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Timeourt

logicon12-Nov-10 1:00

logicon

12-Nov-10 1:00

Hi All,

I have a table with 50000000+ rows in SQL Server 2008 R2 Express. I am querying this database table from a .NET application. Unfortunately this table is not having any PK and probably its now possible to implement one.

When I fire my query it doesn't works due to Timeout. I get error:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

I am reading this with execute dataset method to fill my Datagridview.

Please suggest me approach I should take to make this work.

thanks

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.