Thanks a lot guys: there is a beginning of an understanding. Putting it into practice look at the following:

CREATE TABLE #images (files VARCHAR(500) NULL, InsertCMD

AS 'INSERT INTO Renner_Foto (ImageID, ImageName,...

Unfortunately there are no replies on my post. There is one advantage though: I was obliged to create a solution myself. The code above was mainly made by Ninja and...

Hello Ninja,

I've played around a bit with the code and it works great!

The problem is solved with your query as follows:

Use WielerDatabaseSQL

Go

Select

T.Achternaam,

Stuff((

Select ',' + C.Uitslag

From vwAATestHorizontaal C

Where C.Rennerid = T.Rennerid

Order...

Thanks Ninja, w'll give it a try. I let you know if it works.

I think I can manage that one. Th second seems fine to me. Once I have to update I empty the table and fill it again and we are not...

Sorry, forgot something. When there are additions/changes, (fi other images for the same ryder), we loop through the same folder. This only happens twice a year, maximum.

Grz,

Robert

There should be a primary key, yet to be installed. I am going to produce some improvements, but that has to be decided. Had no time today, tomorrow neither.

To be...

Hello Robin,

To be complete I want to inform you about your code: that code is running too, but I had to make two changes:

1). Because xp_cmdshell accepts no spaces in...

Thanks for your code (very, very fast production - that must be a pro): for simplicity I made the same directory as you did (D:\test img\) and its running like...

Let's be clear: I appreciate what your doing. But when acting on the newbees site you can expect something like me (perhaps I am the worst ever, but still). The...

The wonder has happened: I have got some records in the database!! The problem is as follows:

In the first 100 counters there are 7 images. Sometimes images occur 3 times...

The result is quite simple: every image that exists is added to the database for all the other ones we get the message:

(1 row(s) affected)

Msg 4860, Level 16, State 1,...

I think I am doing/have done what you said:

USE WielerDatabaseSQL

GO

BEGIN TRAN

DECLARE @counter AS int

DECLARE @folderpath AS varchar(255)

DECLARE @fullpath AS varchar(4000)

DECLARE @shellpath AS varchar(4000)

DECLARE @shellfullpath AS varchar(4000)

DECLARE @sqlstring AS...

I think your error has to do with the filepath, more specific the space in [Mijn Documenten]. If you put that piece of code between "" the problems should be...

The output looks as follows:

11.jpg0xFFD8FFE000 etc.

So again: no problems with one image. With my webpage you can see the image and it is OK.