[lp_inline_dataset] at tagSwap.net: Open Source Lasso Code

[lp_inline_dataset]

Description

Link: [lp_inline_dataset]

Author: Bil Corry

Category: Database

Version: 8.x

License: Public Domain

Posted: Apr. 21, 2006

Updated: May. 17, 2006

More by this author...

Records abstraction type. See example for usage.

In addition, the following member tags are available:

->records_array
->field_names
->error_msg
->error_code
->found_count
->shown_count
->shown_first
->shown_last
->page_count
->skiprecords_value
->maxrecords_value
->database_name
->table_name
->keyfield_name
->schema_name
->lasso_currentaction
->action_statement

[lp_inline_rowset] is also required and included.

Parameters

none

Sample Usage

var:'sql' = "
		SELECT
			firstname,
			lastname
		FROM
			contacts
		ORDER BY
			lastname,
			firstname
		LIMIT 10
		";

	inline: $connection_db,	-sql=$sql;
		var:'lp_inline_dataset' = lp_inline_dataset;
	/inline;

	lp_iterate: $lp_inline_dataset;
		'The contact\'s name is ' loop_item->firstname ' ' loop_item->lastname '<br>';
	/lp_iterate;

	'Error is ' $lp_inline_dataset->error_msg;

Source Code

Click the "Download" button below to retrieve a copy of this tag, including the complete documentation and sample usage shown on this page. Place the downloaded ".inc" file in your LassoStartup folder, restart Lasso, and you can begin using this tag immediately.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102

[

define_type:'lp_inline_dataset',
	-description='Records abstraction type.',
	-prototype;

	// based on code from Greg Willits, James Harvard and Fletcher Sandbeck (TotW)

	local:'records_array' = array;
	local:'field_names' = array;
	local:'error_msg' = string;
	local:'error_code' = integer;
	local:'found_count' = integer;
	local:'shown_count' = integer;
	local:'shown_first' = integer;
	local:'shown_last' = integer;
	local:'page_count' = integer;
	local:'skiprecords_value' = integer;
	local:'maxrecords_value'  = integer;
	local:'database_name'  = string;
	local:'table_name'  = string;
	local:'keyfield_name'  = string;
	local:'schema_name'  = string;
	local:'lasso_currentaction'  = string;
	local:'action_statement'  = string;

	define_tag:'onCreate';
		self->'records_array' = @records_array;
		self->'field_names' = @field_names;
		self->'error_msg' = @error_msg;
		self->'error_code' = @error_code;
		self->'found_count' = @found_count;
		self->'shown_count' = @shown_count;
		self->'shown_first' = @shown_first;
		self->'shown_last' = @shown_last;
		self->'page_count' = (math_ceil:(found_count / (decimal:maxrecords_value)));
		self->'skiprecords_value' = @skiprecords_value;
		self->'maxrecords_value'  = @maxrecords_value;
		self->'database_name' = @database_name;
		self->'table_name' = @table_name;
		self->'keyfield_name' = @keyfield_name;
		self->'schema_name' = @schema_name;
		self->'lasso_currentaction' = @lasso_currentaction;
		self->'action_statement' = @action_statement;
	/define_tag;

	define_tag:'onConvert';
		return: @self->'records_array';
	/define_tag;
	
	define_tag:'size';
		return: @self->'records_array'->size;
	/define_tag;

	define_tag:'get',-optional='ptr';
		if: !local_defined:'ptr';
			#ptr = 1;
		/if;
		return: @(lp_inline_rowset: @self->'records_array'->(get: #ptr),@self->'field_names');
	/define_tag;
	
/define_type;

define_type:'lp_inline_rowset',
	-description='Row abstraction type.',
	-prototype;
	
	local:'row_array' = array;
	local:'field_names' = array;

	define_tag:'onCreate',-required='row_array',-required='field_names';
		self->'row_array' = @#row_array;
		self->'field_names' = @#field_names;
	/define_tag;
	
	define_tag:'onConvert';
		return: @self->'row_array';
	/define_tag;

	define_tag:'size';
		return: @self->'row_array'->size;
	/define_tag;
	
	define_tag:'get',-optional='ptr';
		if: !local_defined:'ptr';
			#ptr = 1;
		/if;
		return: @self->'row_array'->(get: #ptr);
	/define_tag;

	define_tag:'_unknowntag';
		local:'index' = self->'field_names'->(findindex: tag_name);
		if: #index->size == 0;
			return: null;
		else;
			return: @self->'row_array'->(get: (#index->(get:1)));
		/if;
	/define_tag;
		
/define_type;

]

Comments

none